Adam Witney <[EMAIL PROTECTED]> writes:
> I have one regression failure on 7.4.1, which does not occur with 7.4
>
> [EMAIL PROTECTED] more src/test/regress/regression.diffs
> *** ./expected/random.out Thu Feb 13 05:24:04 2003
> --- ./results/random.out Tue Dec 23 20:19:40 2003
> ***************
> *** 25,31 ****
> GROUP BY random HAVING count(random) > 1;
> random | count
> --------+-------
> ! (0 rows)
>
> SELECT random FROM RANDOM_TBL
> WHERE random NOT BETWEEN 80 AND 120;
> --- 25,32 ----
> GROUP BY random HAVING count(random) > 1;
> random | count
> --------+-------
> ! 103 | 2
> ! (1 row)
>
> SELECT random FROM RANDOM_TBL
> WHERE random NOT BETWEEN 80 AND 120;
Unless this happens consistently (i.e. if you run the regression tests
20 times, this test fails more than once or twice), don't worry about
it: the 'random' test is mildly non-deterministic.
-Neil
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
