Changeset: ddddd448b3cb for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/ddddd448b3cb Modified Files: sql/test/BugTracker-2020/Tests/deallocate-id.Bug-7010.stable.out sql/test/analytics/Tests/analytics20.stable.out sql/test/miscellaneous/Tests/deallocate.stable.out sql/test/miscellaneous/Tests/groupby_prepare.stable.out sql/test/miscellaneous/Tests/select_groupby.stable.out sql/test/prepare/Tests/bind_with_cast.SF-1720934.stable.out sql/test/prepare/Tests/crash_with_prepare_statement.Bug-2549.stable.out sql/test/prepare/Tests/decimal_needs_truncation.SF-2605686.stable.out sql/test/prepare/Tests/decimal_prepare.SF-1655818.stable.out sql/test/prepare/Tests/fixed_limit_for_prepare.Bug-3208.stable.out sql/test/prepare/Tests/large_prepare.SF-1363729.stable.out sql/test/prepare/Tests/large_prepare_2.SF-1363729.stable.out sql/test/prepare/Tests/limit_in_prepare.Bug-2552.stable.out sql/test/prepare/Tests/prepare-complex.stable.out sql/test/prepare/Tests/prepare-smallint.Bug-3297.stable.out sql/test/prepare/Tests/prepare-smallint.Bug-3297.stable.out.int128 sql/test/prepare/Tests/prepare-types.Bug-6724.stable.out sql/test/prepare/Tests/prepare-utf8.Bug-3930.stable.out sql/test/prepare/Tests/prepare-view.stable.out sql/test/prepare/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.out sql/test/prepare/Tests/prepare_commit_execute.SF-2606020.stable.out sql/test/prepare/Tests/prepare_decimal_bug.SF-2831994.stable.out sql/test/prepare/Tests/prepare_decimal_float.SF-1675795.stable.out sql/test/prepare/Tests/prepare_doesnot_like_LIKE.SF-1234205.stable.out sql/test/prepare/Tests/prepare_on_boolean_bug.Bug-2581.stable.out sql/test/prepare/Tests/prepare_statements_crash_server.Bug-2599.stable.out sql/test/prepare/Tests/prepare_statements_crash_server.Bug-2599.stable.out.int128 sql/test/prepare/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out sql/test/prepare/Tests/prepare_unop_crash.Bug-3653.stable.out sql/test/prepare/Tests/prepared-merge-statement.Bug-6706.stable.out sql/test/prepare/Tests/prepared-select-with-error-causes-hang.Bug-6761.stable.out sql/test/prepare/Tests/prepared-statement-with-udf.Bug-6650.sql sql/test/prepare/Tests/prepared-statement-with-udf.Bug-6650.stable.out sql/test/prepare/Tests/rename_exps.Bug-3974.stable.out sql/test/prepare/Tests/round-or-truncate.Bug-6193.stable.out sql/test/prepare/Tests/sample.15.stable.out sql/test/prepare/Tests/sqlancer_prepare.stable.out sql/test/prepare/Tests/sqlancer_prepare.stable.out.int128 sql/test/prepare/Tests/subquery_prepare.stable.out Branch: monetdbe_prepare Log Message:
Adjust test results. diffs (truncated from 1195 to 300 lines): diff --git a/sql/test/BugTracker-2020/Tests/deallocate-id.Bug-7010.stable.out b/sql/test/BugTracker-2020/Tests/deallocate-id.Bug-7010.stable.out --- a/sql/test/BugTracker-2020/Tests/deallocate-id.Bug-7010.stable.out +++ b/sql/test/BugTracker-2020/Tests/deallocate-id.Bug-7010.stable.out @@ -15,14 +15,14 @@ stdout of test 'deallocate-id.Bug-7010` #prepare select 1; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%2", "%2" ] #prepare select 2; #prepare select 2; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 2, 0, "", "%2", "%2" ] #deallocate 1; diff --git a/sql/test/analytics/Tests/analytics20.stable.out b/sql/test/analytics/Tests/analytics20.stable.out --- a/sql/test/analytics/Tests/analytics20.stable.out +++ b/sql/test/analytics/Tests/analytics20.stable.out @@ -16,8 +16,8 @@ stdout of test 'analytics20` in director #prepare select count(*) over (rows ? preceding) from analytics; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 6, 3, 1, 0, 2, 2 # length +% varchar, int, int, varchar, varchar, varchar # type +% 6, 2, 1, 0, 2, 2 # length [ "bigint", 64, 0, "", "%1", "%1" ] [ "bigint", 64, 0, NULL, NULL, NULL ] #exec 0(2); @@ -39,8 +39,8 @@ stdout of test 'analytics20` in director #prepare select max(aa) over (rows between 5 preceding and ? following) from stressme; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 7, 3, 1, 0, 2, 2 # length +% varchar, int, int, varchar, varchar, varchar # type +% 7, 2, 1, 0, 2, 2 # length [ "varchar", 64, 0, "", "%1", "%1" ] [ "bigint", 64, 0, NULL, NULL, NULL ] #exec 1(2); @@ -61,8 +61,8 @@ stdout of test 'analytics20` in director #prepare select max(aa) over (order by bb range between ? preceding and 10 following) from stressme; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 7, 3, 1, 0, 2, 2 # length +% varchar, int, int, varchar, varchar, varchar # type +% 7, 2, 1, 0, 2, 2 # length [ "varchar", 64, 0, "", "%2", "%2" ] [ "int", 32, 0, NULL, NULL, NULL ] #exec 2(2); diff --git a/sql/test/miscellaneous/Tests/deallocate.stable.out b/sql/test/miscellaneous/Tests/deallocate.stable.out --- a/sql/test/miscellaneous/Tests/deallocate.stable.out +++ b/sql/test/miscellaneous/Tests/deallocate.stable.out @@ -60,7 +60,7 @@ stdout of test 'deallocate` in directory #prepare select "system" or ? from _tables WHERE false; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "boolean", 1, 0, "", "%1", "%1" ] [ "boolean", 1, 0, NULL, NULL, NULL ] @@ -119,7 +119,7 @@ stdout of test 'deallocate` in directory #prepare select "system" or ? from _tables WHERE false; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "boolean", 1, 0, "", "%1", "%1" ] [ "boolean", 1, 0, NULL, NULL, NULL ] diff --git a/sql/test/miscellaneous/Tests/groupby_prepare.stable.out b/sql/test/miscellaneous/Tests/groupby_prepare.stable.out --- a/sql/test/miscellaneous/Tests/groupby_prepare.stable.out +++ b/sql/test/miscellaneous/Tests/groupby_prepare.stable.out @@ -5,16 +5,16 @@ #prepare select col0 from tab0 where (?) in (select col0 from tab0); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 3, 3, 1, 0, 4, 4 # length +% varchar, int, int, varchar, varchar, varchar # type +% 3, 2, 1, 0, 4, 4 # length [ "int", 32, 0, "", "tab0", "col0" ] [ "int", 32, 0, NULL, NULL, NULL ] #prepare select col0 from tab0 where (?,?) in (select col0,col1 from tab0); #prepare select col0 from tab0 where (?,?) in (select col0,col1 from tab0); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 3, 3, 1, 0, 4, 4 # length +% varchar, int, int, varchar, varchar, varchar # type +% 3, 2, 1, 0, 4, 4 # length [ "int", 32, 0, "", "tab0", "col0" ] [ "int", 32, 0, NULL, NULL, NULL ] [ "int", 32, 0, NULL, NULL, NULL ] @@ -22,16 +22,16 @@ #prepare select col0 from tab0 where (col1,col1) in (select col0,? from tab0); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 3, 3, 1, 0, 4, 4 # length +% varchar, int, int, varchar, varchar, varchar # type +% 3, 2, 1, 0, 4, 4 # length [ "int", 32, 0, "", "tab0", "col0" ] [ "int", 32, 0, NULL, NULL, NULL ] #prepare select col0 from tab0 where (col1,col1) in (select ?,? from tab0); #prepare select col0 from tab0 where (col1,col1) in (select ?,? from tab0); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 3, 3, 1, 0, 4, 4 # length +% varchar, int, int, varchar, varchar, varchar # type +% 3, 2, 1, 0, 4, 4 # length [ "int", 32, 0, "", "tab0", "col0" ] [ "int", 32, 0, NULL, NULL, NULL ] [ "int", 32, 0, NULL, NULL, NULL ] @@ -39,16 +39,16 @@ #prepare select col0 from tab0 where (col0) in (?); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 3, 3, 1, 0, 4, 4 # length +% varchar, int, int, varchar, varchar, varchar # type +% 3, 2, 1, 0, 4, 4 # length [ "int", 32, 0, "", "tab0", "col0" ] [ "int", 32, 0, NULL, NULL, NULL ] #prepare select col0 from tab0 where (col0) in (?,?); #prepare select col0 from tab0 where (col0) in (?,?); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type -% 3, 3, 1, 0, 4, 4 # length +% varchar, int, int, varchar, varchar, varchar # type +% 3, 2, 1, 0, 4, 4 # length [ "int", 32, 0, "", "tab0", "col0" ] [ "int", 32, 0, NULL, NULL, NULL ] [ "int", 32, 0, NULL, NULL, NULL ] @@ -56,7 +56,7 @@ #prepare select ? < ANY (select max(col0) from tab0) from tab0 t1; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 2, 1, 0, 2, 2 # length [ "boolean", 1, 0, "", "%4", "%4" ] [ "int", 32, 0, NULL, NULL, NULL ] @@ -64,7 +64,7 @@ #prepare select col0 = ALL (select ? from tab0) from tab0 t1; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 2, 1, 0, 2, 2 # length [ "boolean", 1, 0, "", "%4", "%4" ] [ "int", 32, 0, NULL, NULL, NULL ] @@ -72,7 +72,7 @@ #prepare select 1 from tab0 where 1 between ? and ?; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%1", "%1" ] [ "tinyint", 1, 0, NULL, NULL, NULL ] @@ -81,7 +81,7 @@ #prepare select 1 from tab0 where ? between 1 and ?; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%1", "%1" ] [ "tinyint", 1, 0, NULL, NULL, NULL ] @@ -90,7 +90,7 @@ #prepare select 1 from tab0 where ? between ? and 1; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%1", "%1" ] [ "tinyint", 1, 0, NULL, NULL, NULL ] @@ -99,7 +99,7 @@ #prepare select EXISTS (SELECT ? FROM tab0) from tab0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "boolean", 1, 0, "", "%2", "%2" ] [ "boolean", 1, 0, NULL, NULL, NULL ] @@ -107,7 +107,7 @@ #prepare select EXISTS (SELECT ?,? FROM tab0) from tab0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "boolean", 1, 0, "", "%3", "%3" ] [ "boolean", 1, 0, NULL, NULL, NULL ] @@ -116,7 +116,7 @@ #prepare select case when col0 = 0 then ? else 1 end from tab0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%1", "%1" ] [ "tinyint", 1, 0, NULL, NULL, NULL ] @@ -124,7 +124,7 @@ #prepare select case when col0 = 0 then 1 else ? end from tab0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%1", "%1" ] [ "tinyint", 1, 0, NULL, NULL, NULL ] @@ -132,7 +132,7 @@ #prepare select case when col0 = 0 then ? when col0 = 1 then ? else 1 end from tab0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 1, 1, 0, 2, 2 # length [ "tinyint", 1, 0, "", "%1", "%1" ] [ "tinyint", 1, 0, NULL, NULL, NULL ] @@ -142,7 +142,7 @@ #prepare select 1 from tab1 where (col0,col1) in (select ?,? from tab1); % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 2, 1, 0, 3, 3 # length [ "tinyint", 1, 0, "", "%11", "%11" ] [ "int", 32, 0, NULL, NULL, NULL ] diff --git a/sql/test/miscellaneous/Tests/select_groupby.stable.out b/sql/test/miscellaneous/Tests/select_groupby.stable.out --- a/sql/test/miscellaneous/Tests/select_groupby.stable.out +++ b/sql/test/miscellaneous/Tests/select_groupby.stable.out @@ -121,7 +121,7 @@ stdout of test 'select_groupby` in direc #GROUP BY "first-projection", "twentieth", "twentieth-seventh", "twentieth-third", "twentieth-second" LIMIT 1001; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 6, 3, 1, 0, 7, 17 # length [ "date", 0, 0, "", "", "first-projection" ] [ "char", 100, 0, "", "mytable", "twentieth" ] @@ -149,7 +149,7 @@ stdout of test 'select_groupby` in direc #GROUP BY "first-projection", "twentieth", "twentieth-seventh", "twentieth-third", "twentieth-second" LIMIT ?; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 6, 5, 1, 0, 7, 17 # length [ "date", 0, 0, "", "", "first-projection" ] [ "char", 100, 0, "", "mytable", "twentieth" ] @@ -196,7 +196,7 @@ stdout of test 'select_groupby` in direc #GROUP BY "first-projection", "twentieth", "twentieth-seventh", "twentieth-third", "twentieth-second" LIMIT 1001; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 6, 3, 1, 0, 7, 17 # length [ "date", 0, 0, "", "", "first-projection" ] [ "char", 100, 0, "", "mytable", "twentieth" ] @@ -224,7 +224,7 @@ stdout of test 'select_groupby` in direc #GROUP BY "first-projection", "twentieth", "twentieth-seventh", "twentieth-third", "twentieth-second" LIMIT ?; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 6, 5, 1, 0, 7, 17 # length [ "date", 0, 0, "", "", "first-projection" ] [ "char", 100, 0, "", "mytable", "twentieth" ] @@ -287,7 +287,7 @@ stdout of test 'select_groupby` in direc #LIMIT 1001 OFFSET 0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 3, 1, 0, 8, 7 # length [ "varchar", 256, 0, "", "mytable2", "'col26'" ] #SELECT "'col26'" FROM "myschema"."mytable2" WHERE @@ -311,7 +311,7 @@ stdout of test 'select_groupby` in direc #LIMIT 1001 OFFSET 0; % .prepare, .prepare, .prepare, .prepare, .prepare, .prepare # table_name % type, digits, scale, schema, table, column # name -% varchar, int, int, str, str, str # type +% varchar, int, int, varchar, varchar, varchar # type % 7, 3, 1, 0, 8, 7 # length [ "varchar", 256, 0, "", "mytable2", "'col26'" ] #exec 35 (); @@ -323,7 +323,7 @@ stdout of test 'select_groupby` in direc _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
