Changeset: 0ce2c5ae80ff for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0ce2c5ae80ff
Added Files:
sql/test/pg_regress/Tests/interval.stable.err.int128
sql/test/pg_regress/Tests/interval.stable.out.int128
Modified Files:
sql/test/pg_regress/Tests/interval.sql
sql/test/pg_regress/Tests/interval.stable.err
Branch: default
Log Message:
Disabled query which produced overflow error but with different values, so not
usable for testweb
Also added .int128 output files for platforms which support large decimals
diffs (291 lines):
diff --git a/sql/test/pg_regress/Tests/interval.sql
b/sql/test/pg_regress/Tests/interval.sql
--- a/sql/test/pg_regress/Tests/interval.sql
+++ b/sql/test/pg_regress/Tests/interval.sql
@@ -79,7 +79,7 @@ select avg(cast(f1 as decimal(22,3))) fr
select min(f1) from interval_tbl;
select max(f1) from interval_tbl;
-select sum(f1) from interval_tbl;
+--select sum(f1) from interval_tbl;
select sum(cast(f1 as decimal(22,3))) from interval_tbl;
select count(f1) from interval_tbl;
diff --git a/sql/test/pg_regress/Tests/interval.stable.err
b/sql/test/pg_regress/Tests/interval.stable.err
--- a/sql/test/pg_regress/Tests/interval.stable.err
+++ b/sql/test/pg_regress/Tests/interval.stable.err
@@ -117,10 +117,13 @@ ERROR = !types sec_interval(13,0) and do
MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
QUERY = select avg(cast(f1 as decimal)) from interval_tbl;
ERROR = !too many digits (22 > 18)
+QUERY = select avg(cast(f1 as decimal(22,3))) from interval_tbl;
+ERROR = !decimal(22,3) isn't supported because P=22 > 18 in: "select
avg(cast(f1 as decimal(22,3)"
+ !syntax/parse error,
MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
-QUERY = select sum(f1) from interval_tbl;
-ERROR = !overflow in conversion of -1000 to bte.
-
+QUERY = select sum(cast(f1 as decimal(22,3))) from interval_tbl;
+ERROR = !decimal(22,3) isn't supported because P=22 > 18 in: "select
sum(cast(f1 as decimal(22,3)"
+ !syntax/parse error,
# 15:52:24 >
# 15:52:24 > "Done."
diff --git a/sql/test/pg_regress/Tests/interval.stable.err.int128
b/sql/test/pg_regress/Tests/interval.stable.err.int128
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/interval.stable.err.int128
@@ -0,0 +1,125 @@
+stderr of test 'interval` in directory 'sql/test/pg_regress` itself:
+
+
+# 12:56:39 >
+# 12:56:39 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=31190" "--set"
"mapi_usock=/var/tmp/mtest-27974/.s.monetdb.31190" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0" "--set" "embedded_r=yes"
+# 12:56:39 >
+
+# 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 = 31190
+# cmdline opt mapi_usock = /var/tmp/mtest-27974/.s.monetdb.31190
+# 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 embedded_r = yes
+# cmdline opt gdk_debug = 536870922
+
+# 12:56:39 >
+# 12:56:39 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-27974" "--port=31190"
+# 12:56:39 >
+
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT cast('01:00' as interval second) AS "One hour";
+ERROR = !wrong format (01:00)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT cast('+02:00' as interval second) AS "Two hours";
+ERROR = !wrong format (+02:00)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT cast('-08:00' as interval second) AS "Eight hours";
+ERROR = !wrong format (-08:00)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT cast('-1 +02:03' as interval second) AS "22 hours ago...";
+ERROR = !wrong format (-1 +02:03)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT cast('-1 days +02:03' as interval second) AS "22 hours ago...";
+ERROR = !wrong format (-1 days +02:03)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT cast('10 years -11 month -12 days +13:14' as interval second)
AS "9 years...";
+ERROR = !wrong format (10 years -11 month -12 days +13:14)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('1 day 2 hours 3 minutes 4
seconds');
+ERROR = !wrong format (1 day 2 hours 3 minutes 4 seconds)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('6 years');
+ERROR = !wrong format (6 years)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('5 months');
+ERROR = !wrong format (5 months)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('5 months 12 hours');
+ERROR = !wrong format (5 months 12 hours)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 1 minute');
+ERROR = !wrong format (@ 1 minute)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 5 hour');
+ERROR = !wrong format (@ 5 hour)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 10 day');
+ERROR = !wrong format (@ 10 day)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 34 year');
+ERROR = !wrong format (@ 34 year)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 3 months');
+ERROR = !wrong format (@ 3 months)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 14 seconds ago');
+ERROR = !wrong format (@ 14 seconds ago)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('badly formatted interval');
+ERROR = !wrong format (badly formatted interval)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 30 eons ago');
+ERROR = !wrong format (@ 30 eons ago)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT '' AS nine, INTERVAL_TBL.* FROM INTERVAL_TBL
+ WHERE INTERVAL_TBL.f1 <> cast('@ 10 days' as interval second);
+ERROR = !wrong format (@ 10 days)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT '' AS three, INTERVAL_TBL.* FROM INTERVAL_TBL
+ WHERE INTERVAL_TBL.f1 <= cast('@ 5 hours' as interval second);
+ERROR = !wrong format (@ 5 hours)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT '' AS three, INTERVAL_TBL.* FROM INTERVAL_TBL
+ WHERE INTERVAL_TBL.f1 < cast('@ 1 day' as interval second);
+ERROR = !wrong format (@ 1 day)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT '' AS one, INTERVAL_TBL.* FROM INTERVAL_TBL
+ WHERE INTERVAL_TBL.f1 = cast('@ 34 years' as interval second);
+ERROR = !wrong format (@ 34 years)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT '' AS five, INTERVAL_TBL.* FROM INTERVAL_TBL
+ WHERE INTERVAL_TBL.f1 >= cast('@ 1 month' as interval second);
+ERROR = !wrong format (@ 1 month)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = SELECT '' AS nine, INTERVAL_TBL.* FROM INTERVAL_TBL
+ WHERE INTERVAL_TBL.f1 > cast('@ 3 seconds ago' as interval second);
+ERROR = !wrong format (@ 3 seconds ago)
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = select avg(f1) from interval_tbl;
+ERROR = !types sec_interval(13,0) and double(53,0) are not equal for column
'f1'
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = select avg(cast(f1 as double)) from interval_tbl;
+ERROR = !types sec_interval(13,0) and double(53,0) are not equal for column
'f1'
+MAPI = (monetdb) /var/tmp/mtest-21889/.s.monetdb.34286
+QUERY = select avg(cast(f1 as decimal)) from interval_tbl;
+ERROR = !too many digits (22 > 18)
+
+
+# 15:52:24 >
+# 15:52:24 > "Done."
+# 15:52:24 >
+
diff --git a/sql/test/pg_regress/Tests/interval.stable.out.int128
b/sql/test/pg_regress/Tests/interval.stable.out.int128
new file mode 100644
--- /dev/null
+++ b/sql/test/pg_regress/Tests/interval.stable.out.int128
@@ -0,0 +1,124 @@
+stdout of test 'interval` in directory 'sql/test/pg_regress` itself:
+
+
+# 12:56:39 >
+# 12:56:39 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=31190" "--set"
"mapi_usock=/var/tmp/mtest-27974/.s.monetdb.31190" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/dinther/INSTALL/var/MonetDB/mTests_sql_test_pg_regress" "--set"
"mal_listing=0" "--set" "embedded_r=yes"
+# 12:56:39 >
+
+# MonetDB 5 server v11.20.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 and 128bit
integers 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:31190/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-27974/.s.monetdb.31190
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+# MonetDB/R module loaded
+
+Ready.
+
+# 12:56:39 >
+# 12:56:39 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-27974" "--port=31190"
+# 12:56:39 >
+
+#SELECT cast('-05' as interval second) AS "Five hours";
+% .L1 # table_name
+% Five hours # name
+% sec_interval # type
+% 0 # length
+[ -5.000 ]
+#CREATE TABLE INTERVAL_TBL (f1 interval second);
+#INSERT INTO INTERVAL_TBL (f1) VALUES ('1.2345');
+[ 1 ]
+#INSERT INTO INTERVAL_TBL (f1) VALUES (60 * 60 * 24 * 365 * 2014);
+[ 1 ]
+#INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 34 year');
+[ 1 ]
+#INSERT INTO INTERVAL_TBL (f1) VALUES ('@ 3 months');
+[ 1 ]
+#INSERT INTO INTERVAL_TBL (f1) VALUES ('12345678901234567890');
+[ 1 ]
+#SELECT '' AS ten, INTERVAL_TBL.* FROM INTERVAL_TBL;
+% .L, sys.interval_tbl # table_name
+% ten, f1 # name
+% char, sec_interval # type
+% 0, 0 # length
+[ "", 1.234 ]
+[ "", 63513504000.000 ]
+[ "", -5670419503621183.312 ]
+[ "", -1363962815083169.272 ]
+[ "", -1.000 ]
+#SELECT '' AS fortyfive, r1.*, r2.*
+# FROM INTERVAL_TBL r1, INTERVAL_TBL r2
+# WHERE r1.f1 > r2.f1
+# ORDER BY r1.f1, r2.f1;
+% .L, sys.r1, sys.r2 # table_name
+% fortyfive, f1, f1 # name
+% char, sec_interval, sec_interval # type
+% 0, 0, 0 # length
+[ "", -1363962815083169.272, -5670419503621183.312 ]
+[ "", -1.000, -5670419503621183.312 ]
+[ "", -1.000, -1363962815083169.272 ]
+[ "", 1.234, -5670419503621183.312 ]
+[ "", 1.234, -1363962815083169.272 ]
+[ "", 1.234, -1.000 ]
+[ "", 63513504000.000, -5670419503621183.312 ]
+[ "", 63513504000.000, -1363962815083169.272 ]
+[ "", 63513504000.000, -1.000 ]
+[ "", 63513504000.000, 1.234 ]
+#SELECT '' AS ten, INTERVAL_TBL.* FROM INTERVAL_TBL order by f1 desc;
+% .L, sys.interval_tbl # table_name
+% ten, f1 # name
+% char, sec_interval # type
+% 0, 0 # length
+[ "", 63513504000.000 ]
+[ "", 1.234 ]
+[ "", -1.000 ]
+[ "", -1363962815083169.272 ]
+[ "", -5670419503621183.312 ]
+#select avg(cast(f1 as decimal(22,3))) from interval_tbl;
+% sys.L2 # table_name
+% L2 # name
+% double # type
+% 24 # length
+[ -1.406863761e+18 ]
+#select min(f1) from interval_tbl;
+% sys.L1 # table_name
+% L1 # name
+% sec_interval # type
+% 0 # length
+[ -5670419503621183.312 ]
+#select max(f1) from interval_tbl;
+% sys.L1 # table_name
+% L1 # name
+% sec_interval # type
+% 0 # length
+[ 63513504000.000 ]
+#select sum(cast(f1 as decimal(22,3))) from interval_tbl;
+% sys.L2 # table_name
+% L2 # name
+% decimal # type
+% 24 # length
+[ -7034318805200352350.000 ]
+#select count(f1) from interval_tbl;
+% sys.L1 # table_name
+% L1 # name
+% wrd # type
+% 1 # length
+[ 5 ]
+#select count(distinct f1) from interval_tbl;
+% sys.L1 # table_name
+% L1 # name
+% wrd # type
+% 1 # length
+[ 5 ]
+#DROP TABLE INTERVAL_TBL;
+
+# 12:56:40 >
+# 12:56:40 > "Done."
+# 12:56:40 >
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
