Re: [HACKERS] Regression test status (was type coersion)

David Hartwig <daveh@insightdist.com> writes:
> Both sort orders are correct.  I seems that different machines are
> resolving equivalent strings differently.  I got the same result as
> Tom on an RS/6000 box.  I could be an big vs little endian, signed vs
> unsigned chars issue.  In any case, the actual sort order is
> indeterminate.  Therefore I will submit a new regression test with
> reliable test data.

OK.

> These results are also correct.  Somewhat.  I do not know much about
> datatime porting issues, but if I do a:
>     SELECT d1 FROM  DATETIME_TBL
> I get time reported to the 1/100 of a second.  If GROUP BY d1 the
> hundredths are not shown.  Thus, the counts and groupings are correct.
> Its just not showing the hundredths portion.

The issue here is why you (or whoever it was prepared the regression
test) got different results from me...

>>>> QUERY: SELECT count(*) FROM onek where oidrand(onek.oid, 10);
>>>> ! ERROR:  can't look up operator 713
>
> Don't know about this one.

That bug should be fixed in the current sources, I believe.

            regards, tom lane