Changeset: da4bab5c3b17 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=da4bab5c3b17 Removed Files: sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out.int128 sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out.int128 sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.stable.out.int128 Modified Files: sql/test/BugTracker-2014/Tests/groupby.Bug-3421.sql sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.sql sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.sql sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.stable.out Branch: default Log Message:
Eliminated *.int128 output files (by adding cast(... as bigint)) diffs (truncated from 531 to 300 lines): diff --git a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.sql b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.sql --- a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.sql +++ b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.sql @@ -21,18 +21,18 @@ toplevelorderid = 5508 with data; select * from t2; -- first round -select toplevelorderid, count(*), sum(numberoffills) from t2 group by toplevelorderid; +select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid; -select toplevelorderid, count(*), sum(numberoffills) from t2 where +select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where toplevelorderid = 5508 group by toplevelorderid; -- second round -select toplevelorderid, count(*), sum(numberoffills) from t2 group by toplevelorderid; +select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid; -select toplevelorderid, count(*), sum(numberoffills) from t2 where +select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where toplevelorderid = 5508 group by toplevelorderid; -select toplevelorderid, count(*), sum(numberoffills) from +select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from orderconnectormetrics where toplevelorderid = 5508 group by toplevelorderid; delete from t2; @@ -42,7 +42,7 @@ insert into t2 select * from orderconnec insert into t2 values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null); insert into t2 values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null); -select toplevelorderid, count(*), sum(numberoffills) from t2 where +select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where toplevelorderid = 5508 group by toplevelorderid; drop table t2; diff --git a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out --- a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out +++ b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out @@ -19,28 +19,6 @@ stdout of test 'groupby.Bug-3421` in dir # MonetDB/JAQL module loaded # MonetDB/SQL module loaded -# SQL catalog created, loading sql scripts once -# loading sql script: 09_like.sql -# loading sql script: 10_math.sql -# loading sql script: 11_times.sql -# loading sql script: 12_url.sql -# loading sql script: 13_date.sql -# loading sql script: 14_inet.sql -# loading sql script: 15_querylog.sql -# loading sql script: 16_tracelog.sql -# loading sql script: 17_compress.sql -# loading sql script: 18_dictionary.sql -# loading sql script: 19_cluster.sql -# loading sql script: 20_vacuum.sql -# loading sql script: 21_dependency_functions.sql -# loading sql script: 22_clients.sql -# loading sql script: 23_skyserver.sql -# loading sql script: 24_zorder.sql -# loading sql script: 25_debug.sql -# loading sql script: 26_sysmon.sql -# loading sql script: 39_analytics.sql -# loading sql script: 40_geom.sql -# loading sql script: 40_json.sql # 10:34:33 > # 10:34:33 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29232" "--port=30277" @@ -57,66 +35,78 @@ stdout of test 'groupby.Bug-3421` in dir # unique (toplevelorderid, connector) #); #insert into OrderConnectorMetrics values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null); -[ 1 ] +[ 1 ] #insert into OrderConnectorMetrics values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null); -[ 1 ] +[ 1 ] #create table t2 as select * from orderconnectormetrics where #toplevelorderid = 5508 with data; #select * from t2; -% sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2 # table_name -% toplevelorderid, businessdate, connector, filledvalue, filledqty, numberoffills, chargeusd # name -% bigint, date, varchar, real, real, int, real # type -% 4, 10, 2, 15, 15, 1, 15 # length -[ 5508, 2013-02-01, "C1", 3e+06, 3e+06, 4, NULL ] -[ 5508, 2013-02-01, "C2", 2e+06, 2e+06, 2, NULL ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 group by toplevelorderid; -% sys.t2, sys.L1, sys.L2 # table_name -% toplevelorderid, L1, L2 # name -% bigint, bigint, bigint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 where +% sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2 # table_name +% toplevelorderid, businessdate, connector, filledvalue, filledqty, numberoffills, chargeusd # name +% bigint, date, varchar, real, real, int, real # type +% 4, 10, 2, 15, 15, 1, 15 # length +[ 5508, 2013-02-01, "C1", 3e+6, 3e+6, 4, NULL ] +[ 5508, 2013-02-01, "C2", 2e+6, 2e+6, 2, NULL ] +#select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid; +% sys.t2, sys., sys. # table_name +# sys.t2, sys.L3, sys.L6 # table_name +% toplevelorderid, L, L # name +# toplevelorderid, L3, L6 # name +% bigint, bigint, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where #toplevelorderid = 5508 group by toplevelorderid; -% sys.t2, sys.L1, sys.L2 # table_name -% toplevelorderid, L1, L2 # name -% bigint, bigint, bigint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 group by toplevelorderid; -% sys.t2, sys.L1, sys.L2 # table_name -% toplevelorderid, L1, L2 # name -% bigint, bigint, bigint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 where +% sys.t2, sys., sys. # table_name +# sys.t2, sys.L3, sys.L6 # table_name +% toplevelorderid, L, L # name +# toplevelorderid, L3, L6 # name +% bigint, bigint, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 group by toplevelorderid; +% sys.t2, sys., sys. # table_name +# sys.t2, sys.L3, sys.L6 # table_name +% toplevelorderid, L, L # name +# toplevelorderid, L3, L6 # name +% bigint, bigint, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where #toplevelorderid = 5508 group by toplevelorderid; -% sys.t2, sys.L1, sys.L2 # table_name -% toplevelorderid, L1, L2 # name -% bigint, bigint, bigint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from +% sys.t2, sys., sys. # table_name +# sys.t2, sys.L3, sys.L6 # table_name +% toplevelorderid, L, L # name +# toplevelorderid, L3, L6 # name +% bigint, bigint, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from #orderconnectormetrics where toplevelorderid = 5508 group by toplevelorderid; -% sys.orderconnectormetrics, sys.L1, sys.L2 # table_name -% toplevelorderid, L1, L2 # name -% bigint, bigint, bigint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] +% sys.orderconnectormetrics, sys., sys. # table_name +# sys.orderconnectormetrics, sys.L3, sys.L6 # table_name +% toplevelorderid, L, L # name +# toplevelorderid, L3, L6 # name +% bigint, bigint, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] #delete from t2; -[ 2 ] +[ 2 ] #insert into t2 select * from orderconnectormetrics where toplevelorderid = 5508; -[ 2 ] +[ 2 ] #insert into t2 values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null); -[ 1 ] +[ 1 ] #insert into t2 values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null); -[ 1 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 where +[ 1 ] +#select toplevelorderid, count(*), cast( sum(numberoffills) as bigint) from t2 where #toplevelorderid = 5508 group by toplevelorderid; -% sys.t2, sys.L1, sys.L2 # table_name -% toplevelorderid, L1, L2 # name -% bigint, bigint, bigint # type -% 4, 1, 2 # length -[ 5508, 4, 12 ] +% sys.t2, sys., sys. # table_name +# sys.t2, sys.L3, sys.L6 # table_name +% toplevelorderid, L, L # name +# toplevelorderid, L3, L6 # name +% bigint, bigint, bigint # type +% 4, 1, 2 # length +[ 5508, 4, 12 ] #drop table t2; #drop table OrderConnectorMetrics; diff --git a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out.int128 b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out.int128 deleted file mode 100644 --- a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out.int128 +++ /dev/null @@ -1,126 +0,0 @@ -stdout of test 'groupby.Bug-3421` in directory 'sql/test/BugTracker-2014` itself: - - -# 10:34:33 > -# 10:34:33 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30277" "--set" "mapi_usock=/var/tmp/mtest-29232/.s.monetdb.30277" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/export/scratch1/mk/Jan2014//Linux/var/MonetDB/mTests_sql_test_BugTracker-2014" "--set" "mal_listing=0" -# 10:34:33 > - -# MonetDB 5 server v11.17.2 -# This is an unreleased version -# Serving database 'mTests_sql_test_BugTracker-2014', using 8 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Found 15.591 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://vienna.ins.cwi.nl:30277/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-29232/.s.monetdb.30277 -# MonetDB/GIS module loaded -# MonetDB/JAQL module loaded -# MonetDB/SQL module loaded - -# SQL catalog created, loading sql scripts once -# loading sql script: 09_like.sql -# loading sql script: 10_math.sql -# loading sql script: 11_times.sql -# loading sql script: 12_url.sql -# loading sql script: 13_date.sql -# loading sql script: 14_inet.sql -# loading sql script: 15_querylog.sql -# loading sql script: 16_tracelog.sql -# loading sql script: 17_compress.sql -# loading sql script: 18_dictionary.sql -# loading sql script: 19_cluster.sql -# loading sql script: 20_vacuum.sql -# loading sql script: 21_dependency_functions.sql -# loading sql script: 22_clients.sql -# loading sql script: 23_skyserver.sql -# loading sql script: 24_zorder.sql -# loading sql script: 25_debug.sql -# loading sql script: 26_sysmon.sql -# loading sql script: 39_analytics.sql -# loading sql script: 40_geom.sql -# loading sql script: 40_json.sql - -# 10:34:33 > -# 10:34:33 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29232" "--port=30277" -# 10:34:33 > - -#create table OrderConnectorMetrics ( -# toplevelorderid bigint not null, -# businessdate date, -# connector varchar(256), -# filledValue real, -# filledQty real, -# numberOfFills int, -# chargeUsd real, -# unique (toplevelorderid, connector) -#); -#insert into OrderConnectorMetrics values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null); -[ 1 ] -#insert into OrderConnectorMetrics values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null); -[ 1 ] -#create table t2 as select * from orderconnectormetrics where -#toplevelorderid = 5508 with data; -#select * from t2; -% sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2 # table_name -% toplevelorderid, businessdate, connector, filledvalue, filledqty, numberoffills, chargeusd # name -% bigint, date, varchar, real, real, int, real # type -% 4, 10, 2, 15, 15, 1, 15 # length -[ 5508, 2013-02-01, "C1", 3e+06, 3e+06, 4, NULL ] -[ 5508, 2013-02-01, "C2", 2e+06, 2e+06, 2, NULL ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 group by toplevelorderid; -% sys.t2, sys.L4, sys.L7 # table_name -% toplevelorderid, L3, L6 # name -% bigint, bigint, hugeint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 where -#toplevelorderid = 5508 group by toplevelorderid; -% sys.t2, sys.L4, sys.L7 # table_name -% toplevelorderid, L3, L6 # name -% bigint, bigint, hugeint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 group by toplevelorderid; -% sys.t2, sys.L4, sys.L7 # table_name -% toplevelorderid, L3, L6 # name -% bigint, bigint, hugeint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from t2 where -#toplevelorderid = 5508 group by toplevelorderid; -% sys.t2, sys.L4, sys.L7 # table_name -% toplevelorderid, L3, L6 # name -% bigint, bigint, hugeint # type -% 4, 1, 1 # length -[ 5508, 2, 6 ] -#select toplevelorderid, count(*), sum(numberoffills) from -#orderconnectormetrics where toplevelorderid = 5508 group by toplevelorderid; -% sys.orderconnectormetrics, sys.L4, sys.L7 # table_name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
