Test foreign_key_outer_join_dead_code_elimination-explain-0join-view.sql (id 03daa4a14bfc) (err)
foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out.FILTERED 2018-06-14 19:27:24.705581248 +0200foreign_key_outer_join_dead_code_elimination-explain-0join-view.test.out.FILTERED 2018-06-14 19:27:24.706581239 +0200
1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-0join-view` in directory 'sql/test/FeatureRequests`: 1 1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-0join-view` in directory 'sql/test/FeatureRequests`: 1
2 38 lines, 167 words, 1777 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 39 lines, 170 words, 1829 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 38 lines, 167 words, 1777 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 39 lines, 170 words, 1829 chars in lines not matching '^$|^(\| |)#` 3
4 # 124 lines, 572 words, 4746 chars in all lines 4 ! 4 # 119 lines, 557 words, 4743 chars in all lines 4
5 5 5 5
..................
#explain select count(*) from v0;
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.L10":str, "L7":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); 47 ! 45 sql.resultSet("sys.L7":str, "L7":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