| 1 |
Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-1join-view` in directory 'sql/test/FeatureRequests`: |
1 |
|
1 |
Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-1join-view` in directory 'sql/test/FeatureRequests`: |
1 |
| 2 |
88 lines, 406 words, 4805 chars in lines not matching '^$|^(\| |)#|^=` |
2 |
! |
2 |
89 lines, 409 words, 4858 chars in lines not matching '^$|^(\| |)#|^=` |
2 |
| 3 |
= 88 lines, 406 words, 4805 chars in lines not matching '^$|^(\| |)#` |
3 |
! |
3 |
= 89 lines, 409 words, 4858 chars in lines not matching '^$|^(\| |)#` |
3 |
| 4 |
# 201 lines, 942 words, 8631 chars in all lines |
4 |
! |
4 |
# 192 lines, 907 words, 8314 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 |
|
40 |
X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); |
40 |
| 46 |
X_18:lng := aggr.count(X_8:bat[:int], C_5:bat[:oid]); |
46 |
! |
41 |
X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); |
41 |
|
|
|
+ |
42 |
X_18:lng := aggr.count(X_17:bat[:int]); |
42 |
| 47 |
sql.resultSet("sys.L12":str, "L11":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); |
47 |
! |
43 |
sql.resultSet("sys.L11":str, "L11":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); |
43 |
| 48 |
end user.s4_1; |
48 |
|
44 |
end user.s4_1; |
44 |
| 78 |
% clob # type |
78 |
|
72 |
% clob # type |
72 |
| 79 |
% 123 # length |
79 |
! |
73 |
% 118 # length |
73 |
| 80 |
function user.s6_1():void; |
80 |
|
74 |
function user.s6_1():void; |
74 |
| 81 |
X_1:void := querylog.define("explain select id from v1 order by id;":str, "sequential_pipe":str, 48:int); |
81 |
! |
75 |
X_1:void := querylog.define("explain select id from v1 order by id;":str, "sequential_pipe":str, 28:int); |
75 |
| 82 |
X_25:bat[:str] := bat.new(nil:str); |
82 |
! |
76 |
X_32:bat[:str] := bat.new(nil:str); |
76 |
| 83 |
X_31:bat[:int] := bat.new(nil:int); |
83 |
! |
77 |
X_38:bat[:int] := bat.new(nil:int); |
77 |
| 84 |
X_29:bat[:int] := bat.new(nil:int); |
84 |
! |
78 |
X_36:bat[:int] := bat.new(nil:int); |
78 |
| 85 |
X_28:bat[:str] := bat.new(nil:str); |
85 |
! |
79 |
X_35:bat[:str] := bat.new(nil:str); |
79 |
| 86 |
X_27:bat[:str] := bat.new(nil:str); |
86 |
! |
80 |
X_34:bat[:str] := bat.new(nil:str); |
80 |
| 87 |
X_4:int := sql.mvc(); |
87 |
|
81 |
X_4:int := sql.mvc(); |
81 |
| 90 |
X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); |
90 |
|
84 |
X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); |
84 |
| 91 |
(X_18:bat[:int], X_19:bat[:oid], X_20:bat[:oid]) := algebra.sort(X_17:bat[:int], false:bit, false:bit, false:bit); |
91 |
! |
85 |
(X_25:bat[:int], X_26:bat[:oid], X_27:bat[:oid]) := algebra.sort(X_17:bat[:int], false:bit, false:bit, false:bit); |
85 |
| 92 |
X_23:bat[:int] := algebra.projection(X_19:bat[:oid], X_17:bat[:int]); |
92 |
! |
86 |
X_30:bat[:int] := algebra.projection(X_26:bat[:oid], X_17:bat[:int]); |
86 |
| 93 |
X_32:bat[:str] := bat.append(X_25:bat[:str], "sys.v1":str); |
93 |
! |
87 |
X_39:bat[:str] := bat.append(X_32:bat[:str], "sys.v1":str); |
87 |
| 94 |
X_34:bat[:str] := bat.append(X_27:bat[:str], "id":str); |
94 |
! |
88 |
X_41:bat[:str] := bat.append(X_34:bat[:str], "id":str); |
88 |
| 95 |
X_35:bat[:str] := bat.append(X_28:bat[:str], "int":str); |
95 |
! |
89 |
X_43:bat[:str] := bat.append(X_35:bat[:str], "int":str); |
89 |
| 96 |
X_37:bat[:int] := bat.append(X_29:bat[:int], 32:int); |
96 |
! |
90 |
X_45:bat[:int] := bat.append(X_36:bat[:int], 32:int); |
90 |
| 97 |
X_39:bat[:int] := bat.append(X_31:bat[:int], 0:int); |
97 |
! |
91 |
X_47:bat[:int] := bat.append(X_38:bat[:int], 0:int); |
91 |
| 98 |
sql.resultSet(X_32:bat[:str], X_34:bat[:str], X_35:bat[:str], X_37:bat[:int], X_39:bat[:int], X_23:bat[:int]); |
98 |
! |
92 |
sql.resultSet(X_39:bat[:str], X_41:bat[:str], X_43:bat[:str], X_45:bat[:int], X_47:bat[:int], X_30:bat[:int]); |
92 |
| 99 |
end user.s6_1; |
99 |
|
93 |
end user.s6_1; |
93 |