Changeset: c442f07230a9 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c442f07230a9
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
clients/Tests/exports.stable.out
sql/test/Tests/setoptimizer.stable.out
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
Branch: data-vaults
Log Message:
Approve tests
diffs (truncated from 714 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
@@ -7463,6 +7463,28 @@ Ready.
[ "fits", "listdir", "pattern fits.listdir(dirname:str):void ",
"FITSdir;", "Attach all FITS files in the directory" ]
[ "fits", "listdirpattern", "pattern
fits.listdirpattern(dirname:str, pattern:str):void ", "FITSdirpat;", "Attach
all FITS file in the directory, giving a pattern" ]
[ "fits", "load", "pattern fits.load(tablename:str):void ",
"FITSloadTable;", "Load a FITS table from an attached file" ]
+[ "gadget", "analyzetab", "function gadget.analyzetab(status:int,
tablename:str):int;", "", "" ]
+[ "gadget", "analyzetable", "pattern gadget.analyzetable(readerID:int,
status:int, tablename:str):int ", "gadgetAnalyzeTable;", "Analyze table" ]
+[ "gadget", "attach", "pattern gadget.attach(fname:str):void ",
"gadgetAttach;", "Opens a GADGET file, loads metadata into the catalog
and creates a table" ]
+[ "gadget", "attachall", "pattern gadget.attachall(tname:str,
fname:str...):void ", "gadgetAttachAll;", "Opens all GADGET files,
loads their metadata into the catalog and creates a single table, name tname,
for all of them" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int) (uid:bat[:oid], uval:bat[:any_1]) ",
"mvc_gadget_bind_wrap;", "Bind the 'schema.table.column' BAT with access
kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int):bat[:any_1] ", "mvc_gadget_bind_wrap;",
"Bind the 'schema.table.column' BAT with access kind:\n\t0 - base
table\n\t1 - inserts\n\t2 - updates" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int) (uid:bat[:oid],
uval:bat[:any_1]) ", "mvc_gadget_bind_wrap;", "Bind the
'schema.table.column' BAT with access kind:\n\t0 - base table\n\t1 -
inserts\n\t2 - updates" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int):bat[:any_1] ",
"mvc_gadget_bind_wrap;", "Bind the 'schema.table.column' BAT partition
with access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "gadget", "checktab", "function gadget.checktab(tablename:str)
(X_0:int, X_1:int);", "", "" ]
+[ "gadget", "checktable", "pattern gadget.checktable(mvc:int,
tablename:str) (X_0:int, X_1:int) ", "gadgetCheckTable;", "Check if
table was loaded" ]
+[ "gadget", "export", "pattern gadget.export(tablename:str):void ",
"gadgetExportTable;", "Export a table to a GADGET file" ]
+[ "gadget", "import", "pattern gadget.import(tablename:str):void ",
"gadgetImportTable;", "Import a GADGET table from an attached file" ]
+[ "gadget", "link", "pattern gadget.link(tablename:str):void ",
"gadgetLinkTable;", "Link with GADGET table from an attached file using
MMAP" ]
+[ "gadget", "listdir", "pattern gadget.listdir(dirname:str):void ",
"gadgetListDir;", "Attach all GADGET files in the directory" ]
+[ "gadget", "listdirall", "pattern gadget.listdirall(dirname:str):void ",
"gadgetListDirAll;", "Attach all GADGET files in the directory" ]
+[ "gadget", "listdirpattern", "pattern
gadget.listdirpattern(dirname:str, pattern:str):void ",
"gadgetListDirPat;", "Attach all GADGET file in the directory, giving a
pattern" ]
+[ "gadget", "load", "pattern gadget.load(tablename:str):void ",
"gadgetLoadTable;", "Load a GADGET table from an attached file" ]
+[ "gadget", "loadall", "pattern gadget.loadall(tablename:str):void ",
"gadgetLoadTableAll;", "Load a GADGET table from an attached file" ]
+[ "gadget", "phkeyconvert", "pattern gadget.phkeyconvert(x:flt, y:flt,
z:flt, baseSize:flt, nbits:int):lng ", "gadgetPHkeyConvert;", "Convert a
3D coordinate to a peano hilbert key" ]
+[ "gadget", "phkeyinvert", "pattern gadget.phkeyinvert(phkey:lng,
baseSize:flt, nbits:int) (x:bat[:flt], y:bat[:flt], z:bat[:flt],
cSize:bat[:flt]) ", "gadgetPHkeyInvert;", "Invert a peano hilbert key to
left bottom 3D coordinate of the cell and its length" ]
+[ "gadget", "tid", "pattern gadget.tid(id:int, mvc:int, sname:str,
tname:str):bat[:oid] ", "gadgetTid;", "Return the tables tid column." ]
+[ "gadget", "tid", "pattern gadget.tid(id:int, mvc:int, sname:str,
tname:str, part_nr:int, nr_parts:int):bat[:oid] ", "gadgetTid;", "Return
the tables tid column." ]
[ "generator", "join", "pattern generator.join(b:bat[:bte], gen:bat[:bte])
(l:bat[:oid], r:bat[:oid]) ", "VLTgenerator_join;", "" ]
[ "generator", "join", "pattern generator.join(b:bat[:dbl], gen:bat[:dbl])
(l:bat[:oid], r:bat[:oid]) ", "VLTgenerator_join;", "Overloaded join
operation" ]
[ "generator", "join", "pattern generator.join(b:bat[:flt], gen:bat[:flt])
(l:bat[:oid], r:bat[:oid]) ", "VLTgenerator_join;", "" ]
@@ -7832,10 +7854,17 @@ Ready.
[ "language", "register", "pattern language.register(m:str, f:str,
code:str, help:str):void ", "CMDregisterFunction;", "Compile the code string
to MAL and register it as a function." ]
[ "language", "sink", "pattern language.sink(v:any...):void ",
"MALgarbagesink;", "Variables to be considered together when triggering
garbage collection.\nUsed in the dataflow blocks to avoid early release of
values." ]
[ "language", "source", "pattern language.source(f:str):void ",
"CMDevalFile;", "Merge the instructions stored in the file with the current
program." ]
+[ "lidar", "analyzetab", "function lidar.analyzetab(status:int,
tablename:str):int;", "", "" ]
+[ "lidar", "analyzetable", "pattern lidar.analyzetable(readerID:int,
status:int, tablename:str):int ", "LIDARAnalyzeTable;", "Analyze table" ]
[ "lidar", "attach", "pattern lidar.attach(fname:str):void ",
"LIDARattach;", "Open a LIDAR file and return catalog of the table HDUs"
]
+[ "lidar", "attach", "pattern lidar.attach(fname:str,
tname:str):void ", "LIDARattach;", "Attach to a specific table" ]
+[ "lidar", "attach", "pattern lidar.attach(fname:str, tname:str,
params:str):void ", "LIDARattach;", "Attach to a specific table, with
parameters" ]
+[ "lidar", "checktab", "function lidar.checktab(tablename:str)
(X_0:int, X_1:int);", "", "" ]
+[ "lidar", "checktable", "command lidar.checktable(mvc:int,
tablename:str) (X_0:int, X_1:int) ", "LIDARCheckTable;", "Check if table
was loaded" ]
[ "lidar", "export", "pattern lidar.export(tablename:str, fname:str,
type:str):void ", "LIDARexportTable;", "Exporta LIDAR table to a
LAS/LAZ file" ]
[ "lidar", "load", "pattern lidar.load(tablename:str):void ",
"LIDARloadTable;", "Load a LIDAR table from an attached file" ]
[ "lidar", "prelude", "command lidar.prelude():void ",
"LIDARprelude;", "" ]
+[ "lidar", "unload", "pattern lidar.unload(tablename:str):void ",
"LIDARunload;", "Unload the data from a LIDAR table" ]
[ "lsst", "angsep", "command lsst.angsep(ra1:dbl, dec1:dbl,
ra2:dbl, dec2:dbl):dbl ", "qserv_angSep;", "Returns the angular
separation in degrees between two spherical\ncoordinate pairs (ra1,dec1) and
(ra2,dec2)" ]
[ "lsst", "ptinsphbox", "command lsst.ptinsphbox(ra:dbl, dec:dbl,
ra_min:dbl, dec_min:dbl, ra_max:dbl, dec_max:dbl):int ",
"qserv_ptInSphBox;", "Returns 1 if the given spherical longitude/latitude
box contains the given position" ]
[ "lsst", "ptinsphcircle", "command lsst.ptinsphcircle(ra:dbl,
dec:dbl, ra_cen:dbl, dec_cen:dbl, radius:dbl):int ",
"qserv_ptInSphCircle;", "Returns 1 if the given spherical longitude/latitude
circle contains the given position" ]
@@ -8141,6 +8170,8 @@ Ready.
[ "optimizer", "costModel", "pattern optimizer.costModel(mod:str,
fcn:str):str ", "OPTwrapper;", "Estimate the cost of a relational
expression" ]
[ "optimizer", "dataflow", "pattern optimizer.dataflow():str ",
"OPTwrapper;", "" ]
[ "optimizer", "dataflow", "pattern optimizer.dataflow(mod:str,
fcn:str):str ", "OPTwrapper;", "Dataflow bracket code injection" ]
+[ "optimizer", "datavaults", "pattern optimizer.datavaults():str ",
"OPTwrapper;", "" ]
+[ "optimizer", "datavaults", "pattern optimizer.datavaults(mod:str,
fcn:str):str ", "OPTwrapper;", "Lazy load of datavaults files" ]
[ "optimizer", "deadcode", "pattern optimizer.deadcode():str ",
"OPTwrapper;", "" ]
[ "optimizer", "deadcode", "pattern optimizer.deadcode(mod:str,
fcn:str):str ", "OPTwrapper;", "Dead code optimizer" ]
[ "optimizer", "derivePath", "pattern optimizer.derivePath():str ",
"OPTwrapper;", "" ]
@@ -8667,6 +8698,23 @@ Ready.
[ "uuid", "prelude", "command uuid.prelude():void ", "UUIDprelude;",
"" ]
[ "uuid", "str", "command uuid.str(u:uuid):str ",
"UUIDuuid2str;", "Coerce a uuid to its string type" ]
[ "uuid", "uuid", "command uuid.uuid(s:str):uuid ",
"UUIDstr2uuid;", "Coerce a string to a uuid, validating its format"
]
+[ "vault", "analyzetab", "function vault.analyzetab(status:int,
tablename:str):int;", "", "" ]
+[ "vault", "analyzetable", "pattern vault.analyzetable(readerID:int,
status:int, tablename:str):int ", "VLTanalyzeTable;", "Analyze table" ]
+[ "vault", "basename", "command vault.basename(fnme:str,
split:str):str ", "VLTbasename;", "Split the fnme string just before the
split marker." ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int) (uid:bat[:oid], uval:bat[:any_1]) ",
"mvc_VLT_bind_wrap;", "Bind the 'schema.table.column' BAT with access
kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int):bat[:any_1] ", "mvc_VLT_bind_wrap;",
"Bind the 'schema.table.column' BAT with access kind:\n\t0 - base table\n\t1 -
inserts\n\t2 - updates" ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int) (uid:bat[:oid],
uval:bat[:any_1]) ", "mvc_VLT_bind_wrap;", "Bind the 'schema.table.column'
BAT with access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int):bat[:any_1] ",
"mvc_VLT_bind_wrap;", "Bind the 'schema.table.column' BAT partition with
access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "vault", "checktab", "function vault.checktab(tablename:str)
(X_0:int, X_1:int);", "", "" ]
+[ "vault", "checktable", "pattern vault.checktable(mvc:int,
tablename:str) (readerID:int, status:int) ", "VLTcheckTable;", "Check if
table was loaded" ]
+[ "vault", "epiloque", "command vault.epiloque():void ",
"VLTepilogue;", "Cleanup the vault." ]
+[ "vault", "getdirectory", "command vault.getdirectory():str ",
"VLTgetLocation;", "Return the location of the root vault directory"
]
+[ "vault", "import", "command vault.import(src:str,
trg:str):timestamp ", "VLTimport;", "Use FTP to copy a remote file to the
cache" ]
+[ "vault", "prelude", "command vault.prelude():void ",
"VLTprelude;", "" ]
+[ "vault", "remove", "command vault.remove(t:str):timestamp ",
"VLTremove;", "Drop a file from the local cache" ]
+[ "vault", "setdirectory", "command vault.setdirectory(src:str):str ",
"VLTsetLocation;", "Change the location of the root vault directory"
]
+[ "vault", "tid", "pattern vault.tid(tatus:int, mvc:int, sname:str,
tname:str):bat[:oid] ", "VLTTid;", "Return the tables tid column." ]
+[ "vault", "tid", "pattern vault.tid(tatus:int, mvc:int, sname:str,
tname:str, part_nr:int, nr_parts:int):bat[:oid] ", "VLTTid;", "Return
the tables tid column." ]
[ "wkb", "#cmp", "command wkb.#cmp():void ", "wkbCOMP;", ""
]
[ "wkb", "#del", "command wkb.#del():void ", "wkbDEL;", ""
]
[ "wkb", "#fromstr", "command wkb.#fromstr():void ", "wkbFROMSTR;",
"" ]
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
@@ -9809,6 +9809,28 @@ Ready.
[ "fits", "listdir", "pattern fits.listdir(dirname:str):void ",
"FITSdir;", "Attach all FITS files in the directory" ]
[ "fits", "listdirpattern", "pattern
fits.listdirpattern(dirname:str, pattern:str):void ", "FITSdirpat;", "Attach
all FITS file in the directory, giving a pattern" ]
[ "fits", "load", "pattern fits.load(tablename:str):void ",
"FITSloadTable;", "Load a FITS table from an attached file" ]
+[ "gadget", "analyzetab", "function gadget.analyzetab(status:int,
tablename:str):int;", "", "" ]
+[ "gadget", "analyzetable", "pattern gadget.analyzetable(readerID:int,
status:int, tablename:str):int ", "gadgetAnalyzeTable;", "Analyze table" ]
+[ "gadget", "attach", "pattern gadget.attach(fname:str):void ",
"gadgetAttach;", "Opens a GADGET file, loads metadata into the catalog
and creates a table" ]
+[ "gadget", "attachall", "pattern gadget.attachall(tname:str,
fname:str...):void ", "gadgetAttachAll;", "Opens all GADGET files,
loads their metadata into the catalog and creates a single table, name tname,
for all of them" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int) (uid:bat[:oid], uval:bat[:any_1]) ",
"mvc_gadget_bind_wrap;", "Bind the 'schema.table.column' BAT with access
kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int):bat[:any_1] ", "mvc_gadget_bind_wrap;",
"Bind the 'schema.table.column' BAT with access kind:\n\t0 - base
table\n\t1 - inserts\n\t2 - updates" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int) (uid:bat[:oid],
uval:bat[:any_1]) ", "mvc_gadget_bind_wrap;", "Bind the
'schema.table.column' BAT with access kind:\n\t0 - base table\n\t1 -
inserts\n\t2 - updates" ]
+[ "gadget", "bind", "pattern gadget.bind(tid:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int):bat[:any_1] ",
"mvc_gadget_bind_wrap;", "Bind the 'schema.table.column' BAT partition
with access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "gadget", "checktab", "function gadget.checktab(tablename:str)
(X_0:int, X_1:int);", "", "" ]
+[ "gadget", "checktable", "pattern gadget.checktable(mvc:int,
tablename:str) (X_0:int, X_1:int) ", "gadgetCheckTable;", "Check if
table was loaded" ]
+[ "gadget", "export", "pattern gadget.export(tablename:str):void ",
"gadgetExportTable;", "Export a table to a GADGET file" ]
+[ "gadget", "import", "pattern gadget.import(tablename:str):void ",
"gadgetImportTable;", "Import a GADGET table from an attached file" ]
+[ "gadget", "link", "pattern gadget.link(tablename:str):void ",
"gadgetLinkTable;", "Link with GADGET table from an attached file using
MMAP" ]
+[ "gadget", "listdir", "pattern gadget.listdir(dirname:str):void ",
"gadgetListDir;", "Attach all GADGET files in the directory" ]
+[ "gadget", "listdirall", "pattern gadget.listdirall(dirname:str):void ",
"gadgetListDirAll;", "Attach all GADGET files in the directory" ]
+[ "gadget", "listdirpattern", "pattern
gadget.listdirpattern(dirname:str, pattern:str):void ",
"gadgetListDirPat;", "Attach all GADGET file in the directory, giving a
pattern" ]
+[ "gadget", "load", "pattern gadget.load(tablename:str):void ",
"gadgetLoadTable;", "Load a GADGET table from an attached file" ]
+[ "gadget", "loadall", "pattern gadget.loadall(tablename:str):void ",
"gadgetLoadTableAll;", "Load a GADGET table from an attached file" ]
+[ "gadget", "phkeyconvert", "pattern gadget.phkeyconvert(x:flt, y:flt,
z:flt, baseSize:flt, nbits:int):lng ", "gadgetPHkeyConvert;", "Convert a
3D coordinate to a peano hilbert key" ]
+[ "gadget", "phkeyinvert", "pattern gadget.phkeyinvert(phkey:lng,
baseSize:flt, nbits:int) (x:bat[:flt], y:bat[:flt], z:bat[:flt],
cSize:bat[:flt]) ", "gadgetPHkeyInvert;", "Invert a peano hilbert key to
left bottom 3D coordinate of the cell and its length" ]
+[ "gadget", "tid", "pattern gadget.tid(id:int, mvc:int, sname:str,
tname:str):bat[:oid] ", "gadgetTid;", "Return the tables tid column." ]
+[ "gadget", "tid", "pattern gadget.tid(id:int, mvc:int, sname:str,
tname:str, part_nr:int, nr_parts:int):bat[:oid] ", "gadgetTid;", "Return
the tables tid column." ]
[ "generator", "join", "pattern generator.join(b:bat[:bte], gen:bat[:bte])
(l:bat[:oid], r:bat[:oid]) ", "VLTgenerator_join;", "" ]
[ "generator", "join", "pattern generator.join(b:bat[:dbl], gen:bat[:dbl])
(l:bat[:oid], r:bat[:oid]) ", "VLTgenerator_join;", "Overloaded join
operation" ]
[ "generator", "join", "pattern generator.join(b:bat[:flt], gen:bat[:flt])
(l:bat[:oid], r:bat[:oid]) ", "VLTgenerator_join;", "" ]
@@ -10192,10 +10214,17 @@ Ready.
[ "language", "register", "pattern language.register(m:str, f:str,
code:str, help:str):void ", "CMDregisterFunction;", "Compile the code string
to MAL and register it as a function." ]
[ "language", "sink", "pattern language.sink(v:any...):void ",
"MALgarbagesink;", "Variables to be considered together when triggering
garbage collection.\nUsed in the dataflow blocks to avoid early release of
values." ]
[ "language", "source", "pattern language.source(f:str):void ",
"CMDevalFile;", "Merge the instructions stored in the file with the current
program." ]
+[ "lidar", "analyzetab", "function lidar.analyzetab(status:int,
tablename:str):int;", "", "" ]
+[ "lidar", "analyzetable", "pattern lidar.analyzetable(readerID:int,
status:int, tablename:str):int ", "LIDARAnalyzeTable;", "Analyze table" ]
[ "lidar", "attach", "pattern lidar.attach(fname:str):void ",
"LIDARattach;", "Open a LIDAR file and return catalog of the table HDUs"
]
+[ "lidar", "attach", "pattern lidar.attach(fname:str,
tname:str):void ", "LIDARattach;", "Attach to a specific table" ]
+[ "lidar", "attach", "pattern lidar.attach(fname:str, tname:str,
params:str):void ", "LIDARattach;", "Attach to a specific table, with
parameters" ]
+[ "lidar", "checktab", "function lidar.checktab(tablename:str)
(X_0:int, X_1:int);", "", "" ]
+[ "lidar", "checktable", "command lidar.checktable(mvc:int,
tablename:str) (X_0:int, X_1:int) ", "LIDARCheckTable;", "Check if table
was loaded" ]
[ "lidar", "export", "pattern lidar.export(tablename:str, fname:str,
type:str):void ", "LIDARexportTable;", "Exporta LIDAR table to a
LAS/LAZ file" ]
[ "lidar", "load", "pattern lidar.load(tablename:str):void ",
"LIDARloadTable;", "Load a LIDAR table from an attached file" ]
[ "lidar", "prelude", "command lidar.prelude():void ",
"LIDARprelude;", "" ]
+[ "lidar", "unload", "pattern lidar.unload(tablename:str):void ",
"LIDARunload;", "Unload the data from a LIDAR table" ]
[ "lsst", "angsep", "command lsst.angsep(ra1:dbl, dec1:dbl,
ra2:dbl, dec2:dbl):dbl ", "qserv_angSep;", "Returns the angular
separation in degrees between two spherical\ncoordinate pairs (ra1,dec1) and
(ra2,dec2)" ]
[ "lsst", "ptinsphbox", "command lsst.ptinsphbox(ra:dbl, dec:dbl,
ra_min:dbl, dec_min:dbl, ra_max:dbl, dec_max:dbl):int ",
"qserv_ptInSphBox;", "Returns 1 if the given spherical longitude/latitude
box contains the given position" ]
[ "lsst", "ptinsphcircle", "command lsst.ptinsphcircle(ra:dbl,
dec:dbl, ra_cen:dbl, dec_cen:dbl, radius:dbl):int ",
"qserv_ptInSphCircle;", "Returns 1 if the given spherical longitude/latitude
circle contains the given position" ]
@@ -10503,6 +10532,8 @@ Ready.
[ "optimizer", "costModel", "pattern optimizer.costModel(mod:str,
fcn:str):str ", "OPTwrapper;", "Estimate the cost of a relational
expression" ]
[ "optimizer", "dataflow", "pattern optimizer.dataflow():str ",
"OPTwrapper;", "" ]
[ "optimizer", "dataflow", "pattern optimizer.dataflow(mod:str,
fcn:str):str ", "OPTwrapper;", "Dataflow bracket code injection" ]
+[ "optimizer", "datavaults", "pattern optimizer.datavaults():str ",
"OPTwrapper;", "" ]
+[ "optimizer", "datavaults", "pattern optimizer.datavaults(mod:str,
fcn:str):str ", "OPTwrapper;", "Lazy load of datavaults files" ]
[ "optimizer", "deadcode", "pattern optimizer.deadcode():str ",
"OPTwrapper;", "" ]
[ "optimizer", "deadcode", "pattern optimizer.deadcode(mod:str,
fcn:str):str ", "OPTwrapper;", "Dead code optimizer" ]
[ "optimizer", "derivePath", "pattern optimizer.derivePath():str ",
"OPTwrapper;", "" ]
@@ -11032,6 +11063,23 @@ Ready.
[ "uuid", "prelude", "command uuid.prelude():void ", "UUIDprelude;",
"" ]
[ "uuid", "str", "command uuid.str(u:uuid):str ",
"UUIDuuid2str;", "Coerce a uuid to its string type" ]
[ "uuid", "uuid", "command uuid.uuid(s:str):uuid ",
"UUIDstr2uuid;", "Coerce a string to a uuid, validating its format"
]
+[ "vault", "analyzetab", "function vault.analyzetab(status:int,
tablename:str):int;", "", "" ]
+[ "vault", "analyzetable", "pattern vault.analyzetable(readerID:int,
status:int, tablename:str):int ", "VLTanalyzeTable;", "Analyze table" ]
+[ "vault", "basename", "command vault.basename(fnme:str,
split:str):str ", "VLTbasename;", "Split the fnme string just before the
split marker." ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int) (uid:bat[:oid], uval:bat[:any_1]) ",
"mvc_VLT_bind_wrap;", "Bind the 'schema.table.column' BAT with access
kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int):bat[:any_1] ", "mvc_VLT_bind_wrap;",
"Bind the 'schema.table.column' BAT with access kind:\n\t0 - base table\n\t1 -
inserts\n\t2 - updates" ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int) (uid:bat[:oid],
uval:bat[:any_1]) ", "mvc_VLT_bind_wrap;", "Bind the 'schema.table.column'
BAT with access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "vault", "bind", "pattern vault.bind(status:int, mvc:int, schema:str,
table:str, column:str, access:int, part_nr:int, nr_parts:int):bat[:any_1] ",
"mvc_VLT_bind_wrap;", "Bind the 'schema.table.column' BAT partition with
access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates" ]
+[ "vault", "checktab", "function vault.checktab(tablename:str)
(X_0:int, X_1:int);", "", "" ]
+[ "vault", "checktable", "pattern vault.checktable(mvc:int,
tablename:str) (readerID:int, status:int) ", "VLTcheckTable;", "Check if
table was loaded" ]
+[ "vault", "epiloque", "command vault.epiloque():void ",
"VLTepilogue;", "Cleanup the vault." ]
+[ "vault", "getdirectory", "command vault.getdirectory():str ",
"VLTgetLocation;", "Return the location of the root vault directory"
]
+[ "vault", "import", "command vault.import(src:str,
trg:str):timestamp ", "VLTimport;", "Use FTP to copy a remote file to the
cache" ]
+[ "vault", "prelude", "command vault.prelude():void ",
"VLTprelude;", "" ]
+[ "vault", "remove", "command vault.remove(t:str):timestamp ",
"VLTremove;", "Drop a file from the local cache" ]
+[ "vault", "setdirectory", "command vault.setdirectory(src:str):str ",
"VLTsetLocation;", "Change the location of the root vault directory"
]
+[ "vault", "tid", "pattern vault.tid(tatus:int, mvc:int, sname:str,
tname:str):bat[:oid] ", "VLTTid;", "Return the tables tid column." ]
+[ "vault", "tid", "pattern vault.tid(tatus:int, mvc:int, sname:str,
tname:str, part_nr:int, nr_parts:int):bat[:oid] ", "VLTTid;", "Return
the tables tid column." ]
[ "wkb", "#cmp", "command wkb.#cmp():void ", "wkbCOMP;", ""
]
[ "wkb", "#del", "command wkb.#del():void ", "wkbDEL;", ""
]
[ "wkb", "#fromstr", "command wkb.#fromstr():void ", "wkbFROMSTR;",
"" ]
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -175,6 +175,17 @@ Ready.
\dSf sys."fitsload"
\dSf sys."flush_log"
\dSf sys."fuse"
+\dSf sys."gadgetanalyzetab"
+\dSf sys."gadgetattach"
+\dSf sys."gadgetattachall"
+\dSf sys."gadgetchecktab"
+\dSf sys."gadgetlistdir"
+\dSf sys."gadgetlistdirall"
+\dSf sys."gadgetlistdirpat"
+\dSf sys."gadgetload"
+\dSf sys."gadgetloadall"
+\dSf sys."gadgetphkeyconvert"
+\dSf sys."gadgetphkeyinvert"
\dSf sys."generate_series"
\dSf sys."geometrytype"
\dSf sys."get_type"
@@ -205,9 +216,12 @@ Ready.
\dSf sys."isauuid"
\dSf sys."left_shift"
\dSf sys."left_shift_assign"
+\dSf sys."lidaranalyzetab"
\dSf sys."lidarattach"
+\dSf sys."lidarchecktab"
\dSf sys."lidarexport"
\dSf sys."lidarload"
+\dSf sys."lidarunload"
\dSf sys."like"
\dSf sys."listdir"
\dSf sys."listdirpat"
@@ -509,6 +523,17 @@ SYSTEM FUNCTION sys.fitsload
SYSTEM FUNCTION sys.floor
SYSTEM FUNCTION sys.flush_log
SYSTEM FUNCTION sys.fuse
+SYSTEM FUNCTION sys.gadgetanalyzetab
+SYSTEM FUNCTION sys.gadgetattach
+SYSTEM FUNCTION sys.gadgetattachall
+SYSTEM FUNCTION sys.gadgetchecktab
+SYSTEM FUNCTION sys.gadgetlistdir
+SYSTEM FUNCTION sys.gadgetlistdirall
+SYSTEM FUNCTION sys.gadgetlistdirpat
+SYSTEM FUNCTION sys.gadgetload
+SYSTEM FUNCTION sys.gadgetloadall
+SYSTEM FUNCTION sys.gadgetphkeyconvert
+SYSTEM FUNCTION sys.gadgetphkeyinvert
SYSTEM FUNCTION sys.generate_series
SYSTEM FUNCTION sys.geometrytype
SYSTEM FUNCTION sys.get_type
@@ -552,9 +577,12 @@ SYSTEM FUNCTION sys.left_shift
SYSTEM FUNCTION sys.left_shift_assign
SYSTEM FUNCTION sys.length
SYSTEM FUNCTION sys.levenshtein
+SYSTEM FUNCTION sys.lidaranalyzetab
SYSTEM FUNCTION sys.lidarattach
+SYSTEM FUNCTION sys.lidarchecktab
SYSTEM FUNCTION sys.lidarexport
SYSTEM FUNCTION sys.lidarload
+SYSTEM FUNCTION sys.lidarunload
SYSTEM FUNCTION sys.like
SYSTEM FUNCTION sys.listdir
SYSTEM FUNCTION sys.listdirpat
@@ -918,6 +946,17 @@ create procedure sys.flush_log () extern
create function fuse(one tinyint, two tinyint) returns smallint external name
udf.fuse;
create function fuse(one smallint, two smallint) returns integer external name
udf.fuse;
create function fuse(one integer, two integer) returns bigint external name
udf.fuse;
+create procedure gadgetanalyzetab(status int, tname string) external name
gadget.analyzetab;
+create procedure gadgetattach(fname string) external name gadget.attach;
+create procedure gadgetattachall(*) external name gadget.attachall;
+create procedure gadgetchecktab(tname string) external name gadget.checktab;
+create procedure gadgetlistdir(dname string) external name gadget.listdir;
+create procedure gadgetlistdirall(dname string) external name
gadget.listdirall;
+create procedure gadgetlistdirpat(dname string, pattern string) external name
gadget.listdirpattern;
+create procedure gadgetload(tname string) external name gadget.load;
+create procedure gadgetloadall(tname string) external name gadget.loadall;
+create function gadgetphkeyconvert(x real, y real, z real, basesize real,
nbits int) returns bigint external name gadget.phkeyconvert;
+create function gadgetphkeyinvert(phkey bigint, basesize real, nbits int)
returns table (x real, y real, z real, csize real) external name
gadget.phkeyinvert;
create function sys.generate_series(first tinyint, last tinyint) returns table
(value tinyint) external name generator.series;
create function sys.generate_series(first tinyint, last tinyint, stepsize
tinyint) returns table (value tinyint) external name generator.series;
create function sys.generate_series(first smallint, last smallint) returns
table (value smallint) external name generator.series;
@@ -960,9 +999,14 @@ create function isaurl(theurl url) retur
create function sys.isauuid(s string) returns boolean external name
uuid."isaUUID";
create function "left_shift"(i1 inet, i2 inet) returns boolean external name
inet."<<";
create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external
name inet."<<=";
+create procedure lidaranalyzetab(status int, tname string) external name
lidar.analyzetab;
create procedure lidarattach(fname string) external name lidar.attach;
+create procedure lidarattach(fname string, tname string) external name
lidar.attach;
+create procedure lidarattach(fname string, tname string, params string)
external name lidar.attach;
+create procedure lidarchecktab(tname string) external name lidar.checktab;
create procedure lidarexport(tname string, fname string, format string)
external name lidar.export;
create procedure lidarload(tname string) external name lidar.load;
+create procedure lidarunload(tname string) external name lidar.unload;
create filter function "like"(val string, pat string, esc string) external
name algebra."like";
create filter function "like"(val string, pat string) external name
algebra."like";
@@ -2000,6 +2044,17 @@ drop function pcre_replace(string, strin
[ "sys", "fuse", "create function fuse(one integer, two integer) returns
bigint external name udf.fuse;", "udf", 1, 1, false, false,
false ]
[ "sys", "fuse", "create function fuse(one smallint, two smallint)
returns integer external name udf.fuse;", "udf", 1, 1, false,
false, false ]
[ "sys", "fuse", "create function fuse(one tinyint, two tinyint) returns
smallint external name udf.fuse;", "udf", 1, 1, false, false,
false ]
+[ "sys", "gadgetanalyzetab", "create procedure
gadgetanalyzetab(status int, tname string) external name gadget.analyzetab;",
"gadget", 1, 2, true, false, false ]
+[ "sys", "gadgetattach", "create procedure gadgetattach(fname string)
external name gadget.attach;", "gadget", 1, 2, true,
false, false ]
+[ "sys", "gadgetattachall", "create procedure gadgetattachall(*)
external name gadget.attachall;", "gadget", 1, 2, true,
false, true ]
+[ "sys", "gadgetchecktab", "create procedure gadgetchecktab(tname
string) external name gadget.checktab;", "gadget", 1, 2, true,
false, false ]
+[ "sys", "gadgetlistdir", "create procedure gadgetlistdir(dname
string) external name gadget.listdir;", "gadget", 1, 2, true,
false, false ]
+[ "sys", "gadgetlistdirall", "create procedure
gadgetlistdirall(dname string) external name gadget.listdirall;", "gadget",
1, 2, true, false, false ]
+[ "sys", "gadgetlistdirpat", "create procedure
gadgetlistdirpat(dname string, pattern string) external name
gadget.listdirpattern;", "gadget", 1, 2, true, false, false
]
+[ "sys", "gadgetload", "create procedure gadgetload(tname string)
external name gadget.load;", "gadget", 1, 2, true, false,
false ]
+[ "sys", "gadgetloadall", "create procedure gadgetloadall(tname
string) external name gadget.loadall;", "gadget", 1, 2, true,
false, false ]
+[ "sys", "gadgetphkeyconvert", "create function gadgetphkeyconvert(x
real, y real, z real, basesize real, nbits int) returns bigint external name
gadget.phkeyconvert;", "gadget", 1, 1, false, false,
false ]
+[ "sys", "gadgetphkeyinvert", "create function
gadgetphkeyinvert(phkey bigint, basesize real, nbits int) returns table (x
real, y real, z real, csize real) external name gadget.phkeyinvert;",
"gadget", 1, 5, false, false, false ]
[ "sys", "generate_series", "create function
sys.generate_series(first bigint, last bigint) returns table (value bigint)
external name generator.series;", "generator", 1, 5, false,
false, false ]
[ "sys", "generate_series", "create function
sys.generate_series(first bigint, last bigint, stepsize bigint) returns table
(value bigint) external name generator.series;", "generator", 1, 5,
false, false, false ]
[ "sys", "generate_series", "create function
sys.generate_series(first decimal(10,2), last decimal(10,2), stepsize
decimal(10,2)) returns table (value decimal(10,2)) external name
generator.series;", "generator", 1, 5, false, false, false
]
@@ -2091,9 +2146,14 @@ drop function pcre_replace(string, strin
[ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1,
false, false, false ]
[ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1,
false, false, false ]
[ "sys", "levenshtein", "levenshtein", "txtsim", 0, 1,
false, false, false ]
+[ "sys", "lidaranalyzetab", "create procedure
lidaranalyzetab(status int, tname string) external name lidar.analyzetab;",
"lidar", 1, 2, true, false, false ]
[ "sys", "lidarattach", "create procedure lidarattach(fname string)
external name lidar.attach;", "lidar", 1, 2, true,
false, false ]
+[ "sys", "lidarattach", "create procedure lidarattach(fname string,
tname string) external name lidar.attach;", "lidar", 1, 2,
true, false, false ]
+[ "sys", "lidarattach", "create procedure lidarattach(fname string,
tname string, params string) external name lidar.attach;", "lidar", 1,
2, true, false, false ]
+[ "sys", "lidarchecktab", "create procedure lidarchecktab(tname
string) external name lidar.checktab;", "lidar", 1, 2, true,
false, false ]
[ "sys", "lidarexport", "create procedure lidarexport(tname string,
fname string, format string) external name lidar.export;", "lidar", 1,
2, true, false, false ]
[ "sys", "lidarload", "create procedure lidarload(tname string)
external name lidar.load;", "lidar", 1, 2, true, false,
false ]
+[ "sys", "lidarunload", "create procedure lidarunload(tname string)
external name lidar.unload;", "lidar", 1, 2, true,
false, false ]
[ "sys", "like", "create filter function \"like\"(val string, pat
string) external name algebra.\"like\";", "algebra", 1, 4,
false, false, false ]
[ "sys", "like", "create filter function \"like\"(val string, pat
string, esc string) external name algebra.\"like\";", "algebra", 1,
4, false, false, false ]
[ "sys", "listdir", "create procedure listdir(dirname string)
external name fits.listdir;", "fits", 1, 2, true, false, false ]
@@ -3549,6 +3609,17 @@ drop function pcre_replace(string, strin
[ "sys", "fuse", "one", "int", 32, 0, 1, "two", "int",
32, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "fuse", "one", "smallint", 16, 0, 1, "two",
"smallint", 16, 0, 1, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
