Test mergequery.sql (id 001aedfec00f) (err)
mergequery.stable.out.FILTERED 2018-12-06 00:46:54.000000000 +0100mergequery.test.out.FILTERED 2018-12-06 00:46:54.000000000 +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 # 338 lines, 1726 words, 16682 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 172 X_86:int := sql.append(X_6:int, "sys":str, "answ":str, "x":str, X_78:bat[:dbl]); 172
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 173 X_90:int := sql.append(X_86:int, "sys":str, "answ":str, "y":str, X_81:bat[:dbl]); 173
..................
#SELECT * FROM complete where x>=1.0 AND
177 X_95:lng := aggr.count(X_84:bat[:dbl]); 177 175 X_95:lng := aggr.count(X_84:bat[:dbl]); 175
178 exit X_248:bit; 178 -
179 sql.affectedRows(X_93:int, X_95:lng); 179 176 sql.affectedRows(X_93:int, X_95:lng); 176
..................
#WHERE x BETWEEN 0 AND 2 AND Y BETWEEN 0
222 X_8:int := sql.mvc(); 222 218 X_8:int := sql.mvc(); 218
+ 219 X_180:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 0:int, 4:int); 219
223 X_168:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 0:int, 4:int); 223 220 X_168:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 0:int, 4:int); 220
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 221 C_161:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 0:int, 4:int); 221
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 ! 222 C_210:bat[:oid] := algebra.select(X_168:bat[:dbl], C_161:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 222
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 ! 223 C_214:bat[:oid] := algebra.select(X_180:bat[:dbl], C_210:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 223
228 X_218:bat[:dbl] := algebra.projection(C_214:bat[:oid], X_168:bat[:dbl]); 228 224 X_218:bat[:dbl] := algebra.projection(C_214:bat[:oid], X_168:bat[:dbl]); 224
+ 225 X_181:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 1:int, 4:int); 225
229 X_169:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 1:int, 4:int); 229 226 X_169:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 1:int, 4:int); 226
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 227 C_163:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 1:int, 4:int); 227
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 ! 228 C_211:bat[:oid] := algebra.select(X_169:bat[:dbl], C_163:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 228
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 ! 229 C_215:bat[:oid] := algebra.select(X_181:bat[:dbl], C_211:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 229
234 X_219:bat[:dbl] := algebra.projection(C_215:bat[:oid], X_169:bat[:dbl]); 234 230 X_219:bat[:dbl] := algebra.projection(C_215:bat[:oid], X_169:bat[:dbl]); 230
+ 231 X_182:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 2:int, 4:int); 231
235 X_170:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 2:int, 4:int); 235 232 X_170:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 2:int, 4:int); 232
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 233 C_165:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 2:int, 4:int); 233
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 ! 234 C_212:bat[:oid] := algebra.select(X_170:bat[:dbl], C_165:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 234
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 ! 235 C_216:bat[:oid] := algebra.select(X_182:bat[:dbl], C_212:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 235
240 X_220:bat[:dbl] := algebra.projection(C_216:bat[:oid], X_170:bat[:dbl]); 240 236 X_220:bat[:dbl] := algebra.projection(C_216:bat[:oid], X_170:bat[:dbl]); 236
+ 237 X_183:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "y":str, 0:int, 3:int, 4:int); 237
241 X_171:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 3:int, 4:int); 241 238 X_171:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part1":str, "x":str, 0:int, 3:int, 4:int); 238
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 239 C_167:bat[:oid] := sql.tid(X_8:int, "sys":str, "part1":str, 3:int, 4:int); 239
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 ! 240 C_213:bat[:oid] := algebra.select(X_171:bat[:dbl], C_167:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 240
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 ! 241 C_217:bat[:oid] := algebra.select(X_183:bat[:dbl], C_213:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 241
246 X_221:bat[:dbl] := algebra.projection(C_217:bat[:oid], X_171:bat[:dbl]); 246 242 X_221:bat[:dbl] := algebra.projection(C_217:bat[:oid], X_171:bat[:dbl]); 242
..................
#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 246 X_49:bat[:dbl] := mat.packIncrement(X_241:bat[:dbl], X_221:bat[:dbl]); 246
+ 247 X_60:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "y":str, 0:int); 247
251 X_54:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "x":str, 0:int); 251 248 X_54:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "x":str, 0:int); 248
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 249 C_52:bat[:oid] := sql.tid(X_8:int, "sys":str, "part2":str); 249
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 ! 250 C_76:bat[:oid] := algebra.select(X_54:bat[:dbl], C_52:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 250
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 ! 251 C_84:bat[:oid] := algebra.select(X_60:bat[:dbl], C_76:bat[:oid], 0:dbl, 2:dbl, true:bit, true:bit, false:bit); 251
256 X_66:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "z":str, 0:int); 256 252 X_66:bat[:dbl] := sql.bind(X_8:int, "sys":str, "part2":str, "z":str, 0:int); 252
..................
#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 300 X_99:int := sql.append(X_8:int, "sys":str, "answ":str, "x":str, X_91:bat[:dbl]); 300
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 301 X_103:int := sql.append(X_99:int, "sys":str, "answ":str, "y":str, X_94:bat[:dbl]); 301
..................
#WHERE x BETWEEN 0 AND 2 AND Y BETWEEN 0
308 X_108:lng := aggr.count(X_97:bat[:dbl]); 308 303 X_108:lng := aggr.count(X_97:bat[:dbl]); 303
309 exit X_270:bit; 309 -
310 sql.affectedRows(X_106:int, X_108:lng); 310 304 sql.affectedRows(X_106:int, X_108:lng); 304