Changeset: 7c32bb5fc275 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c32bb5fc275
Modified Files:
sql/test/pg_regress/Tests/float8.stable.err.Windows
sql/test/pg_regress/Tests/oid.stable.err.32bit
Branch: default
Log Message:
Approve testweb err outputs missing SQLState Codes
diffs (258 lines):
diff --git a/sql/test/pg_regress/Tests/float8.stable.err.Windows
b/sql/test/pg_regress/Tests/float8.stable.err.Windows
--- a/sql/test/pg_regress/Tests/float8.stable.err.Windows
+++ b/sql/test/pg_regress/Tests/float8.stable.err.Windows
@@ -29,99 +29,133 @@ stderr of test 'float8` in directory 'sq
# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
# 17:11:19 >
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('10e400' as double);
ERROR = !conversion of string '10e400' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('-10e400' as double);
ERROR = !conversion of string '-10e400' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES (' ');
ERROR = !conversion of string ' ' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz');
ERROR = !conversion of string 'xyz' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('5.0.0');
ERROR = !conversion of string '5.0.0' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0');
ERROR = !conversion of string '5 . 0' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0');
ERROR = !conversion of string '5. 0' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3');
ERROR = !conversion of string ' - 3' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5');
ERROR = !conversion of string '123 5' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('NaN' as double);
ERROR = !conversion of string 'NaN' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('nan' as double);
ERROR = !conversion of string 'nan' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast(' NAN ' as double);
ERROR = !conversion of string ' NAN ' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('infinity' as double);
ERROR = !conversion of string 'infinity' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast(' -INFINiTY ' as double);
ERROR = !conversion of string ' -INFINiTY ' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('N A N' as double);
ERROR = !conversion of string 'N A N' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('NaN x' as double);
ERROR = !conversion of string 'NaN x' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast(' INFINITY x' as double);
ERROR = !conversion of string ' INFINITY x' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('Infinity' as double) + 100.0;
ERROR = !conversion of string 'Infinity' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('Infinity' as double) / cast('Infinity' as double);
ERROR = !conversion of string 'Infinity' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT cast('nan' as double) / cast('nan' as double);
ERROR = !conversion of string 'nan' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT '' AS five, f.f1, truncate(f1) AS trunc_f1
FROM FLOAT8_TBL f;
ERROR = !SELECT: no such unary operator 'truncate(double)'
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 42000
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT |/ cast('64' as double) AS eight;
-ERROR = !syntax error, unexpected '|' in: "select |"
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+ERROR = !syntax/parse error,
+# the original non-normalized output was: ERROR = !syntax error, unexpected
'|' in: "select |"
+CODE = 42000
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
FROM FLOAT8_TBL f
WHERE f.f1 > '0.0';
-ERROR = !syntax error, unexpected '|' in: "select '' as three, f.f1, |"
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+ERROR = !syntax/parse error,
+# the original non-normalized output was: ERROR = !syntax error, unexpected
'|' in: "select '' as three, f.f1, |"
+CODE = 42000
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT ||/ cast('27' as double) AS three;
-ERROR = !syntax error, unexpected CONCATSTRING in: "select ||"
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+ERROR = !syntax/parse error,
+# the original non-normalized output was: ERROR = !syntax error, unexpected
CONCATSTRING in: "select ||"
+CODE = 42000
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
-ERROR = !syntax error, unexpected CONCATSTRING in: "select '' as five, f.f1,
||"
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+ERROR = !syntax/parse error,
+# the original non-normalized output was: ERROR = !syntax error, unexpected
CONCATSTRING in: "select '' as five, f.f1, ||"
+CODE = 42000
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f;
ERROR = !overflow in calculation -1.2345678901234e+200*9.9999999999999997e+199.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22003
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
-ERROR = !decimal (1e200) doesn't have format (18.0)
-MAPI = (monetdb) /var/tmp/mtest-4855/.s.monetdb.34828
+ERROR = !too many digits (201 > 38)
+CODE = 22003
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
ERROR = !division by zero.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22012
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
ERROR = !conversion of string '10e400' to type dbl failed.
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 22018
+#~ MAPI = (monetdb) /var/tmp/mtest-21115/.s.monetdb.39615
QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
ERROR = !conversion of string '-10e400' to type dbl failed.
+CODE = 22018
# 17:11:19 >
# 17:11:19 > "Done."
diff --git a/sql/test/pg_regress/Tests/oid.stable.err.32bit
b/sql/test/pg_regress/Tests/oid.stable.err.32bit
--- a/sql/test/pg_regress/Tests/oid.stable.err.32bit
+++ b/sql/test/pg_regress/Tests/oid.stable.err.32bit
@@ -29,50 +29,66 @@ stderr of test 'oid` in directory 'sql/t
# 15:18:43 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7372" "--port=31804"
# 15:18:43 >
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (12345678901);
ERROR = !overflow in conversion of 12345678901 to oid.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22003
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('asdfasd');
ERROR = !conversion of string 'asdfasd' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('99asdfasd');
ERROR = !conversion of string '99asdfasd' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('5 d');
ERROR = !conversion of string '5 d' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (' 5d');
ERROR = !conversion of string ' 5d' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('5 5');
ERROR = !conversion of string '5 5' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (-10); -- negative oids are not
allowed in MonetDB, so this should fail
ERROR = !overflow in conversion of -10 to oid.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22003
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (-1040); -- negative oids are not
allowed in MonetDB, so this should fail
ERROR = !overflow in conversion of -1040 to oid.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22003
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('-1040'); -- negative oids are not
allowed in MonetDB, so this should fail
ERROR = !conversion of string '-1040' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (' - 500');
ERROR = !conversion of string ' - 500' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('32958209582039852935');
ERROR = !conversion of string '32958209582039852935' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (32958209582039852935);
ERROR = !integer value too large or not a number (32958209582039852935) in:
"insert into oid_tbl(f1) values (32958209582039852935"
- !syntax error, unexpected ')' in: ")"
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+ !syntax/parse error,
+# the original non-normalized output was: !syntax error, unexpected
')' in: ")"
+CODE = 22003
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES ('-23582358720398502385');
ERROR = !conversion of string '-23582358720398502385' to type oid failed.
-MAPI = (monetdb) /var/tmp/mtest-9364/.s.monetdb.31208
+CODE = 22018
+#~ MAPI = monetdb@LAB03:33951
QUERY = INSERT INTO OID_TBL(f1) VALUES (-23582358720398502385);
ERROR = !integer value too large or not a number (23582358720398502385) in:
"insert into oid_tbl(f1) values (-23582358720398502385"
- !syntax error, unexpected ')' in: ")"
+ !syntax/parse error,
+# the original non-normalized output was: !syntax error, unexpected
')' in: ")"
+CODE = 22003
# 16:41:57 >
# 16:41:57 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
