Changeset: 5012083edb0d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5012083edb0d Modified Files: sql/test/merge-partitions/Tests/mergepart30.test Branch: default Log Message:
Different error message when running single-threaded. Both messages are correct, the check happens to be done in a different order. diffs (49 lines): diff --git a/sql/test/merge-partitions/Tests/mergepart30.test b/sql/test/merge-partitions/Tests/mergepart30.test --- a/sql/test/merge-partitions/Tests/mergepart30.test +++ b/sql/test/merge-partitions/Tests/mergepart30.test @@ -192,9 +192,14 @@ ALTER TABLE table1 DROP TABLE another2 statement ok ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM RANGE MINVALUE TO 10 WITH NULL VALUES +skipif threads=1 statement error 42000!ALTER TABLE: conflicting partitions: 0 to 5 and absolute min value to 10 from table sys.another1 ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 to 5 +onlyif threads=1 +statement error 42000!ALTER TABLE: there are values in column a outside the partition range +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 to 5 + query I rowsort SELECT a FROM table1 ---- @@ -222,15 +227,30 @@ ALTER TABLE table1 DROP TABLE another2 statement ok ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM RANGE MINVALUE TO RANGE MAXVALUE +skipif threads=1 statement error 42000!ALTER TABLE: conflicting partitions: 0 to 5 and absolute min value to absolute max value from table sys.another1 ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 to 5 +onlyif threads=1 +statement error 42000!ALTER TABLE: there are values in column a outside the partition range +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 to 5 + +skipif threads=1 statement error 42000!ALTER TABLE: conflicting partitions: absolute min value to 2 and absolute min value to absolute max value from table sys.another1 ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM RANGE MINVALUE to 2 +onlyif threads=1 +statement error 42000!ALTER TABLE: there are values in column a outside the partition range +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM RANGE MINVALUE to 2 + +skipif threads=1 statement error 42000!ALTER TABLE: conflicting partitions: 2 to absolute max value and absolute min value to absolute max value from table sys.another1 ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 2 to RANGE MAXVALUE +onlyif threads=1 +statement error 42000!ALTER TABLE: there are values in column a outside the partition range +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 2 to RANGE MAXVALUE + query I rowsort SELECT a FROM table1 ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
