| 1 |
Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-2join-query` in directory 'sql/test/FeatureRequests`: |
1 |
|
1 |
Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-2join-query` in directory 'sql/test/FeatureRequests`: |
1 |
| 2 |
138 lines, 705 words, 8113 chars in lines not matching '^$|^(\| |)#|^=` |
2 |
! |
2 |
139 lines, 708 words, 8164 chars in lines not matching '^$|^(\| |)#|^=` |
2 |
| 3 |
= 138 lines, 705 words, 8113 chars in lines not matching '^$|^(\| |)#` |
3 |
! |
3 |
= 139 lines, 708 words, 8164 chars in lines not matching '^$|^(\| |)#` |
3 |
| 4 |
# 278 lines, 1436 words, 13117 chars in all lines |
4 |
! |
4 |
# 269 lines, 1411 words, 13035 chars in all lines |
4 |
| 5 |
|
5 |
|
5 |
|
5 |
| 45 |
X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); |
45 |
|
42 |
X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); |
42 |
| 46 |
X_18:lng := aggr.count(X_8:bat[:int], C_5:bat[:oid]); |
46 |
! |
43 |
X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); |
43 |
|
|
|
+ |
44 |
X_18:lng := aggr.count(X_17:bat[:int]); |
44 |
| 47 |
sql.resultSet("sys.L4":str, "L3":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); |
47 |
! |
45 |
sql.resultSet("sys.L3":str, "L3":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); |
45 |
| 48 |
end user.s4_1; |
48 |
|
46 |
end user.s4_1; |
46 |
| 80 |
function user.s6_1():void; |
80 |
|
76 |
function user.s6_1():void; |
76 |
| 81 |
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, 98:int); |
81 |
! |
77 |
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, 23:int); |
77 |
| 82 |
X_25:bat[:str] := bat.new(nil:str); |
82 |
|
78 |
X_25:bat[:str] := bat.new(nil:str); |
78 |
| 129 |
% clob # type |
129 |
|
123 |
% clob # type |
123 |
| 130 |
% 195 # length |
130 |
! |
124 |
% 194 # length |
124 |
| 131 |
function user.s8_1():void; |
131 |
|
125 |
function user.s8_1():void; |
125 |
| 132 |
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, 120:int); |
132 |
! |
126 |
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, 65:int); |
126 |
| 133 |
X_43:bat[:int] := bat.new(nil:int); |
133 |
|
127 |
X_43:bat[:int] := bat.new(nil:int); |
127 |
| 206 |
% clob # type |
206 |
|
198 |
% clob # type |
198 |
| 207 |
% 195 # length |
207 |
! |
199 |
% 194 # length |
199 |
| 208 |
function user.s10_1():void; |
208 |
|
200 |
function user.s10_1():void; |
200 |
| 209 |
X_1:void := querylog.define("explain select id , v2 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, 115:int); |
209 |
! |
201 |
X_1:void := querylog.define("explain select id , v2 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, 65:int); |
201 |
| 210 |
X_43:bat[:int] := bat.new(nil:int); |
210 |
|
202 |
X_43:bat[:int] := bat.new(nil:int); |
202 |