Bruce Momjian <maillist@candle.pha.pa.us>
> emkxp01@mtcc.demon.co.uk
> >
> > 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.
Thanks for the quick response, I'm building the new code now so will know
in the morning how it stands.
I'm building the whole thing with -O instead of -O2 to see if it helps
with some of the other errors I'm seeing. ( an old problem with gcc and
the SPARC processor makes me suspicious)
Later...
The sorting problems are fixes but I'm still getting many fails.
Will investigate...
Keith.