Changeset: a9810d774e67 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a9810d774e67
Added Files:
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test
Removed Files:
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.SQL.py
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
Modified Files:
sql/test/BugTracker-2016/Tests/All
Branch: default
Log Message:
Use .test format and enable test just for int128 installations
diffs (truncated from 23847 to 300 lines):
diff --git a/sql/test/BugTracker-2016/Tests/All
b/sql/test/BugTracker-2016/Tests/All
--- a/sql/test/BugTracker-2016/Tests/All
+++ b/sql/test/BugTracker-2016/Tests/All
@@ -1,5 +1,5 @@
HAVE_GEOM?storagemodel
-convert-function-test.Bug-3460
+HAVE_HGE?convert-function-test.Bug-3460
HAVE_HGE?convert-function-test-hge.Bug-3460
groupby_on_column_expression.Bug-3832
LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908
diff --git
a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.SQL.py
b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.SQL.py
deleted file mode 100644
--- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.SQL.py
+++ /dev/null
@@ -1,19 +0,0 @@
-from MonetDBtesting.sqltest import SQLTestCase
-import pymonetdb, os
-
-conn1 = pymonetdb.connect(database=os.getenv("TSTDB"),
port=int(os.getenv("MAPIPORT")), autocommit=True)
-cur1 = conn1.cursor()
-try:
- cur1.execute('select cast(1 as hugeint)')
- suffix = '.int128'
-except pymonetdb.DatabaseError as e:
- suffix = ''
-cur1.close()
-conn1.close()
-
-with SQLTestCase() as tc:
- tc.connect()
- with open('convert-function-test.Bug-3460.sql') as f:
- tc.execute(query=None, client='mclient', stdin=f)\
-
.assertMatchStableOut(fout='convert-function-test.Bug-3460.stable.out%s' %
(suffix))\
-
.assertMatchStableError(ferr='convert-function-test.Bug-3460.stable.err%s' %
(suffix))
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
deleted file mode 100644
--- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err
+++ /dev/null
@@ -1,3240 +0,0 @@
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, bit) from T_BOOLEAN; -- BIT not valid data type
-ERROR = !Type (bit) unknown in: "select v, convert(v, bit)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, hugeint) from T_BOOLEAN;
-ERROR = !Type (hugeint) unknown in: "select v, convert(v, hugeint)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: ")"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, Binary) from T_BOOLEAN; -- BINARY not valid data
type
-ERROR = !syntax error in: "select v, convert(v, binary)"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, cast(v as hugeint) from T_BOOLEAN;
-ERROR = !Type (hugeint) unknown in: "select v, cast(v as hugeint)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: ")"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, cast(v as Binary) from T_BOOLEAN; -- BINARY not valid data
type
-ERROR = !syntax error in: "select v, cast(v as binary)"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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-146634/.s.monetdb.36912
-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 in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, REF) from T_BOOLEAN; -- REF not valid data type
-ERROR = !syntax error in: "select v, convert(v, ref"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, ROWID) from T_BOOLEAN; -- ROWID not valid data
type
-ERROR = !Type (rowid) unknown in: "select v, convert(v, rowid)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, STRUCT) from T_BOOLEAN; -- STRUCT not valid data
type
-ERROR = !Type (struct) unknown in: "select v, convert(v, struct)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, cast(v as XML) from T_BOOLEAN; -- XML not valid data type
-ERROR = !Type (xml) unknown in: "select v, cast(v as xml)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, cast(v as REF) from T_BOOLEAN; -- REF not valid data type
-ERROR = !syntax error in: "select v, cast(v as ref"
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, cast(v as ROWID) from T_BOOLEAN; -- ROWID not valid data type
-ERROR = !Type (rowid) unknown in: "select v, cast(v as rowid)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, cast(v as STRUCT) from T_BOOLEAN; -- STRUCT not valid data
type
-ERROR = !Type (struct) unknown in: "select v, cast(v as struct)"
- !syntax error in: "from"
-CODE = 22000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, boolean) from T_blob;
-ERROR = !types blob(0,0) and boolean(1,0) are not equal for column 'v'
-CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-146634/.s.monetdb.36912
-QUERY = SELECT v, convert(v, bit) from T_blob; -- BIT not valid data type
-ERROR = !Type (bit) unknown in: "select v, convert(v, bit)"
- !syntax error in: "from"
-CODE = 22000
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
