Thread

  1. Re: consttraints.source

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-01-06T23:56:52Z

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