Changeset: ae1755558cb4 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ae1755558cb4 Modified Files: sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128 Branch: nostmt Log Message:
approve output diffs (truncated from 11272 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 @@ -78,8 +78,8 @@ Ready. [ true ] [ true ] #SELECT v, convert(v, boolean) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, boolean # type % 5, 5 # length [ true, true ] @@ -88,8 +88,8 @@ Ready. [ false, false ] [ NULL, NULL ] #SELECT v, convert(v, tinyint) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, tinyint # type % 5, 1 # length [ true, 1 ] @@ -98,8 +98,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, convert(v, smallint) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, smallint # type % 5, 1 # length [ true, 1 ] @@ -108,8 +108,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, convert(v, integer) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, int # type % 5, 1 # length [ true, 1 ] @@ -118,8 +118,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, convert(v, bigint) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, bigint # type % 5, 1 # length [ true, 1 ] @@ -128,8 +128,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, convert(v, char) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, char # type % 5, 1 # length [ true, "1" ] @@ -138,8 +138,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, convert(v, varchar(6)) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, varchar # type % 5, 1 # length [ true, "1" ] @@ -148,8 +148,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, convert(v, CHARACTER LARGE OBJECT) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, clob # type % 5, 1 # length [ true, "1" ] @@ -158,8 +158,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, convert(v, Clob) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, clob # type % 5, 1 # length [ true, "1" ] @@ -168,8 +168,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, cast(v as boolean) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, boolean # type % 5, 5 # length [ true, true ] @@ -178,8 +178,8 @@ Ready. [ false, false ] [ NULL, NULL ] #SELECT v, cast(v as tinyint) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, tinyint # type % 5, 1 # length [ true, 1 ] @@ -188,8 +188,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, cast(v as smallint) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, smallint # type % 5, 1 # length [ true, 1 ] @@ -198,8 +198,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, cast(v as integer) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, int # type % 5, 1 # length [ true, 1 ] @@ -208,8 +208,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, cast(v as bigint) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, bigint # type % 5, 1 # length [ true, 1 ] @@ -218,8 +218,8 @@ Ready. [ false, 0 ] [ NULL, NULL ] #SELECT v, cast(v as char) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, char # type % 5, 1 # length [ true, "1" ] @@ -228,8 +228,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, cast(v as varchar(6)) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, varchar # type % 5, 1 # length [ true, "1" ] @@ -238,8 +238,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, cast(v as CHARACTER LARGE OBJECT) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, clob # type % 5, 1 # length [ true, "1" ] @@ -248,8 +248,8 @@ Ready. [ false, "0" ] [ NULL, NULL ] #SELECT v, cast(v as Clob) from T_BOOLEAN; -% sys.t_boolean, sys.L1 # table_name -% v, L1 # name +% sys.t_boolean, sys.L3 # table_name +% v, L3 # name % boolean, clob # type % 5, 1 # length [ true, "1" ] @@ -275,8 +275,8 @@ Ready. [ ] [ NULL ] #SELECT v, convert(v, varchar(16)) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, varchar # type % 0, 10 # length [ 00, "00" ] @@ -286,8 +286,8 @@ Ready. [ , "" ] [ NULL, NULL ] #SELECT v, convert(v, CHARACTER LARGE OBJECT) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, clob # type % 0, 10 # length [ 00, "00" ] @@ -297,8 +297,8 @@ Ready. [ , "" ] [ NULL, NULL ] #SELECT v, convert(v, Clob) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, clob # type % 0, 10 # length [ 00, "00" ] @@ -308,8 +308,8 @@ Ready. [ , "" ] [ NULL, NULL ] #SELECT v, convert(v, Blob) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, blob # type % 0, 0 # length [ 00, 00 ] @@ -319,8 +319,8 @@ Ready. [ "" ] [ NULL, NULL ] #SELECT v, cast(v as varchar(16)) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, varchar # type % 0, 10 # length [ 00, "00" ] @@ -330,8 +330,8 @@ Ready. [ , "" ] [ NULL, NULL ] #SELECT v, cast(v as CHARACTER LARGE OBJECT) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, clob # type % 0, 10 # length [ 00, "00" ] @@ -341,8 +341,8 @@ Ready. [ , "" ] [ NULL, NULL ] #SELECT v, cast(v as Clob) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, clob # type % 0, 10 # length [ 00, "00" ] @@ -352,8 +352,8 @@ Ready. [ , "" ] [ NULL, NULL ] #SELECT v, cast(v as Blob) from T_blob; -% sys.t_blob, sys.L1 # table_name -% v, L1 # name +% sys.t_blob, sys.L3 # table_name +% v, L3 # name % blob, blob # type % 0, 0 # length [ 00, 00 ] @@ -380,8 +380,8 @@ Ready. [ 1 ] [ 127 ] #SELECT v, convert(v, boolean) from T_tinyint; -% sys.t_tinyint, sys.L1 # table_name -% v, L1 # name +% sys.t_tinyint, sys.L3 # table_name +% v, L3 # name % tinyint, boolean # type % 4, 5 # length [ 1, true ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
