Changeset: a817478f956a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a817478f956a Modified Files: sql/test/merge-partitions/Tests/mergepart30.sql sql/test/merge-partitions/Tests/mergepart30.stable.err Branch: Jun2020 Log Message:
More testing diffs (127 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 @@ -12,6 +12,9 @@ DROP TABLE table2; CREATE MERGE TABLE table1 (a int) PARTITION BY RANGE ON (a); CREATE TABLE another1 (a int); CREATE TABLE another2 (a int); +CREATE TABLE another3 (a int); +CREATE TABLE another4 (a int); +CREATE TABLE another5 (a int); ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM RANGE MINVALUE TO RANGE MAXVALUE WITH NULL VALUES; --holds all INSERT INTO table1 VALUES (1), (NULL); @@ -74,6 +77,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,14 +90,35 @@ 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 +ALTER TABLE table1 ADD TABLE another1 AS PARTITION FROM RANGE MINVALUE TO 0; +ALTER TABLE table1 ADD TABLE another2 AS PARTITION FROM 10 TO RANGE MAXVALUE; +ALTER TABLE table1 ADD TABLE another3 AS PARTITION FROM 0 TO 10; +ALTER TABLE table1 ADD TABLE another4 AS PARTITION FOR NULL VALUES; + +ALTER TABLE table1 ADD TABLE another5 AS PARTITION FROM -100 TO -1; --error, conflicts with another1 +ALTER TABLE table1 ADD TABLE another5 AS PARTITION FROM 10 TO 11; --error, conflicts with another2 +ALTER TABLE table1 ADD TABLE another5 AS PARTITION FROM 9 TO 10; --error, conflicts with another3 +ALTER TABLE table1 ADD TABLE another5 AS PARTITION FOR NULL VALUES; --error, conflicts with another4 + +ALTER TABLE table1 DROP TABLE another1; +ALTER TABLE table1 DROP TABLE another2; +ALTER TABLE table1 DROP TABLE another3; +ALTER TABLE table1 DROP TABLE another4; +ALTER TABLE table1 DROP TABLE another5; --error, not there + DROP TABLE another1; DROP TABLE another2; +DROP TABLE another3; +DROP TABLE another4; +DROP TABLE another5; DROP TABLE table1; 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-99796/.s.monetdb.30680 +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-99796/.s.monetdb.30680 +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-99796/.s.monetdb.30680 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-99796/.s.monetdb.30680 +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-99796/.s.monetdb.30680 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,10 +97,34 @@ 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-99796/.s.monetdb.30680 +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-99796/.s.monetdb.30680 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 +MAPI = (monetdb) /var/tmp/mtest-99796/.s.monetdb.30680 +QUERY = ALTER TABLE table1 ADD TABLE another5 AS PARTITION FROM -100 TO -1; --error, conflicts with another1 +ERROR = !ALTER TABLE: conflicting partitions: -100 to -1 and absolute min value to 0 from table sys.another1 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-111127/.s.monetdb.37141 +QUERY = ALTER TABLE table1 ADD TABLE another5 AS PARTITION FROM 10 TO 11; --error, conflicts with another2 +ERROR = !ALTER TABLE: conflicting partitions: 10 to 11 and 10 to absolute max value from table sys.another2 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-111127/.s.monetdb.37141 +QUERY = ALTER TABLE table1 ADD TABLE another5 AS PARTITION FROM 9 TO 10; --error, conflicts with another3 +ERROR = !ALTER TABLE: conflicting partitions: 9 to 10 and 0 to 10 from table sys.another3 +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-99796/.s.monetdb.30680 +QUERY = ALTER TABLE table1 ADD TABLE another5 AS PARTITION FOR NULL VALUES; --error, conflicts with another4 +ERROR = !ALTER TABLE: conflicting partitions: table sys.another4 stores null values and only one partition can store null values at the time +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-102928/.s.monetdb.31380 +QUERY = ALTER TABLE table1 DROP TABLE another5; --error, not there +ERROR = !ALTER TABLE: table 'sys.another5' isn't part of RANGE PARTITION TABLE 'sys.table1' +CODE = 42S02 # 09:24:49 > # 09:24:49 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
