Changeset: 7dda99339001 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7dda99339001
Added Files:
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err.int128
Modified Files:
sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err
sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err
sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.err
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/BugTracker/Tests/limits_of_decimal.SF-1685357.stable.err
Branch: default
Log Message:
Approve test outputs for platforms which do not support int128.
Mostly the CODE = SQLState is missing in the *.err* files.
diffs (truncated from 6624 to 300 lines):
diff --git a/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err
b/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err
--- a/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err
+++ b/sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err
@@ -69,8 +69,9 @@ stderr of test 'bit_and.SF-2850341` in d
MAPI = (monetdb) /var/tmp/mtest-28528/.s.monetdb.33240
QUERY = select bit_and(3749090034127126942, 0xffffffffffffffff);
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffff) in: "select bit_and(3749090034127126942,
0xffffffffffffffff"
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffff) in: "select bit_and(3749090034127126942,
0xffffffffffffffff"
!syntax error, unexpected ')' in: ")"
+CODE = 22003
# 22:31:14 >
# 22:31:14 > Done.
diff --git
a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
---
a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
+++
b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
@@ -32,14 +32,17 @@ stderr of test 'large-number-operation-s
MAPI = monetdb@niels:34633
QUERY = select 10000000 * 100000 * 11.51 + 51.097 * 100000;
ERROR = !overflow in calculation 115100000000000000*100.
+CODE = 22003
MAPI = monetdb@niels:34633
QUERY = select convert(1000000000000000000 , decimal(20)) *
100000000000000 * 11.51 + 51.097 * 100000000000000;
-ERROR = !decimal of 20 digits are not supported in: "select
convert(1000000000000000000 , decimal(20)"
+ERROR = !Decimal of 20 digits are not supported in: "select
convert(1000000000000000000 , decimal(20)"
!syntax error, unexpected ')' in: ")"
+CODE = 22003
MAPI = monetdb@niels:34633
QUERY = select convert (convert(1000000000000000000 , decimal(20)) *
100000000000000 * 11.51 , decimal(35)) + convert (51.097 * 100000000000000 ,
decimal(35));
-ERROR = !decimal of 20 digits are not supported in: "select convert
(convert(1000000000000000000 , decimal(20)"
+ERROR = !Decimal of 20 digits are not supported in: "select convert
(convert(1000000000000000000 , decimal(20)"
!syntax error, unexpected ')' in: ")"
+CODE = 22003
# 14:36:23 >
diff --git
a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err
b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err
--- a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err
+++ b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err
@@ -33,94 +33,123 @@ stderr of test 'hexadecimal_literals.Bug
MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
QUERY = select 0xg;
ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select 0xg"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0xG;
ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select 0xg"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x8000000000000000;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x8000000000000000) in: "select 0x8000000000000000"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x8000000000000000) in: "select 0x8000000000000000"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x00000000000000008000000000000000;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000000) in: "select
0x00000000000000008000000000000000"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000000) in: "select
0x00000000000000008000000000000000"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x8000000000000001;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x8000000000000001) in: "select 0x8000000000000001"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x8000000000000001) in: "select 0x8000000000000001"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x00000000000000008000000000000001;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000001) in: "select
0x00000000000000008000000000000001"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000001) in: "select
0x00000000000000008000000000000001"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0xffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffff) in: "select 0xffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffff) in: "select 0xffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x0000000000000000ffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x0000000000000000ffffffffffffffff) in: "select
0x0000000000000000ffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x0000000000000000ffffffffffffffff) in: "select
0x0000000000000000ffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x7fffffffffffffffffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x7fffffffffffffffffffffffffffffff) in: "select
0x7fffffffffffffffffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x7fffffffffffffffffffffffffffffff) in: "select
0x7fffffffffffffffffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x80000000000000000000000000000000;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000000) in: "select
0x80000000000000000000000000000000"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000000) in: "select
0x80000000000000000000000000000000"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x80000000000000000000000000000001;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000001) in: "select
0x80000000000000000000000000000001"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000001) in: "select
0x80000000000000000000000000000001"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0xffffffffffffffffffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffffffffffffffffffff) in: "select
0xffffffffffffffffffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffffffffffffffffffff) in: "select
0xffffffffffffffffffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x123456789abcdef01;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef01) in: "select 0x123456789abcdef01"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef01) in: "select 0x123456789abcdef01"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x123456789abcdef0123456789abcdef0;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef0) in: "select
0x123456789abcdef0123456789abcdef0"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef0) in: "select
0x123456789abcdef0123456789abcdef0"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select 0x123456789abcdef0123456789abcdef01;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef01) in: "select
0x123456789abcdef0123456789abcdef01"
-
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef01) in: "select
0x123456789abcdef0123456789abcdef01"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0xg;
ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select -0xg"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0xG;
ERROR = !syntax error, unexpected IDENT, expecting SCOLON in: "select -0xg"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x8000000000000000;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x8000000000000000) in: "select -0x8000000000000000"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x8000000000000000) in: "select -0x8000000000000000"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x00000000000000008000000000000000;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000000) in: "select
-0x00000000000000008000000000000000"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000000) in: "select
-0x00000000000000008000000000000000"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x8000000000000001;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x8000000000000001) in: "select -0x8000000000000001"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x8000000000000001) in: "select -0x8000000000000001"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x00000000000000008000000000000001;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000001) in: "select
-0x00000000000000008000000000000001"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x00000000000000008000000000000001) in: "select
-0x00000000000000008000000000000001"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0xffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffff) in: "select -0xffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffff) in: "select -0xffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x0000000000000000ffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x0000000000000000ffffffffffffffff) in: "select
-0x0000000000000000ffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x0000000000000000ffffffffffffffff) in: "select
-0x0000000000000000ffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x7fffffffffffffffffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x7fffffffffffffffffffffffffffffff) in: "select
-0x7fffffffffffffffffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x7fffffffffffffffffffffffffffffff) in: "select
-0x7fffffffffffffffffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x80000000000000000000000000000000;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000000) in: "select
-0x80000000000000000000000000000000"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000000) in: "select
-0x80000000000000000000000000000000"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x80000000000000000000000000000001;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000001) in: "select
-0x80000000000000000000000000000001"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x80000000000000000000000000000001) in: "select
-0x80000000000000000000000000000001"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0xffffffffffffffffffffffffffffffff;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffffffffffffffffffff) in: "select
-0xffffffffffffffffffffffffffffffff"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0xffffffffffffffffffffffffffffffff) in: "select
-0xffffffffffffffffffffffffffffffff"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x123456789abcdef01;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef01) in: "select -0x123456789abcdef01"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef01) in: "select -0x123456789abcdef01"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x123456789abcdef0123456789abcdef0;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef0) in: "select
-0x123456789abcdef0123456789abcdef0"
-MAPI = (monetdb) /var/tmp/mtest-30147/.s.monetdb.33525
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef0) in: "select
-0x123456789abcdef0123456789abcdef0"
+CODE = 22003
+MAPI = (monetdb) /var/tmp/mtest-25092/.s.monetdb.31020
QUERY = select -0x123456789abcdef0123456789abcdef01;
-ERROR = !invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef01) in: "select
-0x123456789abcdef0123456789abcdef01"
+ERROR = !Invalid hexadecimal number or hexadecimal too large
(0x123456789abcdef0123456789abcdef01) in: "select
-0x123456789abcdef0123456789abcdef01"
+CODE = 22003
# 17:24:30 >
# 17:24:30 > "Done."
diff --git
a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
--- a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
+++ b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
@@ -55,1071 +55,1071 @@ Ready.
# 17:24:30 >
#select 0x0;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 0 ]
#select 0x1;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 1 ]
#select 0x2;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 2 ]
#select 0x3;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 3 ]
#select 0x4;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 4 ]
#select 0x5;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 5 ]
#select 0x6;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 6 ]
#select 0x7;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 7 ]
#select 0x8;
-% .L1 # table_name
-% L1 # name
+% .L2 # table_name
+% L2 # name
% tinyint # type
% 1 # length
[ 8 ]
#select 0x9;
-% .L1 # table_name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
