Changeset: 87d83f555791 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=87d83f555791
Modified Files:
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
Branch: unlock
Log Message:
approved output
diffs (100 lines):
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
@@ -71,19 +71,19 @@ end user.main;
% clob # type
% 189 # length
function user.main():void;
- X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id;":str,
"sequential_pipe":str, 19:int);
- X_27:bat[:str] := bat.pack("sys.fk":str);
- X_28:bat[:str] := bat.pack("id":str);
- X_29:bat[:str] := bat.pack("int":str);
- X_30:bat[:int] := bat.pack(32:int);
- X_31:bat[:int] := bat.pack(0:int);
+ X_1:void := querylog.define("explain select id from fk left outer join pk1
on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id;":str,
"sequential_pipe":str, 27:int);
+ X_39:bat[:str] := bat.pack("sys.fk":str);
+ X_40:bat[:str] := bat.pack("id":str);
+ X_41:bat[:str] := bat.pack("int":str);
+ X_42:bat[:int] := bat.pack(32:int);
+ X_43:bat[:int] := bat.pack(0:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
X_15:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int);
- X_19:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
- (X_20:bat[:int], X_21:bat[:oid]) := algebra.sort(X_19:bat[:int],
false:bit, false:bit, false:bit);
- X_25:bat[:int] := algebra.projection(X_21:bat[:oid], X_19:bat[:int]);
- sql.resultSet(X_27:bat[:str], X_28:bat[:str], X_29:bat[:str],
X_30:bat[:int], X_31:bat[:int], X_25:bat[:int]);
+ X_29:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
+ (X_32:bat[:int], X_33:bat[:oid]) := algebra.sort(X_29:bat[:int],
false:bit, false:bit, false:bit);
+ X_37:bat[:int] := algebra.projection(X_33:bat[:oid], X_29:bat[:int]);
+ sql.resultSet(X_39:bat[:str], X_40:bat[:str], X_41:bat[:str],
X_42:bat[:int], X_43:bat[:int], X_37:bat[:int]);
end user.main;
#inline actions= 0 time=1 usec
#remap actions= 0 time=2 usec
@@ -117,39 +117,39 @@ end user.main;
% clob # type
% 194 # length
function user.main():void;
- X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 58:int);
- X_48:bat[:int] := bat.new(nil:int);
+ X_1:void := querylog.define("explain select id , v1 from fk left outer
join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by
id;":str, "sequential_pipe":str, 67:int);
+ X_54:bat[:int] := bat.new(nil:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str);
X_19:bat[:oid] := sql.bind_idxbat(X_4:int, "sys":str, "fk":str,
"fk_fk1_fkey":str, 0:int);
(X_21:bat[:oid], X_22:bat[:oid]) := sql.bind_idxbat(X_4:int, "sys":str,
"fk":str, "fk_fk1_fkey":str, 2:int);
X_23:bat[:oid] := sql.delta(X_19:bat[:oid], X_21:bat[:oid],
X_22:bat[:oid]);
- X_37:bat[:oid] := algebra.projection(C_5:bat[:oid], X_23:bat[:oid]);
- C_24:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk1":str);
- (X_39:bat[:oid], X_40:bat[:oid]) := algebra.join(X_37:bat[:oid],
C_24:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng);
+ X_42:bat[:oid] := algebra.projection(C_5:bat[:oid], X_23:bat[:oid]);
+ C_29:bat[:oid] := sql.tid(X_4:int, "sys":str, "pk1":str);
+ (X_45:bat[:oid], X_46:bat[:oid]) := algebra.join(X_42:bat[:oid],
C_29:bat[:oid], nil:BAT, nil:BAT, false:bit, nil:lng);
X_15:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int);
- X_36:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
- X_47:bat[:int] := algebra.projection(X_39:bat[:oid], X_36:bat[:int]);
- C_45:bat[:oid] := bat.mirror(X_36:bat[:int]);
- C_46:bat[:oid] := algebra.difference(C_45:bat[:oid], X_39:bat[:oid],
nil:BAT, nil:BAT, false:bit, false:bit, nil:lng);
- X_31:bat[:int] := sql.bind(X_4:int, "sys":str, "pk1":str, "v1":str, 0:int);
- X_50:bat[:int] := bat.append(X_48:bat[:int], X_47:bat[:int], true:bit);
- X_52:bat[:int] := algebra.projection(C_46:bat[:oid], X_36:bat[:int]);
- X_53:bat[:int] := bat.append(X_50:bat[:int], X_52:bat[:int], true:bit);
- X_61:bat[:int] := bat.new(nil:int);
- X_60:bat[:int] := algebra.projectionpath(X_40:bat[:oid], C_24:bat[:oid],
X_31:bat[:int]);
- X_62:bat[:int] := bat.append(X_61:bat[:int], X_60:bat[:int], true:bit);
- X_64:bat[:int] := algebra.project(C_46:bat[:oid], nil:int);
- X_65:bat[:int] := bat.append(X_62:bat[:int], X_64:bat[:int], true:bit);
- X_78:bat[:str] := bat.pack(".fk":str, ".pk1":str);
- X_79:bat[:str] := bat.pack("id":str, "v1":str);
- X_80:bat[:str] := bat.pack("int":str, "int":str);
- X_81:bat[:int] := bat.pack(32:int, 32:int);
- X_82:bat[:int] := bat.pack(0:int, 0:int);
- (X_72:bat[:int], X_73:bat[:oid]) := algebra.sort(X_53:bat[:int],
false:bit, false:bit, false:bit);
- X_75:bat[:int] := algebra.projection(X_73:bat[:oid], X_53:bat[:int]);
- X_76:bat[:int] := algebra.projection(X_73:bat[:oid], X_65:bat[:int]);
- sql.resultSet(X_78:bat[:str], X_79:bat[:str], X_80:bat[:str],
X_81:bat[:int], X_82:bat[:int], X_75:bat[:int], X_76:bat[:int]);
+ X_41:bat[:int] := algebra.projection(C_5:bat[:oid], X_15:bat[:int]);
+ X_53:bat[:int] := algebra.projection(X_45:bat[:oid], X_41:bat[:int]);
+ C_51:bat[:oid] := bat.mirror(X_41:bat[:int]);
+ C_52:bat[:oid] := algebra.difference(C_51:bat[:oid], X_45:bat[:oid],
nil:BAT, nil:BAT, false:bit, false:bit, nil:lng);
+ X_36:bat[:int] := sql.bind(X_4:int, "sys":str, "pk1":str, "v1":str, 0:int);
+ X_56:bat[:int] := bat.append(X_54:bat[:int], X_53:bat[:int], true:bit);
+ X_58:bat[:int] := algebra.projection(C_52:bat[:oid], X_41:bat[:int]);
+ X_59:bat[:int] := bat.append(X_56:bat[:int], X_58:bat[:int], true:bit);
+ X_72:bat[:int] := bat.new(nil:int);
+ X_71:bat[:int] := algebra.projectionpath(X_46:bat[:oid], C_29:bat[:oid],
X_36:bat[:int]);
+ X_73:bat[:int] := bat.append(X_72:bat[:int], X_71:bat[:int], true:bit);
+ X_75:bat[:int] := algebra.project(C_52:bat[:oid], nil:int);
+ X_76:bat[:int] := bat.append(X_73:bat[:int], X_75:bat[:int], true:bit);
+ X_91:bat[:str] := bat.pack(".fk":str, ".pk1":str);
+ X_92:bat[:str] := bat.pack("id":str, "v1":str);
+ X_93:bat[:str] := bat.pack("int":str, "int":str);
+ X_94:bat[:int] := bat.pack(32:int, 32:int);
+ X_95:bat[:int] := bat.pack(0:int, 0:int);
+ (X_83:bat[:int], X_84:bat[:oid]) := algebra.sort(X_59:bat[:int],
false:bit, false:bit, false:bit);
+ X_88:bat[:int] := algebra.projection(X_84:bat[:oid], X_59:bat[:int]);
+ X_89:bat[:int] := algebra.projection(X_84:bat[:oid], X_76:bat[:int]);
+ sql.resultSet(X_91:bat[:str], X_92:bat[:str], X_93:bat[:str],
X_94:bat[:int], X_95:bat[:int], X_88:bat[:int], X_89:bat[:int]);
end user.main;
#inline actions= 0 time=1 usec
#remap actions= 0 time=2 usec
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
