Changeset: b57697688bc1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b57697688bc1
Modified Files:
sql/test/pg_regress/Tests/float8.stable.err
sql/test/pg_regress/Tests/int8.stable.err
sql/test/pg_regress/Tests/int8.stable.out
sql/test/pg_regress/Tests/interval.stable.err
sql/test/pg_regress/Tests/interval.stable.out
sql/test/pg_regress/Tests/numeric_big.stable.err
sql/test/pg_regress/Tests/oid.stable.err
sql/test/pg_regress/Tests/strings.stable.err
Branch: default
Log Message:
Approve test outputs for platforms which do not support int128.
The CODE = SQLState is missing in the *.err* files.
diffs (truncated from 3508 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/float8.stable.err
b/sql/test/pg_regress/Tests/float8.stable.err
--- a/sql/test/pg_regress/Tests/float8.stable.err
+++ b/sql/test/pg_regress/Tests/float8.stable.err
@@ -32,96 +32,126 @@ stderr of test 'float8` in directory 'sq
MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
QUERY = SELECT |/ cast('64' as double) AS eight;
ERROR = !syntax error, unexpected '|' in: "select |"
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
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
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT ||/ cast('27' as double) AS three;
ERROR = !syntax error, unexpected CONCATSTRING in: "select ||"
-MAPI = (monetdb) /var/tmp/mtest-30808/.s.monetdb.35989
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
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
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-19622/.s.monetdb.32578
+ERROR = !Decimal (1e200) doesn't have format (18.0)
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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-3604/.s.monetdb.35433
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/int8.stable.err
b/sql/test/pg_regress/Tests/int8.stable.err
--- a/sql/test/pg_regress/Tests/int8.stable.err
+++ b/sql/test/pg_regress/Tests/int8.stable.err
@@ -32,82 +32,107 @@ stderr of test 'int8` in directory 'sql/
MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
QUERY = INSERT INTO INT8_TBL(q1) VALUES (' ');
ERROR = !conversion of string ' ' to type lng failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = INSERT INTO INT8_TBL(q1) VALUES ('xxx');
ERROR = !conversion of string 'xxx' to type lng failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485');
ERROR = !conversion of string '3908203590239580293850293850329485' to type lng
failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = INSERT INTO INT8_TBL(q1) VALUES
('-1204982019841029840928340329840934');
ERROR = !conversion of string '-1204982019841029840928340329840934' to type
lng failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = INSERT INTO INT8_TBL(q1) VALUES ('- 123');
ERROR = !conversion of string '- 123' to type lng failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = INSERT INTO INT8_TBL(q1) VALUES (' 345 5');
ERROR = !conversion of string ' 345 5' to type lng failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = INSERT INTO INT8_TBL(q1) VALUES ('');
ERROR = !conversion of string '' to type lng failed.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22018
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL WHERE q2
<> 4567890123456789 ORDER BY q1, q2;
ERROR = !overflow in calculation 4567890123456789*-4567890123456789.
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_1, to_char(q1, '9G999G999G999G999G999'),
to_char(q2, '9,999,999,999,999,999')
FROM INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_2, to_char(q1, '9G999G999G999G999G999D999G999'),
to_char(q2, '9,999,999,999,999,999.999,999')
FROM INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_3, to_char( (q1 * -1), '9999999999999999PR'),
to_char( (q2 * -1), '9999999999999999.999PR')
FROM INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_4, to_char( (q1 * -1), '9999999999999999S'),
to_char( (q2 * -1), 'S9999999999999999')
FROM INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_5, to_char(q2, 'MI9999999999999999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_6, to_char(q2, 'FMS9999999999999999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_7, to_char(q2, 'FM9999999999999999THPR') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_8, to_char(q2, 'SG9999999999999999th') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_9, to_char(q2, '0999999999999999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_10, to_char(q2, 'S0999999999999999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_11, to_char(q2, 'FM0999999999999999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_12, to_char(q2, 'FM9999999999999999.000') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9
9 . 9 9 9') FROM INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_16, to_char(q2, '99999 "text" 9999 "9999" 999
"\\"text between quote marks\\"" 9999') FROM INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
-MAPI = (monetdb) /var/tmp/mtest-19737/.s.monetdb.30205
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-3604/.s.monetdb.35433
QUERY = SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM
INT8_TBL;
ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
+CODE = 42000
# 17:11:19 >
# 17:11:19 > "Done."
diff --git a/sql/test/pg_regress/Tests/int8.stable.out
b/sql/test/pg_regress/Tests/int8.stable.out
--- a/sql/test/pg_regress/Tests/int8.stable.out
+++ b/sql/test/pg_regress/Tests/int8.stable.out
@@ -92,8 +92,7 @@ Ready.
[ "", 4567890123456789, -4567890123456789, 9135780246913578 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
