Test foreign_key_outer_join_dead_code_elimination-explain-0join-view.sql (id 9f8602e8c51d) (err)
foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out.FILTERED 2018-10-18 00:58:27.576652800 +0200foreign_key_outer_join_dead_code_elimination-explain-0join-view.test.out.FILTERED 2018-10-18 00:58:27.581652800 +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 # 117 lines, 540 words, 4439 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 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.L10":str, "L7":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); 47 ! 43 sql.resultSet("sys.L7":str, "L7":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