Changeset: ccacc382c31c for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ccacc382c31c Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message:
Query with wrong results diffs (15 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLancer/Tests/sqlancer18.test --- a/sql/test/SQLancer/Tests/sqlancer18.test +++ b/sql/test/SQLancer/Tests/sqlancer18.test @@ -329,6 +329,11 @@ create table t1 (c0 int) statement ok rowcount 4 insert into t1 values (1),(2),(3),(NULL) +query I rowsort +SELECT 1 FROM (select 4) v100(vc0) WHERE (3) NOT IN (COALESCE((SELECT 1 WHERE FALSE), v100.vc0)) +---- +1 + statement error GDK reported error: mergejoin: more than one match select 1 from t1 where exists (select min((select t2.c0 from t1)) from t1 as t2) _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
