Changeset: 7a0836d3ab3c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7a0836d3ab3c
Modified Files:
sql/test/remote/Tests/partition_elim.stable.out
Branch: mosaic
Log Message:
Approve test.
diffs (truncated from 372 to 300 lines):
diff --git a/sql/test/remote/Tests/partition_elim.stable.out
b/sql/test/remote/Tests/partition_elim.stable.out
--- a/sql/test/remote/Tests/partition_elim.stable.out
+++ b/sql/test/remote/Tests/partition_elim.stable.out
@@ -136,40 +136,34 @@ Ready.
% 130 # length
function user.SQLanalyze():void;
X_5:void := querylog.define("explain select x,y from test where x between
4.0 and 6.0;":str, "default_pipe":str, 51:int);
-barrier X_150:bit := language.dataflow();
+barrier X_149:bit := language.dataflow();
X_43:bat[:dbl] := bat.new(nil:dbl);
X_8:int := sql.mvc();
- X_161:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str,
0:int, 0:int, 2:int);
- X_126:bat[:dbl] := mosaic.decompress(X_161:bat[:dbl]);
- C_162:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 0:int, 2:int);
- X_123:bat[:oid] := mosaic.decompress(C_162:bat[:oid]);
- C_131:bat[:oid] := algebra.select(X_126:bat[:dbl], X_123:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_125:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str,
0:int, 0:int, 2:int);
+ C_122:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 0:int, 2:int);
+ C_130:bat[:oid] := algebra.select(X_125:bat[:dbl], C_122:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_132:bat[:dbl] := algebra.projection(C_130:bat[:oid], X_125:bat[:dbl]);
+ X_126:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str,
0:int, 1:int, 2:int);
+ C_124:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 1:int, 2:int);
+ C_131:bat[:oid] := algebra.select(X_126:bat[:dbl], C_124:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
X_133:bat[:dbl] := algebra.projection(C_131:bat[:oid], X_126:bat[:dbl]);
- X_163:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "x":str,
0:int, 1:int, 2:int);
- X_127:bat[:dbl] := mosaic.decompress(X_163:bat[:dbl]);
- C_164:bat[:oid] := sql.tid(X_8:int, "sys":str, "test2":str, 1:int, 2:int);
- X_125:bat[:oid] := mosaic.decompress(C_164:bat[:oid]);
- C_132:bat[:oid] := algebra.select(X_127:bat[:dbl], X_125:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
- X_134:bat[:dbl] := algebra.projection(C_132:bat[:oid], X_127:bat[:dbl]);
- X_145:bat[:dbl] := mat.packIncrement(X_133:bat[:dbl], 2:int);
- X_28:bat[:dbl] := mat.packIncrement(X_145:bat[:dbl], X_134:bat[:dbl]);
- X_165:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test3":str, "x":str,
0:int);
- X_32:bat[:dbl] := mosaic.decompress(X_165:bat[:dbl]);
- C_166:bat[:oid] := sql.tid(X_8:int, "sys":str, "test3":str);
- X_30:bat[:oid] := mosaic.decompress(C_166:bat[:oid]);
- C_40:bat[:oid] := algebra.select(X_32:bat[:dbl], X_30:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_144:bat[:dbl] := mat.packIncrement(X_132:bat[:dbl], 2:int);
+ X_28:bat[:dbl] := mat.packIncrement(X_144:bat[:dbl], X_133:bat[:dbl]);
+ X_32:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test3":str, "x":str,
0:int);
+ C_30:bat[:oid] := sql.tid(X_8:int, "sys":str, "test3":str);
+ C_40:bat[:oid] := algebra.select(X_32:bat[:dbl], C_30:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
X_34:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test3":str, "y":str,
0:int);
- X_42:bat[:dbl] := mosaic.projection(C_40:bat[:oid], X_34:bat[:dbl]);
+ X_42:bat[:dbl] := algebra.projection(C_40:bat[:oid], X_34:bat[:dbl]);
X_41:bat[:dbl] := algebra.projection(C_40:bat[:oid], X_32:bat[:dbl]);
- X_129:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str,
0:int, 1:int, 2:int);
- X_136:bat[:dbl] := mosaic.projection(C_132:bat[:oid], X_129:bat[:dbl]);
- X_128:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str,
0:int, 0:int, 2:int);
- X_135:bat[:dbl] := mosaic.projection(C_131:bat[:oid], X_128:bat[:dbl]);
+ X_128:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str,
0:int, 1:int, 2:int);
+ X_135:bat[:dbl] := algebra.projection(C_131:bat[:oid], X_128:bat[:dbl]);
+ X_127:bat[:dbl] := sql.bind(X_8:int, "sys":str, "test2":str, "y":str,
0:int, 0:int, 2:int);
+ X_134:bat[:dbl] := algebra.projection(C_130:bat[:oid], X_127:bat[:dbl]);
X_45:bat[:dbl] := bat.append(X_43:bat[:dbl], X_28:bat[:dbl], true:bit);
X_46:bat[:dbl] := bat.append(X_45:bat[:dbl], X_41:bat[:dbl], true:bit);
X_47:bat[:dbl] := bat.new(nil:dbl);
- X_147:bat[:dbl] := mat.packIncrement(X_135:bat[:dbl], 2:int);
- X_29:bat[:dbl] := mat.packIncrement(X_147:bat[:dbl], X_136:bat[:dbl]);
+ X_146:bat[:dbl] := mat.packIncrement(X_134:bat[:dbl], 2:int);
+ X_29:bat[:dbl] := mat.packIncrement(X_146:bat[:dbl], X_135:bat[:dbl]);
X_48:bat[:dbl] := bat.append(X_47:bat[:dbl], X_29:bat[:dbl], true:bit);
X_49:bat[:dbl] := bat.append(X_48:bat[:dbl], X_42:bat[:dbl], true:bit);
X_51:bat[:str] := bat.new(nil:str);
@@ -187,13 +181,13 @@ barrier X_150:bit := language.dataflow()
X_71:bat[:str] := bat.append(X_62:bat[:str], "double":str);
X_72:bat[:int] := bat.append(X_64:bat[:int], 53:int);
X_73:bat[:int] := bat.append(X_66:bat[:int], 0:int);
+ language.pass(X_125:bat[:dbl]);
language.pass(X_126:bat[:dbl]);
- language.pass(X_127:bat[:dbl]);
language.pass(C_40:bat[:oid]);
language.pass(X_32:bat[:dbl]);
- language.pass(C_132:bat[:oid]);
language.pass(C_131:bat[:oid]);
-exit X_150:bit;
+ language.pass(C_130:bat[:oid]);
+exit X_149:bit;
sql.resultSet(X_68:bat[:str], X_69:bat[:str], X_71:bat[:str],
X_72:bat[:int], X_73:bat[:int], X_46:bat[:dbl], X_49:bat[:dbl]);
end user.SQLanalyze;
#inline actions= 0 time=3 usec
@@ -227,40 +221,34 @@ end user.SQLanalyze;
% 130 # length
function user.SQLanalyze():void;
X_8:void := querylog.define("explain select x,y from test where x between
(7-3) and (7-1);":str, "default_pipe":str, 61:int);
-barrier X_163:bit := language.dataflow();
+barrier X_162:bit := language.dataflow();
X_53:bat[:dbl] := bat.new(nil:dbl);
X_11:int := sql.mvc();
- X_174:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str,
0:int, 0:int, 2:int);
- X_139:bat[:dbl] := mosaic.decompress(X_174:bat[:dbl]);
- C_175:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 0:int, 2:int);
- X_136:bat[:oid] := mosaic.decompress(C_175:bat[:oid]);
- C_144:bat[:oid] := algebra.select(X_139:bat[:dbl], X_136:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_138:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str,
0:int, 0:int, 2:int);
+ C_135:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 0:int, 2:int);
+ C_143:bat[:oid] := algebra.select(X_138:bat[:dbl], C_135:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_145:bat[:dbl] := algebra.projection(C_143:bat[:oid], X_138:bat[:dbl]);
+ X_139:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str,
0:int, 1:int, 2:int);
+ C_137:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 1:int, 2:int);
+ C_144:bat[:oid] := algebra.select(X_139:bat[:dbl], C_137:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
X_146:bat[:dbl] := algebra.projection(C_144:bat[:oid], X_139:bat[:dbl]);
- X_176:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "x":str,
0:int, 1:int, 2:int);
- X_140:bat[:dbl] := mosaic.decompress(X_176:bat[:dbl]);
- C_177:bat[:oid] := sql.tid(X_11:int, "sys":str, "test2":str, 1:int, 2:int);
- X_138:bat[:oid] := mosaic.decompress(C_177:bat[:oid]);
- C_145:bat[:oid] := algebra.select(X_140:bat[:dbl], X_138:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
- X_147:bat[:dbl] := algebra.projection(C_145:bat[:oid], X_140:bat[:dbl]);
- X_158:bat[:dbl] := mat.packIncrement(X_146:bat[:dbl], 2:int);
- X_34:bat[:dbl] := mat.packIncrement(X_158:bat[:dbl], X_147:bat[:dbl]);
- X_178:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test3":str, "x":str,
0:int);
- X_38:bat[:dbl] := mosaic.decompress(X_178:bat[:dbl]);
- C_179:bat[:oid] := sql.tid(X_11:int, "sys":str, "test3":str);
- X_36:bat[:oid] := mosaic.decompress(C_179:bat[:oid]);
- C_50:bat[:oid] := algebra.select(X_38:bat[:dbl], X_36:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_157:bat[:dbl] := mat.packIncrement(X_145:bat[:dbl], 2:int);
+ X_34:bat[:dbl] := mat.packIncrement(X_157:bat[:dbl], X_146:bat[:dbl]);
+ X_38:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test3":str, "x":str,
0:int);
+ C_36:bat[:oid] := sql.tid(X_11:int, "sys":str, "test3":str);
+ C_50:bat[:oid] := algebra.select(X_38:bat[:dbl], C_36:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
X_40:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test3":str, "y":str,
0:int);
- X_52:bat[:dbl] := mosaic.projection(C_50:bat[:oid], X_40:bat[:dbl]);
+ X_52:bat[:dbl] := algebra.projection(C_50:bat[:oid], X_40:bat[:dbl]);
X_51:bat[:dbl] := algebra.projection(C_50:bat[:oid], X_38:bat[:dbl]);
- X_142:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str,
0:int, 1:int, 2:int);
- X_149:bat[:dbl] := mosaic.projection(C_145:bat[:oid], X_142:bat[:dbl]);
- X_141:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str,
0:int, 0:int, 2:int);
- X_148:bat[:dbl] := mosaic.projection(C_144:bat[:oid], X_141:bat[:dbl]);
+ X_141:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str,
0:int, 1:int, 2:int);
+ X_148:bat[:dbl] := algebra.projection(C_144:bat[:oid], X_141:bat[:dbl]);
+ X_140:bat[:dbl] := sql.bind(X_11:int, "sys":str, "test2":str, "y":str,
0:int, 0:int, 2:int);
+ X_147:bat[:dbl] := algebra.projection(C_143:bat[:oid], X_140:bat[:dbl]);
X_55:bat[:dbl] := bat.append(X_53:bat[:dbl], X_34:bat[:dbl], true:bit);
X_56:bat[:dbl] := bat.append(X_55:bat[:dbl], X_51:bat[:dbl], true:bit);
X_57:bat[:dbl] := bat.new(nil:dbl);
- X_160:bat[:dbl] := mat.packIncrement(X_148:bat[:dbl], 2:int);
- X_35:bat[:dbl] := mat.packIncrement(X_160:bat[:dbl], X_149:bat[:dbl]);
+ X_159:bat[:dbl] := mat.packIncrement(X_147:bat[:dbl], 2:int);
+ X_35:bat[:dbl] := mat.packIncrement(X_159:bat[:dbl], X_148:bat[:dbl]);
X_58:bat[:dbl] := bat.append(X_57:bat[:dbl], X_35:bat[:dbl], true:bit);
X_59:bat[:dbl] := bat.append(X_58:bat[:dbl], X_52:bat[:dbl], true:bit);
X_61:bat[:str] := bat.new(nil:str);
@@ -278,13 +266,13 @@ barrier X_163:bit := language.dataflow()
X_81:bat[:str] := bat.append(X_72:bat[:str], "double":str);
X_82:bat[:int] := bat.append(X_74:bat[:int], 53:int);
X_83:bat[:int] := bat.append(X_76:bat[:int], 0:int);
+ language.pass(X_138:bat[:dbl]);
language.pass(X_139:bat[:dbl]);
- language.pass(X_140:bat[:dbl]);
language.pass(C_50:bat[:oid]);
language.pass(X_38:bat[:dbl]);
- language.pass(C_145:bat[:oid]);
language.pass(C_144:bat[:oid]);
-exit X_163:bit;
+ language.pass(C_143:bat[:oid]);
+exit X_162:bit;
sql.resultSet(X_78:bat[:str], X_79:bat[:str], X_81:bat[:str],
X_82:bat[:int], X_83:bat[:int], X_56:bat[:dbl], X_59:bat[:dbl]);
end user.SQLanalyze;
#inline actions= 0 time=2 usec
@@ -318,33 +306,27 @@ end user.SQLanalyze;
% 151 # length
function user.SQLanalyze():void;
X_9:void := querylog.define("explain select x,y from test where x between
4.0 and 6.0 and y between 0.0 and 2.0;":str, "default_pipe":str, 40:int);
-barrier X_142:bit := language.dataflow();
+barrier X_141:bit := language.dataflow();
X_40:bat[:str] := bat.new(nil:str);
X_46:bat[:int] := bat.new(nil:int);
X_44:bat[:int] := bat.new(nil:int);
X_43:bat[:str] := bat.new(nil:str);
X_42:bat[:str] := bat.new(nil:str);
X_12:int := sql.mvc();
- X_153:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str,
0:int, 1:int, 2:int);
- X_119:bat[:dbl] := mosaic.decompress(X_153:bat[:dbl]);
- X_154:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str,
0:int, 1:int, 2:int);
- X_117:bat[:dbl] := mosaic.decompress(X_154:bat[:dbl]);
- C_155:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 1:int, 2:int);
- X_115:bat[:oid] := mosaic.decompress(C_155:bat[:oid]);
- C_122:bat[:oid] := algebra.select(X_117:bat[:dbl], X_115:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
- C_124:bat[:oid] := algebra.select(X_119:bat[:dbl], C_122:bat[:oid], 0:dbl,
2:dbl, true:bit, true:bit, false:bit);
- X_128:bat[:dbl] := algebra.projection(C_124:bat[:oid], X_119:bat[:dbl]);
- X_156:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str,
0:int, 0:int, 2:int);
- X_118:bat[:dbl] := mosaic.decompress(X_156:bat[:dbl]);
- X_157:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str,
0:int, 0:int, 2:int);
- X_116:bat[:dbl] := mosaic.decompress(X_157:bat[:dbl]);
- C_158:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 0:int, 2:int);
- X_113:bat[:oid] := mosaic.decompress(C_158:bat[:oid]);
- C_121:bat[:oid] := algebra.select(X_116:bat[:dbl], X_113:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_118:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str,
0:int, 1:int, 2:int);
+ X_116:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str,
0:int, 1:int, 2:int);
+ C_114:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 1:int, 2:int);
+ C_121:bat[:oid] := algebra.select(X_116:bat[:dbl], C_114:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
C_123:bat[:oid] := algebra.select(X_118:bat[:dbl], C_121:bat[:oid], 0:dbl,
2:dbl, true:bit, true:bit, false:bit);
X_127:bat[:dbl] := algebra.projection(C_123:bat[:oid], X_118:bat[:dbl]);
- X_126:bat[:dbl] := algebra.projection(C_124:bat[:oid], X_117:bat[:dbl]);
+ X_117:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "y":str,
0:int, 0:int, 2:int);
+ X_115:bat[:dbl] := sql.bind(X_12:int, "sys":str, "test3":str, "x":str,
0:int, 0:int, 2:int);
+ C_112:bat[:oid] := sql.tid(X_12:int, "sys":str, "test3":str, 0:int, 2:int);
+ C_120:bat[:oid] := algebra.select(X_115:bat[:dbl], C_112:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ C_122:bat[:oid] := algebra.select(X_117:bat[:dbl], C_120:bat[:oid], 0:dbl,
2:dbl, true:bit, true:bit, false:bit);
+ X_126:bat[:dbl] := algebra.projection(C_122:bat[:oid], X_117:bat[:dbl]);
X_125:bat[:dbl] := algebra.projection(C_123:bat[:oid], X_116:bat[:dbl]);
+ X_124:bat[:dbl] := algebra.projection(C_122:bat[:oid], X_115:bat[:dbl]);
X_47:bat[:str] := bat.append(X_40:bat[:str], "sys.test":str);
X_49:bat[:str] := bat.append(X_42:bat[:str], "x":str);
X_51:bat[:str] := bat.append(X_43:bat[:str], "double":str);
@@ -355,17 +337,17 @@ barrier X_142:bit := language.dataflow()
X_60:bat[:str] := bat.append(X_51:bat[:str], "double":str);
X_61:bat[:int] := bat.append(X_53:bat[:int], 53:int);
X_62:bat[:int] := bat.append(X_55:bat[:int], 0:int);
- X_137:bat[:dbl] := mat.packIncrement(X_125:bat[:dbl], 2:int);
- X_37:bat[:dbl] := mat.packIncrement(X_137:bat[:dbl], X_126:bat[:dbl]);
- X_139:bat[:dbl] := mat.packIncrement(X_127:bat[:dbl], 2:int);
- X_38:bat[:dbl] := mat.packIncrement(X_139:bat[:dbl], X_128:bat[:dbl]);
- language.pass(X_119:bat[:dbl]);
+ X_136:bat[:dbl] := mat.packIncrement(X_124:bat[:dbl], 2:int);
+ X_37:bat[:dbl] := mat.packIncrement(X_136:bat[:dbl], X_125:bat[:dbl]);
+ X_138:bat[:dbl] := mat.packIncrement(X_126:bat[:dbl], 2:int);
+ X_38:bat[:dbl] := mat.packIncrement(X_138:bat[:dbl], X_127:bat[:dbl]);
language.pass(X_118:bat[:dbl]);
- language.pass(C_124:bat[:oid]);
language.pass(X_117:bat[:dbl]);
language.pass(C_123:bat[:oid]);
language.pass(X_116:bat[:dbl]);
-exit X_142:bit;
+ language.pass(C_122:bat[:oid]);
+ language.pass(X_115:bat[:dbl]);
+exit X_141:bit;
sql.resultSet(X_57:bat[:str], X_58:bat[:str], X_60:bat[:str],
X_61:bat[:int], X_62:bat[:int], X_37:bat[:dbl], X_38:bat[:dbl]);
end user.SQLanalyze;
#inline actions= 0 time=2 usec
@@ -399,33 +381,27 @@ end user.SQLanalyze;
% 164 # length
function user.SQLanalyze():void;
X_11:void := querylog.define("explain select x,y from test where x between
4.0 and 6.0 and y between (1.0-1.0) and (4.0-2.0);":str, "default_pipe":str,
46:int);
-barrier X_150:bit := language.dataflow();
+barrier X_149:bit := language.dataflow();
X_46:bat[:str] := bat.new(nil:str);
X_52:bat[:int] := bat.new(nil:int);
X_50:bat[:int] := bat.new(nil:int);
X_49:bat[:str] := bat.new(nil:str);
X_48:bat[:str] := bat.new(nil:str);
X_14:int := sql.mvc();
- X_161:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "y":str,
0:int, 1:int, 2:int);
- X_127:bat[:dbl] := mosaic.decompress(X_161:bat[:dbl]);
- X_162:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "x":str,
0:int, 1:int, 2:int);
- X_125:bat[:dbl] := mosaic.decompress(X_162:bat[:dbl]);
- C_163:bat[:oid] := sql.tid(X_14:int, "sys":str, "test3":str, 1:int, 2:int);
- X_123:bat[:oid] := mosaic.decompress(C_163:bat[:oid]);
- C_130:bat[:oid] := algebra.select(X_125:bat[:dbl], X_123:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
- C_132:bat[:oid] := algebra.select(X_127:bat[:dbl], C_130:bat[:oid], 0:dbl,
2:dbl, true:bit, true:bit, false:bit);
- X_136:bat[:dbl] := algebra.projection(C_132:bat[:oid], X_127:bat[:dbl]);
- X_164:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "y":str,
0:int, 0:int, 2:int);
- X_126:bat[:dbl] := mosaic.decompress(X_164:bat[:dbl]);
- X_165:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "x":str,
0:int, 0:int, 2:int);
- X_124:bat[:dbl] := mosaic.decompress(X_165:bat[:dbl]);
- C_166:bat[:oid] := sql.tid(X_14:int, "sys":str, "test3":str, 0:int, 2:int);
- X_121:bat[:oid] := mosaic.decompress(C_166:bat[:oid]);
- C_129:bat[:oid] := algebra.select(X_124:bat[:dbl], X_121:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ X_126:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "y":str,
0:int, 1:int, 2:int);
+ X_124:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "x":str,
0:int, 1:int, 2:int);
+ C_122:bat[:oid] := sql.tid(X_14:int, "sys":str, "test3":str, 1:int, 2:int);
+ C_129:bat[:oid] := algebra.select(X_124:bat[:dbl], C_122:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
C_131:bat[:oid] := algebra.select(X_126:bat[:dbl], C_129:bat[:oid], 0:dbl,
2:dbl, true:bit, true:bit, false:bit);
X_135:bat[:dbl] := algebra.projection(C_131:bat[:oid], X_126:bat[:dbl]);
- X_134:bat[:dbl] := algebra.projection(C_132:bat[:oid], X_125:bat[:dbl]);
+ X_125:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "y":str,
0:int, 0:int, 2:int);
+ X_123:bat[:dbl] := sql.bind(X_14:int, "sys":str, "test3":str, "x":str,
0:int, 0:int, 2:int);
+ C_120:bat[:oid] := sql.tid(X_14:int, "sys":str, "test3":str, 0:int, 2:int);
+ C_128:bat[:oid] := algebra.select(X_123:bat[:dbl], C_120:bat[:oid], 4:dbl,
6:dbl, true:bit, true:bit, false:bit);
+ C_130:bat[:oid] := algebra.select(X_125:bat[:dbl], C_128:bat[:oid], 0:dbl,
2:dbl, true:bit, true:bit, false:bit);
+ X_134:bat[:dbl] := algebra.projection(C_130:bat[:oid], X_125:bat[:dbl]);
X_133:bat[:dbl] := algebra.projection(C_131:bat[:oid], X_124:bat[:dbl]);
+ X_132:bat[:dbl] := algebra.projection(C_130:bat[:oid], X_123:bat[:dbl]);
X_53:bat[:str] := bat.append(X_46:bat[:str], "sys.test":str);
X_55:bat[:str] := bat.append(X_48:bat[:str], "x":str);
X_57:bat[:str] := bat.append(X_49:bat[:str], "double":str);
@@ -436,17 +412,17 @@ barrier X_150:bit := language.dataflow()
X_66:bat[:str] := bat.append(X_57:bat[:str], "double":str);
X_67:bat[:int] := bat.append(X_59:bat[:int], 53:int);
X_68:bat[:int] := bat.append(X_61:bat[:int], 0:int);
- X_145:bat[:dbl] := mat.packIncrement(X_133:bat[:dbl], 2:int);
- X_43:bat[:dbl] := mat.packIncrement(X_145:bat[:dbl], X_134:bat[:dbl]);
- X_147:bat[:dbl] := mat.packIncrement(X_135:bat[:dbl], 2:int);
- X_44:bat[:dbl] := mat.packIncrement(X_147:bat[:dbl], X_136:bat[:dbl]);
- language.pass(X_127:bat[:dbl]);
+ X_144:bat[:dbl] := mat.packIncrement(X_132:bat[:dbl], 2:int);
+ X_43:bat[:dbl] := mat.packIncrement(X_144:bat[:dbl], X_133:bat[:dbl]);
+ X_146:bat[:dbl] := mat.packIncrement(X_134:bat[:dbl], 2:int);
+ X_44:bat[:dbl] := mat.packIncrement(X_146:bat[:dbl], X_135:bat[:dbl]);
language.pass(X_126:bat[:dbl]);
- language.pass(C_132:bat[:oid]);
language.pass(X_125:bat[:dbl]);
language.pass(C_131:bat[:oid]);
language.pass(X_124:bat[:dbl]);
-exit X_150:bit;
+ language.pass(C_130:bat[:oid]);
+ language.pass(X_123:bat[:dbl]);
+exit X_149:bit;
sql.resultSet(X_63:bat[:str], X_64:bat[:str], X_66:bat[:str],
X_67:bat[:int], X_68:bat[:int], X_43:bat[:dbl], X_44:bat[:dbl]);
end user.SQLanalyze;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
