Test foreign_key_outer_join_dead_code_elimination-explain-2join-query.sql (id 350cc55cd57a) (err)
foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out.FILTERED 2018-12-07 01:18:23.620487193 +0100foreign_key_outer_join_dead_code_elimination-explain-2join-query.test.out.FILTERED 2018-12-07 01:18:23.623487163 +0100
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, 708 words, 8146 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 139 lines, 711 words, 8197 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 138 lines, 708 words, 8146 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 139 lines, 711 words, 8197 chars in lines not matching '^$|^(\| |)#` 3
4 # 278 lines, 1439 words, 13150 chars in all lines 4 ! 4 # 269 lines, 1422 words, 13058 chars in all lines 4
5 5 5 5
..................
#explain select count(*) from fk left ou
41 function user.s4_1():void; 41 38 function user.s4_1():void; 38
42 X_1:void := querylog.define("explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2;":str, "sequential_pipe":str, 72:int); 42 ! 39 X_1:void := querylog.define("explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2;":str, "sequential_pipe":str, 12:int); 39
43 X_4:int := sql.mvc(); 43 40 X_4:int := sql.mvc(); 40
..................
#explain select count(*) from fk left ou
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
..................
#explain select id from fk left ou
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
..................
#explain select id , v1 from fk left ou
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
..................
#explain select id , v2 from fk left ou
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