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', 300,
300, 4, null);
+[ 1]
+#insert into OrderConnectorMetrics values (5508, '2013-02-01', 'C2', 200,
200, 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, 300,300,4,
NULL]
+[ 5508,2013-02-01, C2, 200,200,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', 300, 300, 4, null);
+[ 1]
+#insert into t2 values (5508, '2013-02-01', 'C2', 200, 200, 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