Changeset: 073f32072e25 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=073f32072e25 Modified Files: sql/test/SQLancer/Tests/sqlancer05.sql sql/test/SQLancer/Tests/sqlancer05.stable.out Branch: Oct2020 Log Message:
Made insert succeed and approved output diffs (29 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer05.sql b/sql/test/SQLancer/Tests/sqlancer05.sql --- a/sql/test/SQLancer/Tests/sqlancer05.sql +++ b/sql/test/SQLancer/Tests/sqlancer05.sql @@ -73,7 +73,7 @@ NULL 0.385788843525793 true 0.6696036757274413 false 0.3589261452091549 -INSERT INTO t2(c0) VALUES (CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02' END BETWEEN TIMESTAMP '1970-01-05 05:04:47' AND TIMESTAMP '1970-01-01 20:00:35'); -INSERT INTO t2(c0) VALUES(NOT ((CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02' ELSE TIMESTAMP '1970-01-02 23:25:05' END) -NOT BETWEEN SYMMETRIC (COALESCE(TIMESTAMP '1969-12-30 12:07:22', TIMESTAMP '1970-01-05 05:04:47')) AND (CASE WHEN TRUE THEN TIMESTAMP '1970-01-01 20:00:35' END))); +INSERT INTO t2 VALUES (CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02' END BETWEEN TIMESTAMP '1970-01-05 05:04:47' AND TIMESTAMP '1970-01-01 20:00:35', 1); +INSERT INTO t2 VALUES(NOT ((CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02' ELSE TIMESTAMP '1970-01-02 23:25:05' END) +NOT BETWEEN SYMMETRIC (COALESCE(TIMESTAMP '1969-12-30 12:07:22', TIMESTAMP '1970-01-05 05:04:47')) AND (CASE WHEN TRUE THEN TIMESTAMP '1970-01-01 20:00:35' END)), 2); ROLLBACK; diff --git a/sql/test/SQLancer/Tests/sqlancer05.stable.out b/sql/test/SQLancer/Tests/sqlancer05.stable.out --- a/sql/test/SQLancer/Tests/sqlancer05.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer05.stable.out @@ -105,6 +105,11 @@ stdout of test 'sqlancer05` in directory #true 0.6696036757274413 #false 0.3589261452091549 [ 3 ] +#INSERT INTO t2 VALUES (CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02' END BETWEEN TIMESTAMP '1970-01-05 05:04:47' AND TIMESTAMP '1970-01-01 20:00:35', 1); +[ 1 ] +#INSERT INTO t2 VALUES(NOT ((CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02' ELSE TIMESTAMP '1970-01-02 23:25:05' END) +#NOT BETWEEN SYMMETRIC (COALESCE(TIMESTAMP '1969-12-30 12:07:22', TIMESTAMP '1970-01-05 05:04:47')) AND (CASE WHEN TRUE THEN TIMESTAMP '1970-01-01 20:00:35' END)), 2); +[ 1 ] #ROLLBACK; # 12:00:38 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
