MonetDB: Jan2022 - Don't check for largest type on table udf out...

[Pedro Ferreira]

Changeset: 512e7134e394 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/512e7134e394
Modified Files:
        sql/server/rel_dump.c
        sql/test/SQLancer/Tests/sqlancer19.SQL.py
Branch: Jan2022
Log Message:

Don't check for largest type on table udf outputs


diffs (26 lines):

diff --git a/sql/server/rel_dump.c b/sql/server/rel_dump.c
--- a/sql/server/rel_dump.c
+++ b/sql/server/rel_dump.c
@@ -1942,8 +1942,6 @@ rel_read(mvc *sql, char *r, int *pos, li
                                if (list_length(outputs) != 
list_length(sf->func->res))
                                        return sql_error(sql, -1, 
SQLSTATE(42000) "Table returning function: the number of output parameters 
don't match the table ones relation outputs: %d != function outputs: %d\n",
                                                                         
list_length(outputs), list_length(sf->func->res));
-                               if (!list_empty(outputs) && !(outputs = 
check_arguments_and_find_largest_any_type(sql, lrel, outputs, sf, 0)))
-                                       return NULL;
                                rel = rel_table_func(sql->sa, lrel, tudf, 
outputs, TABLE_FROM_RELATION);
                        } else {
                                if (r[*pos] != ')')
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
@@ -339,6 +339,10 @@ with SQLTestCase() as cli:
     cli.execute("SELECT c1 FROM rt6;") \
         
.assertSucceeded().assertDataResultMatch([("3",),("8ጮk|1*",),("27",),("Vrx^qA齀",),("J",),("18",),(">*4嘁pAP",),("+Jm*W0{",),(">V鷓",),
         ("BW5z",),(".#OJruk",),("lU1覃Nlm",),(None,),("968786590",)])
+    cli.execute("SELECT 3 >= ALL(SELECT vx.vc0 FROM storage((SELECT 'sys', 
't3' FROM t3))) FROM (SELECT 0) vx(vc0);") \
+        .assertSucceeded().assertDataResultMatch([(True,)])
+    cli.execute("SELECT 3 >= ALL(SELECT vx.vc0 FROM storage((SELECT 'sys', 
't3' FROM rt3))) FROM (SELECT 0) vx(vc0);") \
+        .assertSucceeded().assertDataResultMatch([(True,)])
     cli.execute("ROLLBACK;")
 
     cli.execute("""
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list