MonetDB: Oct2020 - Extend cases for left join

[Pedro Ferreira]

Changeset: c350fc8e7559 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c350fc8e7559
Modified Files:
        sql/server/rel_unnest.c
        sql/test/SQLancer/Tests/sqlancer11.stable.out
Branch: Oct2020
Log Message:

Extend cases for left join


diffs (51 lines):

diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c
--- a/sql/server/rel_unnest.c
+++ b/sql/server/rel_unnest.c
@@ -2562,7 +2562,7 @@ rewrite_compare(visitor *v, sql_rel *rel
                                        set_processed(rsq);
                                }
                                if (rsq)
-                                       (void)rewrite_inner(v->sql, rel, rsq, 
is_cnt?op_left:op_join);
+                                       (void)rewrite_inner(v->sql, rel, rsq, 
((!quantifier && depth > 0)||is_cnt)?op_left:op_join);
 
                                if (rel_convert_types(v->sql, NULL, NULL, &le, 
&re, 1, type_equal) < 0)
                                        return NULL;
diff --git a/sql/test/SQLancer/Tests/sqlancer11.stable.out 
b/sql/test/SQLancer/Tests/sqlancer11.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer11.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer11.stable.out
@@ -174,6 +174,35 @@ stdout of test 'sqlancer11` in directory
 [ true ]
 [ true ]
 #ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "sys"."t1" ("c1" TINYINT,"c2" CHAR(22),"c4" INTEGER);
+#INSERT INTO "sys"."t1" VALUES (NULL, NULL, 0),(NULL, NULL, -391221783),(NULL, 
NULL, -1107653660),(NULL, NULL, 0),(7, 'cTR'' Abp', 0),(7, 'cTR'' Abp', 1),(7, 
'cTR'' Abp', -1);
+[ 7    ]
+#SELECT t1.c2 FROM t1 WHERE CASE 3 WHEN ((SELECT 0.48) INTERSECT DISTINCT 
(SELECT -1.2)) THEN FALSE ELSE TRUE END;
+% .t1 # table_name
+% c2 # name
+% char # type
+% 22 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ "cTR' Abp"   ]
+[ "cTR' Abp"   ]
+[ "cTR' Abp"   ]
+#SELECT CASE 3 WHEN ((SELECT 0.48) INTERSECT DISTINCT (SELECT -1.2)) THEN 
FALSE ELSE TRUE END FROM t1;
+% .%12 # table_name
+% %12 # name
+% boolean # type
+% 5 # length
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+#ROLLBACK;
 
 # 13:59:46 >  
 # 13:59:46 >  "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list