Changeset: ba72f7712e27 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ba72f7712e27
Modified Files:
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err
Branch: mtime
Log Message:
Approve.
diffs (truncated from 4480 to 300 lines):
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
@@ -33,3545 +33,3241 @@ QUERY = SELECT v, convert(v, bit) from T
ERROR = !Type (bit) unknown in: "select v, convert(v, bit)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-24770/.s.monetdb.36959
QUERY = SELECT v, convert(v, hugeint) from T_BOOLEAN;
ERROR = !Type (hugeint) unknown in: "select v, convert(v, hugeint)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-24770/.s.monetdb.36959
QUERY = SELECT v, convert(v, float) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and double(53,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, float(24)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and real(24,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, real) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and real(24,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, double) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and double(53,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, double precision) from T_BOOLEAN; -- conversion
not supported
ERROR = !types boolean(1,0) and double(53,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, numeric) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(18,3) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, decimal) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(18,3) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, numeric(7)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(7,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, decimal(9)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(9,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, numeric(12,0)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(12,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, decimal(15,3)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(15,3) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, varchar) from T_BOOLEAN; -- missing length
specification
ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select
v, convert(v, varchar)"
!syntax error, unexpected FROM in: "from"
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, longvarchar) from T_BOOLEAN; -- LONGVARCHAR not
valid data type
ERROR = !Type (longvarchar) unknown in: "select v, convert(v, longvarchar)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, long varchar) from T_BOOLEAN; -- LONG VARCHAR not
valid data type
ERROR = !Type (long) unknown in: "select v, convert(v, long varchar"
!syntax error, unexpected ')' in: ")"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, Binary) from T_BOOLEAN; -- BINARY not valid data
type
ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v,
convert(v, binary)"
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, varBinary) from T_BOOLEAN; -- VARBINARY not valid
data type
ERROR = !Type (varbinary) unknown in: "select v, convert(v, varbinary)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, longvarBinary) from T_BOOLEAN; -- LONGVARBINARY
not valid data type
ERROR = !Type (longvarbinary) unknown in: "select v, convert(v, longvarbinary)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, Blob) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and blob(0,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, date) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and date(0,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, time) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and time(1,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, timestamp) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and timestamp(7,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
-QUERY = SELECT v, convert(v, time with timezone) from T_BOOLEAN; -- data type
not supported (parse error)
-ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v,
convert(v, time with timezone"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
-QUERY = SELECT v, convert(v, timestamp with timezone) from T_BOOLEAN; -- 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-28549/.s.monetdb.31468
-QUERY = SELECT v, convert(v, timetz) from T_BOOLEAN; -- conversion not
supported
-ERROR = !types boolean(1,0) and timetz(7,0) are not equal for column 'v'
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
-QUERY = SELECT v, convert(v, timestamptz) from T_BOOLEAN; -- conversion not
supported
+MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398
+QUERY = SELECT v, convert(v, time with time zone) from T_BOOLEAN; --
conversion not supported
+ERROR = !types boolean(1,0) and timetz(1,0) are not equal for column 'v'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398
+QUERY = SELECT v, convert(v, timestamp with time zone) from T_BOOLEAN; --
conversion not supported
ERROR = !types boolean(1,0) and timestamptz(7,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as bit) from T_BOOLEAN; -- BIT not valid data type
ERROR = !Type (bit) unknown in: "select v, cast(v as bit)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-24770/.s.monetdb.36959
QUERY = SELECT v, cast(v as hugeint) from T_BOOLEAN;
ERROR = !Type (hugeint) unknown in: "select v, cast(v as hugeint)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-24770/.s.monetdb.36959
QUERY = SELECT v, cast(v as float) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and double(53,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as float(24)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and real(24,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as real) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and real(24,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as double) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and double(53,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as double precision) from T_BOOLEAN; -- conversion
not supported
ERROR = !types boolean(1,0) and double(53,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as numeric) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(18,3) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as decimal) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(18,3) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as numeric(7)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(7,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as decimal(9)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(9,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as numeric(12,0)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(12,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as decimal(15,3)) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and decimal(15,3) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as varchar) from T_BOOLEAN;
ERROR = !CHARACTER VARYING needs a mandatory length specification in: "select
v, cast(v as varchar)"
!syntax error, unexpected FROM in: "from"
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as longvarchar) from T_BOOLEAN; -- LONGVARCHAR not
valid data type
ERROR = !Type (longvarchar) unknown in: "select v, cast(v as longvarchar)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as long varchar) from T_BOOLEAN; -- LONG VARCHAR not
valid data type
ERROR = !Type (long) unknown in: "select v, cast(v as long varchar"
!syntax error, unexpected ')' in: ")"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as Binary) from T_BOOLEAN; -- BINARY not valid data
type
ERROR = !syntax error, unexpected ')', expecting LARGE in: "select v, cast(v
as binary)"
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as varBinary) from T_BOOLEAN; -- VARBINARY not valid
data type
ERROR = !Type (varbinary) unknown in: "select v, cast(v as varbinary)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as longvarBinary) from T_BOOLEAN; -- LONGVARBINARY
not valid data type
ERROR = !Type (longvarbinary) unknown in: "select v, cast(v as longvarbinary)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as Blob) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and blob(0,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as date) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and date(0,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as time) from T_BOOLEAN; -- conversion not supported
ERROR = !types boolean(1,0) and time(1,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, cast(v as timestamp) from T_BOOLEAN; -- conversion not
supported
ERROR = !types boolean(1,0) and timestamp(7,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
-QUERY = SELECT v, cast(v as time with timezone) from T_BOOLEAN; -- data type
not supported (parse error)
-ERROR = !syntax error, unexpected IDENT, expecting TIME in: "select v, cast(v
as time with timezone"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
-QUERY = SELECT v, cast(v as timestamp with timezone) from T_BOOLEAN; -- 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-28549/.s.monetdb.31468
-QUERY = SELECT v, cast(v as timetz) from T_BOOLEAN; -- conversion not supported
-ERROR = !types boolean(1,0) and timetz(7,0) are not equal for column 'v'
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
-QUERY = SELECT v, cast(v as timestamptz) from T_BOOLEAN; -- conversion not
supported
+MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398
+QUERY = SELECT v, cast(v as time with time zone) from T_BOOLEAN; -- conversion
not supported
+ERROR = !types boolean(1,0) and timetz(1,0) are not equal for column 'v'
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-29584/.s.monetdb.33398
+QUERY = SELECT v, cast(v as timestamp with time zone) from T_BOOLEAN; --
conversion not supported
ERROR = !types boolean(1,0) and timestamptz(7,0) are not equal for column 'v'
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, XML) from T_BOOLEAN; -- XML not valid data type
ERROR = !Type (xml) unknown in: "select v, convert(v, xml)"
!syntax error, unexpected FROM in: "from"
CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-28549/.s.monetdb.31468
+MAPI = (monetdb) /var/tmp/mtest-30274/.s.monetdb.37685
QUERY = SELECT v, convert(v, REF) from T_BOOLEAN; -- REF not valid data type
ERROR = !syntax error, unexpected REF in: "select v, convert(v, ref"
CODE = 42000
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
