Changeset: 7bfe54cd70cd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7bfe54cd70cd
Modified Files:
sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.sql
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out.single
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.sql
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out
sql/test/BugTracker-2019/Tests/duplicates-not-eliminated-long-CASE-stmt.Bug-6697.stable.out.single
sql/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.stable.out
sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.stable.out
sql/test/BugTracker/Tests/crash_on_cast.SF-1357271.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out
sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/miscellaneous/Tests/simple_plans.stable.out
sql/test/remote/Tests/partition_elim.stable.out
Branch: Jun2020
Log Message:
approved output
diffs (truncated from 4095 to 300 lines):
diff --git a/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
b/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/udf/Tests/udf-fuse.stable.out
@@ -169,20 +169,20 @@ end user.s8_0;
% clob # type
% 114 # length
function user.s16_0():void;
- X_1:void := querylog.define("explain select fuse(a,b) from udf_fuse;":str,
"sequential_pipe":str, 26:int);
- X_34:bat[:str] := bat.pack("sys.%1":str);
- X_35:bat[:str] := bat.pack("%1":str);
- X_36:bat[:str] := bat.pack("smallint":str);
- X_37:bat[:int] := bat.pack(16:int);
- X_38:bat[:int] := bat.pack(0:int);
+ X_1:void := querylog.define("explain select fuse(a,b) from udf_fuse;":str,
"sequential_pipe":str, 22:int);
+ X_29:bat[:str] := bat.pack("sys.%1":str);
+ X_30:bat[:str] := bat.pack("%1":str);
+ X_31:bat[:str] := bat.pack("smallint":str);
+ X_32:bat[:int] := bat.pack(16:int);
+ X_33:bat[:int] := bat.pack(0:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "udf_fuse":str);
- X_17:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "a":str,
0:int);
- X_28:bat[:bte] := algebra.projection(C_5:bat[:oid], X_17:bat[:bte]);
- X_22:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "b":str,
0:int);
- X_29:bat[:bte] := algebra.projection(C_5:bat[:oid], X_22:bat[:bte]);
- X_30:bat[:sht] := batudf.fuse(X_28:bat[:bte], X_29:bat[:bte]);
- sql.resultSet(X_34:bat[:str], X_35:bat[:str], X_36:bat[:str],
X_37:bat[:int], X_38:bat[:int], X_30:bat[:sht]);
+ X_8:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "a":str,
0:int);
+ X_23:bat[:bte] := algebra.projection(C_5:bat[:oid], X_8:bat[:bte]);
+ X_17:bat[:bte] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "b":str,
0:int);
+ X_24:bat[:bte] := algebra.projection(C_5:bat[:oid], X_17:bat[:bte]);
+ X_25:bat[:sht] := batudf.fuse(X_23:bat[:bte], X_24:bat[:bte]);
+ sql.resultSet(X_29:bat[:str], X_30:bat[:str], X_31:bat[:str],
X_32:bat[:int], X_33:bat[:int], X_25:bat[:sht]);
end user.s16_0;
#inline actions= 0 time=1 usec
#remap actions= 1 time=6 usec
@@ -215,20 +215,20 @@ end user.s16_0;
% clob # type
% 114 # length
function user.s18_0():void;
- X_1:void := querylog.define("explain select fuse(c,d) from udf_fuse;":str,
"sequential_pipe":str, 26:int);
- X_34:bat[:str] := bat.pack("sys.%1":str);
- X_35:bat[:str] := bat.pack("%1":str);
- X_36:bat[:str] := bat.pack("int":str);
- X_37:bat[:int] := bat.pack(32:int);
- X_38:bat[:int] := bat.pack(0:int);
+ X_1:void := querylog.define("explain select fuse(c,d) from udf_fuse;":str,
"sequential_pipe":str, 22:int);
+ X_29:bat[:str] := bat.pack("sys.%1":str);
+ X_30:bat[:str] := bat.pack("%1":str);
+ X_31:bat[:str] := bat.pack("int":str);
+ X_32:bat[:int] := bat.pack(32:int);
+ X_33:bat[:int] := bat.pack(0:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "udf_fuse":str);
- X_17:bat[:sht] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "c":str,
0:int);
- X_28:bat[:sht] := algebra.projection(C_5:bat[:oid], X_17:bat[:sht]);
- X_22:bat[:sht] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "d":str,
0:int);
- X_29:bat[:sht] := algebra.projection(C_5:bat[:oid], X_22:bat[:sht]);
- X_30:bat[:int] := batudf.fuse(X_28:bat[:sht], X_29:bat[:sht]);
- sql.resultSet(X_34:bat[:str], X_35:bat[:str], X_36:bat[:str],
X_37:bat[:int], X_38:bat[:int], X_30:bat[:int]);
+ X_8:bat[:sht] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "c":str,
0:int);
+ X_23:bat[:sht] := algebra.projection(C_5:bat[:oid], X_8:bat[:sht]);
+ X_17:bat[:sht] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "d":str,
0:int);
+ X_24:bat[:sht] := algebra.projection(C_5:bat[:oid], X_17:bat[:sht]);
+ X_25:bat[:int] := batudf.fuse(X_23:bat[:sht], X_24:bat[:sht]);
+ sql.resultSet(X_29:bat[:str], X_30:bat[:str], X_31:bat[:str],
X_32:bat[:int], X_33:bat[:int], X_25:bat[:int]);
end user.s18_0;
#inline actions= 0 time=0 usec
#remap actions= 1 time=4 usec
@@ -261,20 +261,20 @@ end user.s18_0;
% clob # type
% 114 # length
function user.s20_0():void;
- X_1:void := querylog.define("explain select fuse(e,f) from udf_fuse;":str,
"sequential_pipe":str, 26:int);
- X_34:bat[:str] := bat.pack("sys.%1":str);
- X_35:bat[:str] := bat.pack("%1":str);
- X_36:bat[:str] := bat.pack("bigint":str);
- X_37:bat[:int] := bat.pack(64:int);
- X_38:bat[:int] := bat.pack(0:int);
+ X_1:void := querylog.define("explain select fuse(e,f) from udf_fuse;":str,
"sequential_pipe":str, 22:int);
+ X_29:bat[:str] := bat.pack("sys.%1":str);
+ X_30:bat[:str] := bat.pack("%1":str);
+ X_31:bat[:str] := bat.pack("bigint":str);
+ X_32:bat[:int] := bat.pack(64:int);
+ X_33:bat[:int] := bat.pack(0:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "udf_fuse":str);
- X_17:bat[:int] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "e":str,
0:int);
- X_28:bat[:int] := algebra.projection(C_5:bat[:oid], X_17:bat[:int]);
- X_22:bat[:int] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "f":str,
0:int);
- X_29:bat[:int] := algebra.projection(C_5:bat[:oid], X_22:bat[:int]);
- X_30:bat[:lng] := batudf.fuse(X_28:bat[:int], X_29:bat[:int]);
- sql.resultSet(X_34:bat[:str], X_35:bat[:str], X_36:bat[:str],
X_37:bat[:int], X_38:bat[:int], X_30:bat[:lng]);
+ X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "e":str,
0:int);
+ X_23:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]);
+ X_17:bat[:int] := sql.bind(X_4:int, "sys":str, "udf_fuse":str, "f":str,
0:int);
+ X_24:bat[:int] := algebra.projection(C_5:bat[:oid], X_17:bat[:int]);
+ X_25:bat[:lng] := batudf.fuse(X_23:bat[:int], X_24:bat[:int]);
+ sql.resultSet(X_29:bat[:str], X_30:bat[:str], X_31:bat[:str],
X_32:bat[:int], X_33:bat[:int], X_25:bat[:lng]);
end user.s20_0;
#inline actions= 0 time=0 usec
#remap actions= 1 time=4 usec
diff --git a/sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
b/sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
--- a/sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
+++ b/sql/backends/monet5/UDF/udf/Tests/udf-reverse.stable.out
@@ -107,17 +107,17 @@ end user.s4_0;
% clob # type
% 114 # length
function user.s16_0():void;
- X_1:void := querylog.define("explain select reverse(x) from
udf_reverse;":str, "sequential_pipe":str, 21:int);
- X_27:bat[:str] := bat.pack("sys.%1":str);
- X_28:bat[:str] := bat.pack("%1":str);
- X_29:bat[:str] := bat.pack("clob":str);
- X_30:bat[:int] := bat.pack(0:int);
+ X_1:void := querylog.define("explain select reverse(x) from
udf_reverse;":str, "sequential_pipe":str, 17:int);
+ X_22:bat[:str] := bat.pack("sys.%1":str);
+ X_23:bat[:str] := bat.pack("%1":str);
+ X_24:bat[:str] := bat.pack("clob":str);
+ X_25:bat[:int] := bat.pack(0:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "udf_reverse":str);
- X_17:bat[:str] := sql.bind(X_4:int, "sys":str, "udf_reverse":str, "x":str,
0:int);
- X_22:bat[:str] := algebra.projection(C_5:bat[:oid], X_17:bat[:str]);
- X_23:bat[:str] := batudf.reverse(X_22:bat[:str]);
- sql.resultSet(X_27:bat[:str], X_28:bat[:str], X_29:bat[:str],
X_30:bat[:int], X_30:bat[:int], X_23:bat[:str]);
+ X_8:bat[:str] := sql.bind(X_4:int, "sys":str, "udf_reverse":str, "x":str,
0:int);
+ X_17:bat[:str] := algebra.projection(C_5:bat[:oid], X_8:bat[:str]);
+ X_18:bat[:str] := batudf.reverse(X_17:bat[:str]);
+ sql.resultSet(X_22:bat[:str], X_23:bat[:str], X_24:bat[:str],
X_25:bat[:int], X_25:bat[:int], X_18:bat[:str]);
end user.s16_0;
#inline actions= 0 time=1 usec
#remap actions= 1 time=5 usec
diff --git
a/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
b/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
---
a/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
+++
b/sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
@@ -17,7 +17,7 @@ stdout of test 'segfault_when_quitting_d
#set optimizer = 'sequential_pipe'; -- to get predictable errors
#debug select * from tables;
-mdb>#X_1=0@0:void := querylog.define("debug select * from tables;",
"sequential_pipe", 136:int);
+mdb>#X_1=0@0:void := querylog.define("debug select * from tables;",
"sequential_pipe", 131:int);
# 22:21:12 >
# 22:21:12 > "Done."
diff --git
a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
--- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
+++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
@@ -129,22 +129,20 @@ top N (
% clob # type
% 114 # length
function user.s8_0():void;
- X_1:void := querylog.define("explain select * from oblo;":str,
"minimal_pipe":str, 20:int);
+ X_1:void := querylog.define("explain select * from oblo;":str,
"minimal_pipe":str, 16:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "oblo":str);
+ X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
X_11:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
(X_13:bat[:oid], X_14:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_17:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
- X_18:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
- (X_19:bat[:oid], X_20:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_21:bat[:int] := sql.delta(X_17:bat[:int], X_19:bat[:oid],
X_20:bat[:int], X_18:bat[:int]);
- X_22:bat[:int] := algebra.projection(C_5:bat[:oid], X_21:bat[:int]);
- X_24:bat[:str] := bat.pack("sys.oblo":str);
- X_25:bat[:str] := bat.pack("a":str);
- X_26:bat[:str] := bat.pack("int":str);
- X_27:bat[:int] := bat.pack(32:int);
- X_28:bat[:int] := bat.pack(0:int);
- sql.resultSet(X_24:bat[:str], X_25:bat[:str], X_26:bat[:str],
X_27:bat[:int], X_28:bat[:int], X_22:bat[:int]);
+ X_16:bat[:int] := sql.delta(X_8:bat[:int], X_13:bat[:oid], X_14:bat[:int],
X_11:bat[:int]);
+ X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_16:bat[:int]);
+ X_19:bat[:str] := bat.pack("sys.oblo":str);
+ X_20:bat[:str] := bat.pack("a":str);
+ X_21:bat[:str] := bat.pack("int":str);
+ X_22:bat[:int] := bat.pack(32:int);
+ X_23:bat[:int] := bat.pack(0:int);
+ sql.resultSet(X_19:bat[:str], X_20:bat[:str], X_21:bat[:str],
X_22:bat[:int], X_23:bat[:int], X_17:bat[:int]);
end user.s8_0;
#inline actions= 0 time=0 usec
#remap actions= 0 time=1 usec
@@ -160,28 +158,26 @@ end user.s8_0;
% clob # type
% 114 # length
function user.s10_0():void;
- X_1:void := querylog.define("explain select * from oblo offset 2;":str,
"minimal_pipe":str, 26:int);
+ X_1:void := querylog.define("explain select * from oblo offset 2;":str,
"minimal_pipe":str, 22:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "oblo":str);
+ X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
X_11:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
(X_13:bat[:oid], X_14:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_17:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
- X_18:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
- (X_19:bat[:oid], X_20:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_21:bat[:int] := sql.delta(X_17:bat[:int], X_19:bat[:oid],
X_20:bat[:int], X_18:bat[:int]);
- X_22:bat[:int] := algebra.projection(C_5:bat[:oid], X_21:bat[:int]);
- X_23:lng := calc.lng(2:lng);
- X_25:lng := calc.lng(nil:lng);
- X_27:lng := calc.+(X_23:lng, X_25:lng);
- X_28:lng := calc.-(X_27:lng, 1:int);
- C_29:bat[:oid] := algebra.subslice(X_22:bat[:int], X_23:lng, X_28:lng);
- X_30:bat[:int] := algebra.projection(C_29:bat[:oid], X_22:bat[:int]);
- X_32:bat[:str] := bat.pack("sys.oblo":str);
- X_33:bat[:str] := bat.pack("a":str);
- X_34:bat[:str] := bat.pack("int":str);
- X_35:bat[:int] := bat.pack(32:int);
- X_36:bat[:int] := bat.pack(0:int);
- sql.resultSet(X_32:bat[:str], X_33:bat[:str], X_34:bat[:str],
X_35:bat[:int], X_36:bat[:int], X_30:bat[:int]);
+ X_16:bat[:int] := sql.delta(X_8:bat[:int], X_13:bat[:oid], X_14:bat[:int],
X_11:bat[:int]);
+ X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_16:bat[:int]);
+ X_18:lng := calc.lng(2:lng);
+ X_20:lng := calc.lng(nil:lng);
+ X_22:lng := calc.+(X_18:lng, X_20:lng);
+ X_23:lng := calc.-(X_22:lng, 1:int);
+ C_24:bat[:oid] := algebra.subslice(X_17:bat[:int], X_18:lng, X_23:lng);
+ X_25:bat[:int] := algebra.projection(C_24:bat[:oid], X_17:bat[:int]);
+ X_27:bat[:str] := bat.pack("sys.oblo":str);
+ X_28:bat[:str] := bat.pack("a":str);
+ X_29:bat[:str] := bat.pack("int":str);
+ X_30:bat[:int] := bat.pack(32:int);
+ X_31:bat[:int] := bat.pack(0:int);
+ sql.resultSet(X_27:bat[:str], X_28:bat[:str], X_29:bat[:str],
X_30:bat[:int], X_31:bat[:int], X_25:bat[:int]);
end user.s10_0;
#inline actions= 0 time=0 usec
#remap actions= 0 time=1 usec
@@ -197,28 +193,26 @@ end user.s10_0;
% clob # type
% 114 # length
function user.s12_0():void;
- X_1:void := querylog.define("explain select * from oblo limit 2;":str,
"minimal_pipe":str, 26:int);
+ X_1:void := querylog.define("explain select * from oblo limit 2;":str,
"minimal_pipe":str, 22:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "oblo":str);
+ X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
X_11:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
(X_13:bat[:oid], X_14:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_17:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
- X_18:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
- (X_19:bat[:oid], X_20:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_21:bat[:int] := sql.delta(X_17:bat[:int], X_19:bat[:oid],
X_20:bat[:int], X_18:bat[:int]);
- X_22:bat[:int] := algebra.projection(C_5:bat[:oid], X_21:bat[:int]);
- X_23:lng := calc.lng(2:lng);
- X_25:lng := calc.lng(0:lng);
- X_27:lng := calc.+(X_25:lng, X_23:lng);
- X_28:lng := calc.-(X_27:lng, 1:int);
- C_29:bat[:oid] := algebra.subslice(X_22:bat[:int], X_25:lng, X_28:lng);
- X_30:bat[:int] := algebra.projection(C_29:bat[:oid], X_22:bat[:int]);
- X_32:bat[:str] := bat.pack("sys.oblo":str);
- X_33:bat[:str] := bat.pack("a":str);
- X_34:bat[:str] := bat.pack("int":str);
- X_35:bat[:int] := bat.pack(32:int);
- X_36:bat[:int] := bat.pack(0:int);
- sql.resultSet(X_32:bat[:str], X_33:bat[:str], X_34:bat[:str],
X_35:bat[:int], X_36:bat[:int], X_30:bat[:int]);
+ X_16:bat[:int] := sql.delta(X_8:bat[:int], X_13:bat[:oid], X_14:bat[:int],
X_11:bat[:int]);
+ X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_16:bat[:int]);
+ X_18:lng := calc.lng(2:lng);
+ X_20:lng := calc.lng(0:lng);
+ X_22:lng := calc.+(X_20:lng, X_18:lng);
+ X_23:lng := calc.-(X_22:lng, 1:int);
+ C_24:bat[:oid] := algebra.subslice(X_17:bat[:int], X_20:lng, X_23:lng);
+ X_25:bat[:int] := algebra.projection(C_24:bat[:oid], X_17:bat[:int]);
+ X_27:bat[:str] := bat.pack("sys.oblo":str);
+ X_28:bat[:str] := bat.pack("a":str);
+ X_29:bat[:str] := bat.pack("int":str);
+ X_30:bat[:int] := bat.pack(32:int);
+ X_31:bat[:int] := bat.pack(0:int);
+ sql.resultSet(X_27:bat[:str], X_28:bat[:str], X_29:bat[:str],
X_30:bat[:int], X_31:bat[:int], X_25:bat[:int]);
end user.s12_0;
#inline actions= 0 time=0 usec
#remap actions= 0 time=0 usec
@@ -234,28 +228,26 @@ end user.s12_0;
% clob # type
% 114 # length
function user.s14_0():void;
- X_1:void := querylog.define("explain select * from oblo limit 1 offset
2;":str, "minimal_pipe":str, 26:int);
+ X_1:void := querylog.define("explain select * from oblo limit 1 offset
2;":str, "minimal_pipe":str, 22:int);
X_4:int := sql.mvc();
C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "oblo":str);
+ X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
X_11:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
(X_13:bat[:oid], X_14:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_17:bat[:int] := sql.bind(X_4:int, "sys":str, "oblo":str, "a":str, 0:int);
- X_18:bat[:int] := sql.emptybind(X_4:int, "sys":str, "oblo":str, "a":str,
1:int);
- (X_19:bat[:oid], X_20:bat[:int]) := sql.emptybind(X_4:int, "sys":str,
"oblo":str, "a":str, 2:int);
- X_21:bat[:int] := sql.delta(X_17:bat[:int], X_19:bat[:oid],
X_20:bat[:int], X_18:bat[:int]);
- X_22:bat[:int] := algebra.projection(C_5:bat[:oid], X_21:bat[:int]);
- X_23:lng := calc.lng(1:lng);
- X_25:lng := calc.lng(2:lng);
- X_27:lng := calc.+(X_25:lng, X_23:lng);
- X_28:lng := calc.-(X_27:lng, 1:int);
- C_29:bat[:oid] := algebra.subslice(X_22:bat[:int], X_25:lng, X_28:lng);
- X_30:bat[:int] := algebra.projection(C_29:bat[:oid], X_22:bat[:int]);
- X_32:bat[:str] := bat.pack("sys.oblo":str);
- X_33:bat[:str] := bat.pack("a":str);
- X_34:bat[:str] := bat.pack("int":str);
- X_35:bat[:int] := bat.pack(32:int);
- X_36:bat[:int] := bat.pack(0:int);
- sql.resultSet(X_32:bat[:str], X_33:bat[:str], X_34:bat[:str],
X_35:bat[:int], X_36:bat[:int], X_30:bat[:int]);
+ X_16:bat[:int] := sql.delta(X_8:bat[:int], X_13:bat[:oid], X_14:bat[:int],
X_11:bat[:int]);
+ X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_16:bat[:int]);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
