Changeset: 7df43ce11391 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7df43ce11391
Modified Files:
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
Branch: Dec2016
Log Message:
Approved 32 bit output.
diffs (102 lines):
diff --git
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
---
a/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
+++
b/sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
@@ -38,46 +38,59 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 113 # length
-function user.s7_1():void;
- X_58:void := querylog.define("explain select count(*) from t2564 group by
c1, c2, c3;","sequential_pipe",35);
- X_41 := bat.new(nil:oid,nil:str);
- X_49 := bat.append(X_41,"sys.L2");
- X_44 := bat.new(nil:oid,nil:str);
- X_51 := bat.append(X_44,"L1");
- X_45 := bat.new(nil:oid,nil:str);
- X_53 := bat.append(X_45,"wrd");
- X_46 := bat.new(nil:oid,nil:int);
- X_55 := bat.append(X_46,32);
- X_48 := bat.new(nil:oid,nil:int);
- X_57 := bat.append(X_48,0);
- X_1 := sql.mvc();
- C_2:bat[:oid] := sql.tid(X_1,"sys","t2564");
- X_5:bat[:int] := sql.bind(X_1,"sys","t2564","c3",0);
- (C_8:bat[:oid],r1_8:bat[:int]) := sql.bind(X_1,"sys","t2564","c3",2);
- X_11:bat[:int] := sql.bind(X_1,"sys","t2564","c3",1);
- X_13 := sql.delta(X_5,C_8,r1_8,X_11);
- X_14 := algebra.projection(C_2,X_13);
- X_15:bat[:int] := sql.bind(X_1,"sys","t2564","c1",0);
- (C_17:bat[:oid],r1_17:bat[:int]) := sql.bind(X_1,"sys","t2564","c1",2);
- X_19:bat[:int] := sql.bind(X_1,"sys","t2564","c1",1);
- X_20 := sql.delta(X_15,C_17,r1_17,X_19);
- X_21 := algebra.projection(C_2,X_20);
- X_22:bat[:int] := sql.bind(X_1,"sys","t2564","c2",0);
- (C_24:bat[:oid],r1_24:bat[:int]) := sql.bind(X_1,"sys","t2564","c2",2);
- X_26:bat[:int] := sql.bind(X_1,"sys","t2564","c2",1);
- X_27 := sql.delta(X_22,C_24,r1_24,X_26);
- X_28 := algebra.projection(C_2,X_27);
- (X_29,r1_29,r2_29) := group.subgroup(X_28);
- (X_32,r1_32,r2_32) := group.subgroup(X_21,X_29);
- (X_35,r1_35,r2_35) := group.subgroupdone(X_14,X_32);
- X_38:bat[:wrd] := aggr.subcount(X_35,X_35,r1_35,false);
- sql.resultSet(X_49,X_51,X_53,X_55,X_57,X_38);
-end user.s7_1;
+% 116 # length
+function user.s10_1():void;
+ X_0:void := querylog.define("explain select count(*) from t2564 group by
c1, c2, c3;","sequential_pipe",24:int);
+ X_43 := bat.new(nil:str);
+ X_50 := bat.append(X_43,"sys.L3");
+ X_45 := bat.new(nil:str);
+ X_52 := bat.append(X_45,"L2");
+ X_46 := bat.new(nil:str);
+ X_54 := bat.append(X_46,"bigint");
+ X_47 := bat.new(nil:int);
+ X_56 := bat.append(X_47,64:int);
+ X_49 := bat.new(nil:int);
+ X_58 := bat.append(X_49,0:int);
+ X_3 := sql.mvc();
+ C_4:bat[:oid] := sql.tid(X_3,"sys","t2564");
+ X_7:bat[:int] := sql.bind(X_3,"sys","t2564","c3",0:int);
+ X_16 := algebra.projection(C_4,X_7);
+ X_17:bat[:int] := sql.bind(X_3,"sys","t2564","c1",0:int);
+ X_23 := algebra.projection(C_4,X_17);
+ X_24:bat[:int] := sql.bind(X_3,"sys","t2564","c2",0:int);
+ X_30 := algebra.projection(C_4,X_24);
+ (X_31,C1_32,r2_32) := group.subgroup(X_30);
+ (X_34,C1_35,r2_35) := group.subgroup(X_23,X_31);
+ (X_37,C1_38,r2_38) := group.subgroupdone(X_16,X_34);
+ X_40:bat[:lng] := aggr.subcount(X_37,X_37,C1_38,false);
+ sql.resultSet(X_50,X_52,X_54,X_56,X_58,X_40);
+end user.s10_1;
+#inline actions= 0 time=1 usec
+#remap actions= 0 time=4 usec
+#costmodel actions= 1 time=2 usec
+#coercion actions= 0 time=2 usec
+#evaluate actions= 0 time=4 usec
+#emptybind actions= 9 time=37 usec
+#aliases actions= 3 time=11 usec
+#mergetable actions= 0 time=44 usec
+#deadcode actions= 9 time=11 usec
+#aliases actions= 0 time=7 usec
+#constants actions= 2 time=8 usec
+#commonTerms actions= 0 time=7 usec
+#projectionpath actions= 0 time=5 usec
+#reorder actions= 1 time=35 usec
+#deadcode actions= 0 time=8 usec
+#reduce actions=37 time=14 usec
+#matpack actions= 0 time=4 usec
+#multiplex actions= 0 time=3 usec
+#profiler actions= 1 time=4 usec
+#candidates actions= 1 time=1 usec
+#garbagecollector actions= 1 time=20 usec
+#total actions= 1 time=425 usec
#select count(*) from t2564 group by c1, c2, c3;
-% sys.L2 # table_name
-% L1 # name
-% wrd # type
+% sys.L3 # table_name
+% L2 # name
+% bigint # type
% 1 # length
[ 1 ]
[ 1 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
