Changeset: 185eda0d6ee8 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/185eda0d6ee8 Modified Files: sql/test/SQLancer/Tests/sqlancer18.test Branch: default Log Message:
I hope this is the same issue as the workbench diffs (28 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 @@ -330,15 +330,21 @@ SELECT 1 FROM (select 4) v100(vc0) WHERE ---- 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) + +query I rowsort +with v100(vc0) as (select max(2) group by 0.2) +select 1 from v100 as vx where vx.vc0 = any(select vx.vc0 from v100) +---- +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 DROP VIEW vy _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
