MonetDB: default - Also swap subquery to rhs on values lists

[Pedro Ferreira]

Changeset: f02c374b8036 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f02c374b8036
Modified Files:
        sql/server/rel_select.c
Branch: default
Log Message:

Also swap subquery to rhs on values lists


diffs (14 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
@@ -1742,8 +1742,8 @@ rel_compare(sql_query *query, sql_rel *r
                compare_op = "=";
        }
 
-       if (!ro2 && (lo->token == SQL_SELECT || lo->token == SQL_UNION || 
lo->token == SQL_EXCEPT || lo->token == SQL_INTERSECT) &&
-               (ro->token != SQL_SELECT && ro->token != SQL_UNION && ro->token 
!= SQL_EXCEPT && ro->token != SQL_INTERSECT)) {
+       if (!ro2 && (lo->token == SQL_SELECT || lo->token == SQL_UNION || 
lo->token == SQL_EXCEPT || lo->token == SQL_INTERSECT || lo->token == 
SQL_VALUES) &&
+               (ro->token != SQL_SELECT && ro->token != SQL_UNION && ro->token 
!= SQL_EXCEPT && ro->token != SQL_INTERSECT && ro->token != SQL_VALUES)) {
                symbol *tmp = lo; /* swap subquery to the right hand side */
 
                lo = ro;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list