Changeset: f4725119bc94 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f4725119bc94
Modified Files:
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
Branch: mosaic
Log Message:
Approve test.
diffs (171 lines):
diff --git
a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
---
a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
+++
b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
@@ -42,16 +42,16 @@ function user.s4_1():void;
C_112:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_112:bat[:oid]);
C_96:bat[:oid] := algebra.likeselect(X_9:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
C_97:bat[:oid] := algebra.likeselect(X_15:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, false:bit);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
C_99:bat[:oid] := algebra.likeselect(X_12:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
- C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
C_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
- X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_42:bat[:str] := bat.append(X_35:bat[:str], "sys.functions":str);
X_44:bat[:str] := bat.append(X_37:bat[:str], "name":str);
X_46:bat[:str] := bat.append(X_38:bat[:str], "varchar":str);
@@ -104,16 +104,16 @@ function user.s6_1():void;
C_112:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_112:bat[:oid]);
C_96:bat[:oid] := algebra.likeselect(X_9:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
C_97:bat[:oid] := algebra.likeselect(X_15:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, true:bit);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
C_99:bat[:oid] := algebra.likeselect(X_12:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
- C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
C_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
- X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_42:bat[:str] := bat.append(X_35:bat[:str], "sys.functions":str);
X_44:bat[:str] := bat.append(X_37:bat[:str], "name":str);
X_46:bat[:str] := bat.append(X_38:bat[:str], "varchar":str);
@@ -167,16 +167,16 @@ function user.s8_1():void;
C_112:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_112:bat[:oid]);
C_96:bat[:oid] := algebra.ilikeselect(X_9:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
C_97:bat[:oid] := algebra.ilikeselect(X_15:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, false:bit);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
C_99:bat[:oid] := algebra.ilikeselect(X_12:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
- C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
C_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
- X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_42:bat[:str] := bat.append(X_35:bat[:str], "sys.functions":str);
X_44:bat[:str] := bat.append(X_37:bat[:str], "name":str);
X_46:bat[:str] := bat.append(X_38:bat[:str], "varchar":str);
@@ -228,16 +228,16 @@ function user.s10_1():void;
C_112:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_112:bat[:oid]);
C_96:bat[:oid] := algebra.ilikeselect(X_9:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
C_97:bat[:oid] := algebra.ilikeselect(X_15:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, true:bit);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
C_99:bat[:oid] := algebra.ilikeselect(X_12:bat[:str], X_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
- C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
C_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_29:bat[:oid] := sql.subdelta(C_96:bat[:oid], X_6:bat[:oid],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
- X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_33:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_32:bat[:str] := sql.projectdelta(C_29:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_42:bat[:str] := bat.append(X_35:bat[:str], "sys.functions":str);
X_44:bat[:str] := bat.append(X_37:bat[:str], "name":str);
X_46:bat[:str] := bat.append(X_38:bat[:str], "varchar":str);
@@ -310,15 +310,15 @@ function user.s20_1():void;
C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_101:bat[:bit] := batalgebra.like(X_18:bat[:str], "%optimizers%":str);
C_32:bat[:oid] := algebra.thetaselect(X_101:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
X_35:bat[:str] := algebra.projection(C_32:bat[:oid], X_25:bat[:str]);
X_34:bat[:str] := algebra.projection(C_32:bat[:oid], X_18:bat[:str]);
X_44:bat[:str] := bat.append(X_37:bat[:str], "sys.functions":str);
@@ -372,15 +372,15 @@ function user.s22_1():void;
C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_101:bat[:bit] := batalgebra.not_like(X_18:bat[:str], "%optimizers%":str);
C_32:bat[:oid] := algebra.thetaselect(X_101:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
X_35:bat[:str] := algebra.projection(C_32:bat[:oid], X_25:bat[:str]);
X_34:bat[:str] := algebra.projection(C_32:bat[:oid], X_18:bat[:str]);
X_44:bat[:str] := bat.append(X_37:bat[:str], "sys.functions":str);
@@ -434,15 +434,15 @@ function user.s24_1():void;
C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_101:bat[:bit] := batalgebra.ilike(X_18:bat[:str], "%optimizers%":str);
C_32:bat[:oid] := algebra.thetaselect(X_101:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
X_35:bat[:str] := algebra.projection(C_32:bat[:oid], X_25:bat[:str]);
X_34:bat[:str] := algebra.projection(C_32:bat[:oid], X_18:bat[:str]);
X_44:bat[:str] := bat.append(X_37:bat[:str], "sys.functions":str);
@@ -496,15 +496,15 @@ function user.s26_1():void;
C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- (C_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
+ (X_14:bat[:oid], X_15:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "name":str, 2:int);
X_12:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
C_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_18:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
X_101:bat[:bit] := batalgebra.not_ilike(X_18:bat[:str],
"%optimizers%":str);
C_32:bat[:oid] := algebra.thetaselect(X_101:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0:int);
- (C_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
+ (X_22:bat[:oid], X_23:bat[:str]) := sql.bind(X_5:int, "sys":str,
"functions":str, "func":str, 2:int);
X_21:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 1:int);
- X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
C_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(X_6:bat[:oid], X_19:bat[:str],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
X_35:bat[:str] := algebra.projection(C_32:bat[:oid], X_25:bat[:str]);
X_34:bat[:str] := algebra.projection(C_32:bat[:oid], X_18:bat[:str]);
X_44:bat[:str] := bat.append(X_37:bat[:str], "sys.functions":str);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
