Test rewrite_like_into_likesubselect.Bug-3179.sql (id baf04b4f27a7) (err)
rewrite_like_into_likesubselect.Bug-3179.stable.out.FILTERED 2020-11-22 20:08:33.176742578 +0100rewrite_like_into_likesubselect.Bug-3179.test.out.FILTERED 2020-11-22 20:08:33.192742662 +0100
1 Statistics about stdout of test 'rewrite_like_into_likesubselect.Bug-3179` in directory 'sql/test/BugTracker-2012`: 1 1 Statistics about stdout of test 'rewrite_like_into_likesubselect.Bug-3179` in directory 'sql/test/BugTracker-2012`: 1
2 213 lines, 1190 words, 14727 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 217 lines, 1250 words, 15581 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 213 lines, 1190 words, 14727 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 217 lines, 1250 words, 15581 chars in lines not matching '^$|^(\| |)#` 3
4 # 464 lines, 2406 words, 23218 chars in all lines 4 ! 4 # 467 lines, 2447 words, 23695 chars in all lines 4
5 5 5 5
..................
#explain select name,func from functions
270 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 270 264 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 264
+ 265 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 265
271 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 271 -
272 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 272 -
273 X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 273 ! 266 C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, false:bit); 266
+ 267 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 267
274 X_91:bat[:bit] := batalgebra.like(X_21:bat[:str], "%optimizers%":str); 274 ! 268 C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, false:bit, false:bit); 268
+ 269 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 269
275 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 275 ! 270 C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, false:bit); 270
276 C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid], true:bit, "==":str); 276 ! 271 C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); 271
277 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 277 272 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 272
..................
#explain select name,func from functions
322 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 322 318 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 318
+ 319 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 319
323 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 323 -
324 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 324 -
325 X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 325 ! 320 C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, true:bit); 320
+ 321 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 321
326 X_91:bat[:bit] := batalgebra.not_like(X_21:bat[:str], "%optimizers%":str); 326 ! 322 C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, false:bit, true:bit); 322
+ 323 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 323
327 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 327 ! 324 C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, false:bit, true:bit); 324
328 C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid], true:bit, "==":str); 328 ! 325 C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); 325
329 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 329 326 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 326
..................
#explain select name,func from functions
374 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 374 372 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 372
+ 373 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 373
375 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 375 -
376 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 376 -
377 X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 377 ! 374 C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, false:bit); 374
+ 375 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 375
378 X_91:bat[:bit] := batalgebra.ilike(X_21:bat[:str], "%optimizers%":str); 378 ! 376 C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, true:bit, false:bit); 376
+ 377 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 377
379 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 379 ! 378 C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, false:bit); 378
380 C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid], true:bit, "==":str); 380 ! 379 C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); 379
381 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 381 380 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 380
..................
#explain select name,func from functions
426 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 426 426 X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 0:int); 426
+ 427 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 427
427 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 427 -
428 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 428 -
429 X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 429 ! 428 C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, true:bit); 428
+ 429 (X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 2:int); 429
430 X_91:bat[:bit] := batalgebra.not_ilike(X_21:bat[:str], "%optimizers%":str); 430 ! 430 C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid], "%optimizers%":str, "":str, true:bit, true:bit); 430
+ 431 X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str, "name":str, 1:int); 431
431 C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str); 431 ! 432 C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid], "%optimizers%":str, "":str, true:bit, true:bit); 432
432 C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid], true:bit, "==":str); 432 ! 433 C_35:bat[:oid] := sql.subdelta(C_131:bat[:oid], C_5:bat[:oid], X_19:bat[:oid], C_132:bat[:oid], C_134:bat[:oid]); 433
433 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 433 434 X_37:bat[:str] := sql.projectdelta(C_35:bat[:oid], X_17:bat[:str], X_19:bat[:oid], X_20:bat[:str], X_18:bat[:str]); 434