Changeset: 17b2ceb6cb52 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=17b2ceb6cb52
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: Apr2019
Log Message:
Approve convert-function test with new blob ordering.
diffs (truncated from 1110 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
@@ -268,12 +268,12 @@ Ready.
% v # name
% blob # type
% 0 # length
+[ NULL ]
[ ]
[ 00 ]
+[ 0123456789 ]
[ 11 ]
-[ 0123456789 ]
[ A0B2C3D4F5 ]
-[ NULL ]
#SELECT v, convert(v, varchar(16)) from T_blob;
% sys.t_blob, sys.L3 # table_name
% v, L3 # name
@@ -5862,8 +5862,8 @@ Ready.
[ "", "" ]
[ NULL, NULL ]
#SELECT v, cast(v as Blob) from T_char where v in ('0123456789');
-% sys.t_char, sys.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # name
% char, blob # type
% 33, 0 # length
[ "0123456789", 0123456789 ]
@@ -6202,8 +6202,8 @@ Ready.
[ "", "" ]
[ NULL, NULL ]
#SELECT v, cast(v as Blob) from T_varchar where v in ('0123456789');
-% sys.t_varchar, sys.L4 # table_name
-% v, L4 # name
+% sys.t_varchar, sys.L3 # table_name
+% v, L3 # name
% varchar, blob # type
% 10, 0 # length
[ "0123456789", 0123456789 ]
@@ -6542,8 +6542,8 @@ Ready.
[ "", "" ]
[ NULL, NULL ]
#SELECT v, cast(v as Blob) from T_clob where v in ('0123456789');
-% sys.t_clob, sys.L4 # table_name
-% v, L4 # name
+% sys.t_clob, sys.L3 # table_name
+% v, L3 # name
% clob, blob # type
% 10, 0 # length
[ "0123456789", 0123456789 ]
diff --git
a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128
b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128
---
a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128
+++
b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128
@@ -292,12 +292,12 @@ Ready.
% v # name
% blob # type
% 0 # length
+[ NULL ]
[ ]
[ 00 ]
+[ 0123456789 ]
[ 11 ]
-[ 0123456789 ]
[ A0B2C3D4F5 ]
-[ NULL ]
#SELECT v, convert(v, varchar(16)) from T_blob;
% sys.t_blob, sys.L3 # table_name
% v, L3 # name
@@ -5844,127 +5844,127 @@ Ready.
[ "AaZz" ]
[ "~!@#$%^&*(')_/-+=:;\"<.,.>?" ]
#SELECT v, convert(v, boolean) from T_char where v in ('0', '1');
-% sys.t_char, sys.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # name
% char, bigint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, convert(v, hugeint) from T_char where v in ('0', '1');
-% sys.t_char, sys.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # name
% char, hugeint # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # name
% char, char # type
% 33, 1 # length
[ "0", "0" ]
@@ -6006,133 +6006,133 @@ Ready.
[ "", "" ]
[ NULL, NULL ]
#SELECT v, convert(v, Blob) from T_char where v in ('0123456789');
-% sys.t_char, sys.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # 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.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # name
% char, bigint # type
% 33, 1 # length
[ "0", 0 ]
[ "1", 1 ]
#SELECT v, cast(v as hugeint) from T_char where v in ('0', '1');
-% sys.t_char, sys.L4 # table_name
-% v, L4 # name
+% sys.t_char, sys.L3 # table_name
+% v, L3 # name
% char, hugeint # 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.L4 # table_name
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
