Re: BUG #17842: Adding a qual to a working query gets bogus syntax error

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17842: Adding a qual to a working query gets bogus syntax error
Дата
Msg-id CAKFQuwZ=+eQtJh5d1fmqS1nYWfm9c8JrDV=OZr2ja6PgMW0AeQ@mail.gmail.com
обсуждение исходный текст
Ответ на AW: BUG #17842: Adding a qual to a working query gets bogus syntax error  (Hans Buschmann <buschmann@nidsa.net>)
Список 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 по дате отправления:

Предыдущее
От: Hans Buschmann
Дата:
Сообщение: AW: BUG #17842: Adding a qual to a working query gets bogus syntax error
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: pg_read_server_files doesn't let me use pg_ls_dir() or pg_read_file?