Test mergequery.sql (id 350cc55cd57a) (err)
mergequery.stable.out.FILTERED 2018-12-07 05:08:14.283919300 +0100mergequery.test.out.FILTERED 2018-12-07 05:08:14.283919300 +0100
1 Statistics about stdout of test 'mergequery` in directory 'sql/test/mergetables`: 1 1 Statistics about stdout of test 'mergequery` in directory 'sql/test/mergetables`: 1
2 228 lines, 1155 words, 12835 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 224 lines, 1143 words, 12723 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 228 lines, 1155 words, 12835 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 224 lines, 1143 words, 12723 chars in lines not matching '^$|^(\| |)#` 3
4 # 344 lines, 1751 words, 16882 chars in all lines 4 ! 4 # 336 lines, 1705 words, 16431 chars in all lines 4
5 5 5 5
..................
#SELECT * FROM complete where x>=1.0 AND
173 X_86:int := sql.append(X_6:int, "sys":str, "answ":str, "x":str, X_78:bat[:dbl]); 173 170 X_86:int := sql.append(X_6:int, "sys":str, "answ":str, "x":str, X_78:bat[:dbl]); 170
174 barrier X_248:bit := language.dataflow(); 174 -
175 X_90:int := sql.append(X_86:int, "sys":str, "answ":str, "y":str, X_81:bat[:dbl]); 175 171 X_90:int := sql.append(X_86:int, "sys":str, "answ":str, "y":str, X_81:bat[:dbl]); 171
..................
#SELECT * FROM complete where x>=1.0 AND
177 X_95:lng := aggr.count(X_84:bat[:dbl]); 177 173 X_95:lng := aggr.count(X_84:bat[:dbl]); 173
178 exit X_248:bit; 178 -
179 sql.affectedRows(X_93:int, X_95:lng); 179 174 sql.affectedRows(X_93:int, X_95:lng); 174
..................
#WHERE x BETWEEN 0 AND 2 AND Y BETWEEN 0
222 X_8:int := sql.mvc(); 222 216 X_8:int := sql.mvc(); 216
+ 217 X_180:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 0:int, 4:int); 217
223 X_168:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 0:int, 4:int); 223 218 X_168:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 0:int, 4:int); 218
224 X_180:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 0:int, 4:int); 224 -
225 C_161:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 0:int, 4:int); 225 219 C_161:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 0:int, 4:int); 219
226 C_210:bat[:oid] := algebra.select(X_180:bat[:dbl], C_161:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 226 ! 220 C_210:bat[:oid] := algebra.select(X_168:bat[:dbl], C_161:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 220
227 C_214:bat[:oid] := algebra.select(X_168:bat[:dbl], C_210:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 227 ! 221 C_214:bat[:oid] := algebra.select(X_180:bat[:dbl], C_210:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 221
228 X_218:bat[:dbl] := algebra.projection(C_214:bat[:oid], X_168:bat[:dbl]); 228 222 X_218:bat[:dbl] := algebra.projection(C_214:bat[:oid], X_168:bat[:dbl]); 222
+ 223 X_181:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 1:int, 4:int); 223
229 X_169:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 1:int, 4:int); 229 224 X_169:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 1:int, 4:int); 224
230 X_181:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 1:int, 4:int); 230 -
231 C_163:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 1:int, 4:int); 231 225 C_163:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 1:int, 4:int); 225
232 C_211:bat[:oid] := algebra.select(X_181:bat[:dbl], C_163:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 232 ! 226 C_211:bat[:oid] := algebra.select(X_169:bat[:dbl], C_163:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 226
233 C_215:bat[:oid] := algebra.select(X_169:bat[:dbl], C_211:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 233 ! 227 C_215:bat[:oid] := algebra.select(X_181:bat[:dbl], C_211:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 227
234 X_219:bat[:dbl] := algebra.projection(C_215:bat[:oid], X_169:bat[:dbl]); 234 228 X_219:bat[:dbl] := algebra.projection(C_215:bat[:oid], X_169:bat[:dbl]); 228
+ 229 X_182:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 2:int, 4:int); 229
235 X_170:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 2:int, 4:int); 235 230 X_170:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 2:int, 4:int); 230
236 X_182:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 2:int, 4:int); 236 -
237 C_165:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 2:int, 4:int); 237 231 C_165:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 2:int, 4:int); 231
238 C_212:bat[:oid] := algebra.select(X_182:bat[:dbl], C_165:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 238 ! 232 C_212:bat[:oid] := algebra.select(X_170:bat[:dbl], C_165:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 232
239 C_216:bat[:oid] := algebra.select(X_170:bat[:dbl], C_212:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 239 ! 233 C_216:bat[:oid] := algebra.select(X_182:bat[:dbl], C_212:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 233
240 X_220:bat[:dbl] := algebra.projection(C_216:bat[:oid], X_170:bat[:dbl]); 240 234 X_220:bat[:dbl] := algebra.projection(C_216:bat[:oid], X_170:bat[:dbl]); 234
+ 235 X_183:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 3:int, 4:int); 235
241 X_171:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 3:int, 4:int); 241 236 X_171:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 3:int, 4:int); 236
242 X_183:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 3:int, 4:int); 242 -
243 C_167:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 3:int, 4:int); 243 237 C_167:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 3:int, 4:int); 237
244 C_213:bat[:oid] := algebra.select(X_183:bat[:dbl], C_167:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 244 ! 238 C_213:bat[:oid] := algebra.select(X_171:bat[:dbl], C_167:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 238
245 C_217:bat[:oid] := algebra.select(X_171:bat[:dbl], C_213:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 245 ! 239 C_217:bat[:oid] := algebra.select(X_183:bat[:dbl], C_213:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 239
246 X_221:bat[:dbl] := algebra.projection(C_217:bat[:oid], X_171:bat[:dbl]); 246 240 X_221:bat[:dbl] := algebra.projection(C_217:bat[:oid], X_171:bat[:dbl]); 240
..................
#WHERE x BETWEEN 0 AND 2 AND Y BETWEEN 0
250 X_49:bat[:dbl] := mat.packIncrement(X_241:bat[:dbl], X_221:bat[:dbl]); 250 244 X_49:bat[:dbl] := mat.packIncrement(X_241:bat[:dbl], X_221:bat[:dbl]); 244
+ 245 X_60:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "y":str, 0:int); 245
251 X_54:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "x":str, 0:int); 251 246 X_54:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "x":str, 0:int); 246
252 X_60:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "y":str, 0:int); 252 -
253 C_52:bat[:oid] := sql.tid(X_8:int, "sys":str, "part2":str); 253 247 C_52:bat[:oid] := sql.tid(X_8:int, "sys":str, "part2":str); 247
254 C_76:bat[:oid] := algebra.select(X_60:bat[:dbl], C_52:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 254 ! 248 C_76:bat[:oid] := algebra.select(X_54:bat[:dbl], C_52:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 248
255 C_84:bat[:oid] := algebra.select(X_54:bat[:dbl], C_76:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 255 ! 249 C_84:bat[:oid] := algebra.select(X_60:bat[:dbl], C_76:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 249
256 X_66:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "z":str, 0:int); 256 250 X_66:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "z":str, 0:int); 250
..................
#WHERE x BETWEEN 0 AND 2 AND Y BETWEEN 0
304 X_99:int := sql.append(X_8:int, "sys":str, "answ":str, "x":str, X_91:bat[:dbl]); 304 298 X_99:int := sql.append(X_8:int, "sys":str, "answ":str, "x":str, X_91:bat[:dbl]); 298
305 barrier X_270:bit := language.dataflow(); 305 -
306 X_103:int := sql.append(X_99:int, "sys":str, "answ":str, "y":str, X_94:bat[:dbl]); 306 299 X_103:int := sql.append(X_99:int, "sys":str, "answ":str, "y":str, X_94:bat[:dbl]); 299
..................
#WHERE x BETWEEN 0 AND 2 AND Y BETWEEN 0
308 X_108:lng := aggr.count(X_97:bat[:dbl]); 308 301 X_108:lng := aggr.count(X_97:bat[:dbl]); 301
309 exit X_270:bit; 309 -
310 sql.affectedRows(X_106:int, X_108:lng); 310 302 sql.affectedRows(X_106:int, X_108:lng); 302