| 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, 23621 chars in all lines |
4 |
| 5 |
|
5 |
|
5 |
|
5 |
| 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 |
| 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 |
| 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 |
| 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 |