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

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.