Changeset: db926e5bc0bd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=db926e5bc0bd Modified Files: clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 Branch: subquery Log Message:
approved new signatures diffs (98 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 @@ -66,6 +66,8 @@ stdout of test 'MAL-signatures` in direc % module, function, signature, address, comment # name % clob, clob, clob, clob, clob # type % 11, 28, 364, 44, 874 # length +[ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] +[ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] [ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on dbl" ] [ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on flt" ] @@ -232,6 +234,10 @@ stdout of test 'MAL-signatures` in direc [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(b:bat[:str], sep:bat[:str], nil_if_empty:bit):str ", "CMDBATstr_group_concat;", "Calculate aggregate string concatenate of B with separator SEP." ] [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(b:bat[:str], sep:bat[:str], s:bat[:oid]):str ", "CMDBATstr_group_concat;", "Calculate aggregate string concatenate of B with candidate list and separator SEP." ] [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(b:bat[:str], sep:bat[:str], s:bat[:oid], nil_if_empty:bit):str ", "CMDBATstr_group_concat;", "Calculate aggregate string concatenate of B with candidate list and separator SEP." ] +[ "aggr", "suballnotequal", "command aggr.suballnotequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp2;", "if all values in r are not equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then true" ] +[ "aggr", "suballnotequal", "command aggr.suballnotequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] +[ "aggr", "subanyequal", "command aggr.subanyequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp2;", "if any value in r is equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then false" ] +[ "aggr", "subanyequal", "command aggr.subanyequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:bte], g:bat[:oid], e:bat[:any_1], skip_nils:bit, abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:dbl], g:bat[:oid], e:bat[:any_1], skip_nils:bit, abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:flt], g:bat[:oid], e:bat[:any_1], skip_nils:bit, abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] @@ -11635,14 +11641,12 @@ stdout of test 'MAL-signatures` in direc [ "sql", "all", "inline function sql.all(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1];", "", "" ] [ "sql", "all", "command sql.all(col:bat[:any_1]):any_1 ", "SQLall;", "if all values in col are equal return this, else nil" ] [ "sql", "all", "command sql.all(cmp:bit, nl:bit, nr:bit):bit ", "SQLall_cmp;", "if !cmp then false, (nl or nr) then nil, else true" ] -[ "sql", "allnotequal", "command sql.allnotequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] [ "sql", "alpha", "command sql.alpha(dec:dbl, theta:dbl):dbl ", "SQLcst_alpha_cst;", "Implementation of astronomy alpha function: expands the radius theta depending on the declination" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng):void ", "sql_analyze;", "" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng, sch:str):void ", "sql_analyze;", "" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng, sch:str, tbl:str):void ", "sql_analyze;", "" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng, sch:str, tbl:str, col:str):void ", "sql_analyze;", "Update the database statistics table" ] [ "sql", "any", "command sql.any(cmp:bit, nl:bit, nr:bit):bit ", "SQLany_cmp;", "if cmp then true, (nl or nr) nil then nil, else false" ] -[ "sql", "anyequal", "command sql.anyequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "sql", "append", "pattern sql.append(mvc:int, sname:str, tname:str, cname:str, ins:any):int ", "mvc_append_wrap;", "Append to the column tname.cname (possibly optimized to replace the insert bat of tname.cname. Returns sequence number for order dependence." ] [ "sql", "argRecord", "pattern sql.argRecord():str ", "SQLargRecord;", "Glue together the calling sequence" ] [ "sql", "argRecord", "pattern sql.argRecord(a:any...):str ", "SQLargRecord;", "Glue together the calling sequence" ] @@ -11803,10 +11807,6 @@ stdout of test 'MAL-signatures` in direc [ "sql", "storage", "pattern sql.storage(sname:str) (schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage information for a particular schema " ] [ "sql", "storage", "pattern sql.storage(sname:str, tname:str) (schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage information for a particular table" ] [ "sql", "storage", "pattern sql.storage(sname:str, tname:str, cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage information for a particular column" ] -[ "sql", "suballnotequal", "command sql.suballnotequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp2;", "if all values in r are not equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then true" ] -[ "sql", "suballnotequal", "command sql.suballnotequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] -[ "sql", "subanyequal", "command sql.subanyequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp2;", "if any value in r is equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then false" ] -[ "sql", "subanyequal", "command sql.subanyequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "sql", "subdelta", "command sql.subdelta(col:bat[:oid], cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ", "DELTAsub2;", "Return a single bat of selected delta." ] [ "sql", "subdelta", "command sql.subdelta(col:bat[:oid], cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ", "DELTAsub;", "Return a single bat of selected delta." ] [ "sql", "subzero_or_one", "inline function sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1];", "", "" ] 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 @@ -70,6 +70,8 @@ stdout of test 'MAL-signatures` in direc % module, function, signature, address, comment # name % clob, clob, clob, clob, clob # type % 11, 28, 364, 44, 874 # length +[ "aggr", "allnotequal", "command aggr.allnotequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] +[ "aggr", "anyequal", "command aggr.anyequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "aggr", "avg", "command aggr.avg(b:bat[:bte], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on bte" ] [ "aggr", "avg", "command aggr.avg(b:bat[:dbl], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on dbl" ] [ "aggr", "avg", "command aggr.avg(b:bat[:flt], g:bat[:oid], e:bat[:any_1]):bat[:dbl] ", "AGGRavg13_dbl;", "Grouped tail average on flt" ] @@ -271,6 +273,10 @@ stdout of test 'MAL-signatures` in direc [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(b:bat[:str], sep:bat[:str], nil_if_empty:bit):str ", "CMDBATstr_group_concat;", "Calculate aggregate string concatenate of B with separator SEP." ] [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(b:bat[:str], sep:bat[:str], s:bat[:oid]):str ", "CMDBATstr_group_concat;", "Calculate aggregate string concatenate of B with candidate list and separator SEP." ] [ "aggr", "str_group_concat", "pattern aggr.str_group_concat(b:bat[:str], sep:bat[:str], s:bat[:oid], nil_if_empty:bit):str ", "CMDBATstr_group_concat;", "Calculate aggregate string concatenate of B with candidate list and separator SEP." ] +[ "aggr", "suballnotequal", "command aggr.suballnotequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp2;", "if all values in r are not equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then true" ] +[ "aggr", "suballnotequal", "command aggr.suballnotequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] +[ "aggr", "subanyequal", "command aggr.subanyequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp2;", "if any value in r is equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then false" ] +[ "aggr", "subanyequal", "command aggr.subanyequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:bte], g:bat[:oid], e:bat[:any_1], skip_nils:bit, abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:dbl], g:bat[:oid], e:bat[:any_1], skip_nils:bit, abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:flt], g:bat[:oid], e:bat[:any_1], skip_nils:bit, abort_on_error:bit):bat[:dbl] ", "AGGRsubavg1_dbl;", "Grouped average aggregate" ] @@ -16047,14 +16053,12 @@ stdout of test 'MAL-signatures` in direc [ "sql", "all", "inline function sql.all(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1];", "", "" ] [ "sql", "all", "command sql.all(col:bat[:any_1]):any_1 ", "SQLall;", "if all values in col are equal return this, else nil" ] [ "sql", "all", "command sql.all(cmp:bit, nl:bit, nr:bit):bit ", "SQLall_cmp;", "if !cmp then false, (nl or nr) then nil, else true" ] -[ "sql", "allnotequal", "command sql.allnotequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLallnotequal;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] [ "sql", "alpha", "command sql.alpha(dec:dbl, theta:dbl):dbl ", "SQLcst_alpha_cst;", "Implementation of astronomy alpha function: expands the radius theta depending on the declination" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng):void ", "sql_analyze;", "" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng, sch:str):void ", "sql_analyze;", "" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng, sch:str, tbl:str):void ", "sql_analyze;", "" ] [ "sql", "analyze", "pattern sql.analyze(minmax:int, sample:lng, sch:str, tbl:str, col:str):void ", "sql_analyze;", "Update the database statistics table" ] [ "sql", "any", "command sql.any(cmp:bit, nl:bit, nr:bit):bit ", "SQLany_cmp;", "if cmp then true, (nl or nr) nil then nil, else false" ] -[ "sql", "anyequal", "command sql.anyequal(l:bat[:any_1], r:bat[:any_1]):bit ", "SQLanyequal;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "sql", "append", "pattern sql.append(mvc:int, sname:str, tname:str, cname:str, ins:any):int ", "mvc_append_wrap;", "Append to the column tname.cname (possibly optimized to replace the insert bat of tname.cname. Returns sequence number for order dependence." ] [ "sql", "argRecord", "pattern sql.argRecord():str ", "SQLargRecord;", "Glue together the calling sequence" ] [ "sql", "argRecord", "pattern sql.argRecord(a:any...):str ", "SQLargRecord;", "Glue together the calling sequence" ] @@ -16223,10 +16227,6 @@ stdout of test 'MAL-signatures` in direc [ "sql", "storage", "pattern sql.storage(sname:str) (schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage information for a particular schema " ] [ "sql", "storage", "pattern sql.storage(sname:str, tname:str) (schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage information for a particular table" ] [ "sql", "storage", "pattern sql.storage(sname:str, tname:str, cname:str) (schema:bat[:str], table:bat[:str], column:bat[:str], type:bat[:str], mode:bat[:str], location:bat[:str], count:bat[:lng], atomwidth:bat[:int], columnsize:bat[:lng], heap:bat[:lng], hashes:bat[:lng], phash:bat[:bit], imprints:bat[:lng], sorted:bat[:bit], revsorted:bat[:bit], key:bat[:bit], orderidx:bat[:lng]) ", "sql_storage;", "return a table with storage information for a particular column" ] -[ "sql", "suballnotequal", "command sql.suballnotequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp2;", "if all values in r are not equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then true" ] -[ "sql", "suballnotequal", "command sql.suballnotequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLallnotequal_grp;", "if all values in r are not equal to l return true, else if r has nil nil else false" ] -[ "sql", "subanyequal", "command sql.subanyequal(l:bat[:any_1], r:bat[:any_1], rid:bat[:oid], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp2;", "if any value in r is equal to l return true, else if r has nil nil else false, except if rid is nil (ie empty) then false" ] -[ "sql", "subanyequal", "command sql.subanyequal(l:bat[:any_1], r:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:bit] ", "SQLanyequal_grp;", "if any value in r is equal to l return true, else if r has nil nil else false" ] [ "sql", "subdelta", "command sql.subdelta(col:bat[:oid], cand:bat[:oid], uid:bat[:oid], uval:bat[:oid]):bat[:oid] ", "DELTAsub2;", "Return a single bat of selected delta." ] [ "sql", "subdelta", "command sql.subdelta(col:bat[:oid], cand:bat[:oid], uid:bat[:oid], uval:bat[:oid], ins:bat[:oid]):bat[:oid] ", "DELTAsub;", "Return a single bat of selected delta." ] [ "sql", "subzero_or_one", "inline function sql.subzero_or_one(b:bat[:any_1], gp:bat[:oid], gpe:bat[:oid], no_nil:bit):bat[:any_1];", "", "" ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
