Changeset: fd965637d97a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fd965637d97a
Modified Files:
sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/04-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/13-explain.stable.out
sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
sql/benchmarks/tpch/Tests/16-explain.stable.out
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
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-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.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-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/mergetables/Tests/mergequery.stable.out
Branch: jit
Log Message:
Approve output
diffs (truncated from 8412 to 300 lines):
diff --git a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-fuse.stable.out
@@ -170,25 +170,31 @@ end user.s8_1;
% clob # type
% 97 # length
function user.s16_1():void;
- X_31:void := querylog.define("explain select fuse(a,b) from
udf_fuse;","sequential_pipe",21);
- X_14 := bat.new(nil:oid,nil:str);
- X_22 := bat.append(X_14,"sys.L");
- X_17 := bat.new(nil:oid,nil:str);
- X_24 := bat.append(X_17,"fuse_a");
- X_18 := bat.new(nil:oid,nil:str);
- X_26 := bat.append(X_18,"smallint");
- X_19 := bat.new(nil:oid,nil:int);
- X_28 := bat.append(X_19,16);
- X_21 := bat.new(nil:oid,nil:int);
- X_30 := bat.append(X_21,0);
+ X_41:void := querylog.define("explain select fuse(a,b) from
udf_fuse;","sequential_pipe",27);
+ X_24 := bat.new(nil:oid,nil:str);
+ X_32 := bat.append(X_24,"sys.L");
+ X_27 := bat.new(nil:oid,nil:str);
+ X_34 := bat.append(X_27,"fuse_a");
+ X_28 := bat.new(nil:oid,nil:str);
+ X_36 := bat.append(X_28,"smallint");
+ X_29 := bat.new(nil:oid,nil:int);
+ X_38 := bat.append(X_29,16);
+ X_31 := bat.new(nil:oid,nil:int);
+ X_40 := bat.append(X_31,0);
X_1 := sql.mvc();
C_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
X_5:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","a",0);
- X_8 := algebra.projection(C_2,X_5);
- X_9:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","b",0);
- X_11 := algebra.projection(C_2,X_9);
- X_12:bat[:sht] := batudf.fuse(X_8,X_11);
- sql.resultSet(X_22,X_24,X_26,X_28,X_30,X_12);
+ (C_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","a",2);
+ X_11:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","a",1);
+ X_13 := sql.delta(X_5,C_8,r1_8,X_11);
+ X_14 := algebra.projection(C_2,X_13);
+ X_15:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","b",0);
+ (C_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","b",2);
+ X_19:bat[:bte] := sql.bind(X_1,"sys","udf_fuse","b",1);
+ X_20 := sql.delta(X_15,C_17,r1_17,X_19);
+ X_21 := algebra.projection(C_2,X_20);
+ X_22:bat[:sht] := batudf.fuse(X_14,X_21);
+ sql.resultSet(X_32,X_34,X_36,X_38,X_40,X_22);
end user.s16_1;
#inline actions= 0 time=4 usec
#candidates actions= 1 time=19 usec
@@ -221,25 +227,31 @@ end user.s16_1;
% clob # type
% 97 # length
function user.s18_1():void;
- X_31:void := querylog.define("explain select fuse(c,d) from
udf_fuse;","sequential_pipe",21);
- X_14 := bat.new(nil:oid,nil:str);
- X_22 := bat.append(X_14,"sys.L");
- X_17 := bat.new(nil:oid,nil:str);
- X_24 := bat.append(X_17,"fuse_c");
- X_18 := bat.new(nil:oid,nil:str);
- X_26 := bat.append(X_18,"int");
- X_19 := bat.new(nil:oid,nil:int);
- X_28 := bat.append(X_19,32);
- X_21 := bat.new(nil:oid,nil:int);
- X_30 := bat.append(X_21,0);
+ X_41:void := querylog.define("explain select fuse(c,d) from
udf_fuse;","sequential_pipe",27);
+ X_24 := bat.new(nil:oid,nil:str);
+ X_32 := bat.append(X_24,"sys.L");
+ X_27 := bat.new(nil:oid,nil:str);
+ X_34 := bat.append(X_27,"fuse_c");
+ X_28 := bat.new(nil:oid,nil:str);
+ X_36 := bat.append(X_28,"int");
+ X_29 := bat.new(nil:oid,nil:int);
+ X_38 := bat.append(X_29,32);
+ X_31 := bat.new(nil:oid,nil:int);
+ X_40 := bat.append(X_31,0);
X_1 := sql.mvc();
C_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
X_5:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","c",0);
- X_8 := algebra.projection(C_2,X_5);
- X_9:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","d",0);
- X_11 := algebra.projection(C_2,X_9);
- X_12:bat[:int] := batudf.fuse(X_8,X_11);
- sql.resultSet(X_22,X_24,X_26,X_28,X_30,X_12);
+ (C_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","c",2);
+ X_11:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","c",1);
+ X_13 := sql.delta(X_5,C_8,r1_8,X_11);
+ X_14 := algebra.projection(C_2,X_13);
+ X_15:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","d",0);
+ (C_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","d",2);
+ X_19:bat[:sht] := sql.bind(X_1,"sys","udf_fuse","d",1);
+ X_20 := sql.delta(X_15,C_17,r1_17,X_19);
+ X_21 := algebra.projection(C_2,X_20);
+ X_22:bat[:int] := batudf.fuse(X_14,X_21);
+ sql.resultSet(X_32,X_34,X_36,X_38,X_40,X_22);
end user.s18_1;
#inline actions= 0 time=2 usec
#candidates actions= 1 time=19 usec
@@ -272,25 +284,31 @@ end user.s18_1;
% clob # type
% 97 # length
function user.s20_1():void;
- X_31:void := querylog.define("explain select fuse(e,f) from
udf_fuse;","sequential_pipe",21);
- X_14 := bat.new(nil:oid,nil:str);
- X_22 := bat.append(X_14,"sys.L");
- X_17 := bat.new(nil:oid,nil:str);
- X_24 := bat.append(X_17,"fuse_e");
- X_18 := bat.new(nil:oid,nil:str);
- X_26 := bat.append(X_18,"bigint");
- X_19 := bat.new(nil:oid,nil:int);
- X_28 := bat.append(X_19,64);
- X_21 := bat.new(nil:oid,nil:int);
- X_30 := bat.append(X_21,0);
+ X_41:void := querylog.define("explain select fuse(e,f) from
udf_fuse;","sequential_pipe",27);
+ X_24 := bat.new(nil:oid,nil:str);
+ X_32 := bat.append(X_24,"sys.L");
+ X_27 := bat.new(nil:oid,nil:str);
+ X_34 := bat.append(X_27,"fuse_e");
+ X_28 := bat.new(nil:oid,nil:str);
+ X_36 := bat.append(X_28,"bigint");
+ X_29 := bat.new(nil:oid,nil:int);
+ X_38 := bat.append(X_29,64);
+ X_31 := bat.new(nil:oid,nil:int);
+ X_40 := bat.append(X_31,0);
X_1 := sql.mvc();
C_2:bat[:oid] := sql.tid(X_1,"sys","udf_fuse");
X_5:bat[:int] := sql.bind(X_1,"sys","udf_fuse","e",0);
- X_8 := algebra.projection(C_2,X_5);
- X_9:bat[:int] := sql.bind(X_1,"sys","udf_fuse","f",0);
- X_11 := algebra.projection(C_2,X_9);
- X_12:bat[:lng] := batudf.fuse(X_8,X_11);
- sql.resultSet(X_22,X_24,X_26,X_28,X_30,X_12);
+ (C_8,r1_8) := sql.bind(X_1,"sys","udf_fuse","e",2);
+ X_11:bat[:int] := sql.bind(X_1,"sys","udf_fuse","e",1);
+ X_13 := sql.delta(X_5,C_8,r1_8,X_11);
+ X_14 := algebra.projection(C_2,X_13);
+ X_15:bat[:int] := sql.bind(X_1,"sys","udf_fuse","f",0);
+ (C_17,r1_17) := sql.bind(X_1,"sys","udf_fuse","f",2);
+ X_19:bat[:int] := sql.bind(X_1,"sys","udf_fuse","f",1);
+ X_20 := sql.delta(X_15,C_17,r1_17,X_19);
+ X_21 := algebra.projection(C_2,X_20);
+ X_22:bat[:lng] := batudf.fuse(X_14,X_21);
+ sql.resultSet(X_32,X_34,X_36,X_38,X_40,X_22);
end user.s20_1;
#inline actions= 0 time=2 usec
#candidates actions= 1 time=18 usec
diff --git a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
--- a/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
+++ b/sql/backends/monet5/UDF/Tests/udf-reverse.stable.out
@@ -109,23 +109,26 @@ end user.s4_1;
% clob # type
% 101 # length
function user.s12_1():void;
- X_27:void := querylog.define("explain select reverse(x) from
udf_reverse;","sequential_pipe",19);
- X_11 := bat.new(nil:oid,nil:str);
- X_19 := bat.append(X_11,"sys.L");
- X_14 := bat.new(nil:oid,nil:str);
- X_21 := bat.append(X_14,"reverse_x");
- X_15 := bat.new(nil:oid,nil:str);
- X_23 := bat.append(X_15,"clob");
- X_16 := bat.new(nil:oid,nil:int);
- X_25 := bat.append(X_16,0);
- X_18 := bat.new(nil:oid,nil:int);
- X_26 := bat.append(X_18,0);
+ X_33:void := querylog.define("explain select reverse(x) from
udf_reverse;","sequential_pipe",22);
+ X_17 := bat.new(nil:oid,nil:str);
+ X_25 := bat.append(X_17,"sys.L");
+ X_20 := bat.new(nil:oid,nil:str);
+ X_27 := bat.append(X_20,"reverse_x");
+ X_21 := bat.new(nil:oid,nil:str);
+ X_29 := bat.append(X_21,"clob");
+ X_22 := bat.new(nil:oid,nil:int);
+ X_31 := bat.append(X_22,0);
+ X_24 := bat.new(nil:oid,nil:int);
+ X_32 := bat.append(X_24,0);
X_1 := sql.mvc();
C_2:bat[:oid] := sql.tid(X_1,"sys","udf_reverse");
X_5:bat[:str] := sql.bind(X_1,"sys","udf_reverse","x",0);
- X_8 := algebra.projection(C_2,X_5);
- X_9:bat[:str] := batudf.reverse(X_8);
- sql.resultSet(X_19,X_21,X_23,X_25,X_26,X_9);
+ (C_8,r1_8) := sql.bind(X_1,"sys","udf_reverse","x",2);
+ X_11:bat[:str] := sql.bind(X_1,"sys","udf_reverse","x",1);
+ X_13 := sql.delta(X_5,C_8,r1_8,X_11);
+ X_14 := algebra.projection(C_2,X_13);
+ X_15:bat[:str] := batudf.reverse(X_14);
+ sql.resultSet(X_25,X_27,X_29,X_31,X_32,X_15);
end user.s12_1;
#inline actions= 0 time=4 usec
#candidates actions= 1 time=15 usec
diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
@@ -38,28 +38,47 @@ Ready.
% clob # type
% 254 # length
function user.s4_1():void;
- X_48:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_year = 1993\n and lo_discount between 1 and
3\n and lo_quantity < 25;","sequential_pipe",24);
+ X_62:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_year = 1993\n and lo_discount between 1 and
3\n and lo_quantity < 25;","sequential_pipe",43);
X_5 := sql.mvc();
X_9:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_quantity",0);
- X_13:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_discount",0);
+ X_16:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_discount",0);
C_6:bat[:oid] := sql.tid(X_5,"sys","lineorder");
- C_15 := algebra.subselect(X_13,C_6,1,3,true,true,false);
- C_18 := algebra.thetasubselect(X_9,C_15,25,"<");
- X_20:bat[:oid] :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
- (X_22,r1_37) :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
- X_24:bat[:oid] :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
- X_25 := sql.projectdelta(C_18,X_20,X_22,r1_37,X_24);
- X_28:bat[:int] := sql.bind(X_5,"sys","dwdate","d_year",0);
- C_26:bat[:oid] := sql.tid(X_5,"sys","dwdate");
- C_30 := algebra.subselect(X_28,C_26,1993,1993,true,false,false);
- (X_31,r1_55) := algebra.subjoin(X_25,C_30,nil:BAT,nil:BAT,false,nil:lng);
- X_35:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_extendedprice",0);
- X_37:bat[:int] := algebra.projectionpath(X_31,C_18,X_35);
- X_38 := batcalc.lng(X_37);
- X_39:bat[:int] := algebra.projectionpath(X_31,C_18,X_13);
- X_40:bat[:lng] := batcalc.*(X_38,X_39);
- X_41:hge := aggr.sum(X_40);
- sql.resultSet("sys.L1","revenue","hugeint",128,0,7,X_41);
+ C_78 := algebra.subselect(X_16,C_6,1,3,true,true,false);
+ (C_18,r1_22) := sql.bind(X_5,"sys","lineorder","lo_discount",2);
+ C_79 := algebra.subselect(r1_22,nil:bat[:oid],1,3,true,true,false);
+ X_20:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_discount",1);
+ C_81 := algebra.subselect(X_20,C_6,1,3,true,true,false);
+ C_21 := sql.subdelta(C_78,C_6,C_18,C_79,C_81);
+ C_82 := algebra.thetasubselect(X_9,C_21,25,"<");
+ (C_12,r1_12) := sql.bind(X_5,"sys","lineorder","lo_quantity",2);
+ C_83 := algebra.thetasubselect(r1_12,nil:bat[:oid],25,"<");
+ X_15:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_quantity",1);
+ C_84 := algebra.thetasubselect(X_15,C_21,25,"<");
+ C_24 := sql.subdelta(C_82,C_21,C_12,C_83,C_84);
+ X_26:bat[:oid] :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
+ (X_28,r1_37) :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
+ X_30:bat[:oid] :=
sql.bind_idxbat(X_5,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
+ X_31 := sql.projectdelta(C_24,X_26,X_28,r1_37,X_30);
+ X_34:bat[:int] := sql.bind(X_5,"sys","dwdate","d_year",0);
+ C_32:bat[:oid] := sql.tid(X_5,"sys","dwdate");
+ C_85 := algebra.subselect(X_34,C_32,1993,1993,true,false,false);
+ (C_36,r1_47) := sql.bind(X_5,"sys","dwdate","d_year",2);
+ C_86 := algebra.subselect(r1_47,nil:bat[:oid],1993,1993,true,false,false);
+ X_38:bat[:int] := sql.bind(X_5,"sys","dwdate","d_year",1);
+ C_87 := algebra.subselect(X_38,C_32,1993,1993,true,false,false);
+ C_39 := sql.subdelta(C_85,C_32,C_36,C_86,C_87);
+ (X_40,r1_55) := algebra.subjoin(X_31,C_39,nil:BAT,nil:BAT,false,nil:lng);
+ X_44:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_extendedprice",0);
+ (C_46,r1_62) := sql.bind(X_5,"sys","lineorder","lo_extendedprice",2);
+ X_48:bat[:int] := sql.bind(X_5,"sys","lineorder","lo_extendedprice",1);
+ X_49 := sql.projectdelta(C_24,X_44,C_46,r1_62,X_48);
+ X_50 := algebra.projection(X_40,X_49);
+ X_51 := batcalc.lng(X_50);
+ X_52 := sql.projectdelta(C_24,X_16,C_18,r1_22,X_20);
+ X_53 := algebra.projection(X_40,X_52);
+ X_54:bat[:lng] := batcalc.*(X_51,X_53);
+ X_55:hge := aggr.sum(X_54);
+ sql.resultSet("sys.L1","revenue","hugeint",128,0,7,X_55);
end user.s4_1;
#inline actions= 0 time=9 usec
#candidates actions= 1 time=71 usec
diff --git a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
--- a/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
+++ b/sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
@@ -38,28 +38,47 @@ Ready.
% clob # type
% 277 # length
function user.s4_1():void;
- X_49:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_yearmonthnum = 199401\n and lo_discount
between 4 and 6\n and lo_quantity between 26 and 35;","sequential_pipe",24);
+ X_63:void := querylog.define("explain\nselect
sum(lo_extendedprice*lo_discount) as revenue\n from lineorder, dwdate\n where
lo_orderdate = d_datekey\n and d_yearmonthnum = 199401\n and lo_discount
between 4 and 6\n and lo_quantity between 26 and 35;","sequential_pipe",43);
X_6 := sql.mvc();
X_10:bat[:int] := sql.bind(X_6,"sys","lineorder","lo_quantity",0);
- X_15:bat[:int] := sql.bind(X_6,"sys","lineorder","lo_discount",0);
+ X_18:bat[:int] := sql.bind(X_6,"sys","lineorder","lo_discount",0);
C_7:bat[:oid] := sql.tid(X_6,"sys","lineorder");
- C_17 := algebra.subselect(X_15,C_7,4,6,true,true,false);
- C_20 := algebra.subselect(X_10,C_17,26,35,true,true,false);
- X_21:bat[:oid] :=
sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",0);
- (X_23,r1_38) :=
sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",2);
- X_25:bat[:oid] :=
sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",1);
- X_26 := sql.projectdelta(C_20,X_21,X_23,r1_38,X_25);
- X_29:bat[:int] := sql.bind(X_6,"sys","dwdate","d_yearmonthnum",0);
- C_27:bat[:oid] := sql.tid(X_6,"sys","dwdate");
- C_31 := algebra.subselect(X_29,C_27,199401,199401,true,false,false);
- (X_32,r1_56) := algebra.subjoin(X_26,C_31,nil:BAT,nil:BAT,false,nil:lng);
- X_36:bat[:int] := sql.bind(X_6,"sys","lineorder","lo_extendedprice",0);
- X_38:bat[:int] := algebra.projectionpath(X_32,C_20,X_36);
- X_39 := batcalc.lng(X_38);
- X_40:bat[:int] := algebra.projectionpath(X_32,C_20,X_15);
- X_41:bat[:lng] := batcalc.*(X_39,X_40);
- X_42:hge := aggr.sum(X_41);
- sql.resultSet("sys.L1","revenue","hugeint",128,0,7,X_42);
+ C_79 := algebra.subselect(X_18,C_7,4,6,true,true,false);
+ (C_20,r1_24) := sql.bind(X_6,"sys","lineorder","lo_discount",2);
+ C_80 := algebra.subselect(r1_24,nil:bat[:oid],4,6,true,true,false);
+ X_22:bat[:int] := sql.bind(X_6,"sys","lineorder","lo_discount",1);
+ C_82 := algebra.subselect(X_22,C_7,4,6,true,true,false);
+ C_23 := sql.subdelta(C_79,C_7,C_20,C_80,C_82);
+ C_83 := algebra.subselect(X_10,C_23,26,35,true,true,false);
+ (C_13,r1_13) := sql.bind(X_6,"sys","lineorder","lo_quantity",2);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
