Changeset: 3bea45bee0ef for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3bea45bee0ef
Added Files:
sql/test/pg_regress/Tests/float8.stable.err.Windows
sql/test/pg_regress/Tests/float8.stable.out.Windows
sql/test/pg_regress/Tests/without_oid.stable.out.oid32
Modified Files:
sql/test/pg_regress/Tests/numeric.stable.out
sql/test/pg_regress/Tests/oid.stable.err.oid32
sql/test/pg_regress/Tests/oid.stable.out.oid32
sql/test/pg_regress/Tests/timestamptz.stable.out
Branch: default
Log Message:
Merger
diffs (truncated from 857 to 300 lines):
diff --git a/sql/test/pg_regress/Tests/float8.stable.err.Windows
b/sql/test/pg_regress/Tests/float8.stable.err.Windows
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/float8.stable.err.Windows
@@ -0,0 +1,136 @@
+stderr of test 'float8` 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 = SELECT cast('10e400' as double);
+ERROR = !conversion of string '10e400' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT cast('-10e400' as double);
+ERROR = !conversion of string '-10e400' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('xyz');
+ERROR = !conversion of string 'xyz' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('5 . 0');
+ERROR = !conversion of string '5 . 0' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('5. 0');
+ERROR = !conversion of string '5. 0' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES (' - 3');
+ERROR = !conversion of string ' - 3' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('123 5');
+ERROR = !conversion of string '123 5' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast('NaN' as double);
+ERROR = !conversion of string 'NaN' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast('nan' as double);
+ERROR = !conversion of string 'nan' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast(' NAN ' as double);
+ERROR = !conversion of string ' NAN ' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast('infinity' as double);
+ERROR = !conversion of string 'infinity' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast(' -INFINiTY ' as double);
+ERROR = !conversion of string ' -INFINiTY ' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT cast('N A N' as double);
+ERROR = !conversion of string 'N A N' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT cast('NaN x' as double);
+ERROR = !conversion of string 'NaN x' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT cast(' INFINITY x' as double);
+ERROR = !conversion of string ' INFINITY x' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT cast('Infinity' as double) + 100.0;
+ERROR = !conversion of string 'Infinity' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast('Infinity' as double) / cast('Infinity' as double);
+ERROR = !conversion of string 'Infinity' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT cast('nan' as double) / cast('nan' as double);
+ERROR = !conversion of string 'nan' to type dbl failed.
+MAPI = monetdb@LAB03:31271
+QUERY = SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
+ FROM FLOAT8_TBL f where f.f1 = '1004.3';
+ERROR = !rounding of decimal (2.0) doesn't fit format (19.0)
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+QUERY = SELECT |/ cast('64' as double) AS eight;
+ERROR = !syntax error, unexpected '|' in: "select |"
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+QUERY = SELECT ||/ cast('27' as double) AS three;
+ERROR = !syntax error, unexpected CONCATSTRING in: "select ||"
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+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-29915/.s.monetdb.37487
+QUERY = SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f;
+ERROR = !decimal (1e20) doesn't have format (19.0)
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT '' AS bad, log(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ;
+ERROR = !Math exception: Result too large
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT '' AS bad, log(f.f1) from FLOAT8_TBL f where f.f1 < '0.0' ;
+ERROR = !Math exception: Domain error
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f;
+ERROR = !division by zero.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
+ERROR = !conversion of string '10e400' to type dbl failed.
+MAPI = (monetdb) /var/tmp/mtest-29915/.s.monetdb.37487
+QUERY = INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
+ERROR = !conversion of string '-10e400' to type dbl failed.
+
+# 17:11:19 >
+# 17:11:19 > "Done."
+# 17:11:19 >
+
diff --git a/sql/test/pg_regress/Tests/float8.stable.out.Windows
b/sql/test/pg_regress/Tests/float8.stable.out.Windows
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/float8.stable.out.Windows
@@ -0,0 +1,324 @@
+stdout of test 'float8` 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 >
+
+#--
+#-- double
+#--
+#CREATE TABLE FLOAT8_TBL(f1 double);
+#INSERT INTO FLOAT8_TBL(f1) VALUES (' 0.0 ');
+[ 1 ]
+#INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30 ');
+[ 1 ]
+#INSERT INTO FLOAT8_TBL(f1) VALUES (' -34.84');
+[ 1 ]
+#INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
+[ 1 ]
+#INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
+[ 1 ]
+#SELECT cast('10e-400' as double);
+% .L1 # table_name
+% L1 # name
+% double # type
+% 24 # length
+[ 0 ]
+#SELECT cast('-10e-400' as double);
+% .L1 # table_name
+% L1 # name
+% double # type
+% 24 # length
+[ -0 ]
+#INSERT INTO FLOAT8_TBL(f1) VALUES (' ');
+[ 1 ]
+#SELECT '' AS five, * FROM FLOAT8_TBL;
+% .L, sys.float8_tbl # table_name
+% five, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 0 ]
+[ "", 1004.3 ]
+[ "", -34.84 ]
+[ "", 1.23456789e+200 ]
+[ "", 1.23456789e-200 ]
+[ "", NULL ]
+#SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
+% .L, sys.f # table_name
+% four, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 0 ]
+[ "", -34.84 ]
+[ "", 1.23456789e+200 ]
+[ "", 1.23456789e-200 ]
+#SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
+% .L, sys.f # table_name
+% one, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 1004.3 ]
+#SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
+% .L, sys.f # table_name
+% three, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 0 ]
+[ "", -34.84 ]
+[ "", 1.23456789e-200 ]
+#SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
+% .L, sys.f # table_name
+% three, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 0 ]
+[ "", -34.84 ]
+[ "", 1.23456789e-200 ]
+#SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
+% .L, sys.f # table_name
+% four, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 0 ]
+[ "", 1004.3 ]
+[ "", -34.84 ]
+[ "", 1.23456789e-200 ]
+#SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
+% .L, sys.f # table_name
+% four, f1 # name
+% char, double # type
+% 0, 24 # length
+[ "", 0 ]
+[ "", 1004.3 ]
+[ "", -34.84 ]
+[ "", 1.23456789e-200 ]
+#SELECT '' AS three, f.f1, f.f1 * '-10' AS x
+# FROM FLOAT8_TBL f
+# WHERE f.f1 > '0.0';
+% .L, sys.f, sys.L # table_name
+% three, f1, x # name
+% char, double, double # type
+% 0, 24, 24 # length
+[ "", 1004.3, -10043 ]
+[ "", 1.23456789e+200, -1.23456789e+201 ]
+[ "", 1.23456789e-200, -1.23456789e-199 ]
+#SELECT '' AS three, f.f1, f.f1 + '-10' AS x
+# FROM FLOAT8_TBL f
+# WHERE f.f1 > '0.0';
+% .L, sys.f, sys.L # table_name
+% three, f1, x # name
+% char, double, double # type
+% 0, 24, 24 # length
+[ "", 1004.3, 994.3 ]
+[ "", 1.23456789e+200, 1.23456789e+200 ]
+[ "", 1.23456789e-200, -10 ]
+#SELECT '' AS three, f.f1, f.f1 / '-10' AS x
+# FROM FLOAT8_TBL f
+# WHERE f.f1 > '0.0';
+% .L, sys.f, sys.L # table_name
+% three, f1, x # name
+% char, double, double # type
+% 0, 24, 24 # length
+[ "", 1004.3, -100.43 ]
+[ "", 1.23456789e+200, -1.23456789e+199 ]
+[ "", 1.23456789e-200, -1.23456789e-201 ]
+#SELECT '' AS three, f.f1, f.f1 - '-10' AS x
+# FROM FLOAT8_TBL f
+# WHERE f.f1 > '0.0';
+% .L, sys.f, sys.L # table_name
+% three, f1, x # name
+% char, double, double # type
+% 0, 24, 24 # length
+[ "", 1004.3, 1014.3 ]
+[ "", 1.23456789e+200, 1.23456789e+200 ]
+[ "", 1.23456789e-200, 10 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
