Test foreign_key_outer_join_dead_code_elimination-explain-1join-query.sql (id 9f8602e8c51d) (err)
foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out.FILTERED 2018-10-18 00:58:28.212652800 +0200foreign_key_outer_join_dead_code_elimination-explain-1join-query.test.out.FILTERED 2018-10-18 00:58:28.222652800 +0200
1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-1join-query` in directory 'sql/test/FeatureRequests`: 1 1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-1join-query` in directory 'sql/test/FeatureRequests`: 1
2 138 lines, 673 words, 7951 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 139 lines, 676 words, 8004 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 138 lines, 673 words, 7951 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 139 lines, 676 words, 8004 chars in lines not matching '^$|^(\| |)#` 3
4 # 278 lines, 1372 words, 12795 chars in all lines 4 ! 4 # 267 lines, 1334 words, 12434 chars in all lines 4
5 5 5 5
..................
#explain select count(*) from fk left ou
41 function user.s4_1():void; 41 36 function user.s4_1():void; 36
42 X_1:void := querylog.define("explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1;":str, "sequential_pipe":str, 27:int); 42 ! 37 X_1:void := querylog.define("explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1;":str, "sequential_pipe":str, 12:int); 37
43 X_4:int := sql.mvc(); 43 38 X_4:int := sql.mvc(); 38
..................
#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 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.L4":str, "L3":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); 47 ! 43 sql.resultSet("sys.L3":str, "L3":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
..................
#explain select id from fk left ou
80 function user.s6_1():void; 80 74 function user.s6_1():void; 74
81 X_1:void := querylog.define("explain select id from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id;":str, "sequential_pipe":str, 48:int); 81 ! 75 X_1:void := querylog.define("explain select id from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id;":str, "sequential_pipe":str, 23:int); 75
82 X_25:bat[:str] := bat.new(nil:str); 82 76 X_25:bat[:str] := bat.new(nil:str); 76