On Fri, 25 Jul 2003 19:57:04 -0400 Tom Lane <[EMAIL PROTECTED]> said something like:
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > I am seeing the following parallel regression test failures. Any > > idea on the cause? > > I don't see it here, on either of two different architectures. Maybe > you need a make distclean and rebuild? > And another failure: *** ./expected/constraints.out Fri Jul 25 21:14:51 2003 --- ./results/constraints.out Fri Jul 25 21:34:09 2003 *************** *** 212,244 **** DROP SEQUENCE INSERT_SEQ; CREATE SEQUENCE INSERT_SEQ START 4; CREATE TABLE tmp (xd INT, yd TEXT, zd INT); INSERT INTO tmp VALUES (null, 'Y', null); INSERT INTO tmp VALUES (5, '!check failed', null); INSERT INTO tmp VALUES (null, 'try again', null); INSERT INTO INSERT_TBL(y) select yd from tmp; SELECT '' AS three, * FROM INSERT_TBL; three | x | y | z ! -------+---+---------------+---- ! | 4 | Y | -4 ! | 5 | !check failed | -5 ! | 6 | try again | -6 ! (3 rows) INSERT INTO INSERT_TBL SELECT * FROM tmp WHERE yd = 'try again'; INSERT INTO INSERT_TBL(y,z) SELECT yd, -7 FROM tmp WHERE yd = 'try again'; INSERT INTO INSERT_TBL(y,z) SELECT yd, -8 FROM tmp WHERE yd = 'try again';! ERROR: new row for relation "insert_tbl" violates CHECK constraint "insert_con" SELECT '' AS four, * FROM INSERT_TBL; four | x | y | z ! ------+---+---------------+---- ! | 4 | Y | -4 ! | 5 | !check failed | -5 ! | 6 | try again | -6 ! | | try again | ! | 7 | try again | -7 ! (5 rows) DROP TABLE tmp; -- -- Check constraints on UPDATE -- --- 212,244 ---- DROP SEQUENCE INSERT_SEQ; CREATE SEQUENCE INSERT_SEQ START 4; CREATE TABLE tmp (xd INT, yd TEXT, zd INT); + ERROR: relation 126260 deleted while still in use INSERT INTO tmp VALUES (null, 'Y', null); + ERROR: relation "tmp" does not exist INSERT INTO tmp VALUES (5, '!check failed', null); + ERROR: relation "tmp" does not exist INSERT INTO tmp VALUES (null, 'try again', null); + ERROR: relation "tmp" does not exist INSERT INTO INSERT_TBL(y) select yd from tmp; + ERROR: relation "tmp" does not exist SELECT '' AS three, * FROM INSERT_TBL; three | x | y | z ! -------+---+---+--- ! (0 rows) INSERT INTO INSERT_TBL SELECT * FROM tmp WHERE yd = 'try again'; + ERROR: relation "tmp" does not exist INSERT INTO INSERT_TBL(y,z) SELECT yd, -7 FROM tmp WHERE yd = 'try again';+ ERROR: relation "tmp" does not exist INSERT INTO INSERT_TBL(y,z) SELECT yd, -8 FROM tmp WHERE yd = 'try again';! ERROR: relation "tmp" does not exist SELECT '' AS four, * FROM INSERT_TBL; four | x | y | z ! ------+---+---+--- ! (0 rows) DROP TABLE tmp; + ERROR: table "tmp" does not exist -- -- Check constraints on UPDATE -- *************** *** 246,261 **** UPDATE INSERT_TBL SET x = 6 WHERE x = 6; UPDATE INSERT_TBL SET x = -z, z = -x; UPDATE INSERT_TBL SET x = z, z = x; - ERROR: new row for relation "insert_tbl" violates CHECK constraint "insert_con" SELECT * FROM INSERT_TBL; x | y | z ! ---+---------------+---- ! 4 | Y | -4 ! | try again | ! 7 | try again | -7 ! 5 | !check failed | ! 6 | try again | -6 ! (5 rows) -- DROP TABLE INSERT_TBL; -- --- 246,255 ---- UPDATE INSERT_TBL SET x = 6 WHERE x = 6; UPDATE INSERT_TBL SET x = -z, z = -x; UPDATE INSERT_TBL SET x = z, z = x; SELECT * FROM INSERT_TBL; x | y | z ! ---+---+--- ! (0 rows) -- DROP TABLE INSERT_TBL; -- ====================================================================== -- 21:34:48 up 8 days, 1:35, 2 users, load average: 0.89, 0.65, 0.85
pgp00000.pgp
Description: PGP signature
