Changeset: 8390e967d1d6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8390e967d1d6 Modified Files: sql/test/SQLancer/Tests/sqlancer05.stable.out Branch: Oct2020 Log Message:
Approved output diffs (26 lines): 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 @@ -218,6 +218,22 @@ stdout of test 'sqlancer05` in directory #-1804793562 [ 4 ] #create view v0(c0, c1) as (select distinct t0.c0, t0.c2 from t2, t0 where t0.c1); +#SELECT 1 FROM v0, t0 JOIN t1 ON t0.c1 WHERE (CASE CASE t0.c0 WHEN t0.c0 THEN t1.c1 END WHEN t1.c1 THEN v0.c1 END) BETWEEN (v0.c1) AND (t0.c2); +% .%3 # table_name +% %3 # name +% tinyint # type +% 1 # length +#SELECT count(agg0) FROM ( +#SELECT ALL sum(ALL t1.c1) as agg0 FROM v0, t0 JOIN t1 ON t0.c1 CROSS JOIN t2 WHERE (CASE CASE t0.c0 WHEN t0.c0 THEN t1.c1 END WHEN t1.c1 THEN v0.c1 END) NOT BETWEEN ASYMMETRIC (v0.c1) AND (t0.c2) +#UNION ALL +#SELECT ALL sum(ALL t1.c1) as agg0 FROM v0, t0 JOIN t1 ON t0.c1 CROSS JOIN t2 WHERE NOT ((CASE CASE t0.c0 WHEN t0.c0 THEN t1.c1 END WHEN t1.c1 THEN v0.c1 END) NOT BETWEEN ASYMMETRIC (v0.c1) AND (t0.c2)) +#UNION ALL +#SELECT ALL sum(ALL t1.c1) as agg0 FROM v0, t0 JOIN t1 ON t0.c1 CROSS JOIN t2 WHERE ((CASE CASE t0.c0 WHEN t0.c0 THEN t1.c1 END WHEN t1.c1 THEN v0.c1 END) NOT BETWEEN ASYMMETRIC (v0.c1) AND (t0.c2)) IS NULL +% .%32 # table_name +% %32 # name +% bigint # type +% 1 # length +[ 0 ] #ROLLBACK; # 12:00:38 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
