Changeset: 8564daf6f3b9 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8564daf6f3b9 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message:
Subquery assertion error. Looking into it diffs (33 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 @@ -320,9 +320,6 @@ statement ok ROLLBACK statement ok -START TRANSACTION - -statement ok create table t1 (c0 int) statement ok rowcount 4 @@ -333,9 +330,18 @@ SELECT 1 FROM (select 4) v100(vc0) WHERE ---- 1 +statement ok +create view vy(vc0) as (select distinct (select 4 from t1)) + +statement error GDK reported error: mergejoin: more than one match +select greatest(1, (select (select vy.vc0 from t1) from vy)) + 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) statement ok -ROLLBACK +DROP VIEW vy +statement ok +DROP TABLE t1 + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
