Test foreign_key_outer_join_dead_code_elimination-explain-0join-query.sql (id 350cc55cd57a) (err)
foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out.FILTERED 2018-12-07 01:01:03.912033065 +0100foreign_key_outer_join_dead_code_elimination-explain-0join-query.test.out.FILTERED 2018-12-07 01:01:03.917033093 +0100
1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-0join-query` in directory 'sql/test/FeatureRequests`: 1 1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-0join-query` in directory 'sql/test/FeatureRequests`: 1
2 38 lines, 168 words, 1788 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 39 lines, 171 words, 1841 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 38 lines, 168 words, 1788 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 39 lines, 171 words, 1841 chars in lines not matching '^$|^(\| |)#` 3
4 # 124 lines, 573 words, 4757 chars in all lines 4 ! 4 # 119 lines, 563 words, 4861 chars in all lines 4
5 5 5 5
..................
#explain select count(*) from fk;
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 order b
78 % clob # type 78 74 % clob # type 74
79 % 114 # length 79 ! 75 % 118 # length 75
80 function user.s6_1():void; 80 76 function user.s6_1():void; 76