Test foreign_key_outer_join_dead_code_elimination-explain-1join-view.sql (id 85ca3a09c8e6) (err)
foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out.FILTERED 2018-12-05 20:49:26.925571600 +0100foreign_key_outer_join_dead_code_elimination-explain-1join-view.test.out.FILTERED 2018-12-05 20:49:26.925571600 +0100
1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-1join-view` in directory 'sql/test/FeatureRequests`: 1 1 Statistics about stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-1join-view` in directory 'sql/test/FeatureRequests`: 1
2 88 lines, 404 words, 4783 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 89 lines, 407 words, 4836 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 88 lines, 404 words, 4783 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 89 lines, 407 words, 4836 chars in lines not matching '^$|^(\| |)#` 3
4 # 201 lines, 940 words, 8609 chars in all lines 4 ! 4 # 192 lines, 899 words, 8295 chars in all lines 4
5 5 5 5
..................
#explain select count(*) from v1;
39 % clob # type 39 34 % clob # type 34
40 % 123 # length 40 ! 35 % 103 # length 35
41 function user.s4_1():void; 41 36 function user.s4_1():void; 36
42 X_1:void := querylog.define("explain select count(*) from v1;":str, "sequential_pipe":str, 37:int); 42 ! 37 X_1:void := querylog.define("explain select count(*) from v1;":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 v1;
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.L12":str, "L11":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); 47 ! 43 sql.resultSet("sys.L11":str, "L11":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 v1 order b
78 % clob # type 78 72 % clob # type 72
79 % 123 # length 79 ! 73 % 114 # length 73
80 function user.s6_1():void; 80 74 function user.s6_1():void; 74
81 X_1:void := querylog.define("explain select id from v1 order by id;":str, "sequential_pipe":str, 48:int); 81 ! 75 X_1:void := querylog.define("explain select id from v1 order by id;":str, "sequential_pipe":str, 28:int); 75
82 X_25:bat[:str] := bat.new(nil:str); 82 ! 76 X_32:bat[:str] := bat.new(nil:str); 76
83 X_31:bat[:int] := bat.new(nil:int); 83 ! 77 X_38:bat[:int] := bat.new(nil:int); 77
84 X_29:bat[:int] := bat.new(nil:int); 84 ! 78 X_36:bat[:int] := bat.new(nil:int); 78
85 X_28:bat[:str] := bat.new(nil:str); 85 ! 79 X_35:bat[:str] := bat.new(nil:str); 79
86 X_27:bat[:str] := bat.new(nil:str); 86 ! 80 X_34:bat[:str] := bat.new(nil:str); 80
87 X_4:int := sql.mvc(); 87 81 X_4:int := sql.mvc(); 81
..................
#explain select id from v1 order b
90 X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); 90 84 X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); 84
91 (X_18:bat[:int], X_19:bat[:oid], X_20:bat[:oid]) := algebra.sort(X_17:bat[:int], false:bit, false:bit); 91 ! 85 (X_25:bat[:int], X_26:bat[:oid], X_27:bat[:oid]) := algebra.sort(X_17:bat[:int], false:bit, false:bit); 85
92 X_23:bat[:int] := algebra.projection(X_19:bat[:oid], X_17:bat[:int]); 92 ! 86 X_30:bat[:int] := algebra.projection(X_26:bat[:oid], X_17:bat[:int]); 86
93 X_32:bat[:str] := bat.append(X_25:bat[:str], "sys.v1":str); 93 ! 87 X_39:bat[:str] := bat.append(X_32:bat[:str], "sys.v1":str); 87
94 X_34:bat[:str] := bat.append(X_27:bat[:str], "id":str); 94 ! 88 X_41:bat[:str] := bat.append(X_34:bat[:str], "id":str); 88
95 X_35:bat[:str] := bat.append(X_28:bat[:str], "int":str); 95 ! 89 X_43:bat[:str] := bat.append(X_35:bat[:str], "int":str); 89
96 X_37:bat[:int] := bat.append(X_29:bat[:int], 32:int); 96 ! 90 X_45:bat[:int] := bat.append(X_36:bat[:int], 32:int); 90
97 X_39:bat[:int] := bat.append(X_31:bat[:int], 0:int); 97 ! 91 X_47:bat[:int] := bat.append(X_38:bat[:int], 0:int); 91
98 sql.resultSet(X_32:bat[:str], X_34:bat[:str], X_35:bat[:str], X_37:bat[:int], X_39:bat[:int], X_23:bat[:int]); 98 ! 92 sql.resultSet(X_39:bat[:str], X_41:bat[:str], X_43:bat[:str], X_45:bat[:int], X_47:bat[:int], X_30:bat[:int]); 92
99 end user.s6_1; 99 93 end user.s6_1; 93