Changeset: 109de091c88e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=109de091c88e Modified Files: sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.sql sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.stable.err sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql 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: mtime Log Message:
Update test to use official SQL types. diffs (truncated from 2324 to 300 lines): diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.sql b/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.sql --- a/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.sql +++ b/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.sql @@ -45,10 +45,8 @@ SELECT v, convert(v, Blob) from T_hugein SELECT v, convert(v, date) from T_hugeint; -- conversion not supported SELECT v, convert(v, time) from T_hugeint; -- conversion not supported SELECT v, convert(v, timestamp) from T_hugeint; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_hugeint; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_hugeint; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_hugeint; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_hugeint; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_hugeint; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_hugeint; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_hugeint; @@ -88,10 +86,8 @@ SELECT v, cast(v as Blob) from T_hugeint SELECT v, cast(v as date) from T_hugeint; -- conversion not supported SELECT v, cast(v as time) from T_hugeint; -- conversion not supported SELECT v, cast(v as timestamp) from T_hugeint; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_hugeint; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_hugeint; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_hugeint; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_hugeint; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_hugeint; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_hugeint; -- conversion not supported DROP TABLE T_hugeint; diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.stable.err b/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.stable.err --- a/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.stable.err +++ b/sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.stable.err @@ -78,20 +78,12 @@ MAPI = (monetdb) /var/tmp/mtest-30274/. QUERY = SELECT v, convert(v, timestamp) from T_hugeint; -- conversion not supported ERROR = !types hugeint(128,0) and timestamp(7,0) are not equal for column 'v' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, convert(v, time with timezone) from T_hugeint; -- data type not supported (parse error) -ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, time with timezone" +MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398 +QUERY = SELECT v, convert(v, time with time zone) from T_hugeint; -- conversion not supported +ERROR = !types hugeint(128,0) and timetz(1,0) are not equal for column 'v' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, convert(v, timestamp with timezone) from T_hugeint; -- data type not supported (parse error) -ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, convert(v, timestamp with timezone" -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, convert(v, timetz) from T_hugeint; -- conversion not supported -ERROR = !types hugeint(128,0) and timetz(7,0) are not equal for column 'v' -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, convert(v, timestamptz) from T_hugeint; -- conversion not supported +MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398 +QUERY = SELECT v, convert(v, timestamp with time zone) from T_hugeint; -- conversion not supported ERROR = !types hugeint(128,0) and timestamptz(7,0) are not equal for column 'v' CODE = 42000 MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 @@ -144,20 +136,12 @@ MAPI = (monetdb) /var/tmp/mtest-30274/. QUERY = SELECT v, cast(v as timestamp) from T_hugeint; -- conversion not supported ERROR = !types hugeint(128,0) and timestamp(7,0) are not equal for column 'v' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, cast(v as time with timezone) from T_hugeint; -- data type not supported (parse error) -ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as time with timezone" +MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398 +QUERY = SELECT v, cast(v as time with time zone) from T_hugeint; -- conversion not supported +ERROR = !types hugeint(128,0) and timetz(1,0) are not equal for column 'v' CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, cast(v as timestamp with timezone) from T_hugeint; -- data type not supported (parse error) -ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v as timestamp with timezone" -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, cast(v as timetz) from T_hugeint; -- conversion not supported -ERROR = !types hugeint(128,0) and timetz(7,0) are not equal for column 'v' -CODE = 42000 -MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685 -QUERY = SELECT v, cast(v as timestamptz) from T_hugeint; -- conversion not supported +MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398 +QUERY = SELECT v, cast(v as timestamp with time zone) from T_hugeint; -- conversion not supported ERROR = !types hugeint(128,0) and timestamptz(7,0) are not equal for column 'v' CODE = 42000 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 @@ -50,10 +50,8 @@ SELECT v, convert(v, Blob) from T_BOOLEA SELECT v, convert(v, date) from T_BOOLEAN; -- conversion not supported SELECT v, convert(v, time) from T_BOOLEAN; -- conversion not supported SELECT v, convert(v, timestamp) from T_BOOLEAN; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_BOOLEAN; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_BOOLEAN; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_BOOLEAN; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_BOOLEAN; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_BOOLEAN; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_BOOLEAN; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_BOOLEAN; @@ -93,10 +91,8 @@ SELECT v, cast(v as Blob) from T_BOOLEAN SELECT v, cast(v as date) from T_BOOLEAN; -- conversion not supported SELECT v, cast(v as time) from T_BOOLEAN; -- conversion not supported SELECT v, cast(v as timestamp) from T_BOOLEAN; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_BOOLEAN; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_BOOLEAN; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_BOOLEAN; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_BOOLEAN; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_BOOLEAN; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_BOOLEAN; -- conversion not supported -- some JDBC specific types SELECT v, convert(v, XML) from T_BOOLEAN; -- XML not valid data type @@ -159,10 +155,8 @@ SELECT v, convert(v, Blob) from T_blob; SELECT v, convert(v, date) from T_blob; -- conversion not supported SELECT v, convert(v, time) from T_blob; -- conversion not supported SELECT v, convert(v, timestamp) from T_blob; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_blob; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_blob; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_blob; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_blob; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_blob; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_blob; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_blob; @@ -202,10 +196,8 @@ SELECT v, cast(v as Blob) from T_blob; SELECT v, cast(v as date) from T_blob; -- conversion not supported SELECT v, cast(v as time) from T_blob; -- conversion not supported SELECT v, cast(v as timestamp) from T_blob; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_blob; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_blob; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_blob; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_blob; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_blob; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_blob; -- conversion not supported DROP TABLE T_blob; @@ -257,10 +249,8 @@ SELECT v, convert(v, Blob) from T_tinyin SELECT v, convert(v, date) from T_tinyint; -- conversion not supported SELECT v, convert(v, time) from T_tinyint; -- conversion not supported SELECT v, convert(v, timestamp) from T_tinyint; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_tinyint; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_tinyint; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_tinyint; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_tinyint; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_tinyint; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_tinyint; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_tinyint; @@ -300,10 +290,8 @@ SELECT v, cast(v as Blob) from T_tinyint SELECT v, cast(v as date) from T_tinyint; -- conversion not supported SELECT v, cast(v as time) from T_tinyint; -- conversion not supported SELECT v, cast(v as timestamp) from T_tinyint; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_tinyint; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_tinyint; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_tinyint; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_tinyint; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_tinyint; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_tinyint; -- conversion not supported DROP TABLE T_tinyint; @@ -352,10 +340,8 @@ SELECT v, convert(v, Blob) from T_smalli SELECT v, convert(v, date) from T_smallint; -- conversion not supported SELECT v, convert(v, time) from T_smallint; -- conversion not supported SELECT v, convert(v, timestamp) from T_smallint; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_smallint; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_smallint; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_smallint; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_smallint; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_smallint; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_smallint; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_smallint; @@ -395,10 +381,8 @@ SELECT v, cast(v as Blob) from T_smallin SELECT v, cast(v as date) from T_smallint; -- conversion not supported SELECT v, cast(v as time) from T_smallint; -- conversion not supported SELECT v, cast(v as timestamp) from T_smallint; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_smallint; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_smallint; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_smallint; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_smallint; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_smallint; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_smallint; -- conversion not supported DROP TABLE T_smallint; @@ -447,10 +431,8 @@ SELECT v, convert(v, Blob) from T_int; - SELECT v, convert(v, date) from T_int; -- conversion not supported SELECT v, convert(v, time) from T_int; -- conversion not supported SELECT v, convert(v, timestamp) from T_int; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_int; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_int; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_int; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_int; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_int; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_int; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_int; @@ -490,10 +472,8 @@ SELECT v, cast(v as Blob) from T_int; -- SELECT v, cast(v as date) from T_int; -- conversion not supported SELECT v, cast(v as time) from T_int; -- conversion not supported SELECT v, cast(v as timestamp) from T_int; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_int; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_int; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_int; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_int; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_int; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_int; -- conversion not supported DROP TABLE T_int; @@ -542,10 +522,8 @@ SELECT v, convert(v, Blob) from T_bigint SELECT v, convert(v, date) from T_bigint; -- conversion not supported SELECT v, convert(v, time) from T_bigint; -- conversion not supported SELECT v, convert(v, timestamp) from T_bigint; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_bigint; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_bigint; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_bigint; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_bigint; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_bigint; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_bigint; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_bigint; @@ -585,10 +563,8 @@ SELECT v, cast(v as Blob) from T_bigint; SELECT v, cast(v as date) from T_bigint; -- conversion not supported SELECT v, cast(v as time) from T_bigint; -- conversion not supported SELECT v, cast(v as timestamp) from T_bigint; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_bigint; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_bigint; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_bigint; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_bigint; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_bigint; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_bigint; -- conversion not supported DROP TABLE T_bigint; @@ -640,10 +616,8 @@ SELECT v, convert(v, Blob) from T_float; SELECT v, convert(v, date) from T_float; -- conversion not supported SELECT v, convert(v, time) from T_float; -- conversion not supported SELECT v, convert(v, timestamp) from T_float; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_float; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_float; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_float; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_float; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_float; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_float; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_float; @@ -683,10 +657,8 @@ SELECT v, cast(v as Blob) from T_float; SELECT v, cast(v as date) from T_float; -- conversion not supported SELECT v, cast(v as time) from T_float; -- conversion not supported SELECT v, cast(v as timestamp) from T_float; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_float; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_float; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_float; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_float; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_float; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_float; -- conversion not supported DROP TABLE T_float; @@ -734,10 +706,8 @@ SELECT v, convert(v, Blob) from T_real; SELECT v, convert(v, date) from T_real; -- conversion not supported SELECT v, convert(v, time) from T_real; -- conversion not supported SELECT v, convert(v, timestamp) from T_real; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_real; -- data type not supported (parse error) -SELECT v, convert(v, timestamp with timezone) from T_real; -- data type not supported (parse error) -SELECT v, convert(v, timetz) from T_real; -- conversion not supported -SELECT v, convert(v, timestamptz) from T_real; -- conversion not supported +SELECT v, convert(v, time with time zone) from T_real; -- conversion not supported +SELECT v, convert(v, timestamp with time zone) from T_real; -- conversion not supported -- test cast() SELECT v, cast(v as boolean) from T_real; @@ -777,10 +747,8 @@ SELECT v, cast(v as Blob) from T_real; - SELECT v, cast(v as date) from T_real; -- conversion not supported SELECT v, cast(v as time) from T_real; -- conversion not supported SELECT v, cast(v as timestamp) from T_real; -- conversion not supported -SELECT v, cast(v as time with timezone) from T_real; -- data type not supported (parse error) -SELECT v, cast(v as timestamp with timezone) from T_real; -- data type not supported (parse error) -SELECT v, cast(v as timetz) from T_real; -- conversion not supported -SELECT v, cast(v as timestamptz) from T_real; -- conversion not supported +SELECT v, cast(v as time with time zone) from T_real; -- conversion not supported +SELECT v, cast(v as timestamp with time zone) from T_real; -- conversion not supported DROP TABLE T_real; @@ -829,10 +797,8 @@ SELECT v, convert(v, Blob) from T_double SELECT v, convert(v, date) from T_double; -- conversion not supported SELECT v, convert(v, time) from T_double; -- conversion not supported SELECT v, convert(v, timestamp) from T_double; -- conversion not supported -SELECT v, convert(v, time with timezone) from T_double; -- data type not supported (parse error) _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
