Test foreign_key_outer_join_dead_code_elimination-explain-0join-query.sql (id 9c3533b984e2) (err)
foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out.FILTERED 2018-12-06 23:42:30.631992700 +0100foreign_key_outer_join_dead_code_elimination-explain-0join-query.test.out.FILTERED 2018-12-06 23:42:30.631992700 +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, 167 words, 1777 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 39 lines, 170 words, 1830 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 38 lines, 167 words, 1777 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 39 lines, 170 words, 1830 chars in lines not matching '^$|^(\| |)#` 3
4 # 124 lines, 572 words, 4746 chars in all lines 4 ! 4 # 117 lines, 536 words, 4438 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 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