Changeset: f3830974911f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f3830974911f
Added Files:
        sql/test/miscellaneous/Tests/simple_plans.stable.out.single
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
        monetdb5/modules/kernel/aggr.c
        monetdb5/modules/kernel/alarm.c
        monetdb5/modules/kernel/algebra.c
        monetdb5/modules/kernel/algebra.h
        monetdb5/modules/kernel/group.c
        monetdb5/modules/mal/batExtensions.h
        monetdb5/modules/mal/tablet.c
        sql/backends/monet5/generator/generator.c
        sql/backends/monet5/sql.c
        sql/backends/monet5/sql_subquery.c
        sql/backends/monet5/sql_subquery.h
        sql/backends/monet5/sql_subquery.mal
        sql/backends/monet5/sql_upgrades.c
        sql/server/rel_exp.c
        sql/server/rel_optimizer.c
        sql/server/rel_unnest.c
        sql/storage/bat/bat_storage.c
        sql/storage/store.c
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-cast-null-add.Bug-6630.stable.out
        
sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-having-in.Bug-6560.stable.out
        sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out
        sql/test/SQLancer/Tests/sqlancer01.sql
        sql/test/SQLancer/Tests/sqlancer01.stable.out
        sql/test/mergetables/Tests/mergeinit.stable.err
Branch: default
Log Message:

merged


diffs (truncated from 3351 to 300 lines):

diff --git a/clients/Tests/MAL-signatures.stable.out 
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -126,8 +126,7 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "covariancep",  "command aggr.covariancep(X_1:bat[:sht], 
X_2:bat[:sht], X_3:bat[:oid], X_4:bat[:any_1]):bat[:dbl] ",    
"AGGRcovariancep;",     ""      ]
 [ "aggr",      "covariancep",  "command aggr.covariancep(X_1:bat[:any_2], 
X_2:bat[:any_2]):dbl ",      "ALGcovariancep;",      ""      ]
 [ "aggr",      "exist",        "command aggr.exist(X_1:bat[:any_2], 
X_2:any_1):bit ",  "ALGexist;",    ""      ]
-[ "aggr",      "exist",        "command aggr.exist(X_1:bat[:any]):bit ",       
"SQLexist;",    ""      ]
-[ "aggr",      "exist",        "pattern aggr.exist(X_1:any):bit ",     
"SQLexist_val;",        ""      ]
+[ "aggr",      "exist",        "pattern aggr.exist(X_1:any_1):bit ",   
"SQLexist;",    ""      ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(X_1:bat[:dbl]):str ",    
"JSONgroupStr;",        ""      ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(X_1:bat[:str]):str ",    
"JSONgroupStr;",        ""      ]
 [ "aggr",      "max",  "command aggr.max(X_1:bat[:any_1], X_2:bat[:oid], 
X_3:bat[:any_2]):bat[:any_1] ",       "AGGRmax3;",    ""      ]
@@ -139,8 +138,7 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "min",  "command aggr.min(X_1:bat[:any_2]):any_2 ",     
"ALGminany;",   ""      ]
 [ "aggr",      "min",  "command aggr.min(X_1:bat[:any_2], X_2:bit):any_2 ",    
"ALGminany_skipnil;",   ""      ]
 [ "aggr",      "not_anyequal", "pattern aggr.not_anyequal(X_1:any_1, 
X_2:any_1):bit ", "CMDvarNE;",    ""      ]
-[ "aggr",      "not_exist",    "command aggr.not_exist(X_1:bat[:any]):bit ",   
"SQLnot_exist;",        ""      ]
-[ "aggr",      "not_exist",    "pattern aggr.not_exist(X_1:any):bit ", 
"SQLnot_exist_val;",    ""      ]
+[ "aggr",      "not_exist",    "pattern aggr.not_exist(X_1:any_1):bit ",       
"SQLnot_exist;",        ""      ]
 [ "aggr",      "prod", "command aggr.prod(X_1:bat[:bte], X_2:bat[:oid], 
X_3:bat[:any_1]):bat[:bte] ",  "AGGRprod3_bte;",       ""      ]
 [ "aggr",      "prod", "command aggr.prod(X_1:bat[:dbl], X_2:bat[:oid], 
X_3:bat[:any_1]):bat[:dbl] ",  "AGGRprod3_dbl;",       ""      ]
 [ "aggr",      "prod", "command aggr.prod(X_1:bat[:flt], X_2:bat[:oid], 
X_3:bat[:any_1]):bat[:dbl] ",  "AGGRprod3_dbl;",       ""      ]
@@ -718,6 +716,12 @@ stdout of test 'MAL-signatures` in direc
 [ "bat",       "setPersistent",        "command 
bat.setPersistent(X_1:bat[:any_1]):void ",     "BKCsetPersistent;",    ""      ]
 [ "bat",       "setTransient", "command bat.setTransient(X_1:bat[:any_1]):void 
",      "BKCsetTransient;",     ""      ]
 [ "bat",       "single",       "pattern bat.single(X_1:any_1):bat[:any_1] ",   
"CMDBATsingle;",        ""      ]
+[ "bataggr",   "exist",        "pattern bataggr.exist(X_1:any_1):bat[:bit] ",  
"SQLexist;",    ""      ]
+[ "bataggr",   "exist",        "pattern 
bataggr.exist(X_1:bat[:any_1]):bat[:bit] ",    "SQLexist;",    ""      ]
+[ "bataggr",   "exist",        "pattern bataggr.exist(X_1:bat[:any_1]):bit ",  
"SQLexist;",    ""      ]
+[ "bataggr",   "not_exist",    "pattern bataggr.not_exist(X_1:any_1):bat[:bit] 
",      "SQLnot_exist;",        ""      ]
+[ "bataggr",   "not_exist",    "pattern 
bataggr.not_exist(X_1:bat[:any_1]):bat[:bit] ",        "SQLnot_exist;",        
""      ]
+[ "bataggr",   "not_exist",    "pattern bataggr.not_exist(X_1:bat[:any_1]):bit 
",      "SQLnot_exist;",        ""      ]
 [ "batalgebra",        "ilike",        "command 
batalgebra.ilike(X_1:bat[:str], X_2:str):bat[:bit] ",  "BATPCREilike2;",       
""      ]
 [ "batalgebra",        "ilike",        "command 
batalgebra.ilike(X_1:bat[:str], X_2:str, X_3:str):bat[:bit] ", "BATPCREilike;", 
       ""      ]
 [ "batalgebra",        "like", "command batalgebra.like(X_1:bat[:str], 
X_2:str):bat[:bit] ",   "BATPCRElike2;",        ""      ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128 
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -135,8 +135,7 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "covariancep",  "command aggr.covariancep(X_1:bat[:sht], 
X_2:bat[:sht], X_3:bat[:oid], X_4:bat[:any_1]):bat[:dbl] ",    
"AGGRcovariancep;",     ""      ]
 [ "aggr",      "covariancep",  "command aggr.covariancep(X_1:bat[:any_2], 
X_2:bat[:any_2]):dbl ",      "ALGcovariancep;",      ""      ]
 [ "aggr",      "exist",        "command aggr.exist(X_1:bat[:any_2], 
X_2:any_1):bit ",  "ALGexist;",    ""      ]
-[ "aggr",      "exist",        "command aggr.exist(X_1:bat[:any]):bit ",       
"SQLexist;",    ""      ]
-[ "aggr",      "exist",        "pattern aggr.exist(X_1:any):bit ",     
"SQLexist_val;",        ""      ]
+[ "aggr",      "exist",        "pattern aggr.exist(X_1:any_1):bit ",   
"SQLexist;",    ""      ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(X_1:bat[:dbl]):str ",    
"JSONgroupStr;",        ""      ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(X_1:bat[:str]):str ",    
"JSONgroupStr;",        ""      ]
 [ "aggr",      "max",  "command aggr.max(X_1:bat[:any_1], X_2:bat[:oid], 
X_3:bat[:any_2]):bat[:any_1] ",       "AGGRmax3;",    ""      ]
@@ -148,8 +147,7 @@ stdout of test 'MAL-signatures` in direc
 [ "aggr",      "min",  "command aggr.min(X_1:bat[:any_2]):any_2 ",     
"ALGminany;",   ""      ]
 [ "aggr",      "min",  "command aggr.min(X_1:bat[:any_2], X_2:bit):any_2 ",    
"ALGminany_skipnil;",   ""      ]
 [ "aggr",      "not_anyequal", "pattern aggr.not_anyequal(X_1:any_1, 
X_2:any_1):bit ", "CMDvarNE;",    ""      ]
-[ "aggr",      "not_exist",    "command aggr.not_exist(X_1:bat[:any]):bit ",   
"SQLnot_exist;",        ""      ]
-[ "aggr",      "not_exist",    "pattern aggr.not_exist(X_1:any):bit ", 
"SQLnot_exist_val;",    ""      ]
+[ "aggr",      "not_exist",    "pattern aggr.not_exist(X_1:any_1):bit ",       
"SQLnot_exist;",        ""      ]
 [ "aggr",      "prod", "command aggr.prod(X_1:bat[:bte], X_2:bat[:oid], 
X_3:bat[:any_1]):bat[:bte] ",  "AGGRprod3_bte;",       ""      ]
 [ "aggr",      "prod", "command aggr.prod(X_1:bat[:dbl], X_2:bat[:oid], 
X_3:bat[:any_1]):bat[:dbl] ",  "AGGRprod3_dbl;",       ""      ]
 [ "aggr",      "prod", "command aggr.prod(X_1:bat[:flt], X_2:bat[:oid], 
X_3:bat[:any_1]):bat[:dbl] ",  "AGGRprod3_dbl;",       ""      ]
@@ -829,6 +827,12 @@ stdout of test 'MAL-signatures` in direc
 [ "bat",       "setPersistent",        "command 
bat.setPersistent(X_1:bat[:any_1]):void ",     "BKCsetPersistent;",    ""      ]
 [ "bat",       "setTransient", "command bat.setTransient(X_1:bat[:any_1]):void 
",      "BKCsetTransient;",     ""      ]
 [ "bat",       "single",       "pattern bat.single(X_1:any_1):bat[:any_1] ",   
"CMDBATsingle;",        ""      ]
+[ "bataggr",   "exist",        "pattern bataggr.exist(X_1:any_1):bat[:bit] ",  
"SQLexist;",    ""      ]
+[ "bataggr",   "exist",        "pattern 
bataggr.exist(X_1:bat[:any_1]):bat[:bit] ",    "SQLexist;",    ""      ]
+[ "bataggr",   "exist",        "pattern bataggr.exist(X_1:bat[:any_1]):bit ",  
"SQLexist;",    ""      ]
+[ "bataggr",   "not_exist",    "pattern bataggr.not_exist(X_1:any_1):bat[:bit] 
",      "SQLnot_exist;",        ""      ]
+[ "bataggr",   "not_exist",    "pattern 
bataggr.not_exist(X_1:bat[:any_1]):bat[:bit] ",        "SQLnot_exist;",        
""      ]
+[ "bataggr",   "not_exist",    "pattern bataggr.not_exist(X_1:bat[:any_1]):bit 
",      "SQLnot_exist;",        ""      ]
 [ "batalgebra",        "ilike",        "command 
batalgebra.ilike(X_1:bat[:str], X_2:str):bat[:bit] ",  "BATPCREilike2;",       
""      ]
 [ "batalgebra",        "ilike",        "command 
batalgebra.ilike(X_1:bat[:str], X_2:str, X_3:str):bat[:bit] ", "BATPCREilike;", 
       ""      ]
 [ "batalgebra",        "like", "command batalgebra.like(X_1:bat[:str], 
X_2:str):bat[:bit] ",   "BATPCRElike2;",        ""      ]
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -674,188 +674,7 @@ int mo_system_config(opt **Set, int setl
 const char *wsaerror(int);
 
 # monetdb5
-str AGGRavg13_dbl(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRavg14_dbl(bat *retval, const bat *bid, const bat *gid, const bat *eid, 
int *scale);
-str AGGRavg23_dbl(bat *retval1, bat *retval2, const bat *bid, const bat *gid, 
const bat *eid);
-str AGGRavg24_dbl(bat *retval1, bat *retval2, const bat *bid, const bat *gid, 
const bat *eid, int *scale);
-str AGGRcorr(bat *retval, const bat *b1, const bat *b2, const bat *gid, const 
bat *eid);
-str AGGRcount3(bat *retval, const bat *bid, const bat *gid, const bat *eid, 
const bit *ignorenils);
-str AGGRcount3nils(bat *retval, const bat *bid, const bat *gid, const bat 
*eid);
-str AGGRcount3nonils(bat *retval, const bat *bid, const bat *gid, const bat 
*eid);
-str AGGRcovariance(bat *retval, const bat *b1, const bat *b2, const bat *gid, 
const bat *eid);
-str AGGRcovariancep(bat *retval, const bat *b1, const bat *b2, const bat *gid, 
const bat *eid);
-str AGGRmax3(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRmedian(void *retval, const bat *bid);
-str AGGRmedian_avg(dbl *retval, const bat *bid);
-str AGGRmin3(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_bte(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_dbl(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_flt(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_hge(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_int(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_lng(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRprod3_sht(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRquantile(void *retval, const bat *bid, const bat *qid);
-str AGGRquantile_avg(dbl *retval, const bat *bid, const bat *qid);
-str AGGRstdev3_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid);
-str AGGRstdevp3_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid);
-str AGGRstr_group_concat(bat *retval, const bat *bid, const bat *gid, const 
bat *eid);
-str AGGRstr_group_concat_sep(bat *retval, const bat *bid, const bat *sep, 
const bat *gid, const bat *eid);
-str AGGRsubavg1_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubavg1cand_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubavg1s_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error, int *scale);
-str AGGRsubavg1scand_dbl(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error, int 
*scale);
-str AGGRsubavg2_dbl(bat *retval1, bat *retval2, const bat *bid, const bat 
*gid, const bat *eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubavg2cand_dbl(bat *retval1, bat *retval2, const bat *bid, const bat 
*gid, const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsubavg2s_dbl(bat *retval1, bat *retval2, const bat *bid, const bat 
*gid, const bat *eid, const bit *skip_nils, const bit *abort_on_error, int 
*scale);
-str AGGRsubavg2scand_dbl(bat *retval1, bat *retval2, const bat *bid, const bat 
*gid, const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error, int *scale);
-str AGGRsubcorr(bat *retval, const bat *b1, const bat *b2, const bat *gid, 
const bat *eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubcorrcand(bat *retval, const bat *b1, const bat *b2, const bat *gid, 
const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsubcount(bat *retval, const bat *bid, const bat *gid, const bat *eid, 
const bit *skip_nils);
-str AGGRsubcountcand(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils);
-str AGGRsubcovariance(bat *retval, const bat *b1, const bat *b2, const bat 
*gid, const bat *eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubcovariancecand(bat *retval, const bat *b1, const bat *b2, const bat 
*gid, const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsubcovariancep(bat *retval, const bat *b1, const bat *b2, const bat 
*gid, const bat *eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubcovariancepcand(bat *retval, const bat *b1, const bat *b2, const 
bat *gid, const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsubmax(bat *retval, const bat *bid, const bat *gid, const bat *eid, 
const bit *skip_nils);
-str AGGRsubmax_val(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils);
-str AGGRsubmaxcand(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils);
-str AGGRsubmaxcand_val(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils);
-str AGGRsubmedian(bat *retval, const bat *bid, const bat *gid, const bat *eid, 
const bit *skip_nils);
-str AGGRsubmedian_avg(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils);
-str AGGRsubmediancand(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils);
-str AGGRsubmediancand_avg(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bat *sid, const bit *skip_nils);
-str AGGRsubmin(bat *retval, const bat *bid, const bat *gid, const bat *eid, 
const bit *skip_nils);
-str AGGRsubmin_val(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils);
-str AGGRsubmincand(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils);
-str AGGRsubmincand_val(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils);
-str AGGRsubprod_bte(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprod_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprod_flt(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprod_hge(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprod_int(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprod_lng(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprod_sht(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_bte(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_flt(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_hge(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_int(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_lng(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubprodcand_sht(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubquantile(bat *retval, const bat *bid, const bat *quantile, const 
bat *gid, const bat *eid, const bit *skip_nils);
-str AGGRsubquantile_avg(bat *retval, const bat *bid, const bat *quantile, 
const bat *gid, const bat *eid, const bit *skip_nils);
-str AGGRsubquantilecand(bat *retval, const bat *bid, const bat *quantile, 
const bat *gid, const bat *eid, const bat *sid, const bit *skip_nils);
-str AGGRsubquantilecand_avg(bat *retval, const bat *bid, const bat *quantile, 
const bat *gid, const bat *eid, const bat *sid, const bit *skip_nils);
-str AGGRsubstdev_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubstdevcand_dbl(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubstdevp_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubstdevpcand_dbl(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubstr_group_concat(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubstr_group_concat_sep(bat *retval, const bat *bid, const bat *sep, 
const bat *gid, const bat *eid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsubstr_group_concatcand(bat *retval, const bat *bid, const bat *gid, 
const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsubstr_group_concatcand_sep(bat *retval, const bat *bid, const bat 
*sep, const bat *gid, const bat *eid, const bat *sid, const bit *skip_nils, 
const bit *abort_on_error);
-str AGGRsubsum_bte(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsum_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsum_flt(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsum_hge(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, bit *skip_nils, bit *abort_on_error);
-str AGGRsubsum_int(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsum_lng(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsum_sht(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_bte(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_flt(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_hge(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_int(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_lng(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubsumcand_sht(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubvariance_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubvariancecand_dbl(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bat *sid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubvariancep_dbl(bat *retval, const bat *bid, const bat *gid, const 
bat *eid, const bit *skip_nils, const bit *abort_on_error);
-str AGGRsubvariancepcand_dbl(bat *retval, const bat *bid, const bat *gid, 
const bat *eid, const bat *sid, const bit *skip_nils, const bit 
*abort_on_error);
-str AGGRsum3_bte(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRsum3_dbl(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRsum3_flt(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRsum3_hge(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRsum3_int(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRsum3_lng(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRsum3_sht(bat *retval, const bat *bid, const bat *gid, const bat *eid);
-str AGGRvariance3_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid);
-str AGGRvariancep3_dbl(bat *retval, const bat *bid, const bat *gid, const bat 
*eid);
-str ALARMctime(str *res);
-str ALARMepoch(int *res);
-str ALARMsleep(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
-str ALARMtime(int *res);
-str ALARMusec(lng *ret);
-str ALGbandjoin(bat *r1, bat *r2, const bat *lid, const bat *rid, const bat 
*slid, const bat *srid, const void *low, const void *high, const bit *li, const 
bit *hi, const lng *estimate);
-str ALGbandjoin1(bat *r1, const bat *lid, const bat *rid, const bat *slid, 
const bat *srid, const void *low, const void *high, const bit *li, const bit 
*hi, const lng *estimate);
-str ALGcard(lng *result, const bat *bid);
-str ALGcopy(bat *result, const bat *bid);
-str ALGcorr(dbl *res, const bat *bid1, const bat *bid2);
-str ALGcountCND_bat(lng *result, const bat *bid, const bat *cnd);
-str ALGcountCND_nil(lng *result, const bat *bid, const bat *cnd, const bit 
*ignore_nils);
-str ALGcountCND_no_nil(lng *result, const bat *bid, const bat *cnd);
-str ALGcount_bat(lng *result, const bat *bid);
-str ALGcount_nil(lng *result, const bat *bid, const bit *ignore_nils);
-str ALGcount_no_nil(lng *result, const bat *bid);
-str ALGcovariance(dbl *res, const bat *bid1, const bat *bid2);
-str ALGcovariancep(dbl *res, const bat *bid1, const bat *bid2);
-str ALGcrossproduct1(bat *l, const bat *lid, const bat *rid, const bit 
*max_one);
-str ALGcrossproduct2(bat *l, bat *r, const bat *lid, const bat *rid, const bit 
*max_one);
-str ALGdifference(bat *r1, const bat *lid, const bat *rid, const bat *slid, 
const bat *srid, const bit *nil_matches, const bit *not_in, const lng 
*estimate);
-str ALGexist(bit *ret, const bat *bid, const void *val);
-str ALGfetchoid(ptr ret, const bat *bid, const oid *pos);
-str ALGfind(oid *ret, const bat *bid, ptr val);
-str ALGfirstn(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
-str ALGgroupby(bat *res, const bat *gids, const bat *cnts);
-str ALGintersect(bat *r1, const bat *lid, const bat *rid, const bat *slid, 
const bat *srid, const bit *nil_matches, const bit *max_one, const lng 
*estimate);
-str ALGjoin(bat *r1, bat *r2, const bat *l, const bat *r, const bat *sl, const 
bat *sr, const bit *nil_matches, const lng *estimate);
-str ALGjoin1(bat *r1, const bat *l, const bat *r, const bat *sl, const bat 
*sr, const bit *nil_matches, const lng *estimate);
-str ALGleftjoin(bat *r1, bat *r2, const bat *l, const bat *r, const bat *sl, 
const bat *sr, const bit *nil_matches, const lng *estimate);
-str ALGleftjoin1(bat *r1, const bat *l, const bat *r, const bat *sl, const bat 
*sr, const bit *nil_matches, const lng *estimate);
-str ALGmaxany(ptr result, const bat *bid);
-str ALGmaxany_skipnil(ptr result, const bat *bid, const bit *skipnil);
-str ALGminany(ptr result, const bat *bid);
-str ALGminany_skipnil(ptr result, const bat *bid, const bit *skipnil);
-str ALGouterjoin(bat *r1, bat *r2, const bat *l, const bat *r, const bat *sl, 
const bat *sr, const bit *nil_matches, const lng *estimate);
-str ALGouterjoin1(bat *r1, const bat *l, const bat *r, const bat *sl, const 
bat *sr, const bit *nil_matches, const lng *estimate);
-str ALGprojection(bat *result, const bat *lid, const bat *rid);
-str ALGprojection2(bat *result, const bat *lid, const bat *r1id, const bat 
*r2id);
 str ALGprojectionpath(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
-str ALGprojecttail(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
-str ALGrangejoin(bat *r1, bat *r2, const bat *lid, const bat *rlid, const bat 
*rhid, const bat *slid, const bat *srid, const bit *li, const bit *hi, const 
bit *anti, const bit *symmetric, const lng *estimate);
-str ALGrangejoin1(bat *r1, const bat *lid, const bat *rlid, const bat *rhid, 
const bat *slid, const bat *srid, const bit *li, const bit *hi, const bit 
*anti, const bit *symmetric, const lng *estimate);
-str ALGreuse(bat *ret, const bat *bid);
-str ALGselect1(bat *result, const bat *bid, const void *low, const void *high, 
const bit *li, const bit *hi, const bit *anti);
-str ALGselect1nil(bat *result, const bat *bid, const void *low, const void 
*high, const bit *li, const bit *hi, const bit *anti, const bit *unknown);
-str ALGselect2(bat *result, const bat *bid, const bat *sid, const void *low, 
const void *high, const bit *li, const bit *hi, const bit *anti);
-str ALGselect2nil(bat *result, const bat *bid, const bat *sid, const void 
*low, const void *high, const bit *li, const bit *hi, const bit *anti, const 
bit *unknown);
-str ALGselectNotNil(bat *result, const bat *bid);
-str ALGsemijoin(bat *r1, bat *r2, const bat *l, const bat *r, const bat *sl, 
const bat *sr, const bit *nil_matches, const bit *max_one, const lng *estimate);
-str ALGslice(bat *ret, const bat *bid, const lng *start, const lng *end);
-str ALGslice_int(bat *ret, const bat *bid, const int *start, const int *end);
-str ALGslice_lng(bat *ret, const bat *bid, const lng *start, const lng *end);
-str ALGslice_oid(bat *ret, const bat *bid, const oid *start, const oid *end);
-str ALGsort11(bat *result, const bat *bid, const bit *reverse, const bit 
*nilslast, const bit *stable);
-str ALGsort12(bat *result, bat *norder, const bat *bid, const bit *reverse, 
const bit *nilslast, const bit *stable);
-str ALGsort13(bat *result, bat *norder, bat *ngroup, const bat *bid, const bit 
*reverse, const bit *nilslast, const bit *stable);
-str ALGsort21(bat *result, const bat *bid, const bat *order, const bit 
*reverse, const bit *nilslast, const bit *stable);
-str ALGsort22(bat *result, bat *norder, const bat *bid, const bat *order, 
const bit *reverse, const bit *nilslast, const bit *stable);
-str ALGsort23(bat *result, bat *norder, bat *ngroup, const bat *bid, const bat 
*order, const bit *reverse, const bit *nilslast, const bit *stable);
-str ALGsort31(bat *result, const bat *bid, const bat *order, const bat *group, 
const bit *reverse, const bit *nilslast, const bit *stable);
-str ALGsort32(bat *result, bat *norder, const bat *bid, const bat *order, 
const bat *group, const bit *reverse, const bit *nilslast, const bit *stable);
-str ALGsort33(bat *result, bat *norder, bat *ngroup, const bat *bid, const bat 
*order, const bat *group, const bit *reverse, const bit *nilslast, const bit 
*stable);
-str ALGstdev(dbl *res, const bat *bid);
-str ALGstdevp(dbl *res, const bat *bid);
-str ALGsubslice_lng(bat *ret, const bat *bid, const lng *start, const lng 
*end);
-str ALGthetajoin(bat *r1, bat *r2, const bat *l, const bat *r, const bat *sl, 
const bat *sr, const int *op, const bit *nil_matches, const lng *estimate);
-str ALGthetajoin1(bat *r1, const bat *l, const bat *r, const bat *sl, const 
bat *sr, const int *op, const bit *nil_matches, const lng *estimate);
-str ALGthetaselect1(bat *result, const bat *bid, const void *val, const char 
**op);
-str ALGthetaselect2(bat *result, const bat *bid, const bat *sid, const void 
*val, const char **op);
-str ALGunique1(bat *result, const bat *bid);
-str ALGunique2(bat *result, const bat *bid, const bat *sid);
-str ALGvariance(dbl *res, const bat *bid);
-str ALGvariancep(dbl *res, const bat *bid);
 str AUTHaddRemoteTableCredentials(const char *local_table, const char 
*localuser, const char *uri, const char *remoteuser, const char *pass, bool 
pw_encrypted);
 str AUTHaddUser(oid *ret, Client c, const char *user, const char *pass);
 str AUTHchangePassword(Client c, const char *oldpass, const char *passwd);
diff --git a/monetdb5/modules/kernel/aggr.c b/monetdb5/modules/kernel/aggr.c
--- a/monetdb5/modules/kernel/aggr.c
+++ b/monetdb5/modules/kernel/aggr.c
@@ -110,32 +110,28 @@ AGGRgrouped(bat *retval1, bat *retval2, 
        return MAL_SUCCEED;
 }
 
-mal_export str AGGRsum3_bte(bat *retval, const bat *bid, const bat *gid, const 
bat *eid);
-str
+static str
 AGGRsum3_bte(bat *retval, const bat *bid, const bat *gid, const bat *eid)
 {
        return AGGRgrouped(retval, NULL, bid, gid, eid, NULL, 1, 1, 0, TYPE_bte,
                                           BATgroupsum, NULL, NULL, NULL, 
"aggr.sum");
 }
 
-mal_export str AGGRsum3_sht(bat *retval, const bat *bid, const bat *gid, const 
bat *eid);
-str
+static str
 AGGRsum3_sht(bat *retval, const bat *bid, const bat *gid, const bat *eid)
 {
        return AGGRgrouped(retval, NULL, bid, gid, eid, NULL, 1, 1, 0, TYPE_sht,
                                           BATgroupsum, NULL, NULL, NULL, 
"aggr.sum");
 }
 
-mal_export str AGGRsum3_int(bat *retval, const bat *bid, const bat *gid, const 
bat *eid);
-str
+static str
 AGGRsum3_int(bat *retval, const bat *bid, const bat *gid, const bat *eid)
 {
        return AGGRgrouped(retval, NULL, bid, gid, eid, NULL, 1, 1, 0, TYPE_int,
                                           BATgroupsum, NULL, NULL, NULL, 
"aggr.sum");
 }
 
-mal_export str AGGRsum3_lng(bat *retval, const bat *bid, const bat *gid, const 
bat *eid);
-str
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to