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 checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list