Re: consttraints.source

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: consttraints.source
Дата
Msg-id 199801062356.SAA28485@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: consttraints.source  (Keith Parks <emkxp01@mtcc.demon.co.uk>)
Список pgsql-hackers
>
> Hi,
>
> I'm seeing similar problems, mainly due to failure to sort correctly
> even though there is an "order by" clause.
>
> I did a few tests and found that the sort sort seemed to fail when there
> were multiple columns in the "order by" clause. (Not conclusive)
>
> I don't know when it 1st appeared as I've been trying to compile on
> SPARC-Linux for the past few attempts and this is the 1st time I've
> had a fully working package to run the regression tests on!!

Sort is now fixed.  When I added UNION, I needed to add UNIQUE from
optimizer, so I added a SortClause node to the routine.  Turns out it
was NULL'ing it for every sort field.  Should work now.

--
Bruce Momjian
maillist@candle.pha.pa.us

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

Предыдущее
От: Tony Rios
Дата:
Сообщение: Re: [HACKERS] database size
Следующее
От: darrenk@insightdist.com (Darren King)
Дата:
Сообщение: Re: [HACKERS] database size