>
> 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
