Changeset: 2435e6570739 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/2435e6570739
Modified Files:
sql/server/sql_parser.y
sql/test/SQLancer/Tests/sqlancer18.test
Branch: Jan2022
Log Message:
Missing feature: with queries inside IN and ANY/ALL subqueries
diffs (43 lines):
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -3058,6 +3058,7 @@ insert_atom:
value:
search_condition
| select_no_parens
+ | with_query
;
opt_distinct:
@@ -3608,7 +3609,7 @@ comparison_predicate:
append_symbol(l, $5);
append_int(l, $3);
$$ = _symbol_create_list(SQL_COMPARE, l ); }
- | pred_exp '=' any_all_some '(' value ')'
+ | pred_exp '=' any_all_some '(' value ')'
{ dlist *l = L();
append_symbol(l, $1);
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
@@ -637,3 +637,19 @@ query T nosort
SELECT ((SELECT 5) INTERSECT (SELECT 9)) = ALL(SELECT 4) >= TRUE
----
NULL
+
+query T nosort
+SELECT 1 = ANY(WITH x(x) AS (SELECT 1) SELECT x FROM x)
+----
+True
+
+query T nosort
+SELECT 1 IN (WITH x(x) AS (SELECT 1) SELECT x FROM x)
+----
+True
+
+query T nosort
+SELECT EXISTS (WITH x(x) AS (SELECT 1) SELECT x FROM x)
+----
+True
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
