Changeset: 1679a72b87dc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1679a72b87dc Modified Files: sql/test/merge-partitions/Tests/mergepart30.sql sql/test/merge-partitions/Tests/mergepart30.stable.err Branch: Oct2020 Log Message:
More testing diffs (72 lines): diff --git a/sql/test/merge-partitions/Tests/mergepart30.sql b/sql/test/merge-partitions/Tests/mergepart30.sql --- a/sql/test/merge-partitions/Tests/mergepart30.sql +++ b/sql/test/merge-partitions/Tests/mergepart30.sql @@ -74,6 +74,8 @@ ALTER TABLE table1 DROP TABLE another2; ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM RANGE MINVALUE TO RANGE MAXVALUE; ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 to 5; --error, conflicts with another1 +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM RANGE MINVALUE to 2; --error, conflicts with another1 +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 2 to RANGE MAXVALUE; --error, conflicts with another1 SELECT a FROM table1; SELECT a FROM another1; SELECT a FROM another2; @@ -85,11 +87,13 @@ TRUNCATE another2; ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM RANGE MINVALUE TO 2; ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM RANGE MINVALUE TO 1; --error, conflicts with another1 +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 TO 1; --error, conflicts with another1 ALTER TABLE table1 DROP TABLE another1; ALTER TABLE table1 DROP TABLE another2; --error, not there ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM 2 TO RANGE MAXVALUE; ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 10 TO RANGE MAXVALUE; --error, conflicts with another1 +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 1 TO 3; --error, conflicts with another1 ALTER TABLE table1 DROP TABLE another1; ALTER TABLE table1 DROP TABLE another2; --error, not there diff --git a/sql/test/merge-partitions/Tests/mergepart30.stable.err b/sql/test/merge-partitions/Tests/mergepart30.stable.err --- a/sql/test/merge-partitions/Tests/mergepart30.stable.err +++ b/sql/test/merge-partitions/Tests/mergepart30.stable.err @@ -69,7 +69,15 @@ MAPI = (monetdb) /var/tmp/mtest-84239/. QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 to 5; --error, conflicts with another1 ERROR = !ALTER TABLE: conflicting partitions: 0 to 5 and absolute min value to absolute max value from table sys.another1 CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-84239/.s.monetdb.31974 +MAPI = (monetdb) /var/tmp/mtest-89788/.s.monetdb.36023 +QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM RANGE MINVALUE to 2; --error, conflicts with another1 +ERROR = !ALTER TABLE: conflicting partitions: absolute min value to 2 and absolute min value to absolute max value from table sys.another1 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-89788/.s.monetdb.36023 +QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 2 to RANGE MAXVALUE; --error, conflicts with another1 +ERROR = !ALTER TABLE: conflicting partitions: 2 to absolute max value and absolute min value to absolute max value from table sys.another1 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-89788/.s.monetdb.36023 QUERY = ALTER TABLE table1 DROP TABLE another2; --error, not there ERROR = !ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1' CODE = 42S02 @@ -77,7 +85,11 @@ MAPI = (monetdb) /var/tmp/mtest-86521/. QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM RANGE MINVALUE TO 1; --error, conflicts with another1 ERROR = !ALTER TABLE: conflicting partitions: absolute min value to 1 and absolute min value to 2 from table sys.another1 CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-86671/.s.monetdb.39443 +MAPI = (monetdb) /var/tmp/mtest-89557/.s.monetdb.34879 +QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 0 TO 1; --error, conflicts with another1 +ERROR = !ALTER TABLE: conflicting partitions: 0 to 1 and absolute min value to 2 from table sys.another1 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-89557/.s.monetdb.34879 QUERY = ALTER TABLE table1 DROP TABLE another2; --error, not there ERROR = !ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1' CODE = 42S02 @@ -85,7 +97,11 @@ MAPI = (monetdb) /var/tmp/mtest-86671/. QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 10 TO RANGE MAXVALUE; --error, conflicts with another1 ERROR = !ALTER TABLE: conflicting partitions: 10 to absolute max value and 2 to absolute max value from table sys.another1 CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-86671/.s.monetdb.39443 +MAPI = (monetdb) /var/tmp/mtest-89557/.s.monetdb.34879 +QUERY = ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 1 TO 3; --error, conflicts with another1 +ERROR = !ALTER TABLE: conflicting partitions: 1 to 3 and 2 to absolute max value from table sys.another1 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-89557/.s.monetdb.34879 QUERY = ALTER TABLE table1 DROP TABLE another2; --error, not there ERROR = !ALTER TABLE: table 'sys.another2' isn't part of RANGE PARTITION TABLE 'sys.table1' CODE = 42S02 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
