Changeset: b5f3921d9e06 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b5f3921d9e06
Modified Files:
sql/test/dict/Tests/dict01.test
Branch: Jan2022
Log Message:
Added test for recent fix
diffs (100 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
@@ -248,6 +248,96 @@ statement ok
START TRANSACTION
statement ok
+CREATE SEQUENCE "sys"."seq_8393" AS INTEGER
+
+statement ok
+CREATE TABLE "sys"."t0" ("c0" DECIMAL(18,3),"c1" BIGINT DEFAULT next value for
"sys"."seq_8393")
+
+statement ok rowcount 35
+COPY 35 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.869 -1519170928
+0.755 34
+0.690 -500094807
+NULL -1007149659
+NULL -1182606787
+0.978 2141158291
+0.734 1
+0.757 2
+0.685 3
+0.876 4
+0.237 5
+NULL 6
+0.998 643115392
+0.395 -1477930933
+0.163 7
+0.049 -1127189901
+0.069 -1127508051
+6.000 1895794951
+0.963 -711543940
+0.808 -1
+0.722 -9223372036854775807
+0.616 8
+NULL 1896254920
+0.352 9
+0.135 0
+0.306 10
+NULL 44
+NULL -68731387
+NULL -259682535
+NULL -413188411
+NULL 2060626791
+NULL -1819302001
+0.353 1671526830
+NULL 49
+NULL 5989
+
+statement ok
+ALTER SEQUENCE "sys"."seq_8393" RESTART WITH 11 NO CYCLE
+
+statement ok
+COMMIT
+
+statement ok
+CALL "sys"."dict_compress"('sys','t0','c1',true)
+
+statement ok
+START TRANSACTION
+
+statement ok rowcount 2
+INSERT INTO t0(c1) VALUES(1419068893), (least(json."integer"(JSON 'null'),
sqrt((SELECT DISTINCT 421689172 WHERE TRUE))))
+
+statement ok rowcount 37
+UPDATE t0 SET c1 = DEFAULT
+
+statement ok rowcount 24
+INSERT INTO t0(c1) VALUES(718095040), (-598203097), (0), (447346516),
(1872246785), (-401674441),
(-1541029518),(541285281),(-2111339894),(-2131974587),(-4855319),
+(776811174),(419815752),(-872811856), (-1283391645),(1459537807), (716010206),
(NULL), (131493150), (326028168), (-1959786633),(1432852950), (21),
(-1830329263)
+
+statement ok rowcount 35
+INSERT INTO t0(c0) VALUES(3), (0.686), (0.454), (0.868),(0.686),(0.5),
(0.353), (0.454), (0.54), (0.54), (0.342), (-969122634),(0.2), (0.5),
(4),(0.342),
+(0.7), (0.9), (0.57), (0.99), (0.5645),(0.342),(0.78), (0.86),(2),
(0.46),(0.242), (0.66), (0.11),(0.686), (0.65), (0.65), (1), (0.53), (0.454)
+
+statement ok rowcount 12
+INSERT INTO t0(c0, c1) VALUES(0.2342, 1313410006), (2, 1669659098), (0.45,
512732037), (0.768, -1635964182), (0.68, 2),(0.9, DEFAULT), (0.354, -860428240),
+(0.45, -2077612165),(0.54, 114),(0.585, -766044021), (0.646, -760724786),
(0.33, 519176898)
+
+statement ok rowcount 5
+INSERT INTO t0(c1, c0) VALUES(-1226601715, 0.545), (313, 0.68),(1613852187,
0.234),(1296111754, 0.75),(-1806857005, 0.767)
+
+statement ok
+UPDATE t0 SET c1 = DEFAULT FROM (SELECT 1) x(x)
+
+statement ok
+ROLLBACK
+
+statement ok
+DROP TABLE t0
+
+statement ok
+START TRANSACTION
+
+statement ok
DROP ALL PROCEDURE "sys"."dict_compress"
statement ok
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
