Changeset: a9d1c43994c6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a9d1c43994c6
Modified Files:
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
sql/test/subquery/Tests/subquery3.sql
sql/test/subquery/Tests/subquery3.stable.out
Branch: default
Log Message:
Approved output
diffs (truncated from 1039 to 300 lines):
diff --git
a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
--- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
+++ b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
@@ -5543,127 +5543,127 @@ stdout of test 'convert-function-test.Bu
[ "AaZz" ]
[ "~!@#$%^&*(')_/-+=:;\"<.,.>?" ]
#SELECT v, convert(v, boolean) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, boolean # type
% 33, 5 # length
[ "0", false ]
[ "1", true ]
#SELECT v, convert(v, tinyint) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, tinyint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, smallint) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, smallint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, integer) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, int # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, bigint) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, bigint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, float) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, double # type
% 33, 24 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, float(24)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, real # type
% 33, 15 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, real) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, real # type
% 33, 15 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, double) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, double # type
% 33, 24 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, double precision) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, double # type
% 33, 24 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, numeric) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 20 # length
[ "0", 0.000 ]
[ "1", 1.000 ]
#SELECT v, convert(v, decimal) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 20 # length
[ "0", 0.000 ]
[ "1", 1.000 ]
#SELECT v, convert(v, numeric(10)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 11 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, decimal(11)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 12 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, numeric(12,0)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 13 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, decimal(15,3)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 17 # length
[ "0", 0.000 ]
[ "1", 1.000 ]
#SELECT v, convert(v, char) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.%2 # table_name
+% v, %2 # name
% char, char # type
% 33, 1 # length
[ "0", "0" ]
[ "1", "1" ]
#SELECT v, convert(v, varchar(36)) from T_char;
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.%2 # table_name
+% v, %2 # name
% char, varchar # type
% 33, 26 # length
[ "0", "0" ]
@@ -5698,133 +5698,133 @@ stdout of test 'convert-function-test.Bu
[ "", "" ]
[ NULL, NULL ]
#SELECT v, convert(v, Blob) from T_char where v in ('0123456789');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, blob # type
% 33, 0 # length
[ "0123456789", 0123456789 ]
#SELECT v, cast(v as boolean) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, boolean # type
% 33, 5 # length
[ "0", false ]
[ "1", true ]
#SELECT v, cast(v as tinyint) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, tinyint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as smallint) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, smallint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as integer) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, int # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as bigint) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, bigint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as float) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, double # type
% 33, 24 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as float(24)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, real # type
% 33, 15 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as real) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, real # type
% 33, 15 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as double) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, double # type
% 33, 24 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as double precision) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, double # type
% 33, 24 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as numeric) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 20 # length
[ "0", 0.000 ]
[ "1", 1.000 ]
#SELECT v, cast(v as decimal) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 20 # length
[ "0", 0.000 ]
[ "1", 1.000 ]
#SELECT v, cast(v as numeric(10)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
% char, decimal # type
% 33, 11 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as decimal(11)) from T_char where v in ('0', '1');
-% sys.t_char, sys.%1 # table_name
-% v, %1 # name
+% sys.t_char, sys.t_char # table_name
+% v, v # name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
