Changeset: b2395f569840 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b2395f569840 Modified Files: sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test Branch: unnest2 Log Message:
approved output diffs (17 lines): diff --git a/sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test b/sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test --- a/sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test +++ b/sql/test/BugTracker-2021/Tests/batappend-undefined.Bug-7130.test @@ -57,8 +57,12 @@ select (subq_0.c0 = case when EXISTS ( s statement error GDK reported error: BATsubcross: more than one match select (select (select 1 where subq_0.c0 = (select subq_0.c1 from t_qh)) from (select 320, 1) subq_0(c0,c1)) from (select 2) subq_0(c3) -statement error GDK reported error: BATsubcross: more than one match +query I select 1 from t_qh left outer join (select 2) as subq_0(c1) on EXISTS(select 1 from t_qh as ref_6 where 2 = (select 1 from t_qh where ref_6.c_f = 1 or subq_0.c1 is NULL)) +---- +1 +1 +1 statement error GDK reported error: mergejoin: more than one match select EXISTS(select 1 from t_qh left outer join (select cast(2 as INTEGER) from t_qh) as subq_0(c1) on true <> EXISTS(select 1 from t_qh as ref_6 where 2 < _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
