Changeset: f268af6c920f for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f268af6c920f
Modified Files:
sql/backends/monet5/rel_bin.c
sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
sql/test/remote/Tests/partition_elim.stable.out
Branch: default
Log Message:
approved output
diffs (truncated from 784 to 300 lines):
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -1893,8 +1893,10 @@ rel2bin_semijoin(backend *be, sql_rel *r
break;
s = exp_bin(be, en->data, left, right, NULL, NULL,
NULL, NULL);
- if (!s)
+ if (!s) {
+ assert(0);
return NULL;
+ }
if (join_idx != sql->opt_stats[0])
idx = 1;
/* stop on first non equality join */
diff --git a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
--- a/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
+++ b/sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
@@ -75,7 +75,7 @@ project (
| | | select (
| | | | group by (
| | | | | join (
-| | | | | | table(sys.bidder) [ bidder.id NOT NULL HASHCOL as b2a.id,
bidder.open_auction_id NOT NULL as b2a.open_auction_id, bidder.%TID% NOT NULL
as L33.%TID%, bidder.%bidder_id_pkey NOT NULL HASHIDX as L34.%bidder_id_pkey ]
COUNT ,
+| | | | | | table(sys.bidder) [ bidder.id NOT NULL HASHCOL as b2a.id,
bidder.open_auction_id NOT NULL as b2a.open_auction_id ] COUNT ,
| | | | | | project (
| | | | | | | crossproduct (
| | | | | | | | project (
@@ -90,24 +90,24 @@ project (
| | | | | | | | | | | | | | | | | table(sys.open_auctions) [ open_auctions.id
NOT NULL HASHCOL as o.id, open_auctions.open_auction_id NOT NULL as
o.open_auction_id ] COUNT ,
| | | | | | | | | | | | | | | | | table(sys.bidder) [ bidder.id NOT NULL
HASHCOL as b.id, bidder.open_auction_id NOT NULL as b.open_auction_id,
bidder.date NOT NULL as b.date, bidder.time NOT NULL as b.time,
bidder.personref NOT NULL as b.personref, bidder.increase NOT NULL as
b.increase ] COUNT
| | | | | | | | | | | | | | | | ) [ o.open_auction_id NOT NULL =
b.open_auction_id NOT NULL ]
-| | | | | | | | | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id
NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL,
b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, sys.identity(o.id
NOT NULL) HASHCOL as L57.L57 ],
+| | | | | | | | | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id
NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL,
b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, sys.identity(o.id
NOT NULL) HASHCOL as L53.L53 ],
| | | | | | | | | | | | | | | table(sys.bidder) [ bidder.id NOT NULL HASHCOL
as b3.id, bidder.increase NOT NULL as b3.increase ] COUNT
| | | | | | | | | | | | | | ) [ ]
-| | | | | | | | | | | | | ) [ L57.L57 HASHCOL , o.id NOT NULL HASHCOL ,
o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL,
b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL,
b3.id NOT NULL HASHCOL , b3.increase NOT NULL, sys.identity(o.id NOT NULL)
HASHCOL as L43.L43 ],
+| | | | | | | | | | | | | ) [ L53.L53 HASHCOL , o.id NOT NULL HASHCOL ,
o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL,
b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL,
b3.id NOT NULL HASHCOL , b3.increase NOT NULL, sys.identity(o.id NOT NULL)
HASHCOL as L37.L37 ],
| | | | | | | | | | | | | table(sys.bidder) [ bidder.id NOT NULL HASHCOL as
b3a.id, bidder.open_auction_id NOT NULL as b3a.open_auction_id ] COUNT
| | | | | | | | | | | | ) [ b3a.open_auction_id NOT NULL = o.open_auction_id
NOT NULL ]
-| | | | | | | | | | | ) [ L43.L43, L57.L57 ] [ L57.L57 HASHCOL , o.id NOT NULL
HASHCOL , o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id
NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase
NOT NULL, b3.id NOT NULL HASHCOL , b3.increase NOT NULL, L43.L43 HASHCOL ,
sys.min no nil (b3a.id NOT NULL HASHCOL ) NOT NULL as L10.L10 ]
+| | | | | | | | | | | ) [ L37.L37, L53.L53 ] [ L53.L53 HASHCOL , o.id NOT NULL
HASHCOL , o.open_auction_id NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id
NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase
NOT NULL, b3.id NOT NULL HASHCOL , b3.increase NOT NULL, L37.L37 HASHCOL ,
sys.min no nil (b3a.id NOT NULL HASHCOL ) NOT NULL as L10.L10 ]
| | | | | | | | | | ) [ b3.id NOT NULL HASHCOL = L10 NOT NULL ]
| | | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id
NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT
NULL, b.personref NOT NULL, b.increase NOT NULL, b3.increase NOT NULL as
L13.L13 ]
-| | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id
NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT
NULL, b.personref NOT NULL, b.increase NOT NULL, L13.L13 NOT NULL,
sys.identity(o.id NOT NULL) HASHCOL as L102.L102 ],
-| | | | | | | | table(sys.bidder) [ bidder.id NOT NULL HASHCOL as b2.id,
bidder.increase NOT NULL as b2.increase, bidder.%TID% NOT NULL as L33.%TID%,
bidder.%bidder_id_pkey NOT NULL HASHIDX as L34.%bidder_id_pkey ] COUNT
+| | | | | | | | ) [ o.id NOT NULL HASHCOL , o.open_auction_id NOT NULL, b.id
NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT
NULL, b.personref NOT NULL, b.increase NOT NULL, L13.L13 NOT NULL,
sys.identity(o.id NOT NULL) HASHCOL as L76.L76 ],
+| | | | | | | | table(sys.bidder) [ bidder.id NOT NULL HASHCOL as b2.id,
bidder.increase NOT NULL as b2.increase ] COUNT
| | | | | | | ) [ ]
-| | | | | | ) [ L102.L102 HASHCOL , o.id NOT NULL HASHCOL , o.open_auction_id
NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL,
b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, L13.L13 NOT NULL,
b2.id NOT NULL HASHCOL , b2.increase NOT NULL, sys.identity(o.id NOT NULL)
HASHCOL as L72.L72 ]
+| | | | | | ) [ L76.L76 HASHCOL , o.id NOT NULL HASHCOL , o.open_auction_id
NOT NULL, b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL,
b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL, L13.L13 NOT NULL,
b2.id NOT NULL HASHCOL , b2.increase NOT NULL, sys.identity(o.id NOT NULL)
HASHCOL as L66.L66 ]
| | | | | ) [ b2a.open_auction_id NOT NULL = o.open_auction_id NOT NULL ]
-| | | | ) [ L72.L72, L102.L102 ] [ L102.L102 HASHCOL , b.id NOT NULL HASHCOL ,
b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT
NULL, b.increase NOT NULL, L13.L13 NOT NULL, b2.id NOT NULL HASHCOL ,
b2.increase NOT NULL, L72.L72 HASHCOL , sys.max no nil (b2a.id NOT NULL HASHCOL
) NOT NULL as L24.L24 ]
+| | | | ) [ L66.L66, L76.L76 ] [ L76.L76 HASHCOL , b.id NOT NULL HASHCOL ,
b.open_auction_id NOT NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT
NULL, b.increase NOT NULL, L13.L13 NOT NULL, b2.id NOT NULL HASHCOL ,
b2.increase NOT NULL, L66.L66 HASHCOL , sys.max no nil (b2a.id NOT NULL HASHCOL
) NOT NULL as L24.L24 ]
| | | ) [ b2.id NOT NULL HASHCOL = L24.L24 NOT NULL ]
-| | ) [ L102.L102 HASHCOL , b.id NOT NULL HASHCOL , b.open_auction_id NOT
NULL, b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT
NULL, L13.L13 NOT NULL, b2.id NOT NULL HASHCOL , b2.increase NOT NULL, L72.L72
HASHCOL , L24.L24 NOT NULL, sys.sql_mul(L13.L13 NOT NULL, double "2.000000") as
L111.L111, b2.increase NOT NULL as L112.L112 ]
-| ) [ L111.L111 <= L112.L112 NOT NULL ]
+| | ) [ L76.L76 HASHCOL , b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL,
b.date NOT NULL, b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL,
L13.L13 NOT NULL, b2.id NOT NULL HASHCOL , b2.increase NOT NULL, L66.L66
HASHCOL , L24.L24 NOT NULL, sys.sql_mul(L13.L13 NOT NULL, double "2.000000") as
L105.L105, b2.increase NOT NULL as L106.L106 ]
+| ) [ L105.L105 <= L106.L106 NOT NULL ]
) [ b.id NOT NULL HASHCOL , b.open_auction_id NOT NULL, b.date NOT NULL,
b.time NOT NULL, b.personref NOT NULL, b.increase NOT NULL ]
#Select b.* FROM open_auctions o, bidder b WHERE (select b3.INCREASE from
bidder b3 where b3.id = (select min (b3a.id) from bidder b3a where
b3a.open_auction_id = o.open_auction_id)) * 2 <= (Select b2.INCREASE from
bidder b2 where b2.id = (SELECT MAX (b2a.id) from bidder b2a where
b2a.open_auction_id = o.open_auction_id)) AND o.open_auction_id =
b.open_auction_id;
% sys.b, sys.b, sys.b, sys.b, sys.b, sys.b # table_name
diff --git a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
--- a/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
+++ b/sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
@@ -85,11 +85,11 @@ Ready.
# 11:07:50 >
Operation successful
-+----------------------------------------------------------------------------------------------------------+
++---------------------------------------------------------------------------------------------------------+
| mal |
-+==========================================================================================================+
++=========================================================================================================+
| function user.s4_1():void;
|
-| X_56:void := querylog.define("explain select \"name\" from
\"tables\"\n;","sequential_pipe",34:int); |
+| X_0:void := querylog.define("explain select \"name\" from
\"tables\"\n;","sequential_pipe",36:int); |
| X_40 := bat.new(nil:str);
|
| X_46 := bat.append(X_40,".tables");
|
| X_41 := bat.new(nil:str);
|
@@ -104,12 +104,12 @@ Operation successful
| X_3 := sql.mvc();
|
| X_17:bat[:sht] := sql.bind(X_3,"sys","_tables","type",0:int);
|
| C_4:bat[:oid] := sql.tid(X_3,"sys","_tables");
|
-| C_67 := algebra.subselect(X_17,C_4,2:sht,2:sht,true,true,true);
|
+| C_65 := algebra.subselect(X_17,C_4,2:sht,2:sht,true,true,true);
|
| (C_20:bat[:oid],X_21:bat[:sht]) :=
sql.bind(X_3,"sys","_tables","type",2:int); |
-| C_68 :=
algebra.subselect(X_21,nil:bat[:oid],2:sht,2:sht,true,true,true);
|
+| C_66 :=
algebra.subselect(X_21,nil:bat[:oid],2:sht,2:sht,true,true,true);
|
| X_19:bat[:sht] := sql.bind(X_3,"sys","_tables","type",1:int);
|
-| C_70 := algebra.subselect(X_19,C_4,2:sht,2:sht,true,true,true);
|
-| C_26 := sql.subdelta(C_67,C_4,C_20,C_68,C_70);
|
+| C_68 := algebra.subselect(X_19,C_4,2:sht,2:sht,true,true,true);
|
+| C_26 := sql.subdelta(C_65,C_4,C_20,C_66,C_68);
|
| X_7:bat[:str] := sql.bind(X_3,"sys","_tables","name",0:int);
|
| (C_12:bat[:oid],X_13:bat[:str]) :=
sql.bind(X_3,"sys","_tables","name",2:int); |
| X_10:bat[:str] := sql.bind(X_3,"sys","_tables","name",1:int);
|
@@ -119,35 +119,34 @@ Operation successful
| X_33:bat[:str] := sql.bind(X_3,"tmp","_tables","name",0:int);
|
| X_34 := algebra.projection(C_31,X_33);
|
| X_38 := bat.append(X_37,X_34,true);
|
-| # querylog.define("explain select \"name\" from
\"tables\"\n;","sequential_pipe") |
| sql.resultSet(X_46,X_48,X_50,X_52,X_54,X_38);
|
| end user.s4_1;
|
| #inline actions= 0 time=1 usec
|
-| #remap actions= 0 time=3 usec
|
-| #costmodel actions= 1 time=2 usec
|
-| #coercion actions= 1 time=6 usec
|
-| #evaluate actions= 0 time=3 usec
|
-| #emptybind actions= 0 time=8 usec
|
-| #pushselect actions= 5 time=29 usec
|
-| #aliases actions= 2 time=8 usec
|
-| #mergetable actions= 0 time=32 usec
|
-| #deadcode actions= 3 time=7 usec
|
-| #aliases actions= 0 time=5 usec
|
-| #constants actions= 5 time=7 usec
|
-| #commonTerms actions= 0 time=6 usec
|
-| #projectionpath actions= 0 time=3 usec
|
-| #reorder actions= 1 time=25 usec
|
-| #deadcode actions= 0 time=6 usec
|
-| #reduce actions=30 time=10 usec
|
-| #matpack actions= 0 time=2 usec
|
+| #remap actions= 0 time=4 usec
|
+| #costmodel actions= 1 time=3 usec
|
+| #coercion actions= 1 time=11 usec
|
+| #evaluate actions= 0 time=5 usec
|
+| #emptybind actions= 0 time=1 usec
|
+| #pushselect actions= 5 time=47 usec
|
+| #aliases actions= 2 time=14 usec
|
+| #mergetable actions= 0 time=54 usec
|
+| #deadcode actions= 3 time=13 usec
|
+| #aliases actions= 0 time=1 usec
|
+| #constants actions= 3 time=12 usec
|
+| #commonTerms actions= 0 time=10 usec
|
+| #projectionpath actions= 0 time=6 usec
|
+| #reorder actions= 1 time=43 usec
|
+| #deadcode actions= 0 time=9 usec
|
+| #matpack actions= 0 time=1 usec
|
| #multiplex actions= 0 time=3 usec
|
-| #profiler actions= 1 time=3 usec
|
+| #profiler actions= 1 time=6 usec
|
| #candidates actions= 1 time=2 usec
|
-| #garbagecollector actions= 1 time=16 usec
|
-+----------------------------------------------------------------------------------------------------------+
-56 rows
+| #garbagecollector actions= 1 time=26 usec
|
+| #total actions=23 time=423 usec
|
++---------------------------------------------------------------------------------------------------------+
+55 rows
-# 15:15:37 >
-# 15:15:37 > Done.
-# 15:15:37 >
+# 09:07:58 >
+# 09:07:58 > "Done."
+# 09:07:58 >
diff --git a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
--- a/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
+++ b/sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
@@ -43,21 +43,21 @@ Ready.
+--------------------------------------------------------------------+
18 rows
Operation successful
-+------------------------------------------------------------------------------------------------------+
++-----------------------------------------------------------------------------------------------------+
| mal |
-+======================================================================================================+
++=====================================================================================================+
| function user.s4_1():void;
|
-| X_50:void := querylog.define("explain select count(*) from
tables\n;","sequential_pipe",28:int); |
+| X_0:void := querylog.define("explain select count(*) from
tables\n;","sequential_pipe",30:int); |
| X_38:bat[:lng] := bat.new(nil:lng);
|
| X_3 := sql.mvc();
|
| X_17:bat[:sht] := sql.bind(X_3,"sys","_tables","type",0:int);
|
| C_4:bat[:oid] := sql.tid(X_3,"sys","_tables");
|
-| C_61 := algebra.subselect(X_17,C_4,2:sht,2:sht,true,true,true);
|
+| C_59 := algebra.subselect(X_17,C_4,2:sht,2:sht,true,true,true);
|
| (C_20:bat[:oid],X_21:bat[:sht]) :=
sql.bind(X_3,"sys","_tables","type",2:int); |
-| C_62 :=
algebra.subselect(X_21,nil:bat[:oid],2:sht,2:sht,true,true,true);
|
+| C_60 :=
algebra.subselect(X_21,nil:bat[:oid],2:sht,2:sht,true,true,true);
|
| X_19:bat[:sht] := sql.bind(X_3,"sys","_tables","type",1:int);
|
-| C_64 := algebra.subselect(X_19,C_4,2:sht,2:sht,true,true,true);
|
-| C_26 := sql.subdelta(C_61,C_4,C_20,C_62,C_64);
|
+| C_62 := algebra.subselect(X_19,C_4,2:sht,2:sht,true,true,true);
|
+| C_26 := sql.subdelta(C_59,C_4,C_20,C_60,C_62);
|
| X_7:bat[:int] := sql.bind(X_3,"sys","_tables","id",0:int);
|
| (C_12:bat[:oid],X_13:bat[:int]) :=
sql.bind(X_3,"sys","_tables","id",2:int); |
| X_10:bat[:int] := sql.bind(X_3,"sys","_tables","id",1:int);
|
@@ -71,35 +71,34 @@ Operation successful
| X_36 := aggr.count(X_35);
|
| X_41 := bat.append(X_40,X_36,true);
|
| X_42:lng := aggr.sum(X_41);
|
-| # querylog.define("explain select count(*) from
tables\n;","sequential_pipe") |
| sql.resultSet(".L41","L40","bigint",64:int,0:int,7:int,X_42);
|
| end user.s4_1;
|
-| #inline actions= 0 time=1 usec
|
-| #remap actions= 0 time=2 usec
|
-| #costmodel actions= 1 time=1 usec
|
-| #coercion actions= 1 time=7 usec
|
-| #evaluate actions= 0 time=3 usec
|
-| #emptybind actions= 0 time=15 usec
|
-| #pushselect actions= 5 time=37 usec
|
-| #aliases actions= 2 time=8 usec
|
-| #mergetable actions= 0 time=36 usec
|
-| #deadcode actions= 3 time=7 usec
|
-| #aliases actions= 0 time=5 usec
|
-| #constants actions= 4 time=7 usec
|
-| #commonTerms actions= 0 time=6 usec
|
-| #projectionpath actions= 0 time=3 usec
|
-| #reorder actions= 1 time=22 usec
|
-| #deadcode actions= 0 time=4 usec
|
-| #reduce actions=29 time=9 usec
|
-| #matpack actions= 0 time=2 usec
|
-| #multiplex actions= 0 time=2 usec
|
-| #profiler actions= 1 time=3 usec
|
-| #candidates actions= 1 time=1 usec
|
-| #garbagecollector actions= 1 time=15 usec
|
-+------------------------------------------------------------------------------------------------------+
-50 rows
+| #inline actions= 0 time=2 usec
|
+| #remap actions= 0 time=4 usec
|
+| #costmodel actions= 1 time=3 usec
|
+| #coercion actions= 1 time=10 usec
|
+| #evaluate actions= 0 time=5 usec
|
+| #emptybind actions= 0 time=1 usec
|
+| #pushselect actions= 5 time=46 usec
|
+| #aliases actions= 2 time=14 usec
|
+| #mergetable actions= 0 time=52 usec
|
+| #deadcode actions= 3 time=12 usec
|
+| #aliases actions= 0 time=0 usec
|
+| #constants actions= 2 time=11 usec
|
+| #commonTerms actions= 0 time=9 usec
|
+| #projectionpath actions= 0 time=6 usec
|
+| #reorder actions= 1 time=39 usec
|
+| #deadcode actions= 0 time=9 usec
|
+| #matpack actions= 0 time=0 usec
|
+| #multiplex actions= 0 time=3 usec
|
+| #profiler actions= 1 time=6 usec
|
+| #candidates actions= 1 time=2 usec
|
+| #garbagecollector actions= 1 time=25 usec
|
+| #total actions=23 time=405 usec
|
++-----------------------------------------------------------------------------------------------------+
+49 rows
-# 19:39:11 >
-# 19:39:11 > "Done."
-# 19:39:11 >
+# 09:08:01 >
+# 09:08:01 > "Done."
+# 09:08:01 >
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
@@ -134,62 +134,62 @@ Ready.
% .explain # table_name
% mal # name
% clob # type
-% 115 # length
+% 118 # length
function user.main():void;
- X_2:void := querylog.define("explain select x,y from test where x between
4.0 and 6.0;","default_pipe",49:int);
-barrier X_85 := language.dataflow();
- X_28 := bat.new(nil:str);
- X_35 := bat.append(X_28,".test");
- X_43 := bat.append(X_35,".test");
- X_30 := bat.new(nil:str);
- X_37 := bat.append(X_30,"x");
- X_44 := bat.append(X_37,"y");
- X_31 := bat.new(nil:str);
- X_38 := bat.append(X_31,"double");
- X_45 := bat.append(X_38,"double");
- X_32 := bat.new(nil:int);
- X_40 := bat.append(X_32,53:int);
- X_46 := bat.append(X_40,53:int);
- X_34 := bat.new(nil:int);
- X_42 := bat.append(X_34,0:int);
- X_47 := bat.append(X_42,0:int);
- X_20:bat[:dbl] := bat.new(nil:dbl);
- X_5 := sql.mvc();
- X_58:bat[:dbl] := sql.bind(X_5,"sys","test2","x",0:int,0:int,2:int);
- C_68:bat[:oid] := sql.tid(X_5,"sys","test2",0:int,2:int);
- C_76 := algebra.subselect(X_58,C_68,4:dbl,6:dbl,true,true,false);
- X_63 := algebra.projection(C_76,X_58);
- X_59:bat[:dbl] := sql.bind(X_5,"sys","test2","x",0:int,1:int,2:int);
- C_70:bat[:oid] := sql.tid(X_5,"sys","test2",1:int,2:int);
- C_77 := algebra.subselect(X_59,C_70,4:dbl,6:dbl,true,true,false);
- X_64 := algebra.projection(C_77,X_59);
- X_76 := mat.packIncrement(X_63,2:int);
- X_13 := mat.packIncrement(X_76,X_64);
- X_22 := bat.append(X_20,X_13,true);
- X_16:bat[:dbl] := sql.bind(X_5,"sys","test3","x",0:int);
- C_15:bat[:oid] := sql.tid(X_5,"sys","test3");
- C_19 := algebra.subselect(X_16,C_15,4:dbl,6:dbl,true,true,false);
- X_18 := algebra.projection(C_19,X_16);
- X_23 := bat.append(X_22,X_18,true);
- X_24:bat[:dbl] := bat.new(nil:dbl);
- X_60:bat[:dbl] := sql.bind(X_5,"sys","test2","y",0:int,0:int,2:int);
- X_65 := algebra.projection(C_76,X_60);
- X_61:bat[:dbl] := sql.bind(X_5,"sys","test2","y",0:int,1:int,2:int);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
