Re: BUG #5084: Query gives different number of rows depending on ORDER BY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5084: Query gives different number of rows depending on ORDER BY
Дата
Msg-id 13213.1254166040@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5084: Query gives different number of rows depending on ORDER BY  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: BUG #5084: Query gives different number of rows depending on ORDER BY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> Notice that the (k = k) qual is being dropped somewhere, which changes
> the output since that's a disguised not-null condition.

Huh ... I'm surprised it only does that with the ORDER BY present.
I suppose it's got something to do with the equivalence-class machinery.

            regards, tom lane

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #5084: Query gives different number of rows depending on ORDER BY
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5084: Query gives different number of rows depending on ORDER BY