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.