Changeset: d62936eba5a7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d62936eba5a7 Modified Files: sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.stable.out sql/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.stable.out sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out sql/test/BugTracker-2008/Tests/group_by_in_subquery_fails.SF-2219131.stable.out sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out sql/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.out sql/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out sql/test/BugTracker-2008/Tests/varchar_char_semantics.SF-2075085.stable.out sql/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.stable.out sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out sql/test/BugTracker-2009/Tests/AVG_of_SQRT.SF-2757642.stable.out sql/test/BugTracker-2009/Tests/BOM.SF-2787813.stable.out sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out sql/test/BugTracker-2009/Tests/Floating_point_exception.SF-2791356.stable.out sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.stable.out sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.stable.out sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.stable.out sql/test/BugTracker-2009/Tests/TypeException_having_count_distinct.SF-2494227.stable.out sql/test/BugTracker-2009/Tests/addmonths_missing.SF-2854949.stable.out sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out sql/test/BugTracker-2009/Tests/avg-bug.SF-2132666.stable.out sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out.int128 sql/test/BugTracker-2009/Tests/case_evaluates_all_branches.SF-2893484.stable.out sql/test/BugTracker-2009/Tests/caselessthen.stable.out sql/test/BugTracker-2009/Tests/coercion.stable.out sql/test/BugTracker-2009/Tests/correlated-selection-bug.stable.out sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out sql/test/BugTracker-2009/Tests/count_distinct_bug.SF-2826015.stable.out sql/test/BugTracker-2009/Tests/distinct.SF-2546483.stable.out sql/test/BugTracker-2009/Tests/double_count_limit_bug.SF-2862146.stable.out sql/test/BugTracker-2009/Tests/error_while_drop_func_returns_table_type.SF-2604573.stable.out sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.out sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out sql/test/BugTracker-2009/Tests/function_call_not_handled.SF-2864179.stable.out sql/test/BugTracker-2009/Tests/having_or_bug.stable.out sql/test/BugTracker-2009/Tests/insert_order_by.SF-2658243.stable.out sql/test/BugTracker-2009/Tests/leftjoin_undefined.SF-2879011.stable.out sql/test/BugTracker-2009/Tests/like_bug.SF-2878994.stable.out sql/test/BugTracker-2009/Tests/lookup_column_name_bug_2.SF-2656762.stable.out sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out sql/test/BugTracker-2009/Tests/order_by_column_position_rel_name_bug.stable.out sql/test/BugTracker-2009/Tests/orderby_with_row_number.SF-2895791.stable.out sql/test/BugTracker-2009/Tests/parallel_bulk-load.SF-2771052.test.stable.out sql/test/BugTracker-2009/Tests/pow_operator.SF-2812721.stable.out sql/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.out sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.stable.out sql/test/BugTracker-2009/Tests/push_select_down_crash.stable.out sql/test/BugTracker-2009/Tests/random.SF-2737889.stable.out sql/test/BugTracker-2009/Tests/restart_with_large_int.SF-2846238.stable.out sql/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.stable.out sql/test/BugTracker-2009/Tests/subtraction_between_two_columns.SF-2582389.stable.out sql/test/BugTracker-2009/Tests/union_where_combined.SF-2887282.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.stable.out sql/test/BugTracker-2009/Tests/utf8_bug.SF-2822855.stable.out Branch: sq2default Log Message:
approved new headers diffs (truncated from 1736 to 300 lines): diff --git a/sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out b/sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out --- a/sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out +++ b/sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out @@ -34,8 +34,8 @@ stdout of test 'OOM_query.SF-2457195` in #(lower(lhs) like 'a%'), #(lower(lhs) like 'in%'), #(lower(lhs) like 'un%'), -% sys.test, sys.L3, sys.L5, sys.L7, sys.L11, sys.L13, sys.L15, sys.L17, sys.L21, sys.L23, sys.L25, sys.L27, sys.L31, sys.L33, sys.L35 # table_name -% rhs, L3, L5, L7, L11, L13, L15, L17, L21, L23, L25, L27, L31, L33, L35 # name +% sys.test, sys.%2, sys.%3, sys.%4, sys.%5, sys.%6, sys.%7, sys.%10, sys.%11, sys.%12, sys.%13, sys.%14, sys.%15, sys.%16, sys.%17 # table_name +% rhs, %2, %3, %4, %5, %6, %7, %10, %11, %12, %13, %14, %15, %16, %17 # name % varchar, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean # type % 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5 # length [ "IN", true, false, true, false, false, false, false, false, false, false, false, false, false, false ] @@ -103,8 +103,8 @@ stdout of test 'OOM_query.SF-2457195` in #(lower(lhs) like 'a%'), #(lower(lhs) like 'in%'), #(lower(lhs) like 'un%'), -% sys.test, sys.L3, sys.L5, sys.L7, sys.L11, sys.L13, sys.L15, sys.L17, sys.L21, sys.L23, sys.L25, sys.L27, sys.L31, sys.L33, sys.L35 # table_name -% rhs, L3, L5, L7, L11, L13, L15, L17, L21, L23, L25, L27, L31, L33, L35 # name +% sys.test, sys.%2, sys.%3, sys.%4, sys.%5, sys.%6, sys.%7, sys.%10, sys.%11, sys.%12, sys.%13, sys.%14, sys.%15, sys.%16, sys.%17 # table_name +% rhs, %2, %3, %4, %5, %6, %7, %10, %11, %12, %13, %14, %15, %16, %17 # name % varchar, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean, boolean # type % 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5, 5 # length [ "IN", true, false, true, false, false, false, false, false, false, false, false, false, false, false ] diff --git a/sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out b/sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out --- a/sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out +++ b/sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out @@ -24,7 +24,7 @@ stdout of test 'auto_coersion_bug.SF-207 [ 1 ] #SELECT CAST(2 * q1 AS BIGINT) AS q FROM A; -% sys.L3 # table_name +% sys.%2 # table_name % q # name % bigint # type % 16 # length @@ -32,8 +32,8 @@ stdout of test 'auto_coersion_bug.SF-207 [ 1 ] #SELECT SUM(2 * COL1 * COL2) #FROM A2; -% sys.L4 # table_name -% L4 # name +% sys.%2 # table_name +% %2 # name % bigint # type % 6 # length [ 246864 ] @@ -41,8 +41,8 @@ stdout of test 'auto_coersion_bug.SF-207 #SELECT (-COL2+COL1) #FROM A #WHERE COL3 IS NULL; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % bigint # type % 4 # length [ 3000 ] diff --git a/sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.stable.out b/sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.stable.out --- a/sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.stable.out +++ b/sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.stable.out @@ -31,8 +31,8 @@ stdout of test 'copy-count.SF-2485215` i 1123 [ 1 ] #copy select count(*) from t into stdout using delimiters ',', E'\n'; -% .L3 # table_name -% L3 # name +% .%1 # table_name +% %1 # name % bigint # type % 1 # length 1 diff --git a/sql/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.stable.out b/sql/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.stable.out --- a/sql/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.stable.out +++ b/sql/test/BugTracker-2008/Tests/decimal_cast_in_view.SF-2075223.stable.out @@ -29,8 +29,8 @@ stdout of test 'decimal_cast_in_view.SF- % 10 # length [ " 54." ] #select CAST (a as NUMERIC (5, 2)) from A; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % decimal # type % 7 # length [ 54.00 ] diff --git a/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out b/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out --- a/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out +++ b/sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out @@ -28,14 +28,14 @@ stdout of test 'extract_bug.SF-2075266` [ 1 ] #SELECT CAST( EXTRACT (SECOND FROM FIPS2) #* 1000000 - 999990 as decimal(18,6)) FROM A; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % decimal # type % 20 # length [ 9.000000 ] #select EXTRACT (SECOND FROM FIPS2) FROM A; -% sys.L2 # table_name -% L2 # name +% sys.%1 # table_name +% %1 # name % decimal # type % 11 # length [ 0.999999 ] diff --git a/sql/test/BugTracker-2008/Tests/group_by_in_subquery_fails.SF-2219131.stable.out b/sql/test/BugTracker-2008/Tests/group_by_in_subquery_fails.SF-2219131.stable.out --- a/sql/test/BugTracker-2008/Tests/group_by_in_subquery_fails.SF-2219131.stable.out +++ b/sql/test/BugTracker-2008/Tests/group_by_in_subquery_fails.SF-2219131.stable.out @@ -28,8 +28,8 @@ stdout of test 'group_by_in_subquery_fai # 17:32:51 > #select (select 1); -% .L3 # table_name -% L3 # name +% .%1 # table_name +% %1 # name % tinyint # type % 1 # length [ 1 ] diff --git a/sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out b/sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out --- a/sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out +++ b/sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out @@ -25,8 +25,8 @@ stdout of test 'groupby_with_NULL.SF-215 [ 1 ] [ 1 ] #select color, null, cast( sum(count) as bigint) from testola group by color; -% sys.testola, .L1, sys.L3 # table_name -% color, L1, L2 # name +% sys.testola, .%4, sys.%2 # table_name +% color, %4, %2 # name % varchar, char, bigint # type % 4, 0, 2 # length [ "blue", NULL, 12 ] diff --git a/sql/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.out b/sql/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.out --- a/sql/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.out +++ b/sql/test/BugTracker-2008/Tests/is_distinct_broken.SF-2430201.stable.out @@ -42,8 +42,8 @@ stdout of test 'is_distinct_broken.SF-24 [ 24644162 ] #drop table way_tags_2430201; #select distinct (select 10 union all select 10); -% .L12 # table_name -% L3 # name +% .%7 # table_name +% %2 # name % tinyint # type % 2 # length [ 10 ] diff --git a/sql/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out b/sql/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out --- a/sql/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out +++ b/sql/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out @@ -30,8 +30,8 @@ stdout of test 'select_between_wrong_res #FROM A #WHERE a BETWEEN 11.999 AND 12 OR #a BETWEEN 19.999 AND 2.001E1; -% sys.L4 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % bigint # type % 1 # length [ 3 ] diff --git a/sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out b/sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out --- a/sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out +++ b/sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out @@ -39,8 +39,8 @@ stdout of test 'select_not_wrong_result. #(SELECT B.a #FROM B #WHERE a > 'a4' )); -% sys.L6 # table_name -% L5 # name +% .%3 # table_name +% %3 # name % bigint # type % 1 # length [ 0 ] diff --git a/sql/test/BugTracker-2008/Tests/varchar_char_semantics.SF-2075085.stable.out b/sql/test/BugTracker-2008/Tests/varchar_char_semantics.SF-2075085.stable.out --- a/sql/test/BugTracker-2008/Tests/varchar_char_semantics.SF-2075085.stable.out +++ b/sql/test/BugTracker-2008/Tests/varchar_char_semantics.SF-2075085.stable.out @@ -31,8 +31,8 @@ stdout of test 'varchar_char_semantics.S [ 10, "1234567890", "1234567890" ] [ 5, "12345 ", "12345" ] #SELECT COUNT(*) FROM T850 WHERE T850C = T850VC; -% sys.L4 # table_name -% L3 # name +% sys.%1 # table_name +% %1 # name % bigint # type % 1 # length [ 1 ] diff --git a/sql/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.stable.out b/sql/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.stable.out --- a/sql/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.stable.out +++ b/sql/test/BugTracker-2008/Tests/view_reply_incorrect.SF-2075097.stable.out @@ -1,29 +1,38 @@ stdout of test 'view_reply_incorrect.SF-2075097` in directory 'sql/test/BugTracker-2008` itself: -# 12:25:53 > -# 12:25:53 > mserver5 "--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=30598 --set xrpc_port=44185 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker-2008" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. -# 12:25:53 > - -# MonetDB server v5.6.0, based on kernel v1.24.1 -# Serving database 'mTests_src_test_BugTracker-2008' -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Copyright (c) 1993-2008 CWI, all rights reserved -# Visit http://monetdb.cwi.nl/ for further information -# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:30598/ -# MonetDB/SQL module v2.24.1 loaded +# 17:15:35 > +# 17:15:35 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33945" "--set" "mapi_usock=/var/tmp/mtest-14741/.s.monetdb.33945" "--forcemito" "--dbpath=/home/niels/scratch/monetdb/Linux-x86_64/var/MonetDB/mTests_sql_test_BugTracker-2008" "--set" "embedded_c=true" +# 17:15:35 > -#function user.main():void; -# clients.quit(); -#end main; - +# MonetDB 5 server v11.36.0 (hg id: 1d18bd8860b4+) +# This is an unreleased version +# Serving database 'mTests_sql_test_BugTracker-2008', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers +# Found 15.384 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://localhost.localdomain:33945/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-14741/.s.monetdb.33945 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded -# 12:25:53 > -# 12:25:53 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=30598 -# 12:25:53 > +# 17:15:36 > +# 17:15:36 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-14741" "--port=33945" +# 17:15:36 > +#CREATE TABLE GROUPS1 +#(EMPNUM INT, GRP INT); +#CREATE TABLE NAMES1 +#(EMPNUM INT, NAME CHAR(5)); +#CREATE VIEW NAMGRP1 AS +#SELECT * FROM NAMES1 NATURAL JOIN GROUPS1; +#INSERT INTO GROUPS1 VALUES (0, 10); [ 1 ] +#INSERT INTO GROUPS1 VALUES (1, 20); [ 1 ] +#INSERT INTO GROUPS1 VALUES (2, 30); [ 1 ] [ 1 ] [ 1 ] diff --git a/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out b/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out --- a/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out +++ b/sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out @@ -28,56 +28,56 @@ stdout of test 'AVG_ReturnsNoLines.SF-25 [ 1 ] #SELECT AVG(x) AS avgx, AVG(x) AS avgx2 #FROM x; -% sys.L4, sys.L7 # table_name +% sys.%1, sys.%2 # table_name % avgx, avgx2 # name % double, double # type % 24, 24 # length [ 2, 2 ] #SELECT AVG(x) AS avgx, SUM(x) AS sumx #FROM x; -% sys.L4, sys.L7 # table_name +% sys.%1, sys.%2 # table_name % avgx, sumx # name % double, double # type % 24, 24 # length [ 2, 6 ] #SELECT AVG(x) AS avgx, COUNT(x) AS countx #FROM x; -% sys.L4, sys.L7 # table_name +% sys.%1, sys.%2 # table_name % avgx, countx # name % double, bigint # type % 24, 1 # length [ 2, 3 ] #SELECT AVG(x) AS avgx, COUNT(*) AS countstar #FROM x; -% sys.L4, .L7 # table_name +% sys.%1, .%2 # table_name % avgx, countstar # name % double, bigint # type % 24, 1 # length [ 2, 3 ] #SELECT AVG(x) AS avgx, MIN(x) AS minx #FROM x; -% sys.L4, sys.L7 # table_name +% sys.%1, sys.%2 # table_name % avgx, minx # name % double, double # type % 24, 24 # length [ 2, 1 ] #SELECT AVG(x) AS avgx, MAX(x) AS maxx #FROM x; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
