Changeset: 37a671183baf for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/37a671183baf Modified Files: sql/test/SQLancer/Tests/sqlancer14.test Branch: default Log Message:
Crash on BATproject2 diffs (76 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer14.test b/sql/test/SQLancer/Tests/sqlancer14.test --- a/sql/test/SQLancer/Tests/sqlancer14.test +++ b/sql/test/SQLancer/Tests/sqlancer14.test @@ -555,3 +555,72 @@ True statement ok ROLLBACK + +statement ok +CREATE TABLE t0(c0 DATE, c1 INTERVAL SECOND PRIMARY KEY DEFAULT INTERVAL '0' SECOND, c2 bigint) + +statement ok +CREATE TABLE t1(c1 INTERVAL SECOND, c2 bigint, c5 TIMESTAMP) + +statement ok +COPY 14 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"' +<COPY_INTO_DATA> +84369713.000 NULL "1970-01-01 01:00:00.000000" +833671629.000 NULL "1970-01-01 01:00:00.000000" +0.000 1 NULL +2.000 5 NULL +3.000 3 NULL +3.000 3 NULL +9.000 -10 "1970-01-01 01:00:00.000000" +6.000 -4 "1970-01-01 01:00:00.000000" +0.000 2 "1970-01-01 01:00:00.000000" +2.000 2 "1970-01-01 01:00:00.000000" +9.000 7 "1970-01-01 01:00:00.000000" +4.000 0 "1970-01-01 01:00:00.000000" +1.000 1 "1970-01-01 01:00:00.000000" +2.000 NULL "1970-01-01 01:00:00.000000" + +statement ok +TRUNCATE t1 + +statement ok +COPY 10 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"' +<COPY_INTO_DATA> +8.000 3 "1970-01-06 06:36:14.000000" +-72732622.000 2 "1970-01-01 01:00:00.000000" +NULL -3 "1969-12-15 13:58:34.000000" +NULL 2 NULL +NULL 9 "1970-01-07 17:53:24.000000" +NULL 7 NULL +NULL 9 NULL +NULL 2 NULL +NULL 8 NULL +NULL 9 NULL + +statement ok +INSERT INTO t0(c0, c1) VALUES(DATE '1970-01-01', INTERVAL '4' SECOND) + +statement ok +INSERT INTO t1(c1, c5, c2) VALUES(INTERVAL '3' SECOND, TIMESTAMP '1970-02-01 01:00:00', 4), (INTERVAL '6' SECOND, TIMESTAMP '1970-01-01 01:00:00', 2), (INTERVAL '-5' SECOND, TIMESTAMP '1970-01-01 01:00:00', 1) + +statement ok +DELETE FROM t0 + +statement ok +INSERT INTO t1(c1, c5) VALUES(INTERVAL '7' SECOND, TIMESTAMP '1969-12-17 07:47:25'), (INTERVAL '0' SECOND, TIMESTAMP '1969-12-17 07:47:25'), (INTERVAL '6' SECOND, TIMESTAMP '1969-12-17 07:47:25'), +(INTERVAL '0' SECOND, TIMESTAMP '1969-12-17 07:47:25'), (INTERVAL '2' SECOND, TIMESTAMP '1969-12-12 05:50:27') + +statement ok +INSERT INTO t0(c0) VALUES(DATE '1970-01-01') + +statement ok +INSERT INTO t1(c1) VALUES(INTERVAL '4' SECOND), (INTERVAL '6' SECOND) + +statement ok +UPDATE t1 SET c1 = INTERVAL '3' SECOND FROM t0 WHERE t1.c1 BETWEEN t0.c1 AND t0.c1 + +statement ok +DROP TABLE t0 + +statement ok +DROP TABLE t1 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
