Changeset: 50331cf20a2a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=50331cf20a2a Modified Files: sql/test/merge-partitions/Tests/mergepart23.SQL.py sql/test/merge-partitions/Tests/mergepart23.stable.err Branch: Jun2020 Log Message:
Test dependencies on partioned tables after server restart diffs (68 lines): diff --git a/sql/test/merge-partitions/Tests/mergepart23.SQL.py b/sql/test/merge-partitions/Tests/mergepart23.SQL.py --- a/sql/test/merge-partitions/Tests/mergepart23.SQL.py +++ b/sql/test/merge-partitions/Tests/mergepart23.SQL.py @@ -45,6 +45,8 @@ SELECT "minimum", "maximum" FROM range_p script2 = ''' SELECT "minimum", "maximum" FROM range_partitions; +DROP TABLE subtable1; --error, subtable1 is a child of testme +DROP TABLE subtable3; --error, subtable3 is a child of anothertest ALTER TABLE anothertest ADD TABLE subtable1 AS PARTITION FROM 11 TO 20; --error, subtable1 is part of another table SELECT "minimum", "maximum" FROM range_partitions; ''' @@ -64,6 +66,8 @@ ALTER TABLE testme DROP TABLE subtable5; ALTER TABLE anothertest DROP TABLE subtable3; ALTER TABLE anothertest DROP TABLE subtable4; SELECT "minimum", "maximum" FROM range_partitions; +ALTER TABLE testme DROP COLUMN "a"; --error, a is a partition column +ALTER TABLE anothertest DROP COLUMN "a"; --error, a is used on partition expression DROP TABLE testme; DROP TABLE subtable1; DROP TABLE subtable2; diff --git a/sql/test/merge-partitions/Tests/mergepart23.stable.err b/sql/test/merge-partitions/Tests/mergepart23.stable.err --- a/sql/test/merge-partitions/Tests/mergepart23.stable.err +++ b/sql/test/merge-partitions/Tests/mergepart23.stable.err @@ -15,10 +15,18 @@ stderr of test 'mergepart23` in director # builtin opt raw_strings = false # cmdline opt gdk_nr_threads = 0 # cmdline opt mapi_open = true -# cmdline opt mapi_port = 40039 -# cmdline opt mapi_usock = /var/tmp/mtest-8430/.s.monetdb.40039 -# cmdline opt gdk_dbpath = /tmp/tmp5_6lepwa/db1/db1 -MAPI = (monetdb) /var/tmp/mtest-8430/.s.monetdb.40039 +# cmdline opt mapi_port = 58997 +# cmdline opt mapi_usock = /var/tmp/mtest-10859/.s.monetdb.58997 +# cmdline opt gdk_dbpath = /tmp/tmpxda437iy/db1/db1 +MAPI = (monetdb) /var/tmp/mtest-10859/.s.monetdb.58997 +QUERY = DROP TABLE subtable1; --error, subtable1 is a child of testme +ERROR = !DROP TABLE: unable to drop table subtable1 (there are database objects which depend on it) +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-10859/.s.monetdb.58997 +QUERY = DROP TABLE subtable3; --error, subtable3 is a child of anothertest +ERROR = !DROP TABLE: unable to drop table subtable3 (there are database objects which depend on it) +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-10859/.s.monetdb.58997 QUERY = ALTER TABLE anothertest ADD TABLE subtable1 AS PARTITION FROM 11 TO 20; --error, subtable1 is part of another table ERROR = !ALTER TABLE: table 'sys.subtable1' is already part of another table CODE = 42000 @@ -32,9 +40,17 @@ CODE = 42000 # builtin opt raw_strings = false # cmdline opt gdk_nr_threads = 0 # cmdline opt mapi_open = true -# cmdline opt mapi_port = 59527 -# cmdline opt mapi_usock = /var/tmp/mtest-8016/.s.monetdb.59527 -# cmdline opt gdk_dbpath = /tmp/tmpeohzwcf3/db1/db1 +# cmdline opt mapi_port = 50085 +# cmdline opt mapi_usock = /var/tmp/mtest-12650/.s.monetdb.50085 +# cmdline opt gdk_dbpath = /tmp/tmphzgzx_1k/db1/db1 +MAPI = (monetdb) /var/tmp/mtest-12650/.s.monetdb.50085 +QUERY = ALTER TABLE testme DROP COLUMN "a"; --error, a is a partition column +ERROR = !ALTER TABLE: cannot drop column 'a': is the partitioned column on the table 'testme' +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-12650/.s.monetdb.50085 +QUERY = ALTER TABLE anothertest DROP COLUMN "a"; --error, a is used on partition expression +ERROR = !ALTER TABLE: cannot drop column 'a': there are database objects which depend on it +CODE = 2BM37 # builtin opt gdk_dbpath = /home/ferreira/repositories/MonetDB-Jun2020/BUILD/var/monetdb5/dbfarm/demo # builtin opt mapi_port = 50000 # builtin opt mapi_open = false _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
