Changeset: b5f14dac5078 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b5f14dac5078
Modified Files:
sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/empty_avg.SF-1207887.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out
sql/test/BugDay_2005-11-09_2.9.3/Tests/union-duplicates.SF-1119186.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_interval.SF.1280682.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/in_operator.SF-1211925.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/interval_times_int.SF-1281996.stable.out
sql/test/BugDay_2005-12-19_2.9.3/Tests/timestamp_fraction.SF-1357342.stable.out
sql/test/BugTracker/Tests/auto_increment.SF-1834820.stable.out
sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out
sql/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.stable.out
sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.stable.out.int128
sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.stable.out
sql/test/BugTracker/Tests/connect_crash.SF-1436626.stable.out
sql/test/BugTracker/Tests/convert_dec2varchar.SF-1774312.stable.out
sql/test/BugTracker/Tests/convert_dec2varchar_crash.SF-1775550.stable.out
sql/test/BugTracker/Tests/count_crash.SF-1918780.stable.out
sql/test/BugTracker/Tests/crash_on_cast.SF-1357271.stable.out
sql/test/BugTracker/Tests/crash_on_delete.SF-1639108.stable.out
sql/test/BugTracker/Tests/crash_on_delete.SF-1651567.stable.out
sql/test/BugTracker/Tests/crash_on_insert.SF-1639113.stable.out
sql/test/BugTracker/Tests/full_join_crash.SF-1841754.stable.out
sql/test/BugTracker/Tests/groupby_with_alias.SF-1520575.stable.out.int128
sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out
sql/test/BugTracker/Tests/intersect_in_subquery.SF-1339411.stable.out
sql/test/BugTracker/Tests/large_prepare_2.SF-1363729.stable.out
sql/test/BugTracker/Tests/like_for_time_values.SF-1715659.stable.out
sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out
sql/test/BugTracker/Tests/ms_round.SF-1907063.stable.out
sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out
sql/test/BugTracker/Tests/proc_insert_into.SF-1958572.stable.out
sql/test/BugTracker/Tests/rand_not_executed_for_every_row.SF-1723791.stable.out
sql/test/BugTracker/Tests/range_join_any.SF-2041785.stable.out
sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out
sql/test/BugTracker/Tests/select_crashes_in_the_optimization.SF-1848553.stable.out
sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out
sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.out
sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out
sql/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.stable.out
sql/test/BugTracker/Tests/union_order.stable.out
sql/test/BugTracker/Tests/variable_names.SF-1838816.stable.out
sql/test/BugTracker/Tests/variables.SF-1508160.stable.out
sql/test/BugTracker/Tests/with_only_once.SF-1720293.stable.out
sql/test/BugTracker/Tests/with_row_number.SF-1898089.stable.out
Branch: sq2default
Log Message:
approved output
diffs (truncated from 1258 to 300 lines):
diff --git
a/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.stable.out
b/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.stable.out
--- a/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.stable.out
+++ b/sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.stable.out
@@ -28,8 +28,8 @@ stdout of test 'crash_in_case.SF-1097749
# 16:45:44 >
#select case when 1 > 2 then 'false' when 2 > 1 then 'true' end;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% char # type
% 5 # length
[ "true" ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out
--- a/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out
@@ -24,14 +24,14 @@ stdout of test 'date_functions.SF-967145
# 11:50:50 >
#select current_date - current_date;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% int # type
% 1 # length
[ 0 ]
#select current_date() - current_date();
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% int # type
% 1 # length
[ 0 ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/empty_avg.SF-1207887.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/empty_avg.SF-1207887.stable.out
--- a/sql/test/BugDay_2005-11-09_2.9.3/Tests/empty_avg.SF-1207887.stable.out
+++ b/sql/test/BugDay_2005-11-09_2.9.3/Tests/empty_avg.SF-1207887.stable.out
@@ -30,8 +30,8 @@ stdout of test 'empty_avg.SF-1207887` in
#create table sf1207887 (field decimal(3,1));
#select avg(field) from sf1207887;
-% sys.L4 # table_name
-% L3 # name
+% sys.%1 # table_name
+% %1 # name
% double # type
% 24 # length
[ NULL ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
@@ -23,50 +23,50 @@ stdout of test 'interval_on_time_stamp.S
# 11:50:55 >
#select date '1997-07-31' + interval '1' month;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% date # type
% 10 # length
[ 1997-08-31 ]
#select date '1997-10-31' + interval '1' month;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% date # type
% 10 # length
[ 1997-12-01 ]
#select timestamp '1997-07-15 19:00:00' + interval '9' hour;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% timestamp # type
% 26 # length
[ 1997-07-16 04:00:00.000000 ]
#select time '19:00:00' + interval '9' hour;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% time # type
% 15 # length
[ 04:00:00.000000 ]
#select date '1997-07-31' + interval '1' hour;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% date # type
% 10 # length
[ 1997-07-31 ]
#select interval '0' year + interval '0' month;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% month_interval # type
% 1 # length
[ 0 ]
#select interval '00:00' hour to minute + interval '00:00' minute to second;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% sec_interval # type
% 5 # length
[ 0.000 ]
#select interval '2' hour + interval '74' minute;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% sec_interval # type
% 9 # length
[ 11640.000 ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out
@@ -26,8 +26,8 @@ stdout of test 'like_doesnot_like_string
# 11:50:53 >
#select 'test' like 'test';
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% boolean # type
% 5 # length
[ true ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out
@@ -31,8 +31,8 @@ stdout of test 'sql_server_abort.SF-1080
#START TRANSACTION;
#select 5 not between 4 and 6;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% boolean # type
% 5 # length
[ false ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out
@@ -24,8 +24,8 @@ stdout of test 'sql_server_crash.SF-1080
# 11:50:54 >
#select NULLIF(NULLIF('first', 'second'), 'first');
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% char # type
% 5 # length
[ NULL ]
diff --git
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/union-duplicates.SF-1119186.stable.out
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/union-duplicates.SF-1119186.stable.out
---
a/sql/test/BugDay_2005-11-09_2.9.3/Tests/union-duplicates.SF-1119186.stable.out
+++
b/sql/test/BugDay_2005-11-09_2.9.3/Tests/union-duplicates.SF-1119186.stable.out
@@ -31,14 +31,14 @@ stdout of test 'union-duplicates.SF-1119
[ 1 ]
[ 6 ]
#SELECT * FROM aap1119186 UNION SELECT * FROM aap1119186;
-% .L11 # table_name
+% .%7 # table_name
% id # name
% int # type
% 1 # length
[ 1 ]
[ 6 ]
#SELECT * FROM aap1119186 UNION ALL SELECT * FROM aap1119186;
-% .L11 # table_name
+% .%7 # table_name
% id # name
% int # type
% 1 # length
@@ -47,7 +47,7 @@ stdout of test 'union-duplicates.SF-1119
[ 1 ]
[ 6 ]
#SELECT 'a' AS test FROM aap1119186;
-% .L2 # table_name
+% . # table_name
% test # name
% char # type
% 1 # length
@@ -55,7 +55,7 @@ stdout of test 'union-duplicates.SF-1119
[ "a" ]
#SELECT 'a' AS test FROM aap1119186 UNION SELECT 'b' AS
#test FROM aap1119186;
-% .L11 # table_name
+% .%5 # table_name
% test # name
% char # type
% 1 # length
@@ -63,7 +63,7 @@ stdout of test 'union-duplicates.SF-1119
[ "b" ]
#SELECT 'a' AS test FROM aap1119186 UNION ALL SELECT 'b' AS
#test FROM aap1119186;
-% .L11 # table_name
+% .%5 # table_name
% test # name
% char # type
% 1 # length
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
--- a/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
+++ b/sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out
@@ -24,38 +24,38 @@ stdout of test 'NULL_in_CASE.SF-1211335`
# 11:50:59 >
#select CASE WHEN 1=1 THEN 1 ELSE NULL END;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% tinyint # type
% 1 # length
[ 1 ]
#select CASE WHEN 1=0 THEN 1 ELSE NULL END;
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% tinyint # type
% 1 # length
[ NULL ]
#select CASE WHEN 2=2 THEN 2 else cast(null as char) end;
-% .L3 # table_name
-% L3 # name
+% .%2 # table_name
+% %2 # name
% char # type
% 1 # length
[ "2" ]
#select CASE WHEN 2=0 THEN 2 else cast(null as char) end;
-% .L3 # table_name
-% L3 # name
+% .%2 # table_name
+% %2 # name
% char # type
% 1 # length
[ NULL ]
#select CASE WHEN 3=3 THEN 3 else cast(null as int) end;
-% .L3 # table_name
-% L3 # name
+% .%2 # table_name
+% %2 # name
% int # type
% 1 # length
[ 3 ]
#select CASE WHEN 3=0 THEN 3 else cast(null as int) end;
-% .L3 # table_name
-% L3 # name
+% .%2 # table_name
+% %2 # name
% int # type
% 1 # length
[ NULL ]
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out
---
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out
@@ -73,14 +73,14 @@ stdout of test 'aggregate_functions_with
[ 1 ]
[ 1 ]
#select count(*) from test_aggre_limit limit 1;
-% .L4 # table_name
-% L3 # name
+% .%1 # table_name
+% %1 # name
% bigint # type
% 2 # length
[ 50 ]
#select type, count(*) from test_aggre_limit group by type limit 1;
-% sys.test_aggre_limit, sys.L4 # table_name
-% type, L3 # name
+% sys.test_aggre_limit, sys.%1 # table_name
+% type, %1 # name
% varchar, bigint # type
% 3, 2 # length
[ "int", 29 ]
diff --git
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.stable.out
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.stable.out
---
a/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.stable.out
+++
b/sql/test/BugDay_2005-12-19_2.9.3/Tests/cast_bigint_to_int.SF-1211903.stable.out
@@ -14,20 +14,20 @@ stdout of test 'cast_bigint_to_int.SF-12
#select cast(1117422000 as integer);
-% .L2 # table_name
-% L2 # name
+% .%1 # table_name
+% %1 # name
% int # type
% 10 # length
[ 1117422000 ]
#select cast('1117422000' as integer);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
