BUG #15618: Duplicating a join clause breaks index use

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15618: Duplicating a join clause breaks index use
Дата
Msg-id 15618-5357e448d7cbeb27@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15618: Duplicating a join clause breaks index use  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      15618
Logged by:          cd a
Email address:      cdalxndr@yahoo.com
PostgreSQL version: 10.3
Operating system:   Windows 10
Description:

Adding a unused join clause to the query, modifies the run time from 50ms to
4seconds.
No columns from the join clause are returned and the joined table is not
used in other places.
The join clause is a duplicate of another one that is used for further
joining.

The joined clause should have been automatically removed as it has no side
effects, thus using indices and optimizing query runtime.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Petr Fedorov
Дата:
Сообщение: 'update returning *' returns 0 columns instead of empty row with 2columns when (i) no rows updated and (ii) when applied to a partitioned tablewith sub-partition
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #15618: Duplicating a join clause breaks index use