Changeset: e32c9611150a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e32c9611150a
Modified Files:
sql/test/merge-partitions/Tests/mergepart00.test
sql/test/merge-partitions/Tests/mergepart01.test
sql/test/merge-partitions/Tests/mergepart02.test
sql/test/merge-partitions/Tests/mergepart03.test
sql/test/merge-partitions/Tests/mergepart04.test
sql/test/merge-partitions/Tests/mergepart05.test
sql/test/merge-partitions/Tests/mergepart06.test
sql/test/merge-partitions/Tests/mergepart07.test
sql/test/merge-partitions/Tests/mergepart09.test
sql/test/merge-partitions/Tests/mergepart10.test
sql/test/merge-partitions/Tests/mergepart11.test
sql/test/merge-partitions/Tests/mergepart12.test
sql/test/merge-partitions/Tests/mergepart13.test
sql/test/merge-partitions/Tests/mergepart14.test
sql/test/merge-partitions/Tests/mergepart15.test
sql/test/merge-partitions/Tests/mergepart16.test
sql/test/merge-partitions/Tests/mergepart17.test
sql/test/merge-partitions/Tests/mergepart18.test
sql/test/merge-partitions/Tests/mergepart19.test
sql/test/merge-partitions/Tests/mergepart20.test
sql/test/merge-partitions/Tests/mergepart21.test
sql/test/merge-partitions/Tests/mergepart22.test
sql/test/merge-partitions/Tests/mergepart24.test
sql/test/merge-partitions/Tests/mergepart25.test
sql/test/merge-partitions/Tests/mergepart26.test
sql/test/merge-partitions/Tests/mergepart27.test
sql/test/merge-partitions/Tests/mergepart30.test
sql/test/merge-partitions/Tests/mergepart32.test
Branch: Jul2021
Log Message:
Testing error messages.
I have to make sure the right are thrown while we are cleaning the storage.
diffs (truncated from 1548 to 300 lines):
diff --git a/sql/test/merge-partitions/Tests/mergepart00.test
b/sql/test/merge-partitions/Tests/mergepart00.test
--- a/sql/test/merge-partitions/Tests/mergepart00.test
+++ b/sql/test/merge-partitions/Tests/mergepart00.test
@@ -3,7 +3,7 @@ SELECT COUNT(*) from table_partitions
----
0
-statement error
+statement error 42000!CREATE MERGE TABLE: the partition column 'd' is not part
of the table
CREATE MERGE TABLE myfirstattempt (a int, b varchar(32)) PARTITION BY RANGE ON
(d)
query I rowsort
diff --git a/sql/test/merge-partitions/Tests/mergepart01.test
b/sql/test/merge-partitions/Tests/mergepart01.test
--- a/sql/test/merge-partitions/Tests/mergepart01.test
+++ b/sql/test/merge-partitions/Tests/mergepart01.test
@@ -42,40 +42,40 @@ SELECT COUNT(*) from range_partitions
----
1
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable1' is already part of
RANGE PARTITION TABLE 'sys.testme'
ALTER TABLE testme ADD TABLE subtable1 AS PARTITION FROM 5 TO 10
statement ok
CREATE TABLE wrongtable (a int, b varchar(32), c real)
-statement error
+statement error 3F000!ALTER RANGE PARTITION TABLE: to be added table doesn't
match RANGE PARTITION TABLE definition
ALTER TABLE testme ADD TABLE wrongtable AS PARTITION FROM 5 TO 6
statement ok
CREATE TABLE subtable2 (a int, b varchar(32))
-statement error
+statement error 42000!ALTER TABLE: cannot add a value partition into a RANGE
PARTITION TABLE
ALTER TABLE testme ADD TABLE subtable2 AS PARTITION IN ('0', '1', '2')
-statement error
+statement error 42000!ALTER TABLE: conflicting partitions: 7 to 9 and 5 to 10
from table sys.subtable1
ALTER TABLE testme ADD TABLE subtable2 AS PARTITION FROM 7 TO 9
-statement error
+statement error 42000!ALTER TABLE: conflicting partitions: 5 to 5 and 5 to 10
from table sys.subtable1
ALTER TABLE testme ADD TABLE subtable2 AS PARTITION FROM 5 TO 5
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable2' isn't part of RANGE
PARTITION TABLE 'sys.testme'
ALTER TABLE testme DROP TABLE subtable2
-statement error
+statement error 42000!DROP TABLE: unable to drop table subtable1 (there are
database objects which depend on it)
DROP TABLE subtable1
-statement error
+statement error 2BM37!ALTER TABLE: unable to set schema of table 'testme'
(there are database objects which depend on it)
ALTER TABLE testme SET SCHEMA other_schema
-statement error
+statement error 2BM37!ALTER TABLE: unable to set schema of table 'subtable1'
(there are database objects which depend on it)
ALTER TABLE subtable1 SET SCHEMA other_schema
-statement error
+statement error 2BM37!ALTER TABLE: unable to rename table 'subtable1' (there
are database objects which depend on it)
ALTER TABLE subtable1 RENAME TO subtable3
statement ok
@@ -84,7 +84,7 @@ ALTER TABLE testme DROP TABLE subtable1
statement ok
ALTER TABLE subtable1 SET SCHEMA other_schema
-statement error
+statement error 42000!ALTER TABLE: all children tables of 'sys.testme' must be
part of schema 'sys'
ALTER TABLE testme ADD TABLE other_schema.subtable1 AS PARTITION FROM 4 TO 23
statement ok
diff --git a/sql/test/merge-partitions/Tests/mergepart02.test
b/sql/test/merge-partitions/Tests/mergepart02.test
--- a/sql/test/merge-partitions/Tests/mergepart02.test
+++ b/sql/test/merge-partitions/Tests/mergepart02.test
@@ -30,10 +30,10 @@ 3
statement ok
CREATE TABLE subtable2 (a int, b varchar(32))
-statement error
+statement error 42000!ALTER TABLE: cannot add a range partition into a LIST
PARTITION TABLE
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM 5 TO 10
-statement error
+statement error 42000!ALTER TABLE: the new partition is conflicting with the
existing partition sys.subtable1
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION IN ('3', '4', '5')
statement ok
@@ -49,7 +49,7 @@ SELECT COUNT(*) from value_partitions
----
6
-statement error
+statement error 42000!DROP TABLE: unable to drop table subtable1 (there are
database objects which depend on it)
DROP TABLE subtable1
statement ok
diff --git a/sql/test/merge-partitions/Tests/mergepart03.test
b/sql/test/merge-partitions/Tests/mergepart03.test
--- a/sql/test/merge-partitions/Tests/mergepart03.test
+++ b/sql/test/merge-partitions/Tests/mergepart03.test
@@ -43,7 +43,7 @@ ALTER TABLE listparts DROP TABLE subtabl
statement ok rowcount 1
INSERT INTO subtable2 VALUES (-5, 'oh no')
-statement error
+statement error M0M29!ALTER TABLE: there are values in the column a outside
the partition range
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM '-1' TO 12000
query I rowsort
diff --git a/sql/test/merge-partitions/Tests/mergepart04.test
b/sql/test/merge-partitions/Tests/mergepart04.test
--- a/sql/test/merge-partitions/Tests/mergepart04.test
+++ b/sql/test/merge-partitions/Tests/mergepart04.test
@@ -18,7 +18,7 @@ SELECT COUNT(*) from value_partitions
----
3
-statement error
+statement error M0M29!INSERT: the insert violates the partition list of values
INSERT INTO anothertest VALUES (4, 'wrong')
statement ok
@@ -46,7 +46,7 @@ ALTER TABLE anothertest DROP TABLE subte
statement ok rowcount 1
INSERT INTO subtest2 VALUES (-5, 'oh no')
-statement error
+statement error M0M29!ALTER TABLE: there are values in the column a outside
the partition list of values
ALTER TABLE anothertest ADD TABLE subtest2 AS PARTITION IN ('12', '-1', '100')
query I rowsort
diff --git a/sql/test/merge-partitions/Tests/mergepart05.test
b/sql/test/merge-partitions/Tests/mergepart05.test
--- a/sql/test/merge-partitions/Tests/mergepart05.test
+++ b/sql/test/merge-partitions/Tests/mergepart05.test
@@ -7,10 +7,10 @@ CREATE TABLE subtable1 (b varchar(32))
statement ok
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM RANGE MINVALUE TO
'something'
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable1' is already part of
RANGE PARTITION TABLE 'sys.listparts'
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM 'else' TO RANGE
MAXVALUE
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable1' is already part of
RANGE PARTITION TABLE 'sys.listparts'
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM RANGE MINVALUE TO
RANGE MAXVALUE
query TT rowsort
@@ -19,7 +19,7 @@ SELECT minimum, maximum FROM range_parti
NULL
something
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable1' is already part of
RANGE PARTITION TABLE 'sys.listparts'
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM 'hello' TO 'world'
query TT rowsort
@@ -43,20 +43,20 @@ SELECT minimum, maximum FROM range_parti
statement ok
ALTER TABLE listparts DROP TABLE subtable1
-statement error
+statement error 42000!ALTER TABLE: minimum value is higher than maximum value
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM 'hello"' TO
'"world'
query TT rowsort
SELECT minimum, maximum FROM range_partitions
----
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable1' isn't part of RANGE
PARTITION TABLE 'sys.listparts'
ALTER TABLE listparts DROP TABLE subtable1
statement ok rowcount 1
INSERT INTO subtable1 VALUES ('wrong')
-statement error
+statement error M0M29!ALTER TABLE: there are values in the column b outside
the partition range
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM '"hello' TO
'world"'
query TT rowsort
@@ -75,7 +75,7 @@ CREATE MERGE TABLE testtimestamps (b tim
statement ok
CREATE TABLE subtime (b timestamp)
-statement error
+statement error 42000!ALTER TABLE: minimum value is higher than maximum value
ALTER TABLE testtimestamps ADD TABLE subtime AS PARTITION FROM timestamp
'2002-01-01 00:00' TO timestamp '2001-01-01 00:00'
statement ok
@@ -99,7 +99,7 @@ DELETE FROM subtime
statement ok rowcount 1
INSERT INTO subtime VALUES (timestamp '2050-01-01 00:00')
-statement error
+statement error M0M29!ALTER TABLE: there are values in the column b outside
the partition range
ALTER TABLE testtimestamps ADD TABLE subtime AS PARTITION FROM timestamp
'2048-01-01 00:00' TO timestamp '2049-01-01 00:00'
statement ok
@@ -132,7 +132,7 @@ ALTER TABLE testrangelimits DROP TABLE s
statement ok rowcount 1
INSERT INTO sublimits VALUES (0)
-statement error
+statement error M0M29!ALTER TABLE: there are values in the column a outside
the partition range
ALTER TABLE testrangelimits ADD TABLE sublimits AS PARTITION FROM RANGE
MINVALUE TO 0
statement ok
diff --git a/sql/test/merge-partitions/Tests/mergepart06.test
b/sql/test/merge-partitions/Tests/mergepart06.test
--- a/sql/test/merge-partitions/Tests/mergepart06.test
+++ b/sql/test/merge-partitions/Tests/mergepart06.test
@@ -22,7 +22,7 @@ ALTER TABLE testrangelimits ADD TABLE su
statement ok rowcount 1
INSERT INTO testrangelimits VALUES (1, 'first')
-statement error
+statement error M0M29!INSERT: the insert violates the partition range (NB
higher limit exclusive) of values
INSERT INTO testrangelimits VALUES (1000, 'ups')
statement ok
@@ -34,7 +34,7 @@ ALTER TABLE testrangelimits ADD TABLE su
statement ok
ALTER TABLE testrangelimits ADD TABLE sublimits4 AS PARTITION FROM 500 TO 600
-statement error
+statement error 42000!ALTER TABLE: conflicting partitions: -1 to 1 and 0 to
100 from table sys.sublimits1
ALTER TABLE testrangelimits ADD TABLE sublimits5 AS PARTITION FROM -1 TO 1
statement ok rowcount 3
@@ -49,10 +49,10 @@ INSERT INTO testrangelimits VALUES (171,
statement ok rowcount 4
INSERT INTO testrangelimits VALUES (401, 'another'), (NULL, 'test'), (450,
'to'), (499, 'pass')
-statement error
+statement error M0M29!INSERT: the insert violates the partition range (NB
higher limit exclusive) of values
INSERT INTO testrangelimits VALUES (201, 'oh no')
-statement error
+statement error M0M29!INSERT: the insert violates the partition range (NB
higher limit exclusive) of values
INSERT INTO testrangelimits VALUES (444, 'another'), (305, 'error'), (4,
'happening')
statement ok rowcount 1
@@ -64,13 +64,13 @@ INSERT INTO sublimits2 VALUES (102, 'suc
statement ok rowcount 1
INSERT INTO sublimits3 VALUES (NULL, 'attempt')
-statement error
+statement error M0M29!INSERT: table sys.sublimits3 is part of merge table
sys.testrangelimits and the insert violates the partition range of values
INSERT INTO sublimits3 VALUES (2, 'will')
-statement error
+statement error M0M29!INSERT: table sys.sublimits1 is part of merge table
sys.testrangelimits and the insert violates the partition range of values
INSERT INTO sublimits1 VALUES (202, 'fail')
-statement error
+statement error M0M29!INSERT: table sys.sublimits2 is part of merge table
sys.testrangelimits and the insert violates the partition range of values
INSERT INTO sublimits2 VALUES (NULL, 'again')
query IT rowsort
diff --git a/sql/test/merge-partitions/Tests/mergepart07.test
b/sql/test/merge-partitions/Tests/mergepart07.test
--- a/sql/test/merge-partitions/Tests/mergepart07.test
+++ b/sql/test/merge-partitions/Tests/mergepart07.test
@@ -16,16 +16,16 @@ INSERT INTO subtable2 VALUES (102, 'hell
statement ok
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM 10 TO 100 WITH
NULL VALUES
-statement error
+statement error 42000!ALTER TABLE: range bound cannot be null
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM NULL TO 110
-statement error
+statement error 42000!ALTER TABLE: range bound cannot be null
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM 101 TO NULL
-statement error
+statement error 42000!ALTER TABLE: range bound cannot be null
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM NULL TO NULL
-statement error
+statement error 42000!ALTER TABLE: conflicting partitions: table sys.subtable1
stores null values and only one partition can store null values at the time
ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM 101 TO 110 WITH
NULL VALUES
statement ok
@@ -34,10 +34,10 @@ ALTER TABLE listparts ADD TABLE subtable
statement ok
ALTER TABLE listparts DROP TABLE subtable1
-statement error
+statement error 42S02!ALTER TABLE: table 'sys.subtable1' isn't part of RANGE
PARTITION TABLE 'sys.listparts'
ALTER TABLE listparts DROP TABLE subtable1
-statement error
+statement error M0M29!ALTER TABLE: there are values in the column a outside
the partition range
ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM 10 TO 100
statement ok
@@ -67,16 +67,16 @@ INSERT INTO othersub1 VALUES (1, NULL)
statement ok
ALTER TABLE anothertest ADD TABLE othersub1 AS PARTITION FROM 'a' TO 'string'
WITH NULL VALUES
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
