Changeset: 6b83fe7310c0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6b83fe7310c0
Added Files:
sql/test/pg_regress/Tests/int8.stable.err.int128
sql/test/pg_regress/Tests/int8.stable.out.int128
Modified Files:
sql/test/pg_regress/Tests/int8.stable.err
sql/test/pg_regress/Tests/int8.stable.out
Branch: default
Log Message:
Added .int128 specific output file to support different outputs on different
architectures (see testweb)
diffs (truncated from 367 to 300 lines):
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
@@ -51,6 +51,9 @@ MAPI = (monetdb) /var/tmp/mtest-29915/.
QUERY = INSERT INTO INT8_TBL(q1) VALUES ('');
ERROR = !conversion of string '' to type lng failed.
MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL;
+ERROR = !overflow in calculation 4567890123456789*4567890123456789.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
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)'
diff --git a/sql/test/pg_regress/Tests/int8.stable.err.int128
b/sql/test/pg_regress/Tests/int8.stable.err.int128
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/int8.stable.err.int128
@@ -0,0 +1,112 @@
+stderr of test 'int8` in directory 'sql/test/pg_regress` itself:
+
+
+# 17:11:18 >
+# 17:11:18 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=38959" "--set"
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0"
+# 17:11:18 >
+
+# builtin opt gdk_dbpath = /ufs/dinther/INSTALL/var/monetdb5/dbfarm/demo
+# builtin opt gdk_debug = 0
+# builtin opt gdk_vmtrim = no
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 38959
+# cmdline opt mapi_usock = /var/tmp/mtest-1142/.s.monetdb.38959
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbpath =
/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress
+# cmdline opt mal_listing = 0
+# cmdline opt gdk_debug = 536870922
+
+# 17:11:19 >
+# 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-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES (' ');
+ERROR = !conversion of string ' ' to type lng failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES ('xxx');
+ERROR = !conversion of string 'xxx' to type lng failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485');
+ERROR = !conversion of string '3908203590239580293850293850329485' to type lng
failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES
('-1204982019841029840928340329840934');
+ERROR = !conversion of string '-1204982019841029840928340329840934' to type
lng failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES ('- 123');
+ERROR = !conversion of string '- 123' to type lng failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES (' 345 5');
+ERROR = !conversion of string ' 345 5' to type lng failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO INT8_TBL(q1) VALUES ('');
+ERROR = !conversion of string '' to type lng failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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(hugeint,char)'
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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(hugeint,char)'
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+QUERY = SELECT '' AS to_char_17, to_char(q2, '999999SG9999999999') FROM
INT8_TBL;
+ERROR = !SELECT: no such binary operator 'to_char(bigint,char)'
+
+# 17:11:19 >
+# 17:11:19 > "Done."
+# 17:11:19 >
+
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
@@ -72,7 +72,7 @@ Ready.
#SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
% five, q1, q2, plus # name
-% char, bigint, bigint, hugeint # type
+% char, bigint, bigint, bigint # type
% 0, 16, 17, 16 # length
[ "", 123, 456, 579 ]
[ "", 123, 4567890123456789, 4567890123456912 ]
@@ -83,7 +83,7 @@ Ready.
#SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
% five, q1, q2, minus # name
-% char, bigint, bigint, hugeint # type
+% char, bigint, bigint, bigint # type
% 0, 16, 17, 17 # length
[ "", 123, 456, -333 ]
[ "", 123, 4567890123456789, -4567890123456666 ]
@@ -93,23 +93,13 @@ Ready.
#SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL;
% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
% three, q1, q2, multiply # name
-% char, bigint, bigint, hugeint # type
+% char, bigint, bigint, bigint # type
% 0, 16, 17, 33 # length
[ "", 123, 456, 56088 ]
[ "", 123, 4567890123456789, 561850485185185047 ]
[ "", 4567890123456789, 123, 561850485185185047 ]
[ "", 4567890123456789, 4567890123456789,
20865620179974079051998750190521 ]
[ "", 4567890123456789, -4567890123456789,
-20865620179974079051998750190521 ]
-#SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL
-# WHERE q1 < 1000 or (q2 > 0 and q2 < 1000);
-% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
-% three, q1, q2, multiply # name
-% char, bigint, bigint, hugeint # type
-% 0, 16, 16, 18 # length
-[ "", 123, 456, 56088 ]
-[ "", 123, 4567890123456789, 561850485185185047 ]
-[ "", 4567890123456789, 123, 561850485185185047 ]
-
#SELECT '' AS five, q1, q2, q1 / q2 AS divide FROM INT8_TBL;
% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
% five, q1, q2, divide # name
@@ -143,7 +133,7 @@ Ready.
#SELECT '' AS five, 2 * q1 AS "twice integer" FROM INT8_TBL;
% .L, .L # table_name
% five, "twice integer" # name
-% char, hugeint # type
+% char, bigint # type
% 0, 16 # length
[ "", 246 ]
[ "", 246 ]
@@ -154,7 +144,7 @@ Ready.
#SELECT '' AS five, q1 * 2 AS "twice integer" FROM INT8_TBL;
% .L, sys.L # table_name
% five, "twice integer" # name
-% char, hugeint # type
+% char, bigint # type
% 0, 16 # length
[ "", 246 ]
[ "", 246 ]
diff --git a/sql/test/pg_regress/Tests/int8.stable.out.int128
b/sql/test/pg_regress/Tests/int8.stable.out.int128
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/int8.stable.out.int128
@@ -0,0 +1,168 @@
+stdout of test 'int8` in directory 'sql/test/pg_regress` itself:
+
+
+# 17:11:18 >
+# 17:11:18 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=38959" "--set"
"mapi_usock=/var/tmp/mtest-1142/.s.monetdb.38959" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0"
+# 17:11:18 >
+
+# MonetDB 5 server v11.18.0
+# This is an unreleased version
+# Serving database 'mTests_sql_test_pg_regress', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Found 15.356 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://uwakai.da.cwi.nl:38959/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-1142/.s.monetdb.38959
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+
+# 17:11:19 >
+# 17:11:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-1142" "--port=38959"
+# 17:11:19 >
+
+#--
+#-- bigint
+#-- Test bigint 64-bit integers.
+#--
+#CREATE TABLE INT8_TBL(q1 bigint, q2 bigint);
+#INSERT INTO INT8_TBL VALUES(' 123 ',' 456');
+[ 1 ]
+#INSERT INTO INT8_TBL VALUES('123 ','4567890123456789');
+[ 1 ]
+#INSERT INTO INT8_TBL VALUES('4567890123456789','123');
+[ 1 ]
+#INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789');
+[ 1 ]
+#INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789');
+[ 1 ]
+#-- bad inputs
+#
+#
+#
+#
+#
+#
+#
+#SELECT * FROM INT8_TBL;
+% sys.int8_tbl, sys.int8_tbl # table_name
+% q1, q2 # name
+% bigint, bigint # type
+% 16, 17 # length
+[ 123, 456 ]
+[ 123, 4567890123456789 ]
+[ 4567890123456789, 123 ]
+[ 4567890123456789, 4567890123456789 ]
+[ 4567890123456789, -4567890123456789 ]
+
+#SELECT '' AS five, q1 AS plus, -q1 AS minus FROM INT8_TBL;
+% .L, sys.L, sys.L # table_name
+% five, plus, minus # name
+% char, bigint, bigint # type
+% 0, 16, 17 # length
+[ "", 123, -123 ]
+[ "", 123, -123 ]
+[ "", 4567890123456789, -4567890123456789 ]
+[ "", 4567890123456789, -4567890123456789 ]
+[ "", 4567890123456789, -4567890123456789 ]
+
+#SELECT '' AS five, q1, q2, q1 + q2 AS plus FROM INT8_TBL;
+% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
+% five, q1, q2, plus # name
+% char, bigint, bigint, hugeint # type
+% 0, 16, 17, 16 # length
+[ "", 123, 456, 579 ]
+[ "", 123, 4567890123456789, 4567890123456912 ]
+[ "", 4567890123456789, 123, 4567890123456912 ]
+[ "", 4567890123456789, 4567890123456789, 9135780246913578 ]
+[ "", 4567890123456789, -4567890123456789, 0 ]
+
+#SELECT '' AS five, q1, q2, q1 - q2 AS minus FROM INT8_TBL;
+% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
+% five, q1, q2, minus # name
+% char, bigint, bigint, hugeint # type
+% 0, 16, 17, 17 # length
+[ "", 123, 456, -333 ]
+[ "", 123, 4567890123456789, -4567890123456666 ]
+[ "", 4567890123456789, 123, 4567890123456666 ]
+[ "", 4567890123456789, 4567890123456789, 0 ]
+[ "", 4567890123456789, -4567890123456789, 9135780246913578 ]
+#SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL;
+% .L, sys.int8_tbl, sys.int8_tbl, sys.L # table_name
+% three, q1, q2, multiply # name
+% char, bigint, bigint, hugeint # type
+% 0, 16, 17, 33 # length
+[ "", 123, 456, 56088 ]
+[ "", 123, 4567890123456789, 561850485185185047 ]
+[ "", 4567890123456789, 123, 561850485185185047 ]
+[ "", 4567890123456789, 4567890123456789,
20865620179974079051998750190521 ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
