Changeset: 21125fa9138d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/21125fa9138d
Branch: Jul2021
Log Message:
merged
diffs (65 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer15.test
b/sql/test/SQLancer/Tests/sqlancer15.test
--- a/sql/test/SQLancer/Tests/sqlancer15.test
+++ b/sql/test/SQLancer/Tests/sqlancer15.test
@@ -18,3 +18,61 @@ INSERT INTO t0(c4) VALUES(1), ("epoch_ms
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c1" TINYINT,"c2" BIGINT,CONSTRAINT "t0_c1_pkey" PRIMARY
KEY ("c1"))
+
+statement ok rowcount 1
+INSERT INTO t0(c1) VALUES(3)
+
+statement ok
+CREATE TABLE "t1" ("c0" DOUBLE,"c1" TINYINT)
+
+statement ok rowcount 3
+COPY 3 RECORDS INTO "t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+0.08609425065477394 -1
+NULL NULL
+-45 NULL
+
+statement ok
+CREATE TABLE "t2" ("c1" TINYINT,"c3" REAL,"c4" BIGINT)
+
+statement ok rowcount 20
+COPY 20 RECORDS INTO "t2" FROM stdin USING DELIMITERS E'\t',E'\n','"'
+<COPY_INTO_DATA>
+NULL NULL -1189531030
+NULL NULL -1721683267
+NULL 0.35263324 NULL
+NULL 2.0905742e+09 NULL
+NULL 0.34408945 NULL
+NULL 0.44041038 NULL
+0 8.0997114e+08 1848957376
+1 NULL NULL
+9 NULL NULL
+7 NULL NULL
+9 0.08480057 NULL
+-5 0.15051073 1833181788
+-1 NULL 1269327700
+7 NULL 999905610
+NULL 0.98237896 NULL
+NULL 0.41320944 NULL
+8 NULL NULL
+3 NULL NULL
+NULL NULL NULL
+NULL 0.8227772 NULL
+
+statement ok rowcount 3
+TRUNCATE t1
+
+statement ok rowcount 20
+INSERT INTO t1(c0,c1) (SELECT 0.92, NULL FROM t2)
+
+statement ok rowcount 1
+UPDATE t0 SET c1 = (SELECT t1.c0 FROM t0, t1 GROUP BY t1.c0)
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
