Changeset: eca804f5a7b9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/eca804f5a7b9 Modified Files: sql/test/SQLancer/Tests/sqlancer14.test Branch: default Log Message:
Simplify test diffs (51 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 @@ -584,7 +584,7 @@ statement ok TRUNCATE t1 statement ok -COPY 10 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"' +COPY 18 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" @@ -596,27 +596,22 @@ 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') +3.000 4 "1970-02-01 01:00:00.000000" +6.000 2 "1970-01-01 01:00:00.000000" +-5.000 1 "1970-01-01 01:00:00.000000" +7.000 NULL "1969-12-17 07:47:25.000000" +0.000 NULL "1969-12-17 07:47:25.000000" +6.000 NULL "1969-12-17 07:47:25.000000" +0.000 NULL "1969-12-17 07:47:25.000000" +2.000 NULL "1969-12-12 05:50:27.000000" statement ok INSERT INTO t1(c1) VALUES(INTERVAL '4' SECOND), (INTERVAL '6' SECOND) statement ok +INSERT INTO t0(c0, c1) VALUES(DATE '1970-01-01', INTERVAL '4' SECOND), (DATE '1970-01-01', INTERVAL '3' SECOND) + +statement ok UPDATE t1 SET c1 = INTERVAL '3' SECOND FROM t0 WHERE t1.c1 BETWEEN t0.c1 AND t0.c1 statement ok _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
