Changeset: 143153489a2e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/143153489a2e Modified Files: sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test Branch: literal_features Log Message:
approve convert tests diffs (truncated from 1066 to 300 lines): diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test b/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test --- a/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test +++ b/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.test @@ -424,8 +424,29 @@ 0 1 1 -statement error +query IT rowsort SELECT v, convert(v, varchar) from T_hugeint +---- +-1 +-1 +-127 +-127 +-2147483647 +-2147483647 +-32767 +-32767 +0 +0 +1 +1 +127 +127 +2147483647 +2147483647 +32767 +32767 +NULL +NULL query IT rowsort SELECT v, convert(v, varchar(16)) from T_hugeint @@ -935,8 +956,29 @@ 0 1 1 -statement error +query IT rowsort SELECT v, cast(v as varchar) from T_hugeint +---- +-1 +-1 +-127 +-127 +-2147483647 +-2147483647 +-32767 +-32767 +0 +0 +1 +1 +127 +127 +2147483647 +2147483647 +32767 +32767 +NULL +NULL query IT rowsort SELECT v, cast(v as varchar(16)) from T_hugeint diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test --- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test +++ b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test @@ -159,8 +159,19 @@ t NULL NULL -statement error +query IT rowsort SELECT v, convert(v, varchar) from T_BOOLEAN +---- +0 +false +0 +false +1 +true +1 +true +NULL +NULL query IT rowsort SELECT v, convert(v, varchar(6)) from T_BOOLEAN @@ -371,8 +382,19 @@ t NULL NULL -statement error +query IT rowsort SELECT v, cast(v as varchar) from T_BOOLEAN +---- +0 +false +0 +false +1 +true +1 +true +NULL +NULL query IT rowsort SELECT v, cast(v as varchar(6)) from T_BOOLEAN @@ -552,8 +574,21 @@ SELECT v, convert(v, decimal(15,3)) from statement error SELECT v, convert(v, char) from T_blob where v between '11' and '11' -statement error +query TT rowsort SELECT v, convert(v, varchar) from T_blob +---- +(empty) +(empty) +00 +00 +0123456789 +0123456789 +11 +11 +A0B2C3D4F5 +A0B2C3D4F5 +NULL +NULL query TT rowsort SELECT v, convert(v, varchar(16)) from T_blob @@ -706,8 +741,21 @@ SELECT v, cast(v as decimal(15,3)) from statement error SELECT v, cast(v as char) from T_blob where v between '11' and '11' -statement error +query TT rowsort SELECT v, cast(v as varchar) from T_blob +---- +(empty) +(empty) +00 +00 +0123456789 +0123456789 +11 +11 +A0B2C3D4F5 +A0B2C3D4F5 +NULL +NULL query TT rowsort SELECT v, cast(v as varchar(16)) from T_blob @@ -1108,8 +1156,21 @@ 0 1 1 -statement error +query IT rowsort SELECT v, convert(v, varchar) from T_tinyint +---- +-1 +-1 +-127 +-127 +0 +0 +1 +1 +127 +127 +NULL +NULL query IT rowsort SELECT v, convert(v, varchar(6)) from T_tinyint @@ -1475,8 +1536,21 @@ 0 1 1 -statement error +query IT rowsort SELECT v, cast(v as varchar) from T_tinyint +---- +-1 +-1 +-127 +-127 +0 +0 +1 +1 +127 +127 +NULL +NULL query IT rowsort SELECT v, cast(v as varchar(6)) from T_tinyint @@ -1928,8 +2002,25 @@ 0 1 1 -statement error +query IT rowsort SELECT v, convert(v, varchar) from T_smallint +---- +-1 +-1 +-127 +-127 +-32767 +-32767 +0 +0 +1 +1 +127 +127 +32767 +32767 +NULL +NULL query IT rowsort SELECT v, convert(v, varchar(6)) from T_smallint @@ -2369,8 +2460,25 @@ 0 1 1 -statement error +query IT rowsort SELECT v, cast(v as varchar) from T_smallint +---- +-1 +-1 +-127 +-127 +-32767 +-32767 +0 +0 +1 +1 +127 +127 +32767 +32767 +NULL +NULL query IT rowsort SELECT v, cast(v as varchar(6)) from T_smallint @@ -2894,8 +3002,29 @@ 0 1 1 -statement error +query IT rowsort SELECT v, convert(v, varchar) from T_int +---- +-1 +-1 +-127 +-127 +-2147483647 +-2147483647 +-32767 +-32767 +0 +0 +1 +1 +127 +127 +2147483647 +2147483647 +32767 +32767 +NULL +NULL query IT rowsort SELECT v, convert(v, varchar(16)) from T_int @@ -3405,8 +3534,29 @@ 0 1 1 -statement error +query IT rowsort SELECT v, cast(v as varchar) from T_int +---- +-1 +-1 +-127 +-127 +-2147483647 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
