Test partition_elim.sql (id 90b5cb418b8e) (err)
partition_elim.stable.out.FILTERED 2020-08-01 02:20:55.802515061 +0200partition_elim.test.out.FILTERED 2020-08-01 02:20:55.819515150 +0200
1 Statistics about stdout of test 'partition_elim` in directory 'sql/test/remote`: 1 1 Statistics about stdout of test 'partition_elim` in directory 'sql/test/remote`: 1
2 261 lines, 1259 words, 13843 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 261 lines, 1839 words, 17923 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 261 lines, 1259 words, 13843 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 261 lines, 1839 words, 17923 chars in lines not matching '^$|^(\| |)#` 3
4 # 499 lines, 2530 words, 22390 chars in all lines 4 ! 4 # 451 lines, 3249 words, 26997 chars in all lines 4
5 5 5 5
..................
#explain select x,y from test where x be
139 % clob # type 139 85 % clob # type 85
140 % 130 # length 140 ! 86 % 195 # length 86
141 function user.main():void; 141 87 function user.main():void; 87
142 X_1:void := querylog.define("explain select x,y from test where x between 4.0 and 6.0;":str, "default_pipe":str, 33:int); 142 + 88 X_1:void := querylog.define("explain select x,y from test where x between 4.0 and 6.0;":str, "default_pipe":str, 33:int); # select: sorted; select: sorted; select: sorted; select: sorted 88
143 barrier X_123:bit := language.dataflow(); 143 + 89 barrier X_123:bit := language.dataflow(); # select: sorted; select: sorted; select: sorted; select: sorted 89
144 X_34:bat[:dbl] := bat.new(nil:dbl); 144 + 90 X_34:bat[:dbl] := bat.new(nil:dbl); # select: sorted; select: sorted; select: sorted; select: sorted 90
145 X_4:int := sql.mvc(); 145 + 91 X_4:int := sql.mvc(); # select: sorted; select: sorted; select: sorted; select: sorted 91
146 X_99:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "x":str, 0:int, 0:int, 2:int); 146 + 92 X_99:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "x":str, 0:int, 0:int, 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 92
147 C_94:bat[:oid] := sql.tid(X_4:int, "sys":str, "test2":str, 0:int, 2:int); 147 + 93 C_94:bat[:oid] := sql.tid(X_4:int, "sys":str, "test2":str, 0:int, 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 93
148 C_104:bat[:oid] := algebra.select(X_99:bat[:dbl], C_94:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); 148 + 94 C_104:bat[:oid] := algebra.select(X_99:bat[:dbl], C_94:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 94
149 X_106:bat[:dbl] := algebra.projection(C_104:bat[:oid], X_99:bat[:dbl]); 149 + 95 X_106:bat[:dbl] := algebra.projection(C_104:bat[:oid], X_99:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 95
150 X_100:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "x":str, 0:int, 1:int, 2:int); 150 + 96 X_100:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "x":str, 0:int, 1:int, 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 96
151 C_96:bat[:oid] := sql.tid(X_4:int, "sys":str, "test2":str, 1:int, 2:int); 151 + 97 C_96:bat[:oid] := sql.tid(X_4:int, "sys":str, "test2":str, 1:int, 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 97
152 C_105:bat[:oid] := algebra.select(X_100:bat[:dbl], C_96:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); 152 + 98 C_105:bat[:oid] := algebra.select(X_100:bat[:dbl], C_96:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 98
153 X_107:bat[:dbl] := algebra.projection(C_105:bat[:oid], X_100:bat[:dbl]); 153 + 99 X_107:bat[:dbl] := algebra.projection(C_105:bat[:oid], X_100:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 99
154 X_118:bat[:dbl] := mat.packIncrement(X_106:bat[:dbl], 2:int); 154 + 100 X_118:bat[:dbl] := mat.packIncrement(X_106:bat[:dbl], 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 100
155 X_22:bat[:dbl] := mat.packIncrement(X_118:bat[:dbl], X_107:bat[:dbl]); 155 + 101 X_22:bat[:dbl] := mat.packIncrement(X_118:bat[:dbl], X_107:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 101
156 X_27:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "x":str, 0:int); 156 + 102 X_27:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "x":str, 0:int); # select: sorted; select: sorted; select: sorted; select: sorted 102
157 C_24:bat[:oid] := sql.tid(X_4:int, "sys":str, "test3":str); 157 + 103 C_24:bat[:oid] := sql.tid(X_4:int, "sys":str, "test3":str); # select: sorted; select: sorted; select: sorted; select: sorted 103
158 C_31:bat[:oid] := algebra.select(X_27:bat[:dbl], C_24:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); 158 + 104 C_31:bat[:oid] := algebra.select(X_27:bat[:dbl], C_24:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 104
159 X_28:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "y":str, 0:int); 159 + 105 X_28:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "y":str, 0:int); # select: sorted; select: sorted; select: sorted; select: sorted 105
160 X_33:bat[:dbl] := algebra.projection(C_31:bat[:oid], X_28:bat[:dbl]); 160 + 106 X_33:bat[:dbl] := algebra.projection(C_31:bat[:oid], X_28:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 106
161 X_32:bat[:dbl] := algebra.projection(C_31:bat[:oid], X_27:bat[:dbl]); 161 + 107 X_32:bat[:dbl] := algebra.projection(C_31:bat[:oid], X_27:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 107
162 X_102:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "y":str, 0:int, 1:int, 2:int); 162 + 108 X_102:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "y":str, 0:int, 1:int, 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 108
163 X_109:bat[:dbl] := algebra.projection(C_105:bat[:oid], X_102:bat[:dbl]); 163 + 109 X_109:bat[:dbl] := algebra.projection(C_105:bat[:oid], X_102:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 109
164 X_101:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "y":str, 0:int, 0:int, 2:int); 164 + 110 X_101:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test2":str, "y":str, 0:int, 0:int, 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 110
165 X_108:bat[:dbl] := algebra.projection(C_104:bat[:oid], X_101:bat[:dbl]); 165 + 111 X_108:bat[:dbl] := algebra.projection(C_104:bat[:oid], X_101:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 111
166 X_36:bat[:dbl] := bat.append(X_34:bat[:dbl], X_22:bat[:dbl], true:bit); 166 + 112 X_36:bat[:dbl] := bat.append(X_34:bat[:dbl], X_22:bat[:dbl], true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 112
167 X_37:bat[:dbl] := bat.append(X_36:bat[:dbl], X_32:bat[:dbl], true:bit); 167 + 113 X_37:bat[:dbl] := bat.append(X_36:bat[:dbl], X_32:bat[:dbl], true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 113
168 X_38:bat[:dbl] := bat.new(nil:dbl); 168 + 114 X_38:bat[:dbl] := bat.new(nil:dbl); # select: sorted; select: sorted; select: sorted; select: sorted 114
169 X_120:bat[:dbl] := mat.packIncrement(X_108:bat[:dbl], 2:int); 169 + 115 X_120:bat[:dbl] := mat.packIncrement(X_108:bat[:dbl], 2:int); # select: sorted; select: sorted; select: sorted; select: sorted 115
170 X_23:bat[:dbl] := mat.packIncrement(X_120:bat[:dbl], X_109:bat[:dbl]); 170 + 116 X_23:bat[:dbl] := mat.packIncrement(X_120:bat[:dbl], X_109:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 116
171 X_39:bat[:dbl] := bat.append(X_38:bat[:dbl], X_23:bat[:dbl], true:bit); 171 + 117 X_39:bat[:dbl] := bat.append(X_38:bat[:dbl], X_23:bat[:dbl], true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 117
172 X_40:bat[:dbl] := bat.append(X_39:bat[:dbl], X_33:bat[:dbl], true:bit); 172 + 118 X_40:bat[:dbl] := bat.append(X_39:bat[:dbl], X_33:bat[:dbl], true:bit); # select: sorted; select: sorted; select: sorted; select: sorted 118
173 X_42:bat[:str] := bat.pack(".test":str, ".test":str); 173 + 119 X_42:bat[:str] := bat.pack(".test":str, ".test":str); # select: sorted; select: sorted; select: sorted; select: sorted 119
174 X_43:bat[:str] := bat.pack("x":str, "y":str); 174 + 120 X_43:bat[:str] := bat.pack("x":str, "y":str); # select: sorted; select: sorted; select: sorted; select: sorted 120
175 X_44:bat[:str] := bat.pack("double":str, "double":str); 175 + 121 X_44:bat[:str] := bat.pack("double":str, "double":str); # select: sorted; select: sorted; select: sorted; select: sorted 121
176 X_45:bat[:int] := bat.pack(53:int, 53:int); 176 + 122 X_45:bat[:int] := bat.pack(53:int, 53:int); # select: sorted; select: sorted; select: sorted; select: sorted 122
177 X_46:bat[:int] := bat.pack(0:int, 0:int); 177 + 123 X_46:bat[:int] := bat.pack(0:int, 0:int); # select: sorted; select: sorted; select: sorted; select: sorted 123
178 language.pass(X_99:bat[:dbl]); 178 + 124 language.pass(X_99:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 124
179 language.pass(X_100:bat[:dbl]); 179 + 125 language.pass(X_100:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 125
180 language.pass(C_31:bat[:oid]); 180 + 126 language.pass(C_31:bat[:oid]); # select: sorted; select: sorted; select: sorted; select: sorted 126
181 language.pass(X_27:bat[:dbl]); 181 + 127 language.pass(X_27:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 127
182 language.pass(C_105:bat[:oid]); 182 + 128 language.pass(C_105:bat[:oid]); # select: sorted; select: sorted; select: sorted; select: sorted 128
183 language.pass(C_104:bat[:oid]); 183 + 129 language.pass(C_104:bat[:oid]); # select: sorted; select: sorted; select: sorted; select: sorted 129
184 exit X_123:bit; 184 + 130 exit X_123:bit; # select: sorted; select: sorted; select: sorted; select: sorted 130
185 sql.resultSet(X_42:bat[:str], X_43:bat[:str], X_44:bat[:str], X_45:bat[:int], X_46:bat[:int], X_37:bat[:dbl], X_40:bat[:dbl]); 185 + 131 sql.resultSet(X_42:bat[:str], X_43:bat[:str], X_44:bat[:str], X_45:bat[:int], X_46:bat[:int], X_37:bat[:dbl], X_40:bat[:dbl]); # select: sorted; select: sorted; select: sorted; select: sorted 131
186 end user.main; 186 + 132 end user.main; # select: sorted; select: sorted; select: sorted; select: sorted 132
187 #inline actions= 0 time=1 usec 187 ! 133 #inline actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 133
188 #remap actions= 0 time=2 usec 188 ! 134 #remap actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 134
189 #costmodel actions= 1 time=2 usec 189 ! 135 #costmodel actions= 1 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 135
190 #coercion actions= 0 time=2 usec 190 ! 136 #coercion actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 136
191 #aliases actions= 6 time=9 usec 191 ! 137 #aliases actions= 4 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 137
192 #evaluate actions= 4 time=18 usec 192 ! 138 #evaluate actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 138
193 #emptybind actions= 0 time=1 usec 193 ! 139 #emptybind actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 139
194 #pushselect actions= 6 time=43 usec 194 ! 140 #pushselect actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 140
195 #aliases actions=14 time=40 usec 195 ! 141 #aliases actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 141
196 #mitosis actions=1 time=93 usec 196 ! 142 #mitosis actions=2 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 142
197 #mergetable actions= 3 time=194 usec 197 ! 143 #mergetable actions= 3 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 143
198 #deadcode actions= 4 time=40 usec 198 ! 144 #deadcode actions= 3 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 144
199 #aliases actions= 0 time=1 usec 199 ! 145 #aliases actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 145
200 #constants actions= 9 time=32 usec 200 ! 146 #constants actions= 5 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 146
201 #commonTerms actions= 0 time=27 usec 201 ! 147 #commonTerms actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 147
202 #projectionpath actions= 0 time=18 usec 202 ! 148 #projectionpath actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 148
203 #deadcode actions= 0 time=32 usec 203 ! 149 #deadcode actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 149
204 #reorder actions= 1 time=130 usec 204 ! 150 #reorder actions= 1 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 150
205 #matpack actions= 2 time=23 usec 205 ! 151 #matpack actions= 2 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 151
206 #dataflow actions= 1 time=91 usec 206 ! 152 #dataflow actions= 1 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 152
207 #multiplex actions= 0 time=7 usec 207 ! 153 #multiplex actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 153
208 #profiler actions=1 time=5 usec 208 ! 154 #profiler actions= 1 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 154
209 #candidates actions=1 time=4 usec 209 ! 155 #candidates actions= 1 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 155
210 #wlc actions= 0 time=1 usec 210 ! 156 #deadcode actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 156
211 #garbagecollector actions= 1 time=247 usec 211 ! 157 #postfix actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 157
212 #total actions=26 time=1497 usec 212 ! 158 #wlc actions= 0 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 158
+ 159 #garbagecollector actions= 1 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 159
+ 160 #total actions=29 time=0 usec # select: sorted; select: sorted; select: sorted; select: sorted 160
213 #explain select x,y from test where x between (7-3) and (7-1); 213 161 #explain select x,y from test where x between (7-3) and (7-1); 161
..................
#explain select x,y from test where x be
294 % clob # type 294 243 % clob # type 243
295 % 151 # length 295 ! 244 % 184 # length 244
296 function user.main():void; 296 245 function user.main():void; 245
297 X_1:void := querylog.define("explain select x,y from test where x between 4.0 and 6.0 and y between 0.0 and 2.0;":str, "default_pipe":str, 21:int); 297 + 246 X_1:void := querylog.define("explain select x,y from test where x between 4.0 and 6.0 and y between 0.0 and 2.0;":str, "default_pipe":str, 21:int); # select: sorted; select: sorted 246
298 barrier X_111:bit := language.dataflow(); 298 + 247 barrier X_111:bit := language.dataflow(); # select: sorted; select: sorted 247
299 X_30:bat[:str] := bat.pack("sys.test":str, "sys.test":str); 299 + 248 X_30:bat[:str] := bat.pack("sys.test":str, "sys.test":str); # select: sorted; select: sorted 248
300 X_31:bat[:str] := bat.pack("x":str, "y":str); 300 + 249 X_31:bat[:str] := bat.pack("x":str, "y":str); # select: sorted; select: sorted 249
301 X_32:bat[:str] := bat.pack("double":str, "double":str); 301 + 250 X_32:bat[:str] := bat.pack("double":str, "double":str); # select: sorted; select: sorted 250
302 X_33:bat[:int] := bat.pack(53:int, 53:int); 302 + 251 X_33:bat[:int] := bat.pack(53:int, 53:int); # select: sorted; select: sorted 251
303 X_34:bat[:int] := bat.pack(0:int, 0:int); 303 + 252 X_34:bat[:int] := bat.pack(0:int, 0:int); # select: sorted; select: sorted 252
304 X_4:int := sql.mvc(); 304 + 253 X_4:int := sql.mvc(); # select: sorted; select: sorted 253
305 X_87:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "y":str, 0:int, 0:int, 2:int); 305 + 254 X_87:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "y":str, 0:int, 0:int, 2:int); # select: sorted; select: sorted 254
306 X_85:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "x":str, 0:int, 0:int, 2:int); 306 + 255 X_85:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "x":str, 0:int, 0:int, 2:int); # select: sorted; select: sorted 255
307 C_80:bat[:oid] := sql.tid(X_4:int, "sys":str, "test3":str, 0:int, 2:int); 307 + 256 C_80:bat[:oid] := sql.tid(X_4:int, "sys":str, "test3":str, 0:int, 2:int); # select: sorted; select: sorted 256
308 C_90:bat[:oid] := algebra.select(X_85:bat[:dbl], C_80:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); 308 + 257 C_90:bat[:oid] := algebra.select(X_85:bat[:dbl], C_80:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted 257
309 C_92:bat[:oid] := algebra.select(X_87:bat[:dbl], C_90:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit, true:bit); 309 + 258 C_92:bat[:oid] := algebra.select(X_87:bat[:dbl], C_90:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted 258
310 X_94:bat[:dbl] := algebra.projection(C_92:bat[:oid], X_85:bat[:dbl]); 310 + 259 X_94:bat[:dbl] := algebra.projection(C_92:bat[:oid], X_85:bat[:dbl]); # select: sorted; select: sorted 259
311 X_88:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "y":str, 0:int, 1:int, 2:int); 311 + 260 X_88:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "y":str, 0:int, 1:int, 2:int); # select: sorted; select: sorted 260
312 X_86:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "x":str, 0:int, 1:int, 2:int); 312 + 261 X_86:bat[:dbl] := sql.bind(X_4:int, "sys":str, "test3":str, "x":str, 0:int, 1:int, 2:int); # select: sorted; select: sorted 261
313 C_82:bat[:oid] := sql.tid(X_4:int, "sys":str, "test3":str, 1:int, 2:int); 313 + 262 C_82:bat[:oid] := sql.tid(X_4:int, "sys":str, "test3":str, 1:int, 2:int); # select: sorted; select: sorted 262
314 C_91:bat[:oid] := algebra.select(X_86:bat[:dbl], C_82:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); 314 + 263 C_91:bat[:oid] := algebra.select(X_86:bat[:dbl], C_82:bat[:oid], 4:dbl, 6:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted 263
315 C_93:bat[:oid] := algebra.select(X_88:bat[:dbl], C_91:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit, true:bit); 315 + 264 C_93:bat[:oid] := algebra.select(X_88:bat[:dbl], C_91:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit, true:bit); # select: sorted; select: sorted 264
316 X_95:bat[:dbl] := algebra.projection(C_93:bat[:oid], X_86:bat[:dbl]); 316 + 265 X_95:bat[:dbl] := algebra.projection(C_93:bat[:oid], X_86:bat[:dbl]); # select: sorted; select: sorted 265
317 X_106:bat[:dbl] := mat.packIncrement(X_94:bat[:dbl], 2:int); 317 + 266 X_106:bat[:dbl] := mat.packIncrement(X_94:bat[:dbl], 2:int); # select: sorted; select: sorted 266
318 X_27:bat[:dbl] := mat.packIncrement(X_106:bat[:dbl], X_95:bat[:dbl]); 318 + 267 X_27:bat[:dbl] := mat.packIncrement(X_106:bat[:dbl], X_95:bat[:dbl]); # select: sorted; select: sorted 267
319 X_96:bat[:dbl] := algebra.projection(C_92:bat[:oid], X_87:bat[:dbl]); 319 + 268 X_96:bat[:dbl] := algebra.projection(C_92:bat[:oid], X_87:bat[:dbl]); # select: sorted; select: sorted 268
320 X_97:bat[:dbl] := algebra.projection(C_93:bat[:oid], X_88:bat[:dbl]); 320 + 269 X_97:bat[:dbl] := algebra.projection(C_93:bat[:oid], X_88:bat[:dbl]); # select: sorted; select: sorted 269
321 X_108:bat[:dbl] := mat.packIncrement(X_96:bat[:dbl], 2:int); 321 + 270 X_108:bat[:dbl] := mat.packIncrement(X_96:bat[:dbl], 2:int); # select: sorted; select: sorted 270
322 X_28:bat[:dbl] := mat.packIncrement(X_108:bat[:dbl], X_97:bat[:dbl]); 322 + 271 X_28:bat[:dbl] := mat.packIncrement(X_108:bat[:dbl], X_97:bat[:dbl]); # select: sorted; select: sorted 271
323 language.pass(X_85:bat[:dbl]); 323 + 272 language.pass(X_85:bat[:dbl]); # select: sorted; select: sorted 272
324 language.pass(X_86:bat[:dbl]); 324 + 273 language.pass(X_86:bat[:dbl]); # select: sorted; select: sorted 273
325 language.pass(C_92:bat[:oid]); 325 + 274 language.pass(C_92:bat[:oid]); # select: sorted; select: sorted 274
326 language.pass(X_87:bat[:dbl]); 326 + 275 language.pass(X_87:bat[:dbl]); # select: sorted; select: sorted 275
327 language.pass(C_93:bat[:oid]); 327 + 276 language.pass(C_93:bat[:oid]); # select: sorted; select: sorted 276
328 language.pass(X_88:bat[:dbl]); 328 + 277 language.pass(X_88:bat[:dbl]); # select: sorted; select: sorted 277
329 exit X_111:bit; 329 + 278 exit X_111:bit; # select: sorted; select: sorted 278
330 sql.resultSet(X_30:bat[:str], X_31:bat[:str], X_32:bat[:str], X_33:bat[:int], X_34:bat[:int], X_27:bat[:dbl], X_28:bat[:dbl]); 330 + 279 sql.resultSet(X_30:bat[:str], X_31:bat[:str], X_32:bat[:str], X_33:bat[:int], X_34:bat[:int], X_27:bat[:dbl], X_28:bat[:dbl]); # select: sorted; select: sorted 279
331 end user.main; 331 + 280 end user.main; # select: sorted; select: sorted 280
332 #inline actions= 0 time=0 usec 332 + 281 #inline actions= 0 time=0 usec # select: sorted; select: sorted 281
333 #remap actions= 0 time=1 usec 333 ! 282 #remap actions= 0 time=0 usec # select: sorted; select: sorted 282
334 #costmodel actions= 1 time=1 usec 334 ! 283 #costmodel actions= 1 time=0 usec # select: sorted; select: sorted 283
335 #coercion actions= 4 time=4 usec 335 ! 284 #coercion actions= 0 time=0 usec # select: sorted; select: sorted 284
336 #aliases actions= 4 time=4 usec 336 ! 285 #aliases actions= 4 time=0 usec # select: sorted; select: sorted 285
337 #evaluate actions= 0 time=4 usec 337 ! 286 #evaluate actions= 0 time=0 usec # select: sorted; select: sorted 286
338 #emptybind actions= 0 time=1 usec 338 ! 287 #emptybind actions= 0 time=0 usec # select: sorted; select: sorted 287
339 #pushselect actions= 0 time=7 usec 339 ! 288 #pushselect actions= 0 time=0 usec # select: sorted; select: sorted 288
340 #aliases actions= 0 time=0 usec 340 + 289 #aliases actions= 0 time=0 usec # select: sorted; select: sorted 289
341 #mitosis actions=2 time=17 usec 341 ! 290 #mitosis actions=2 time=0 usec # select: sorted; select: sorted 290
342 #mergetable actions= 4 time=36 usec 342 ! 291 #mergetable actions= 4 time=0 usec # select: sorted; select: sorted 291
343 #deadcode actions= 2 time=8 usec 343 ! 292 #deadcode actions= 2 time=0 usec # select: sorted; select: sorted 292
344 #aliases actions= 0 time=1 usec 344 ! 293 #aliases actions= 0 time=0 usec # select: sorted; select: sorted 293
345 #constants actions= 3 time=5 usec 345 ! 294 #constants actions= 3 time=0 usec # select: sorted; select: sorted 294
346 #commonTerms actions= 0 time=6 usec 346 ! 295 #commonTerms actions= 0 time=0 usec # select: sorted; select: sorted 295
347 #projectionpath actions= 0 time=3 usec 347 ! 296 #projectionpath actions= 0 time=0 usec # select: sorted; select: sorted 296
348 #deadcode actions= 0 time=6 usec 348 ! 297 #deadcode actions= 0 time=0 usec # select: sorted; select: sorted 297
349 #reorder actions= 1 time=18 usec 349 ! 298 #reorder actions= 1 time=0 usec # select: sorted; select: sorted 298
350 #matpack actions= 2 time=8 usec 350 ! 299 #matpack actions= 2 time=0 usec # select: sorted; select: sorted 299
351 #dataflow actions= 1 time=18 usec 351 ! 300 #dataflow actions= 1 time=0 usec # select: sorted; select: sorted 300
352 #multiplex actions= 0 time=2 usec 352 ! 301 #multiplex actions= 0 time=0 usec # select: sorted; select: sorted 301
353 #profiler actions= 1 time=1 usec 353 ! 302 #profiler actions= 1 time=0 usec # select: sorted; select: sorted 302
354 #candidates actions= 1 time=1 usec 354 ! 303 #candidates actions= 1 time=0 usec # select: sorted; select: sorted 303
355 #deadcode actions= 0 time=7 usec 355 ! 304 #deadcode actions= 0 time=0 usec # select: sorted; select: sorted 304
356 #postfix actions= 0 time=6 usec 356 ! 305 #postfix actions= 0 time=0 usec # select: sorted; select: sorted 305
357 #wlc actions= 0 time=0 usec 357 + 306 #wlc actions= 0 time=0 usec # select: sorted; select: sorted 306
358 #garbagecollector actions= 1 time=30 usec 358 ! 307 #garbagecollector actions= 1 time=0 usec # select: sorted; select: sorted 307
359 #total actions=29 time=257 usec 359 ! 308 #total actions=29 time=0 usec # select: sorted; select: sorted 308
360 #explain select x,y from test where x between 4.0 and 6.0 and y between (1.0-1.0) and (4.0-2.0); 360 309 #explain select x,y from test where x between 4.0 and 6.0 and y between (1.0-1.0) and (4.0-2.0); 309