Changeset: 868f25080dfa for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=868f25080dfa Modified Files: sql/test/SQLancer/Tests/sqlancer06.sql sql/test/SQLancer/Tests/sqlancer06.stable.out Branch: Oct2020 Log Message:
Approved output diffs (48 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql b/sql/test/SQLancer/Tests/sqlancer06.sql --- a/sql/test/SQLancer/Tests/sqlancer06.sql +++ b/sql/test/SQLancer/Tests/sqlancer06.sql @@ -346,5 +346,5 @@ NULL 0.824 NULL NULL select cast((t2.c0) not in ((select all 1.360204425E9 from t0), t2.c0) as int) from t1 full outer join t2 on false; - --error, more than one row returned by a subquery used as an expression + --5 0s 2 NULLs ROLLBACK; diff --git a/sql/test/SQLancer/Tests/sqlancer06.stable.out b/sql/test/SQLancer/Tests/sqlancer06.stable.out --- a/sql/test/SQLancer/Tests/sqlancer06.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer06.stable.out @@ -556,10 +556,34 @@ stdout of test 'sqlancer06` in directory #946154646 #0.5253008674729628 [ 5 ] +#select cast((t2.c0) not in ((select all 1.360204425E9 from t0), t2.c0) as int) from t1 full outer join t2 on false; +% .%7 # table_name +% %7 # name +% int # type +% 1 # length +[ NULL ] +[ NULL ] +[ 0 ] +[ 0 ] +[ 0 ] +[ 0 ] +[ 0 ] #COPY 2 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"'; #NULL 0.824 #NULL NULL [ 2 ] +#select cast((t2.c0) not in ((select all 1.360204425E9 from t0), t2.c0) as int) from t1 full outer join t2 on false; +% .%7 # table_name +% %7 # name +% int # type +% 1 # length +[ NULL ] +[ NULL ] +[ 0 ] +[ 0 ] +[ 0 ] +[ 0 ] +[ 0 ] #ROLLBACK; # 19:38:32 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
