Changeset: a7454ec1de1b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a7454ec1de1b
Modified Files:
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
Branch: mosaic
Log Message:
Approve test result.
diffs (179 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
@@ -39,14 +39,13 @@ function user.s4_1():void;
X_37:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- 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_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
+ C_95:bat[:oid] := algebra.likeselect(X_9:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
(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);
+ C_96: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],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_98:bat[:oid] := algebra.likeselect(X_12:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
+ C_29:bat[:oid] := sql.subdelta(C_95:bat[:oid], C_6:bat[:oid],
X_14:bat[:oid], C_96:bat[:oid], C_98:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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);
@@ -101,14 +100,13 @@ function user.s6_1():void;
X_37:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- 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_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
+ C_95:bat[:oid] := algebra.likeselect(X_9:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
(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);
+ C_96: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],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_98:bat[:oid] := algebra.likeselect(X_12:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
+ C_29:bat[:oid] := sql.subdelta(C_95:bat[:oid], C_6:bat[:oid],
X_14:bat[:oid], C_96:bat[:oid], C_98:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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);
@@ -164,14 +162,13 @@ function user.s8_1():void;
X_37:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- 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_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
+ C_95:bat[:oid] := algebra.ilikeselect(X_9:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
(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);
+ C_96: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],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_98:bat[:oid] := algebra.ilikeselect(X_12:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, false:bit);
+ C_29:bat[:oid] := sql.subdelta(C_95:bat[:oid], C_6:bat[:oid],
X_14:bat[:oid], C_96:bat[:oid], C_98:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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);
@@ -225,14 +222,13 @@ function user.s10_1():void;
X_37:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0:int);
- 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_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
+ C_95:bat[:oid] := algebra.ilikeselect(X_9:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
(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);
+ C_96: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],
X_14:bat[:oid], C_97:bat[:oid], C_99:bat[:oid]);
+ C_98:bat[:oid] := algebra.ilikeselect(X_12:bat[:str], C_6:bat[:oid],
"%optimizers%":str, "":str, true:bit);
+ C_29:bat[:oid] := sql.subdelta(C_95:bat[:oid], C_6:bat[:oid],
X_14:bat[:oid], C_96:bat[:oid], C_98:bat[:oid]);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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);
@@ -307,18 +303,17 @@ function user.s20_1():void;
X_40:bat[:str] := bat.new(nil:str);
X_39:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
- C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
- X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
+ C_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0: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],
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_18:bat[:str] := sql.projectdelta(C_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_100:bat[:bit] := batalgebra.like(X_18:bat[:str], "%optimizers%":str);
+ C_32:bat[:oid] := algebra.thetaselect(X_100:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(C_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);
@@ -369,18 +364,17 @@ function user.s22_1():void;
X_40:bat[:str] := bat.new(nil:str);
X_39:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
- C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
- X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
+ C_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0: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],
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_18:bat[:str] := sql.projectdelta(C_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_100:bat[:bit] := batalgebra.not_like(X_18:bat[:str], "%optimizers%":str);
+ C_32:bat[:oid] := algebra.thetaselect(X_100:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(C_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);
@@ -431,18 +425,17 @@ function user.s24_1():void;
X_40:bat[:str] := bat.new(nil:str);
X_39:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
- C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
- X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
+ C_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0: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],
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_18:bat[:str] := sql.projectdelta(C_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_100:bat[:bit] := batalgebra.ilike(X_18:bat[:str], "%optimizers%":str);
+ C_32:bat[:oid] := algebra.thetaselect(X_100:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(C_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);
@@ -493,18 +486,17 @@ function user.s26_1():void;
X_40:bat[:str] := bat.new(nil:str);
X_39:bat[:str] := bat.new(nil:str);
X_5:int := sql.mvc();
- C_151:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
- X_6:bat[:oid] := mosaic.decompress(C_151:bat[:oid]);
+ C_6:bat[:oid] := sql.tid(X_5:int, "sys":str, "functions":str);
X_9:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str, "name":str,
0: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],
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_18:bat[:str] := sql.projectdelta(C_6:bat[:oid], X_9:bat[:str],
X_14:bat[:oid], X_15:bat[:str], X_12:bat[:str]);
+ X_100:bat[:bit] := batalgebra.not_ilike(X_18:bat[:str],
"%optimizers%":str);
+ C_32:bat[:oid] := algebra.thetaselect(X_100:bat[:bit], true:bit, "==":str);
X_19:bat[:str] := sql.bind(X_5:int, "sys":str, "functions":str,
"func":str, 0: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],
X_22:bat[:oid], X_23:bat[:str], X_21:bat[:str]);
+ X_25:bat[:str] := sql.projectdelta(C_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
