Changeset: 5094178fc55f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5094178fc55f
Modified Files:
sql/test/subquery/Tests/subquery7.test
Branch: Jul2021
Log Message:
Small bug I found while testing the unnest issue. Union all on two identical
correlated values should give the cardinality error
diffs (17 lines):
diff --git a/sql/test/subquery/Tests/subquery7.test
b/sql/test/subquery/Tests/subquery7.test
--- a/sql/test/subquery/Tests/subquery7.test
+++ b/sql/test/subquery/Tests/subquery7.test
@@ -125,4 +125,13 @@ UPDATE "mytables" SET system = true WHER
)
statement ok
+create table t_qh(c_f INTEGER, c_y2 INTEGER)
+
+statement ok rowcount 3
+insert into t_qh values (1,1), (2,2), (3,3)
+
+statement error GDK reported error: BATsubcross: more than one match
+select 1 from t_qh where 3 = (select c_y2 union all select c_f)
+
+statement ok
ROLLBACK
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
