Changeset: f6042c7b011d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f6042c7b011d
Modified Files:
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (75 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
@@ -263,12 +263,13 @@ function user.main():void;
X_44:bat[:int] := bat.pack(0:int, 0:int);
X_4:int := sql.mvc();
X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 0:int);
+ C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
+ C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, false:bit, false:bit);
(X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "name":str, 2:int);
+ C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, false:bit, false:bit);
X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid],
X_20:bat[:str], X_18:bat[:str]);
- X_91:bat[:bit] := batalgebra.like(X_21:bat[:str], "%optimizers%":str);
- C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
- C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid],
true:bit, "==":str);
+ C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, false:bit, false:bit);
+ 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]);
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]);
X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"func":str, 0:int);
(X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "func":str, 2:int);
@@ -315,12 +316,13 @@ function user.main():void;
X_44:bat[:int] := bat.pack(0:int, 0:int);
X_4:int := sql.mvc();
X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 0:int);
+ C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
+ C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, false:bit, true:bit);
(X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "name":str, 2:int);
+ C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, false:bit, true:bit);
X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid],
X_20:bat[:str], X_18:bat[:str]);
- X_91:bat[:bit] := batalgebra.not_like(X_21:bat[:str], "%optimizers%":str);
- C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
- C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid],
true:bit, "==":str);
+ C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, false:bit, true:bit);
+ 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]);
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]);
X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"func":str, 0:int);
(X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "func":str, 2:int);
@@ -367,12 +369,13 @@ function user.main():void;
X_44:bat[:int] := bat.pack(0:int, 0:int);
X_4:int := sql.mvc();
X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 0:int);
+ C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
+ C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, true:bit, false:bit);
(X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "name":str, 2:int);
+ C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, true:bit, false:bit);
X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid],
X_20:bat[:str], X_18:bat[:str]);
- X_91:bat[:bit] := batalgebra.ilike(X_21:bat[:str], "%optimizers%":str);
- C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
- C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid],
true:bit, "==":str);
+ C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, true:bit, false:bit);
+ 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]);
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]);
X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"func":str, 0:int);
(X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "func":str, 2:int);
@@ -419,12 +422,13 @@ function user.main():void;
X_44:bat[:int] := bat.pack(0:int, 0:int);
X_4:int := sql.mvc();
X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 0:int);
+ C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
+ C_131:bat[:oid] := algebra.likeselect(X_17:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, true:bit, true:bit);
(X_19:bat[:oid], X_20:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "name":str, 2:int);
+ C_132:bat[:oid] := algebra.likeselect(X_20:bat[:str], nil:bat[:oid],
"%optimizers%":str, "":str, true:bit, true:bit);
X_18:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"name":str, 1:int);
- X_21:bat[:str] := sql.delta(X_17:bat[:str], X_19:bat[:oid],
X_20:bat[:str], X_18:bat[:str]);
- X_91:bat[:bit] := batalgebra.not_ilike(X_21:bat[:str], "%optimizers%":str);
- C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "functions":str);
- C_35:bat[:oid] := algebra.thetaselect(X_91:bat[:bit], C_5:bat[:oid],
true:bit, "==":str);
+ C_134:bat[:oid] := algebra.likeselect(X_18:bat[:str], C_5:bat[:oid],
"%optimizers%":str, "":str, true:bit, true:bit);
+ 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]);
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]);
X_22:bat[:str] := sql.bind(X_4:int, "sys":str, "functions":str,
"func":str, 0:int);
(X_25:bat[:oid], X_26:bat[:str]) := sql.bind(X_4:int, "sys":str,
"functions":str, "func":str, 2:int);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
