Changeset: 5779c7079b59 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5779c7079b59
Modified Files:
sql/server/rel_distribute.c
sql/test/SQLancer/Tests/sqlancer19.SQL.py
Branch: default
Log Message:
Look on left and right relations after possibly doing rel_copy
diffs (33 lines):
diff --git a/sql/server/rel_distribute.c b/sql/server/rel_distribute.c
--- a/sql/server/rel_distribute.c
+++ b/sql/server/rel_distribute.c
@@ -190,7 +190,6 @@ replica(visitor *v, sql_rel *rel)
static sql_rel *
distribute(visitor *v, sql_rel *rel)
{
- sql_rel *l = rel->l, *r = rel->r;
prop *p, *pl, *pr;
/* for merge statement join, ignore the multiple references */
@@ -204,6 +203,7 @@ distribute(visitor *v, sql_rel *rel)
return rel;
}
}
+ sql_rel *l = rel->l, *r = rel->r; /* look on left and right relations
after possibly doing rel_copy */
switch (rel->op) {
case op_basetable: {
diff --git a/sql/test/SQLancer/Tests/sqlancer19.SQL.py
b/sql/test/SQLancer/Tests/sqlancer19.SQL.py
--- a/sql/test/SQLancer/Tests/sqlancer19.SQL.py
+++ b/sql/test/SQLancer/Tests/sqlancer19.SQL.py
@@ -240,6 +240,10 @@ with SQLTestCase() as cli:
.assertSucceeded()
cli.execute("select 1 from v4, v5, v6;") \
.assertSucceeded().assertDataResultMatch([])
+ cli.execute("create view v7(vc0) as (select case '201' when ',' then
rt3.c0 when '' then cast(rt3.c0 as bigint) end from rt3);") \
+ .assertSucceeded()
+ cli.execute("SELECT 1 FROM v7 CROSS JOIN ((SELECT 1) UNION ALL (SELECT 2))
AS sub0(c0);") \
+
.assertSucceeded().assertDataResultMatch([(1,),(1,),(1,),(1,),(1,),(1,),(1,),(1,),(1,),(1,),(1,),(1,)])
cli.execute("ROLLBACK;")
cli.execute("""
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
