Re: BUG #17842: Adding a qual to a working query gets bogus syntax error - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #17842: Adding a qual to a working query gets bogus syntax error
Date
Msg-id CAKFQuwZ=+eQtJh5d1fmqS1nYWfm9c8JrDV=OZr2ja6PgMW0AeQ@mail.gmail.com
Whole thread Raw
In response to AW: BUG #17842: Adding a qual to a working query gets bogus syntax error  (Hans Buschmann <buschmann@nidsa.net>)
List pgsql-bugs


On Tue, Mar 14, 2023, 12:08 Hans Buschmann <buschmann@nidsa.net> wrote:

I think this qual pushdown is dangerous, because it is applied before the join and so includes invalid cases.

Well, it's better than any alternative that is more expensive even when the data in question isn't prone to parsing problems.  We optimize for the common case of consistent normalized data.  You have tools if you need to operate with bad data.

David J.




 tom lane

pgsql-bugs by date:

Previous
From: Hans Buschmann
Date:
Subject: AW: BUG #17842: Adding a qual to a working query gets bogus syntax error
Next
From: hubert depesz lubaczewski
Date:
Subject: pg_read_server_files doesn't let me use pg_ls_dir() or pg_read_file?