Changeset: 39e27536177d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=39e27536177d
Added 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/mergepart08.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/mergepart28.test.in
sql/test/merge-partitions/Tests/mergepart30.test
sql/test/merge-partitions/Tests/mergepart31.test
Branch: mtest
Log Message:
Convert sql/test/merge-partitions tests
diffs (truncated from 4249 to 300 lines):
diff --git a/sql/test/merge-partitions/Tests/mergepart00.test
b/sql/test/merge-partitions/Tests/mergepart00.test
new file mode 100644
--- /dev/null
+++ b/sql/test/merge-partitions/Tests/mergepart00.test
@@ -0,0 +1,30 @@
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+0
+
+statement error
+CREATE MERGE TABLE myfirstattempt (a int, b varchar(32)) PARTITION BY RANGE ON
(d)
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+0
+
+statement ok
+CREATE MERGE TABLE mysecondattempt (a int, b varchar(32)) PARTITION BY RANGE
ON (a)
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+1
+
+statement ok
+DROP TABLE mysecondattempt
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+0
+
+
diff --git a/sql/test/merge-partitions/Tests/mergepart01.test
b/sql/test/merge-partitions/Tests/mergepart01.test
new file mode 100644
--- /dev/null
+++ b/sql/test/merge-partitions/Tests/mergepart01.test
@@ -0,0 +1,128 @@
+statement ok
+CREATE SCHEMA other_schema
+
+statement ok
+CREATE MERGE TABLE testme (a int, b varchar(32)) PARTITION BY RANGE ON (a)
+
+statement ok
+ALTER TABLE testme SET SCHEMA other_schema
+
+statement ok
+ALTER TABLE other_schema.testme SET SCHEMA sys
+
+statement ok
+ALTER TABLE testme RENAME TO testme2
+
+statement ok
+ALTER TABLE testme2 RENAME TO testme
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+1
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+statement ok
+CREATE TABLE subtable1 (a int, b varchar(32))
+
+statement ok
+ALTER TABLE testme ADD TABLE subtable1 AS PARTITION FROM 5 TO 10
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+1
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+1
+
+statement error
+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
+ALTER TABLE testme ADD TABLE wrongtable AS PARTITION FROM 5 TO 6
+
+statement ok
+CREATE TABLE subtable2 (a int, b varchar(32))
+
+statement error
+ALTER TABLE testme ADD TABLE subtable2 AS PARTITION IN ('0', '1', '2')
+
+statement error
+ALTER TABLE testme ADD TABLE subtable2 AS PARTITION FROM 7 TO 9
+
+statement ok
+ALTER TABLE testme ADD TABLE subtable2 AS PARTITION FROM 5 TO 5
+
+statement ok
+ALTER TABLE testme DROP TABLE subtable2
+
+statement error
+DROP TABLE subtable1
+
+statement error
+ALTER TABLE testme SET SCHEMA other_schema
+
+statement error
+ALTER TABLE subtable1 SET SCHEMA other_schema
+
+statement error
+ALTER TABLE subtable1 RENAME TO subtable3
+
+statement ok
+ALTER TABLE testme DROP TABLE subtable1
+
+statement ok
+ALTER TABLE subtable1 SET SCHEMA other_schema
+
+statement error
+ALTER TABLE testme ADD TABLE other_schema.subtable1 AS PARTITION FROM 4 TO 23
+
+statement ok
+ALTER TABLE testme ADD TABLE subtable2 AS PARTITION FROM 5 TO 5
+
+statement ok
+ALTER TABLE testme DROP TABLE subtable2
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+1
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+statement ok
+DROP TABLE testme
+
+statement ok
+DROP TABLE wrongtable
+
+statement ok
+DROP TABLE subtable2
+
+statement ok
+DROP SCHEMA other_schema CASCADE
+
+query I rowsort
+SELECT COUNT(*) from table_partitions
+----
+0
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+
diff --git a/sql/test/merge-partitions/Tests/mergepart02.test
b/sql/test/merge-partitions/Tests/mergepart02.test
new file mode 100644
--- /dev/null
+++ b/sql/test/merge-partitions/Tests/mergepart02.test
@@ -0,0 +1,80 @@
+statement ok
+CREATE MERGE TABLE listparts (a int, b varchar(32)) PARTITION BY VALUES ON (a)
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+query I rowsort
+SELECT COUNT(*) from value_partitions
+----
+0
+
+statement ok
+CREATE TABLE subtable1 (a int, b varchar(32))
+
+statement ok
+ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION IN ('1', '2', '3')
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+query I rowsort
+SELECT COUNT(*) from value_partitions
+----
+3
+
+statement ok
+CREATE TABLE subtable2 (a int, b varchar(32))
+
+statement error
+ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM 5 TO 10
+
+statement error
+ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION IN ('3', '4', '5')
+
+statement ok
+ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION IN ('5', '6', '7')
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+query I rowsort
+SELECT COUNT(*) from value_partitions
+----
+6
+
+statement error
+DROP TABLE subtable1
+
+statement ok
+ALTER TABLE listparts DROP TABLE subtable1
+
+statement ok
+ALTER TABLE listparts DROP TABLE subtable2
+
+statement ok
+DROP TABLE listparts
+
+statement ok
+DROP TABLE subtable1
+
+statement ok
+DROP TABLE subtable2
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+query I rowsort
+SELECT COUNT(*) from value_partitions
+----
+0
+
+
diff --git a/sql/test/merge-partitions/Tests/mergepart03.test
b/sql/test/merge-partitions/Tests/mergepart03.test
new file mode 100644
--- /dev/null
+++ b/sql/test/merge-partitions/Tests/mergepart03.test
@@ -0,0 +1,63 @@
+statement ok
+CREATE MERGE TABLE listparts (a int, b varchar(32)) PARTITION BY RANGE ON (a)
+
+statement ok
+CREATE TABLE subtable1 (a int, b varchar(32))
+
+statement ok
+CREATE TABLE subtable2 (a int, b varchar(32))
+
+statement ok
+START TRANSACTION
+
+statement ok
+ALTER TABLE listparts ADD TABLE subtable1 AS PARTITION FROM '-4' TO '12'
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+1
+
+statement ok
+ROLLBACK
+
+statement ok
+INSERT INTO subtable2 VALUES (1, 'hello')
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+0
+
+statement ok
+ALTER TABLE listparts ADD TABLE subtable2 AS PARTITION FROM '-4' TO '12'
+
+query I rowsort
+SELECT COUNT(*) from range_partitions
+----
+1
+
+statement ok
+ALTER TABLE listparts DROP TABLE subtable2
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
