Changeset: c43212ad8a27 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c43212ad8a27
Modified Files:
sql/test/dict/Tests/dict01.test
Branch: Jan2022
Log Message:
dict: algebra.select undefined
diffs (90 lines):
diff --git a/sql/test/dict/Tests/dict01.test b/sql/test/dict/Tests/dict01.test
--- a/sql/test/dict/Tests/dict01.test
+++ b/sql/test/dict/Tests/dict01.test
@@ -41,12 +41,6 @@ statement ok
START TRANSACTION
statement ok
-DROP ALL PROCEDURE "sys"."dict_compress"
-
-statement ok
-DROP ALL PROCEDURE "sys"."for_compress"
-
-statement ok
DROP TABLE "mct20"
statement ok
@@ -54,3 +48,73 @@ DROP TABLE "mct21"
statement ok
COMMIT
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t1" ("c0" UUID,"c1" SMALLINT NOT NULL)
+
+statement ok rowcount 9
+COPY 9 RECORDS INTO "t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+c036a4cf-ecec-57d1-9aca-6dce4eb8d12b 5
+df1bcbac-01e3-81bc-a7c2-c2769fc9751a 0
+NULL 7
+NULL 9
+NULL 1
+NULL 3
+bb4fb0da-aff1-1919-f4eb-abaaf9e6b1f7 6
+648be74d-ccff-ea44-fd64-dfcb3a8c5b6c 8
+fb7c955a-defd-1b91-0aca-aecfc8a0c5aa 2
+
+statement ok
+CREATE TABLE "t0" ("c0" BIGINT NOT NULL)
+
+statement ok rowcount 11
+COPY 11 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+1
+5
+3
+8
+-1
+9
+4
+2
+6
+0
+7
+
+statement ok
+COMMIT
+
+statement ok
+CALL "sys"."dict_compress"('sys','t0','c0',false)
+
+statement ok rowcount 11
+INSERT INTO t1(c0, c1)(SELECT UUID '7A4A6b8b-e7f9-FA09-5650-6d1c83B1fc69',
t0.c0 FROM t0)
+
+statement ok
+START TRANSACTION
+
+statement ok
+DROP TABLE "t0"
+
+statement ok
+DROP TABLE "t1"
+
+statement ok
+COMMIT
+
+statement ok
+START TRANSACTION
+
+statement ok
+DROP ALL PROCEDURE "sys"."dict_compress"
+
+statement ok
+DROP ALL PROCEDURE "sys"."for_compress"
+
+statement ok
+COMMIT
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
