Changeset: ae0662640514 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ae0662640514 Modified Files: sql/test/SQLancer/Tests/sqlancer03.sql sql/test/SQLancer/Tests/sqlancer03.stable.out Branch: Jun2020 Log Message:
Approved output diffs (37 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql b/sql/test/SQLancer/Tests/sqlancer03.sql --- a/sql/test/SQLancer/Tests/sqlancer03.sql +++ b/sql/test/SQLancer/Tests/sqlancer03.sql @@ -147,4 +147,8 @@ START TRANSACTION; create table t0 (a int, b int); insert into t0 values (1,1), (2,2); select min(t0.a), pi() from t0 group by t0.b; + +SELECT 1 FROM t0 WHERE DATE '1970-01-01' = NULL; +SELECT 1 FROM t0 WHERE NULL IN (DATE '1970-01-01'); +SELECT ALL DATE '1970-01-01', CAST(COUNT(ALL TIMESTAMP '1970-01-01 01:06:52') AS INT) FROM t0 WHERE (NULL) NOT IN (DATE '1970-01-01') GROUP BY ((CAST(0.6 AS STRING))||(0.75)), INTERVAL '-13' SECOND; ROLLBACK; diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out b/sql/test/SQLancer/Tests/sqlancer03.stable.out --- a/sql/test/SQLancer/Tests/sqlancer03.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out @@ -242,6 +242,21 @@ stdout of test 'sqlancer03` in directory % 1, 24 # length [ 1, 3.141592654 ] [ 2, 3.141592654 ] +#SELECT 1 FROM t0 WHERE DATE '1970-01-01' = NULL; +% .%1 # table_name +% %1 # name +% tinyint # type +% 1 # length +#SELECT 1 FROM t0 WHERE NULL IN (DATE '1970-01-01'); +% .%3 # table_name +% %3 # name +% tinyint # type +% 1 # length +#SELECT ALL DATE '1970-01-01', CAST(COUNT(ALL TIMESTAMP '1970-01-01 01:06:52') AS INT) FROM t0 WHERE (NULL) NOT IN (DATE '1970-01-01') GROUP BY ((CAST(0.6 AS STRING))||(0.75)), INTERVAL '-13' SECOND; +% .%11, .%7 # table_name +% %11, %7 # name +% date, int # type +% 10, 1 # length #ROLLBACK; # 17:14:16 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list