Changeset: b2d0be5253e2 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b2d0be5253e2 Modified Files: sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.err sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out Branch: Jan2014 Log Message:
Approved correct output. diffs (95 lines): diff --git a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.err b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.err --- a/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.err +++ b/sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.err @@ -28,8 +28,6 @@ stderr of test 'groupby.Bug-3421` in dir # 10:34:33 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29232" "--port=30277" # 10:34:33 > -CREATE FILTER FUNCTION: name 'like' (clob, clob, clob) already in use -ParseException:SQLparser:CREATE FILTER FUNCTION: name 'like' (clob, clob, clob) already in use # 10:34:33 > 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 @@ -47,6 +47,79 @@ Ready. # 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", 3000000, 3000000, 4, NULL ] +[ 5508, 2013-02-01, "C2", 2000000, 2000000, 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, wrd, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), sum(numberoffills) from t2 where +#toplevelorderid = 5508 group by toplevelorderid; +% sys.t2, sys.L1, sys.L2 # table_name +% toplevelorderid, L1, L2 # name +% bigint, wrd, 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, wrd, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), sum(numberoffills) from t2 where +#toplevelorderid = 5508 group by toplevelorderid; +% sys.t2, sys.L1, sys.L2 # table_name +% toplevelorderid, L1, L2 # name +% bigint, wrd, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#select toplevelorderid, count(*), sum(numberoffills) from +#orderconnectormetrics where toplevelorderid = 5508 group by toplevelorderid; +% sys.orderconnectormetrics, sys.L1, sys.L2 # table_name +% toplevelorderid, L1, L2 # name +% bigint, wrd, bigint # type +% 4, 1, 1 # length +[ 5508, 2, 6 ] +#delete from t2; +[ 2 ] +#insert into t2 select * from orderconnectormetrics where toplevelorderid = 5508; +[ 2 ] +#insert into t2 values (5508, '2013-02-01', 'C1', 3000000, 3000000, 4, null); +[ 1 ] +#insert into t2 values (5508, '2013-02-01', 'C2', 2000000, 2000000, 2, null); +[ 1 ] +#select toplevelorderid, count(*), sum(numberoffills) from t2 where +#toplevelorderid = 5508 group by toplevelorderid; +% sys.t2, sys.L1, sys.L2 # table_name +% toplevelorderid, L1, L2 # name +% bigint, wrd, bigint # type +% 4, 1, 2 # length +[ 5508, 4, 12 ] +#drop table t2; +#drop table OrderConnectorMetrics; # 10:34:33 > # 10:34:33 > "Done." _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list