Changeset: 8996a827642d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8996a827642d Modified Files: sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128 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: Jun2016 Log Message:
Improving tests by setting time zone explicitly, enlarging varchar(16) into varchar(20) such that the decimal value with 7 decimals fits into the string. diffs (214 lines): diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql --- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql +++ b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql @@ -1,6 +1,8 @@ -- test SQL functions: convert(fromType, toType) and cast(fromType as toType) for all SQL data types and data values -- See also https://www.monetdb.org/bugzilla/show_bug.cgi?id=3460 +SET TIME ZONE INTERVAL '+02:00' HOUR TO MINUTE; + -- BOOLEAN (true, false) CREATE TABLE T_boolean (v boolean); INSERT into T_boolean VALUES (true), (false); @@ -1000,7 +1002,7 @@ SELECT v, convert(v, decimal(15,3)) from SELECT v, convert(v, char) from T_dec where v between 0 and 1; SELECT v, convert(v, varchar) from T_dec; -- missing length specification -SELECT v, convert(v, varchar(16)) from T_dec; +SELECT v, convert(v, varchar(20)) from T_dec; SELECT v, convert(v, longvarchar) from T_dec; -- LONGVARCHAR not valid data type SELECT v, convert(v, long varchar) from T_dec; -- LONG VARCHAR not valid data type SELECT v, convert(v, CHARACTER LARGE OBJECT) from T_dec; @@ -1043,7 +1045,7 @@ SELECT v, cast(v as decimal(15,3)) from SELECT v, cast(v as char) from T_dec where v between 0 and 1; SELECT v, cast(v as varchar) from T_dec; -- missing length specification -SELECT v, cast(v as varchar(16)) from T_dec; +SELECT v, cast(v as varchar(20)) from T_dec; SELECT v, cast(v as longvarchar) from T_dec; -- LONGVARCHAR not valid data type SELECT v, cast(v as long varchar) from T_dec; -- LONG VARCHAR not valid data type SELECT v, cast(v as CHARACTER LARGE OBJECT) from T_dec; diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err --- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err +++ b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err @@ -1381,9 +1381,6 @@ QUERY = SELECT v, convert(v, varchar) fr ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" !syntax error, unexpected FROM in: "from" MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 -QUERY = SELECT v, convert(v, varchar(16)) from T_dec; -ERROR = !value too long for type (var)char(16) -MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 QUERY = SELECT v, convert(v, longvarchar) from T_dec; -- LONGVARCHAR not valid data type ERROR = !type (longvarchar) unknown in: "select v, convert(v, longvarchar)" !syntax error, unexpected FROM in: "from" @@ -1445,9 +1442,6 @@ QUERY = SELECT v, cast(v as varchar) fro ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" !syntax error, unexpected FROM in: "from" MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 -QUERY = SELECT v, cast(v as varchar(16)) from T_dec; -ERROR = !value too long for type (var)char(16) -MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 QUERY = SELECT v, cast(v as longvarchar) from T_dec; -- LONGVARCHAR not valid data type ERROR = !type (longvarchar) unknown in: "select v, cast(v as longvarchar)" !syntax error, unexpected FROM in: "from" diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128 b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128 --- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128 +++ b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128 @@ -1303,9 +1303,6 @@ QUERY = SELECT v, convert(v, varchar) fr ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, convert(v, varchar)" !syntax error, unexpected FROM in: "from" MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 -QUERY = SELECT v, convert(v, varchar(16)) from T_dec; -ERROR = !value too long for type (var)char(16) -MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 QUERY = SELECT v, convert(v, longvarchar) from T_dec; -- LONGVARCHAR not valid data type ERROR = !type (longvarchar) unknown in: "select v, convert(v, longvarchar)" !syntax error, unexpected FROM in: "from" @@ -1363,9 +1360,6 @@ QUERY = SELECT v, cast(v as varchar) fro ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select v, cast(v as varchar)" !syntax error, unexpected FROM in: "from" MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 -QUERY = SELECT v, cast(v as varchar(16)) from T_dec; -ERROR = !value too long for type (var)char(16) -MAPI = (monetdb) /var/tmp/mtest-26956/.s.monetdb.37342 QUERY = SELECT v, cast(v as longvarchar) from T_dec; -- LONGVARCHAR not valid data type ERROR = !type (longvarchar) unknown in: "select v, cast(v as longvarchar)" !syntax error, unexpected FROM in: "from" 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 @@ -2512,7 +2512,7 @@ Ready. [ NULL, NULL ] #DROP TABLE T_bigint; #CREATE TABLE T_float (v FLOAT); -#INSERT into T_float VALUES (1), (0), (-1), (-127), (127), (-32767), (32767), (-2147483647), (2147483647); +#INSERT into T_float VALUES (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0); [ 9 ] #INSERT into T_float VALUES (null); [ 1 ] @@ -4912,7 +4912,7 @@ Ready. [ NULL, NULL ] #DROP TABLE T_num; #CREATE TABLE T_dec (v DECIMAL(17,7)); -#INSERT into T_dec VALUES (1), (0), (-1), (-127), (127), (-32767), (32767), (-2147483647), (2147483647), (0.12), (-3.1415629); +#INSERT into T_dec VALUES (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0), (0.12), (-3.1415629); [ 11 ] #INSERT into T_dec VALUES (null); [ 1 ] @@ -5180,6 +5180,23 @@ Ready. [ 0.1200000, 0.120 ] [ -3.1415629, -3.142 ] [ NULL, NULL ] +#SELECT v, convert(v, varchar(20)) from T_dec; +% sys.t_dec, sys.L1 # table_name +% v, L1 # name +% decimal, varchar # type +% 19, 19 # length +[ 1.0000000, "1.0000000" ] +[ 0.0000000, "0.0000000" ] +[ -1.0000000, "-1.0000000" ] +[ -127.0000000, "-127.0000000" ] +[ 127.0000000, "127.0000000" ] +[ -32767.0000000, "-32767.0000000" ] +[ 32767.0000000, "32767.0000000" ] +[ -2147483647.0000000, "-2147483647.0000000" ] +[ 2147483647.0000000, "2147483647.0000000" ] +[ 0.1200000, "0.1200000" ] +[ -3.1415629, "-3.1415629" ] +[ NULL, NULL ] #SELECT v, convert(v, CHARACTER LARGE OBJECT) from T_dec; % sys.t_dec, sys.L1 # table_name % v, L1 # name @@ -5461,6 +5478,23 @@ Ready. [ 0.1200000, 0.120 ] [ -3.1415629, -3.142 ] [ NULL, NULL ] +#SELECT v, cast(v as varchar(20)) from T_dec; +% sys.t_dec, sys.L1 # table_name +% v, L1 # name +% decimal, varchar # type +% 19, 19 # length +[ 1.0000000, "1.0000000" ] +[ 0.0000000, "0.0000000" ] +[ -1.0000000, "-1.0000000" ] +[ -127.0000000, "-127.0000000" ] +[ 127.0000000, "127.0000000" ] +[ -32767.0000000, "-32767.0000000" ] +[ 32767.0000000, "32767.0000000" ] +[ -2147483647.0000000, "-2147483647.0000000" ] +[ 2147483647.0000000, "2147483647.0000000" ] +[ 0.1200000, "0.1200000" ] +[ -3.1415629, "-3.1415629" ] +[ NULL, NULL ] #SELECT v, cast(v as CHARACTER LARGE OBJECT) from T_dec; % sys.t_dec, sys.L1 # table_name % v, L1 # name 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 @@ -2644,7 +2644,7 @@ Ready. [ NULL, NULL ] #DROP TABLE T_bigint; #CREATE TABLE T_float (v FLOAT); -#INSERT into T_float VALUES (1), (0), (-1), (-127), (127), (-32767), (32767), (-2147483647), (2147483647); +#INSERT into T_float VALUES (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0); [ 9 ] #INSERT into T_float VALUES (null); [ 1 ] @@ -5176,7 +5176,7 @@ Ready. [ NULL, NULL ] #DROP TABLE T_num; #CREATE TABLE T_dec (v DECIMAL(17,7)); -#INSERT into T_dec VALUES (1), (0), (-1), (-127), (127), (-32767), (32767), (-2147483647), (2147483647), (0.12), (-3.1415629); +#INSERT into T_dec VALUES (1.0), (0.0), (-1.0), (-127.0), (127.0), (-32767.0), (32767.0), (-2147483647.0), (2147483647.0), (0.12), (-3.1415629); [ 11 ] #INSERT into T_dec VALUES (null); [ 1 ] @@ -5461,6 +5461,23 @@ Ready. [ 0.1200000, 0.120 ] [ -3.1415629, -3.142 ] [ NULL, NULL ] +#SELECT v, convert(v, varchar(20)) from T_dec; +% sys.t_dec, sys.L1 # table_name +% v, L1 # name +% decimal, varchar # type +% 19, 19 # length +[ 1.0000000, "1.0000000" ] +[ 0.0000000, "0.0000000" ] +[ -1.0000000, "-1.0000000" ] +[ -127.0000000, "-127.0000000" ] +[ 127.0000000, "127.0000000" ] +[ -32767.0000000, "-32767.0000000" ] +[ 32767.0000000, "32767.0000000" ] +[ -2147483647.0000000, "-2147483647.0000000" ] +[ 2147483647.0000000, "2147483647.0000000" ] +[ 0.1200000, "0.1200000" ] +[ -3.1415629, "-3.1415629" ] +[ NULL, NULL ] #SELECT v, convert(v, CHARACTER LARGE OBJECT) from T_dec; % sys.t_dec, sys.L1 # table_name % v, L1 # name @@ -5759,6 +5776,23 @@ Ready. [ 0.1200000, 0.120 ] [ -3.1415629, -3.142 ] [ NULL, NULL ] +#SSELECT v, cast(v as varchar(20)) from T_dec; +% sys.t_dec, sys.L1 # table_name +% v, L1 # name +% decimal, varchar # type +% 19, 19 # length +[ 1.0000000, "1.0000000" ] +[ 0.0000000, "0.0000000" ] +[ -1.0000000, "-1.0000000" ] +[ -127.0000000, "-127.0000000" ] +[ 127.0000000, "127.0000000" ] +[ -32767.0000000, "-32767.0000000" ] +[ 32767.0000000, "32767.0000000" ] +[ -2147483647.0000000, "-2147483647.0000000" ] +[ 2147483647.0000000, "2147483647.0000000" ] +[ 0.1200000, "0.1200000" ] +[ -3.1415629, "-3.1415629" ] +[ NULL, NULL ] #SELECT v, cast(v as CHARACTER LARGE OBJECT) from T_dec; % sys.t_dec, sys.L1 # table_name % v, L1 # name _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
