From: | David Hartwig <daveh(at)insightdist(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Regression test status (was type coersion) |
Date: | 1998-08-17 13:46:29 |
Message-ID: | 35D83435.2C059B5C@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
> I rebuilt the system from current sources today, and ran the regression
> tests for the first time in a long time. select_views works fine for
> me, but there are several other tests that look badly broken:
> SELECT ... ORDER BY upper(c) is misordering the results in select_implicit,
> GROUP BY
> regards, tom lane
>
> *** expected/select_implicit.out Sat Aug 15 11:56:03 1998
> --- results/select_implicit.out Sat Aug 15 13:44:16 1998
> ***************
> *** 213,226 ****
> QUERY: SELECT a FROM test_missing_target ORDER BY upper(c);
> a
> -
> - 1
> 2
> 3
> 4
> 5
> 6
> - 7
> 8
> 9
> 0
> (10 rows)
> --- 213,226 ----
> QUERY: SELECT a FROM test_missing_target ORDER BY upper(c);
> a
> -
> 2
> + 1
> 3
> 4
> 5
> 6
> 8
> + 7
> 9
> 0
> (10 rows)
>
Interesting. I do not recall my exact data set in the regression, but I
believe both results are correct. In some sense, on your machine
upper('CCCC') and upper('cccc') are sorting in a different order then my
machine. I realize that internally they are actually ordinally tied. But I
thought they should still produce a predictable, uniform, result set. Either,
there is a bug or I need more reliable test data. I will verify this when I
get home.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-08-17 14:17:33 | Re: [DOCS] Re: [HACKERS] So what is the current documentation status? |
Previous Message | Jan Wieck | 1998-08-17 13:21:39 | Rules: first fix |