Changeset: be86b21c6597 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=be86b21c6597
Modified Files:
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit
Branch: Aug2011
Log Message:
propagate output approval of changeset 2cf5a083f632 to specific output
diffs (76 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
@@ -41,39 +41,39 @@
% clob # type
% 0 # length
function user.s2_1{autoCommit=true}():void;
- _2 := sql.mvc();
- _30:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c2",0);
- _29:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c2",2);
- _32 := algebra.kdifference(_30,_29);
- _33 := algebra.kunion(_32,_29);
- _28:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c2",1);
- _34 := algebra.kunion(_33,_28);
- _5:bat[:oid,:oid] := sql.bind_dbat(_2,"sys","t2564",1);
- _8 := bat.reverse(_5);
- _35 := algebra.kdifference(_34,_8);
- (ext53,grp51) := group.new(_35);
- _21:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c3",0);
- _20:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c3",2);
- _22 := algebra.kdifference(_21,_20);
- _23 := algebra.kunion(_22,_20);
- _19:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c3",1);
- _24 := algebra.kunion(_23,_19);
- _25 := algebra.kdifference(_24,_8);
- (ext56,grp54) := group.derive(ext53,grp51,_25);
- _12:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c1",0);
- _10:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c1",2);
- _14 := algebra.kdifference(_12,_10);
- _15 := algebra.kunion(_14,_10);
- _9:bat[:oid,:int] := sql.bind(_2,"sys","t2564","c1",1);
- _16 := algebra.kunion(_15,_9);
- _17 := algebra.kdifference(_16,_8);
- (ext59,grp57) := group.done(ext56,grp54,_17);
- _42 := bat.mirror(ext59);
- _43:bat[:oid,:wrd] := aggr.count(grp57,grp57,_42);
- _44 := sql.resultSet(1,1,_43);
- sql.rsColumn(_44,"sys.t2564","L4":str,"wrd",32,0,_43);
- _52 := io.stdout();
- sql.exportResult(_52,_44);
+ X_2 := sql.mvc();
+ X_30:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c2",0);
+ X_29:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c2",2);
+ X_32 := algebra.kdifference(X_30,X_29);
+ X_33 := algebra.kunion(X_32,X_29);
+ X_28:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c2",1);
+ X_34 := algebra.kunion(X_33,X_28);
+ X_5:bat[:oid,:oid] := sql.bind_dbat(X_2,"sys","t2564",1);
+ X_8 := bat.reverse(X_5);
+ X_35 := algebra.kdifference(X_34,X_8);
+ (ext53,grp51) := group.new(X_35);
+ X_21:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c3",0);
+ X_20:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c3",2);
+ X_22 := algebra.kdifference(X_21,X_20);
+ X_23 := algebra.kunion(X_22,X_20);
+ X_19:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c3",1);
+ X_24 := algebra.kunion(X_23,X_19);
+ X_25 := algebra.kdifference(X_24,X_8);
+ (ext56,grp54) := group.derive(ext53,grp51,X_25);
+ X_12:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c1",0);
+ X_10:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c1",2);
+ X_14 := algebra.kdifference(X_12,X_10);
+ X_15 := algebra.kunion(X_14,X_10);
+ X_9:bat[:oid,:int] := sql.bind(X_2,"sys","t2564","c1",1);
+ X_16 := algebra.kunion(X_15,X_9);
+ X_17 := algebra.kdifference(X_16,X_8);
+ (ext59,grp57) := group.done(ext56,grp54,X_17);
+ X_42 := bat.mirror(ext59);
+ X_43:bat[:oid,:wrd] := aggr.count(grp57,grp57,X_42);
+ X_44 := sql.resultSet(1,1,X_43);
+ sql.rsColumn(X_44,"sys.t2564","L4":str,"wrd",32,0,X_43);
+ X_52 := io.stdout();
+ sql.exportResult(X_52,X_44);
end s2_1;
#select count(*) from t2564 group by c1, c2, c3;
% sys.t2564 # table_name
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
