Changeset: d50d69c7447e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d50d69c7447e
Modified Files:
sql/server/rel_select.c
sql/test/subquery/Tests/subquery6.test
Branch: default
Log Message:
Expect basetables here
diffs (24 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -2050,7 +2050,7 @@ rel_in_value_exp(sql_query *query, sql_r
}
}
if (!e) {
- if (add_select && rel && *rel &&
!is_project((*rel)->op) && !is_select((*rel)->op))
+ if (add_select && rel && *rel &&
!is_project((*rel)->op) && !is_select((*rel)->op) && !is_base((*rel)->op))
*rel = rel_select(sql->sa, *rel, NULL);
e = exp_in_func(sql, le, values, (sc->token == SQL_IN),
is_tuple);
}
diff --git a/sql/test/subquery/Tests/subquery6.test
b/sql/test/subquery/Tests/subquery6.test
--- a/sql/test/subquery/Tests/subquery6.test
+++ b/sql/test/subquery/Tests/subquery6.test
@@ -407,7 +407,7 @@ select 1 = any(ColID), max(totalsales) f
statement error 42000!SELECT: cannot use non GROUP BY column
'tbl_productsales.colid' in query results without an aggregate function
select 1 in (ColID), max(totalsales) from tbl_ProductSales
-statement error 42000!SELECT: cannot use non GROUP BY column in query results
without an aggregate function
+statement error 42000!SELECT: cannot use non GROUP BY column
'tbl_productsales.colid' in query results without an aggregate function
select 1 in (ColID, (select 1)), max(totalsales) from tbl_ProductSales
statement error 42000!Tuple matching at projections not implemented in the
backend yet
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
