From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | David Hartwig <daveh(at)insightdist(dot)com> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Regression test status (was type coersion) |
Date: | 1998-08-26 18:25:18 |
Message-ID: | 29966.904155918@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
David Hartwig <daveh(at)insightdist(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter T Mount | 1998-08-26 18:28:03 | EMail Problems |
Previous Message | Bruce Momjian | 1998-08-26 17:46:36 | Re: [HACKERS] Segmentation fault with lo_export |