Changeset: b26b10651034 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b26b10651034
Modified Files:
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
sql/test/testdb/Tests/load.test
Branch: Aug2024
Log Message:
Test dumping of expression-based partitioned merge tables.
diffs (87 lines):
diff --git a/sql/test/testdb/Tests/dump-nogeom.stable.out
b/sql/test/testdb/Tests/dump-nogeom.stable.out
--- a/sql/test/testdb/Tests/dump-nogeom.stable.out
+++ b/sql/test/testdb/Tests/dump-nogeom.stable.out
@@ -101344,6 +101344,18 @@ 7 "another"
9 "to"
9 "pass"
8 "attempt"
+CREATE MERGE TABLE "testschema"."testme_exp" (
+ "a" INTEGER,
+ "b" VARCHAR(32)
+) PARTITION BY RANGE USING ("sys"."md5"("a"));
+CREATE TABLE "testschema"."subtable_exp1" (
+ "a" INTEGER,
+ "b" VARCHAR(32)
+);
+CREATE TABLE "testschema"."subtable_exp2" (
+ "a" INTEGER,
+ "b" VARCHAR(32)
+);
CREATE REMOTE TABLE "testschema"."remotetable" (
"i" INTEGER
) ON 'mapi:monetdb://remote.host.url:50000/dbname' WITH USER 'bob' ENCRYPTED
PASSWORD
'f8e3183d38e6c51889582cb260ab825252f395b4ac8fb0e6b13e9a71f7c10a80d5301e4a949f2783cb0c20205f1d850f87045f4420ad2271c8fd5f0cd8944be3';
@@ -101441,6 +101453,8 @@ ALTER TABLE "testschema"."testme3" ADD T
ALTER TABLE "testschema"."testvaluespartitions" ADD TABLE
"testschema"."sublimits1" AS PARTITION IN ('1', '2', '3');
ALTER TABLE "testschema"."testvaluespartitions" ADD TABLE
"testschema"."sublimits2" AS PARTITION IN ('4', '5', '6') WITH NULL VALUES;
ALTER TABLE "testschema"."testvaluespartitions" ADD TABLE
"testschema"."sublimits3" AS PARTITION IN ('7', '8', '9');
+ALTER TABLE "testschema"."testme_exp" ADD TABLE "testschema"."subtable_exp1"
AS PARTITION FROM '00000000000000000000000000000000' TO
'7fffffffffffffffffffffffffffffff';
+ALTER TABLE "testschema"."testme_exp" ADD TABLE "testschema"."subtable_exp2"
AS PARTITION FROM '80000000000000000000000000000000' TO
'ffffffffffffffffffffffffffffffff';
ALTER TABLE "testschema"."mt3" ADD TABLE "testschema"."mt1";
ALTER TABLE "testschema"."mt3" ADD TABLE "testschema"."t4";
ALTER TABLE "testschema"."mt2" ADD TABLE "testschema"."t1";
diff --git a/sql/test/testdb/Tests/dump.stable.out
b/sql/test/testdb/Tests/dump.stable.out
--- a/sql/test/testdb/Tests/dump.stable.out
+++ b/sql/test/testdb/Tests/dump.stable.out
@@ -101344,6 +101344,18 @@ 7 "another"
9 "to"
9 "pass"
8 "attempt"
+CREATE MERGE TABLE "testschema"."testme_exp" (
+ "a" INTEGER,
+ "b" VARCHAR(32)
+) PARTITION BY RANGE USING ("sys"."md5"("a"));
+CREATE TABLE "testschema"."subtable_exp1" (
+ "a" INTEGER,
+ "b" VARCHAR(32)
+);
+CREATE TABLE "testschema"."subtable_exp2" (
+ "a" INTEGER,
+ "b" VARCHAR(32)
+);
CREATE REMOTE TABLE "testschema"."remotetable" (
"i" INTEGER
) ON 'mapi:monetdb://remote.host.url:50000/dbname' WITH USER 'bob' ENCRYPTED
PASSWORD
'f8e3183d38e6c51889582cb260ab825252f395b4ac8fb0e6b13e9a71f7c10a80d5301e4a949f2783cb0c20205f1d850f87045f4420ad2271c8fd5f0cd8944be3';
@@ -101459,6 +101471,8 @@ ALTER TABLE "testschema"."testme3" ADD T
ALTER TABLE "testschema"."testvaluespartitions" ADD TABLE
"testschema"."sublimits1" AS PARTITION IN ('1', '2', '3');
ALTER TABLE "testschema"."testvaluespartitions" ADD TABLE
"testschema"."sublimits2" AS PARTITION IN ('4', '5', '6') WITH NULL VALUES;
ALTER TABLE "testschema"."testvaluespartitions" ADD TABLE
"testschema"."sublimits3" AS PARTITION IN ('7', '8', '9');
+ALTER TABLE "testschema"."testme_exp" ADD TABLE "testschema"."subtable_exp1"
AS PARTITION FROM '00000000000000000000000000000000' TO
'7fffffffffffffffffffffffffffffff';
+ALTER TABLE "testschema"."testme_exp" ADD TABLE "testschema"."subtable_exp2"
AS PARTITION FROM '80000000000000000000000000000000' TO
'ffffffffffffffffffffffffffffffff';
ALTER TABLE "testschema"."mt3" ADD TABLE "testschema"."mt1";
ALTER TABLE "testschema"."mt3" ADD TABLE "testschema"."t4";
ALTER TABLE "testschema"."mt2" ADD TABLE "testschema"."t1";
diff --git a/sql/test/testdb/Tests/load.test b/sql/test/testdb/Tests/load.test
--- a/sql/test/testdb/Tests/load.test
+++ b/sql/test/testdb/Tests/load.test
@@ -101509,6 +101509,21 @@ statement ok
INSERT INTO testschema.sublimits3 VALUES (8, 'attempt')
statement ok
+CREATE MERGE TABLE testme_exp (a int, b varchar(32)) PARTITION BY RANGE USING
(sys.md5(a))
+
+statement ok
+CREATE TABLE subtable_exp1 (a int, b varchar(32))
+
+statement ok
+CREATE TABLE subtable_exp2 (a int, b varchar(32))
+
+statement ok
+ALTER TABLE testme_exp ADD TABLE subtable_exp1 AS PARTITION FROM
'00000000000000000000000000000000' TO '7fffffffffffffffffffffffffffffff'
+
+statement ok
+ALTER TABLE testme_exp ADD TABLE subtable_exp2 AS PARTITION FROM
'80000000000000000000000000000000' TO 'ffffffffffffffffffffffffffffffff'
+
+statement ok
CREATE REMOTE TABLE testschema.remotetable (i INTEGER) ON
'mapi:monetdb://remote.host.url:50000/dbname' WITH USER 'bob' ENCRYPTED
PASSWORD
'f8e3183d38e6c51889582cb260ab825252f395b4ac8fb0e6b13e9a71f7c10a80d5301e4a949f2783cb0c20205f1d850f87045f4420ad2271c8fd5f0cd8944be3'
statement ok
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
