Changeset: af5759328793 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=af5759328793
Added Files:
        clients/Tests/MAL-signatures.sql
        sql/backends/monet5/Tests/int_notation_1e5.sql
        sql/backends/monet5/Tests/int_notation_1e5.stable.err
        sql/backends/monet5/Tests/int_notation_1e5.stable.out
        sql/backends/monet5/Tests/pyapi31.stable.err
        sql/backends/monet5/Tests/pyapi31.stable.out
        sql/backends/monet5/Tests/pyapi32.sql
        sql/backends/monet5/Tests/pyapi32.stable.err
        sql/backends/monet5/Tests/pyapi32.stable.out
        sql/backends/monet5/Tests/pyloader01.sql
        sql/backends/monet5/Tests/pyloader01.stable.err
        sql/backends/monet5/Tests/pyloader01.stable.out
        sql/backends/monet5/Tests/pyloader02.sql
        sql/backends/monet5/Tests/pyloader02.stable.err
        sql/backends/monet5/Tests/pyloader02.stable.out
        sql/backends/monet5/Tests/pyloader03.sql
        sql/backends/monet5/Tests/pyloader03.stable.err
        sql/backends/monet5/Tests/pyloader03.stable.out
        sql/backends/monet5/Tests/pyloader04.sql
        sql/backends/monet5/Tests/pyloader04.stable.err
        sql/backends/monet5/Tests/pyloader04.stable.out
        sql/backends/monet5/Tests/pyloader05.sql
        sql/backends/monet5/Tests/pyloader05.stable.err
        sql/backends/monet5/Tests/pyloader05.stable.out
        sql/backends/monet5/Tests/pyloader07.sql
        sql/backends/monet5/Tests/pyloader07.stable.err
        sql/backends/monet5/Tests/pyloader07.stable.out
        sql/backends/monet5/UDF/pyapi/convert_loops.h
        sql/backends/monet5/UDF/pyapi/emit.c
        sql/backends/monet5/UDF/pyapi/emit.h
        sql/backends/monet5/UDF/pyapi/pyloader.c
        sql/test/copy/Tests/columns.sql
        sql/test/copy/Tests/columns.stable.err
        sql/test/copy/Tests/columns.stable.out
        sql/test/malloc_fail/Tests/initialize.sql
        sql/test/malloc_fail/Tests/initialize.stable.err
        sql/test/malloc_fail/Tests/initialize.stable.out
        sql/test/malloc_fail/Tests/setmemorylimit-fail.reqtests
        sql/test/malloc_fail/Tests/setmemorylimit-fail2.reqtests
        sql/test/malloc_fail/Tests/setmemorylimit.reqtests
Removed Files:
        clients/Tests/MAL-signatures.malC
        sql/backends/monet5/sql_readline.c
        sql/backends/monet5/sql_readline.h
Modified Files:
        NT/rules.msc
        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
        clients/mapiclient/mclient.c
        clients/mapiclient/stethoscope.c
        clients/mapiclient/tachograph.c
        clients/mapiclient/tomograph.c
        configure.ag
        gdk/ChangeLog
        gdk/gdk.h
        gdk/gdk_atoms.c
        gdk/gdk_bat.c
        gdk/gdk_bbp.c
        gdk/gdk_bbp.h
        gdk/gdk_join.c
        gdk/gdk_private.h
        gdk/gdk_select.c
        gdk/gdk_storage.c
        gdk/gdk_utils.c
        gdk/gdk_utils.h
        geom/monetdb5/30_geom.mal
        monetdb5/ChangeLog
        monetdb5/extras/mal_optimizer_template/91_opt_sql_append.mal
        monetdb5/extras/rapi/50_rapi.mal
        monetdb5/extras/rapi/rapi.c
        monetdb5/extras/sphinx/30_sphinx.mal
        monetdb5/mal/Makefile.ag
        monetdb5/mal/Tests/dynamicload.malC
        monetdb5/mal/Tests/dynamicload.stable.err
        monetdb5/mal/Tests/tst120a.malC
        monetdb5/mal/Tests/tst120a.stable.out
        monetdb5/mal/Tests/tst120b.malC
        monetdb5/mal/Tests/tst120b.stable.out
        monetdb5/mal/Tests/tst275.stable.out
        monetdb5/mal/Tests/tst804.stable.err
        monetdb5/mal/mal.c
        monetdb5/mal/mal.h
        monetdb5/mal/mal_atom.c
        monetdb5/mal/mal_client.c
        monetdb5/mal/mal_client.h
        monetdb5/mal/mal_debugger.c
        monetdb5/mal/mal_errors.h
        monetdb5/mal/mal_exception.c
        monetdb5/mal/mal_function.c
        monetdb5/mal/mal_import.c
        monetdb5/mal/mal_instruction.c
        monetdb5/mal/mal_instruction.h
        monetdb5/mal/mal_interpreter.c
        monetdb5/mal/mal_linker.c
        monetdb5/mal/mal_linker.h
        monetdb5/mal/mal_listing.c
        monetdb5/mal/mal_module.c
        monetdb5/mal/mal_module.h
        monetdb5/mal/mal_parser.c
        monetdb5/mal/mal_private.h
        monetdb5/mal/mal_profiler.c
        monetdb5/mal/mal_readline.c
        monetdb5/mal/mal_resolve.c
        monetdb5/mal/mal_runtime.c
        monetdb5/mal/mal_scenario.c
        monetdb5/mal/mal_session.c
        monetdb5/modules/atoms/str.c
        monetdb5/modules/kernel/algebra.c
        monetdb5/modules/kernel/bat5.c
        monetdb5/modules/kernel/status.c
        monetdb5/modules/mal/bbp.c
        monetdb5/modules/mal/bbp.h
        monetdb5/modules/mal/bbp.mal
        monetdb5/modules/mal/clients.c
        monetdb5/modules/mal/clients.h
        monetdb5/modules/mal/clients.mal
        monetdb5/modules/mal/inspect.c
        monetdb5/modules/mal/mal_mapi.c
        monetdb5/modules/mal/manual.c
        monetdb5/modules/mal/manual.h
        monetdb5/modules/mal/manual.mal
        monetdb5/modules/mal/sysmon.c
        monetdb5/modules/mal/tablet.c
        monetdb5/optimizer/Tests/inlineFunction.stable.out
        monetdb5/optimizer/Tests/inlineFunction1.stable.out
        monetdb5/optimizer/Tests/inlineFunction3.stable.out
        monetdb5/optimizer/Tests/inlineFunction4.stable.out
        monetdb5/optimizer/opt_generator.c
        monetdb5/optimizer/opt_macro.c
        monetdb5/optimizer/opt_mergetable.c
        monetdb5/optimizer/opt_mitosis.c
        monetdb5/optimizer/opt_pipes.c
        monetdb5/optimizer/opt_support.c
        monetdb5/tools/Makefile.ag
        sql/backends/monet5/40_sql.mal
        sql/backends/monet5/LSST/80_lsst.mal
        sql/backends/monet5/Makefile.ag
        sql/backends/monet5/Tests/All
        sql/backends/monet5/Tests/pyapi30.stable.out
        sql/backends/monet5/UDF/cudf/80_udf.mal
        sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
        sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
        sql/backends/monet5/UDF/pyapi/Makefile.ag
        sql/backends/monet5/UDF/pyapi/connection.c
        sql/backends/monet5/UDF/pyapi/connection.h
        sql/backends/monet5/UDF/pyapi/formatinput.c
        sql/backends/monet5/UDF/pyapi/formatinput.h
        sql/backends/monet5/UDF/pyapi/pyapi.c
        sql/backends/monet5/UDF/pyapi/pyapi.h
        sql/backends/monet5/UDF/pyapi/pyapi.mal
        sql/backends/monet5/UDF/pyapi/pytypes.h
        sql/backends/monet5/UDF/pyapi/type_conversion.c
        sql/backends/monet5/UDF/pyapi/type_conversion.h
        sql/backends/monet5/generator/90_generator.mal
        sql/backends/monet5/gsl/73_gsl.mal
        sql/backends/monet5/iot/50_iot.mal
        sql/backends/monet5/rel_bin.c
        sql/backends/monet5/sql.c
        sql/backends/monet5/sql.h
        sql/backends/monet5/sql.mal
        sql/backends/monet5/sql_cast.c
        sql/backends/monet5/sql_execute.c
        sql/backends/monet5/sql_gencode.c
        sql/backends/monet5/sql_optimizer.c
        sql/backends/monet5/sql_result.c
        sql/backends/monet5/sql_scenario.c
        sql/backends/monet5/sql_upgrades.c
        sql/backends/monet5/vaults/Makefile.ag
        sql/backends/monet5/vaults/bam/85_bam.mal
        sql/backends/monet5/vaults/fits/72_fits.mal
        sql/backends/monet5/vaults/fits/Makefile.ag
        sql/backends/monet5/vaults/lidar/75_lidar.mal
        sql/backends/monet5/vaults/lidar/Makefile.ag
        sql/backends/monet5/vaults/netcdf/74_netcdf.mal
        sql/backends/monet5/vaults/netcdf/Makefile.ag
        sql/backends/monet5/vaults/shp/75_shp.mal
        sql/backends/monet5/vaults/shp/Makefile.ag
        sql/benchmarks/ssbm/Tests/01-explain.stable.out
        sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/02-explain.stable.out
        sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/03-explain.stable.out
        sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/04-explain.stable.out
        sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/05-explain.stable.out
        sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/06-explain.stable.out
        sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/07-explain.stable.out
        sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/08-explain.stable.out
        sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/09-explain.stable.out
        sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/10-explain.stable.out
        sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/11-explain.stable.out
        sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/12-explain.stable.out
        sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
        sql/benchmarks/ssbm/Tests/13-explain.stable.out
        sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/02-explain.stable.out
        sql/benchmarks/tpch/Tests/03-explain.stable.out
        sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/04-explain.stable.out
        sql/benchmarks/tpch/Tests/05-explain.stable.out
        sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/07-explain.stable.out
        sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/08-explain.stable.out
        sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/09-explain.stable.out
        sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/11-explain.stable.out
        sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/12-explain.stable.out
        sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/13-explain.stable.out
        sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/15-explain.stable.out
        sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/16-explain.stable.out
        sql/benchmarks/tpch/Tests/17-explain.stable.out
        sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/18-explain.stable.out
        sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/19-explain.stable.out
        sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/20-explain.stable.out
        sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
        sql/benchmarks/tpch/Tests/21-explain.stable.out
        sql/benchmarks/tpch/Tests/22-explain.stable.out
        sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
        sql/include/sql_catalog.h
        sql/scripts/25_debug.sql
        sql/scripts/75_storagemodel.sql
        sql/server/rel_optimizer.c
        sql/server/rel_psm.c
        sql/server/rel_select.c
        sql/server/rel_semantic.c
        sql/server/rel_updates.c
        sql/server/sql_mvc.h
        sql/server/sql_parser.h
        sql/server/sql_parser.y
        sql/server/sql_scan.c
        sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out
        
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
        
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
        sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
        
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
        sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
        sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
        sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
        sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.sql
        sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err
        
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128
        sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out
        
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.out.int128
        sql/test/BugTracker-2016/Tests/querylog.stable.out
        sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.out.int128
        sql/test/copy/Tests/All
        sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
        sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade-chain/Tests/check.stable.out
        sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128
        sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
        sql/test/emptydb-upgrade/Tests/check.stable.out
        sql/test/emptydb-upgrade/Tests/check.stable.out.int128
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out
        sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.int128
        sql/test/emptydb/updatetests
        sql/test/leaks/Tests/check0.stable.out
        sql/test/leaks/Tests/check0.stable.out.int128
        sql/test/leaks/Tests/check1.stable.out
        sql/test/leaks/Tests/check1.stable.out.int128
        sql/test/leaks/Tests/check2.stable.out
        sql/test/leaks/Tests/check2.stable.out.int128
        sql/test/leaks/Tests/check3.stable.out
        sql/test/leaks/Tests/check3.stable.out.int128
        sql/test/leaks/Tests/check4.stable.out
        sql/test/leaks/Tests/check4.stable.out.int128
        sql/test/leaks/Tests/check5.stable.out
        sql/test/leaks/Tests/check5.stable.out.int128
        sql/test/leaks/Tests/drop3.stable.out
        sql/test/leaks/Tests/drop3.stable.out.int128
        sql/test/leaks/Tests/select1.stable.out
        sql/test/leaks/Tests/select1.stable.out.int128
        sql/test/leaks/Tests/select2.stable.out
        sql/test/leaks/Tests/select2.stable.out.int128
        sql/test/leaks/Tests/temp1.stable.out
        sql/test/leaks/Tests/temp1.stable.out.int128
        sql/test/leaks/Tests/temp2.stable.out
        sql/test/leaks/Tests/temp2.stable.out.int128
        sql/test/leaks/Tests/temp3.stable.out
        sql/test/leaks/Tests/temp3.stable.out.int128
        sql/test/malloc_fail/Tests/All
        sql/test/malloc_fail/Tests/setmemorylimit-fail.sql
        sql/test/malloc_fail/Tests/setmemorylimit-fail.stable.err
        sql/test/malloc_fail/Tests/setmemorylimit-fail.stable.out
        sql/test/malloc_fail/Tests/setmemorylimit-fail2.sql
        sql/test/malloc_fail/Tests/setmemorylimit.sql
        sql/test/mergetables/Tests/mergequery.stable.out
        sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out
        sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
        sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
        sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out
        sql/test/testdb-upgrade/Tests/upgrade.stable.out
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
        testing/Mtest.py.in
        tools/mserver/mserver5.c
Branch: iot
Log Message:

Merge with default


diffs (truncated from 20120 to 300 lines):

diff --git a/NT/rules.msc b/NT/rules.msc
--- a/NT/rules.msc
+++ b/NT/rules.msc
@@ -351,14 +351,8 @@ create_winconfig_conds_new_py:
        $(ECHO) HAVE_LIBBZ2_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
 !ENDIF
 !IFDEF HAVE_LIBPY
-!IFDEF HAVE_LIBPANDAS
-       $(ECHO) HAVE_LIBPANDAS_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ELSE
-       $(ECHO) HAVE_LIBPANDAS_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
-!ENDIF
        $(ECHO) HAVE_LIBPY_FALSE='#' >> "$(TOPDIR)\winconfig_conds_new.py"
 !ELSE
-       $(ECHO) HAVE_LIBPANDAS_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
        $(ECHO) HAVE_LIBPY_FALSE='' >> "$(TOPDIR)\winconfig_conds_new.py"
 !ENDIF
 !IFDEF HAVE_LIBR
diff --git a/clients/Tests/MAL-signatures.malC 
b/clients/Tests/MAL-signatures.malC
deleted file mode 100644
--- a/clients/Tests/MAL-signatures.malC
+++ /dev/null
@@ -1,1 +0,0 @@
-?*)
diff --git a/clients/Tests/MAL-signatures.sql b/clients/Tests/MAL-signatures.sql
new file mode 100644
--- /dev/null
+++ b/clients/Tests/MAL-signatures.sql
@@ -0,0 +1,1 @@
+select * from sys.malfunctions() order by module, "function", address, 
signature, comment;
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
@@ -828,7 +828,7 @@ CREATE TABLE "sys"."schemas" ("id" INTEG
 CREATE TABLE "sys"."sequences" ("id" INTEGER, "schema_id" INTEGER, "name" 
VARCHAR(256), "start" BIGINT, "minvalue" BIGINT, "maxvalue" BIGINT, "increment" 
BIGINT, "cacheinc" BIGINT, "cycle" BOOLEAN);
 CREATE TABLE "sys"."spatial_ref_sys" ("srid" INTEGER NOT NULL, "auth_name" 
VARCHAR(256), "auth_srid" INTEGER, "srtext" VARCHAR(2048), "proj4text" 
VARCHAR(2048), CONSTRAINT "spatial_ref_sys_srid_pkey" PRIMARY KEY ("srid"));
 CREATE TABLE "sys"."statistics" ("column_id" INTEGER, "type" CHARACTER LARGE 
OBJECT, "width" INTEGER, "stamp" TIMESTAMP, "sample" BIGINT, "count" BIGINT, 
"unique" BIGINT, "nils" BIGINT, "minval" CHARACTER LARGE OBJECT, "maxval" 
CHARACTER LARGE OBJECT, "sorted" BOOLEAN);
-CREATE TABLE "sys"."storagemodelinput" ("schema" CHARACTER LARGE OBJECT, 
"table" CHARACTER LARGE OBJECT, "column" CHARACTER LARGE OBJECT, "type" 
CHARACTER LARGE OBJECT, "typewidth" INTEGER, "count" BIGINT, "distinct" BIGINT, 
"atomwidth" INTEGER, "reference" BOOLEAN, "sorted" BOOLEAN, "orderidx" BIGINT);
+CREATE TABLE "sys"."storagemodelinput" ("schema" CHARACTER LARGE OBJECT, 
"table" CHARACTER LARGE OBJECT, "column" CHARACTER LARGE OBJECT, "type" 
CHARACTER LARGE OBJECT, "typewidth" INTEGER, "count" BIGINT, "distinct" BIGINT, 
"atomwidth" INTEGER, "reference" BOOLEAN, "sorted" BOOLEAN, "revsorted" 
BOOLEAN, "unique" BOOLEAN, "orderidx" BIGINT);
 CREATE TABLE "sys"."systemfunctions" ("function_id" INTEGER);
 CREATE TABLE "sys"."table_types" ("table_type_id" SMALLINT NOT NULL, 
"table_type_name" VARCHAR(25) NOT NULL, CONSTRAINT 
"table_types_table_type_id_pkey" PRIMARY KEY ("table_type_id"), CONSTRAINT 
"table_types_table_type_name_unique" UNIQUE ("table_type_name"));
 CREATE TABLE "sys"."triggers" ("id" INTEGER, "name" VARCHAR(1024), "table_id" 
INTEGER, "time" SMALLINT, "orientation" SMALLINT, "event" SMALLINT, "old_name" 
VARCHAR(1024), "new_name" VARCHAR(1024), "condition" VARCHAR(2048), "statement" 
VARCHAR(2048));
@@ -958,7 +958,7 @@ create filter function "like"(val string
 
 create procedure listdir(dirname string) external name fits.listdir;
 create procedure listdirpat(dirname string,pat string) external name 
fits.listdirpattern;
-create function sys.malfunctions() returns table("signature" string, "address" 
string, "comment" string) external name "manual"."functions";
+create function sys.malfunctions() returns table("module" string, "function" 
string, "signature" string, "address" string, "comment" string) external name 
"manual"."functions";
 create function "masklen" (p inet) returns int external name inet."masklen";
 create function mbr(geom geometry) returns mbr external name geom."mbr";
 create function sys.md5(v string) returns string external name clients.md5sum;
@@ -1162,12 +1162,12 @@ create aggregate stddev_samp(val time) r
 create aggregate stddev_samp(val timestamp) returns double external name 
"aggr"."stdev";
 create procedure sys.stop(tag int) external name sql.sysmon_stop;
 create procedure sys.stop(tag bigint) external name sql.sysmon_stop;
-create function sys."storage"() returns table ("schema" string, "table" 
string, "column" string, "type" string, "mode" string, location string, "count" 
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash 
boolean, "imprints" bigint, sorted boolean, orderidx bigint) external name 
sql."storage";
-create function sys."storage"(sname string) returns table ("schema" string, 
"table" string, "column" string, "type" string, "mode" string, location string, 
"count" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes 
bigint, phash boolean, "imprints" bigint, sorted boolean, orderidx bigint) 
external name sql."storage";
-create function sys."storage"(sname string, tname string) returns table 
("schema" string, "table" string, "column" string, "type" string, "mode" 
string, location string, "count" bigint, typewidth int, columnsize bigint, 
heapsize bigint, hashes bigint, phash boolean, "imprints" bigint, sorted 
boolean, orderidx bigint) external name sql."storage";
-create function sys."storage"(sname string, tname string, cname string) 
returns table ("schema" string, "table" string, "column" string, "type" string, 
"mode" string, location string, "count" bigint, typewidth int, columnsize 
bigint, heapsize bigint, hashes bigint, phash boolean, "imprints" bigint, 
sorted boolean, orderidx bigint) external name sql."storage";
-create function sys.storagemodel() returns table ("schema" string, "table" 
string, "column" string, "type" string, "count" bigint, columnsize bigint, 
heapsize bigint, hashes bigint, "imprints" bigint, sorted boolean, orderidx 
bigint) begin return select i."schema", i."table", i."column", i."type", 
i."count", columnsize(i."type", i.count, i."distinct"), heapsize(i."type", 
i."distinct", i."atomwidth"), hashsize(i."reference", i."count"), 
imprintsize(i."count",i."type"), i.sorted, i.orderidx from 
sys.storagemodelinput i; end;
-create procedure sys.storagemodelinit() begin delete from 
sys.storagemodelinput; insert into sys.storagemodelinput select x."schema", 
x."table", x."column", x."type", x.typewidth, x.count, 0, x.typewidth, false, 
x.sorted, x.orderidx from sys."storage"() x; update sys.storagemodelinput set 
reference = true where concat(concat("schema","table"), "column") in (select 
concat(concat("fkschema"."name", "fktable"."name"), "fkkeycol"."name") from 
"sys"."keys" as "fkkey", "sys"."objects" as "fkkeycol", "sys"."tables" as 
"fktable", "sys"."schemas" as "fkschema" where "fktable"."id" = 
"fkkey"."table_id" and "fkkey"."id" = "fkkeycol"."id" and "fkschema"."id" = 
"fktable"."schema_id" and "fkkey"."rkey" > -1); update sys.storagemodelinput 
set "distinct" = "count" where "type" = 'varchar' or "type"='clob'; end;
+create function sys."storage"() returns table ("schema" string, "table" 
string, "column" string, "type" string, "mode" string, location string, "count" 
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash 
boolean, "imprints" bigint, sorted boolean, revsorted boolean, "unique" 
boolean, orderidx bigint) external name sql."storage";
+create function sys."storage"(sname string) returns table ("schema" string, 
"table" string, "column" string, "type" string, "mode" string, location string, 
"count" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes 
bigint, phash boolean, "imprints" bigint, sorted boolean, revsorted boolean, 
"unique" boolean, orderidx bigint) external name sql."storage";
+create function sys."storage"(sname string, tname string) returns table 
("schema" string, "table" string, "column" string, "type" string, "mode" 
string, location string, "count" bigint, typewidth int, columnsize bigint, 
heapsize bigint, hashes bigint, phash boolean, "imprints" bigint, sorted 
boolean, revsorted boolean, "unique" boolean, orderidx bigint) external name 
sql."storage";
+create function sys."storage"(sname string, tname string, cname string) 
returns table ("schema" string, "table" string, "column" string, "type" string, 
"mode" string, location string, "count" bigint, typewidth int, columnsize 
bigint, heapsize bigint, hashes bigint, phash boolean, "imprints" bigint, 
sorted boolean, revsorted boolean, "unique" boolean, orderidx bigint) external 
name sql."storage";
+create function sys.storagemodel() returns table ("schema" string, "table" 
string, "column" string, "type" string, "count" bigint, columnsize bigint, 
heapsize bigint, hashes bigint, "imprints" bigint, sorted boolean, revsorted 
boolean, "unique" boolean, orderidx bigint) begin return select i."schema", 
i."table", i."column", i."type", i."count", columnsize(i."type", i.count, 
i."distinct"), heapsize(i."type", i."distinct", i."atomwidth"), 
hashsize(i."reference", i."count"), imprintsize(i."count",i."type"), i.sorted, 
i.revsorted, i."unique", i.orderidx from sys.storagemodelinput i; end;
+create procedure sys.storagemodelinit() begin delete from 
sys.storagemodelinput; insert into sys.storagemodelinput select x."schema", 
x."table", x."column", x."type", x.typewidth, x.count, 0, x.typewidth, false, 
x.sorted, x.revsorted, x."unique", x.orderidx from sys."storage"() x; update 
sys.storagemodelinput set reference = true where 
concat(concat("schema","table"), "column") in (select 
concat(concat("fkschema"."name", "fktable"."name"), "fkkeycol"."name") from 
"sys"."keys" as "fkkey", "sys"."objects" as "fkkeycol", "sys"."tables" as 
"fktable", "sys"."schemas" as "fkschema" where "fktable"."id" = 
"fkkey"."table_id" and "fkkey"."id" = "fkkeycol"."id" and "fkschema"."id" = 
"fktable"."schema_id" and "fkkey"."rkey" > -1); update sys.storagemodelinput 
set "distinct" = "count" where "type" = 'varchar' or "type"='clob'; end;
 create function str_to_date(s string, format string) returns date external 
name mtime."str_to_date";
 create function str_to_time(s string, format string) returns time external 
name mtime."str_to_time";
 create function str_to_timestamp(s string, format string) returns timestamp 
external name mtime."str_to_timestamp";
@@ -1656,7 +1656,9 @@ drop function pcre_replace(string, strin
 [ "storage",   "phash",        "boolean",      1,      0,      NULL,   true,   
11,     NULL    ]
 [ "storage",   "imprints",     "bigint",       64,     0,      NULL,   true,   
12,     NULL    ]
 [ "storage",   "sorted",       "boolean",      1,      0,      NULL,   true,   
13,     NULL    ]
-[ "storage",   "orderidx",     "bigint",       64,     0,      NULL,   true,   
14,     NULL    ]
+[ "storage",   "revsorted",    "boolean",      1,      0,      NULL,   true,   
14,     NULL    ]
+[ "storage",   "unique",       "boolean",      1,      0,      NULL,   true,   
15,     NULL    ]
+[ "storage",   "orderidx",     "bigint",       64,     0,      NULL,   true,   
16,     NULL    ]
 [ "storagemodel",      "schema",       "clob", 0,      0,      NULL,   true,   
0,      NULL    ]
 [ "storagemodel",      "table",        "clob", 0,      0,      NULL,   true,   
1,      NULL    ]
 [ "storagemodel",      "column",       "clob", 0,      0,      NULL,   true,   
2,      NULL    ]
@@ -1667,7 +1669,9 @@ drop function pcre_replace(string, strin
 [ "storagemodel",      "hashes",       "bigint",       64,     0,      NULL,   
true,   7,      NULL    ]
 [ "storagemodel",      "imprints",     "bigint",       64,     0,      NULL,   
true,   8,      NULL    ]
 [ "storagemodel",      "sorted",       "boolean",      1,      0,      NULL,   
true,   9,      NULL    ]
-[ "storagemodel",      "orderidx",     "bigint",       64,     0,      NULL,   
true,   10,     NULL    ]
+[ "storagemodel",      "revsorted",    "boolean",      1,      0,      NULL,   
true,   10,     NULL    ]
+[ "storagemodel",      "unique",       "boolean",      1,      0,      NULL,   
true,   11,     NULL    ]
+[ "storagemodel",      "orderidx",     "bigint",       64,     0,      NULL,   
true,   12,     NULL    ]
 [ "storagemodelinput", "schema",       "clob", 0,      0,      NULL,   true,   
0,      NULL    ]
 [ "storagemodelinput", "table",        "clob", 0,      0,      NULL,   true,   
1,      NULL    ]
 [ "storagemodelinput", "column",       "clob", 0,      0,      NULL,   true,   
2,      NULL    ]
@@ -1678,7 +1682,9 @@ drop function pcre_replace(string, strin
 [ "storagemodelinput", "atomwidth",    "int",  32,     0,      NULL,   true,   
7,      NULL    ]
 [ "storagemodelinput", "reference",    "boolean",      1,      0,      NULL,   
true,   8,      NULL    ]
 [ "storagemodelinput", "sorted",       "boolean",      1,      0,      NULL,   
true,   9,      NULL    ]
-[ "storagemodelinput", "orderidx",     "bigint",       64,     0,      NULL,   
true,   10,     NULL    ]
+[ "storagemodelinput", "revsorted",    "boolean",      1,      0,      NULL,   
true,   10,     NULL    ]
+[ "storagemodelinput", "unique",       "boolean",      1,      0,      NULL,   
true,   11,     NULL    ]
+[ "storagemodelinput", "orderidx",     "bigint",       64,     0,      NULL,   
true,   12,     NULL    ]
 [ "systemfunctions",   "function_id",  "int",  32,     0,      NULL,   true,   
0,      NULL    ]
 [ "table_types",       "table_type_id",        "smallint",     16,     0,      
NULL,   false,  0,      NULL    ]
 [ "table_types",       "table_type_name",      "varchar",      25,     0,      
NULL,   false,  1,      NULL    ]
@@ -1759,7 +1765,7 @@ drop function pcre_replace(string, strin
 % .s,  .f,     .L,     .f,     .f,     .f,     .f,     .f,     .f # table_name
 % name,        name,   query,  mod,    language,       type,   side_effect,    
varres, vararg # name
 % varchar,     varchar,        varchar,        varchar,        int,    int,    
boolean,        boolean,        boolean # type
-% 8,   35,     806,    9,      1,      1,      5,      5,      5 # length
+% 8,   35,     831,    9,      1,      1,      5,      5,      5 # length
 [ "bam",       "bam_drop_file",        "create procedure 
bam.bam_drop_file(file_id bigint, dbschema smallint) external name 
bam.bam_drop_file;",       "bam",  1,      2,      true,   false,  false   ]
 [ "bam",       "bam_export",   "create procedure bam.bam_export(output_path 
string) external name bam.bam_export;",    "bam",  1,      2,      true,   
false,  false   ]
 [ "bam",       "bam_flag",     "create function bam.bam_flag(flag smallint, 
name string) returns boolean external name bam.bam_flag;", "bam",  1,      1,   
   false,  false,  false   ]
@@ -2136,7 +2142,7 @@ drop function pcre_replace(string, strin
 [ "sys",       "ltrim",        "ltrim",        "str",  0,      1,      false,  
false,  false   ]
 [ "sys",       "ltrim",        "ltrim",        "str",  0,      1,      false,  
false,  false   ]
 [ "sys",       "ltrim",        "ltrim",        "str",  0,      1,      false,  
false,  false   ]
-[ "sys",       "malfunctions", "create function sys.malfunctions() returns 
table(\"signature\" string, \"address\" string, \"comment\" string) external 
name \"manual\".\"functions\";",       "manual",       1,      5,      false,  
false,  false   ]
+[ "sys",       "malfunctions", "create function sys.malfunctions() returns 
table(\"module\" string, \"function\" string, \"signature\" string, \"address\" 
string, \"comment\" string) external name \"manual\".\"functions\";",       
"manual",       1,      5,      false,  false,  false   ]
 [ "sys",       "masklen",      "create function \"masklen\" (p inet) returns 
int external name inet.\"masklen\";",     "inet", 1,      1,      false,  
false,  false   ]
 [ "sys",       "max",  "max",  "aggr", 0,      3,      false,  false,  false   
]
 [ "sys",       "mbr",  "create function mbr(geom geometry) returns mbr 
external name geom.\"mbr\";",   "geom", 1,      1,      false,  false,  false   
]
@@ -3234,12 +3240,12 @@ drop function pcre_replace(string, strin
 [ "sys",       "stddev_samp",  "create aggregate stddev_samp(val tinyint) 
returns double external name \"aggr\".\"stdev\";",   "aggr", 1,      3,      
false,  false,  false   ]
 [ "sys",       "stop", "create procedure sys.stop(tag bigint) external name 
sql.sysmon_stop;", "sql",  1,      2,      true,   false,  false   ]
 [ "sys",       "stop", "create procedure sys.stop(tag int) external name 
sql.sysmon_stop;",    "sql",  1,      2,      true,   false,  false   ]
-[ "sys",       "storage",      "create function sys.\"storage\"() returns 
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string, 
\"mode\" string, location string, \"count\" bigint, typewidth int, columnsize 
bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" bigint, 
sorted boolean, orderidx bigint) external name sql.\"storage\";",  "sql",  1,   
   5,      false,  false,  false   ]
-[ "sys",       "storage",      "create function sys.\"storage\"(sname string) 
returns table (\"schema\" string, \"table\" string, \"column\" string, \"type\" 
string, \"mode\" string, location string, \"count\" bigint, typewidth int, 
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" 
bigint, sorted boolean, orderidx bigint) external name sql.\"storage\";",      
"sql",  1,      5,      false,  false,  false   ]
-[ "sys",       "storage",      "create function sys.\"storage\"(sname string, 
tname string) returns table (\"schema\" string, \"table\" string, \"column\" 
string, \"type\" string, \"mode\" string, location string, \"count\" bigint, 
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash 
boolean, \"imprints\" bigint, sorted boolean, orderidx bigint) external name 
sql.\"storage\";",        "sql",  1,      5,      false,  false,  false   ]
-[ "sys",       "storage",      "create function sys.\"storage\"(sname string, 
tname string, cname string) returns table (\"schema\" string, \"table\" string, 
\"column\" string, \"type\" string, \"mode\" string, location string, \"count\" 
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash 
boolean, \"imprints\" bigint, sorted boolean, orderidx bigint) external name 
sql.\"storage\";",  "sql",  1,      5,      false,  false,  false   ]
-[ "sys",       "storagemodel", "create function sys.storagemodel() returns 
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string, 
\"count\" bigint, columnsize bigint, heapsize bigint, hashes bigint, 
\"imprints\" bigint, sorted boolean, orderidx bigint) begin return select 
i.\"schema\", i.\"table\", i.\"column\", i.\"type\", i.\"count\", 
columnsize(i.\"type\", i.count, i.\"distinct\"), heapsize(i.\"type\", 
i.\"distinct\", i.\"atomwidth\"), hashsize(i.\"reference\", i.\"count\"), 
imprintsize(i.\"count\",i.\"type\"), i.sorted, i.orderidx from 
sys.storagemodelinput i; end;",     "user", 2,      5,      false,  false,  
false   ]
-[ "sys",       "storagemodelinit",     "create procedure 
sys.storagemodelinit() begin delete from sys.storagemodelinput; insert into 
sys.storagemodelinput select x.\"schema\", x.\"table\", x.\"column\", 
x.\"type\", x.typewidth, x.count, 0, x.typewidth, false, x.sorted, x.orderidx 
from sys.\"storage\"() x; update sys.storagemodelinput set reference = true 
where concat(concat(\"schema\",\"table\"), \"column\") in (select 
concat(concat(\"fkschema\".\"name\", \"fktable\".\"name\"), 
\"fkkeycol\".\"name\") from \"sys\".\"keys\" as \"fkkey\", \"sys\".\"objects\" 
as \"fkkeycol\", \"sys\".\"tables\" as \"fktable\", \"sys\".\"schemas\" as 
\"fkschema\" where \"fktable\".\"id\" = \"fkkey\".\"table_id\" and 
\"fkkey\".\"id\" = \"fkkeycol\".\"id\" and \"fkschema\".\"id\" = 
\"fktable\".\"schema_id\" and \"fkkey\".\"rkey\" > -1); update 
sys.storagemodelinput set \"distinct\" = \"count\" where \"type\" = 'varchar' 
or \"type\"='clob'; end;",       "user", 2,      2,      true,   false,  false  
 ]
+[ "sys",       "storage",      "create function sys.\"storage\"() returns 
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string, 
\"mode\" string, location string, \"count\" bigint, typewidth int, columnsize 
bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" bigint, 
sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint) 
external name sql.\"storage\";",   "sql",  1,      5,      false,  false,  
false   ]
+[ "sys",       "storage",      "create function sys.\"storage\"(sname string) 
returns table (\"schema\" string, \"table\" string, \"column\" string, \"type\" 
string, \"mode\" string, location string, \"count\" bigint, typewidth int, 
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" 
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint) 
external name sql.\"storage\";",       "sql",  1,      5,      false,  false,  
false   ]
+[ "sys",       "storage",      "create function sys.\"storage\"(sname string, 
tname string) returns table (\"schema\" string, \"table\" string, \"column\" 
string, \"type\" string, \"mode\" string, location string, \"count\" bigint, 
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash 
boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" 
boolean, orderidx bigint) external name sql.\"storage\";", "sql",  1,      5,   
   false,  false,  false   ]
+[ "sys",       "storage",      "create function sys.\"storage\"(sname string, 
tname string, cname string) returns table (\"schema\" string, \"table\" string, 
\"column\" string, \"type\" string, \"mode\" string, location string, \"count\" 
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash 
boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" 
boolean, orderidx bigint) external name sql.\"storage\";",   "sql",  1,      5, 
     false,  false,  false   ]
+[ "sys",       "storagemodel", "create function sys.storagemodel() returns 
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string, 
\"count\" bigint, columnsize bigint, heapsize bigint, hashes bigint, 
\"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" boolean, 
orderidx bigint) begin return select i.\"schema\", i.\"table\", i.\"column\", 
i.\"type\", i.\"count\", columnsize(i.\"type\", i.count, i.\"distinct\"), 
heapsize(i.\"type\", i.\"distinct\", i.\"atomwidth\"), 
hashsize(i.\"reference\", i.\"count\"), imprintsize(i.\"count\",i.\"type\"), 
i.sorted, i.revsorted, i.\"unique\", i.orderidx from sys.storagemodelinput i; 
end;",   "user", 2,      5,      false,  false,  false   ]
+[ "sys",       "storagemodelinit",     "create procedure 
sys.storagemodelinit() begin delete from sys.storagemodelinput; insert into 
sys.storagemodelinput select x.\"schema\", x.\"table\", x.\"column\", 
x.\"type\", x.typewidth, x.count, 0, x.typewidth, false, x.sorted, x.revsorted, 
x.\"unique\", x.orderidx from sys.\"storage\"() x; update sys.storagemodelinput 
set reference = true where concat(concat(\"schema\",\"table\"), \"column\") in 
(select concat(concat(\"fkschema\".\"name\", \"fktable\".\"name\"), 
\"fkkeycol\".\"name\") from \"sys\".\"keys\" as \"fkkey\", \"sys\".\"objects\" 
as \"fkkeycol\", \"sys\".\"tables\" as \"fktable\", \"sys\".\"schemas\" as 
\"fkschema\" where \"fktable\".\"id\" = \"fkkey\".\"table_id\" and 
\"fkkey\".\"id\" = \"fkkeycol\".\"id\" and \"fkschema\".\"id\" = 
\"fktable\".\"schema_id\" and \"fkkey\".\"rkey\" > -1); update 
sys.storagemodelinput set \"distinct\" = \"count\" where \"type\" = 'varchar' 
or \"type\"='clob'; end;",    "user", 2,      2,      true,   false,  false   ]
 [ "sys",       "str_to_date",  "create function str_to_date(s string, format 
string) returns date external name mtime.\"str_to_date\";",       "mtime",      
  1,      1,      false,  false,  false   ]
 [ "sys",       "str_to_time",  "create function str_to_time(s string, format 
string) returns time external name mtime.\"str_to_time\";",       "mtime",      
  1,      1,      false,  false,  false   ]
 [ "sys",       "str_to_timestamp",     "create function str_to_timestamp(s 
string, format string) returns timestamp external name 
mtime.\"str_to_timestamp\";",        "mtime",        1,      1,      false,  
false,  false   ]
@@ -3332,7 +3338,7 @@ drop function pcre_replace(string, strin
 % sys.s,       sys.f,  .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, 
.arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16, .arg16 # table_name
 % name,        name,   name1,  type1,  type_digits1,   type_scale1,    inout1, 
name2,  type2,  type_digits2,   type_scale2,    inout2, name3,  type3,  
type_digits3,   type_scale3,    inout3, name4,  type4,  type_digits4,   
type_scale4,    inout4, name5,  type5,  type_digits5,   type_scale5,    inout5, 
name6,  type6,  type_digits6,   type_scale6,    inout6, name7,  type7,  
type_digits7,   type_scale7,    inout7, name8,  type8,  type_digits8,   
type_scale8,    inout8, name9,  type9,  type_digits9,   type_scale9,    inout9, 
name10, type10, type_digits10,  type_scale10,   inout10,        name11, type11, 
type_digits11,  type_scale11,   inout11,        name12, type12, type_digits12,  
type_scale12,   inout12,        name13, type13, type_digits13,  type_scale13,   
inout13,        name14, type14, type_digits14,  type_scale14,   inout14,        
name15, type15, type_digits15,  type_scale15,   inout15 # name
 % varchar,     varchar,        varchar,        varchar,        int,    int,    
tinyint,        varchar,        varchar,        int,    int,    tinyint,        
varchar,        varchar,        int,    int,    tinyint,        varchar,        
varchar,        int,    int,    tinyint,        varchar,        varchar,        
int,    int,    tinyint,        varchar,        varchar,        int,    int,    
tinyint,        varchar,        varchar,        int,    int,    tinyint,        
varchar,        varchar,        int,    int,    tinyint,        varchar,        
varchar,        int,    int,    tinyint,        varchar,        varchar,        
int,    int,    tinyint,        varchar,        varchar,        int,    int,    
tinyint,        varchar,        varchar,        int,    int,    tinyint,        
varchar,        varchar,        int,    int,    tinyint,        varchar,        
varchar,        int,    int,    tinyint,        varchar,        varchar,        
int,    int,    tinyint # type
-% 8,   35,     16,     14,     4,      1,      1,      16,     14,     2,      
1,      1,      27,     12,     2,      1,      1,      12,     7,      2,      
1,      1,      10,     7,      2,      1,      1,      8,      7,      2,      
1,      1,      9,      6,      2,      1,      1,      10,     6,      2,      
1,      1,      8,      7,      2,      1,      1,      8,      7,      2,      
1,      1,      5,      7,      2,      1,      1,      8,      6,      2,      
1,      1,      6,      7,      1,      1,      1,      8,      6,      2,      
1,      1,      5,      4,      1,      1,      1 # length
+% 8,   35,     16,     14,     4,      1,      1,      16,     14,     2,      
1,      1,      27,     12,     2,      1,      1,      12,     7,      2,      
1,      1,      10,     7,      2,      1,      1,      8,      7,      2,      
1,      1,      9,      6,      2,      1,      1,      10,     6,      2,      
1,      1,      8,      7,      2,      1,      1,      9,      7,      2,      
1,      1,      6,      7,      2,      1,      1,      8,      6,      2,      
1,      1,      6,      7,      1,      1,      1,      9,      7,      1,      
1,      1,      6,      7,      1,      1,      1 # length
 [ "bam",       "bam_drop_file",        "dbschema",     "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,   NULL,   NULL,   NULL,   
NULL,   NULL    ]
 [ "bam",       "bam_export",   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,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "bam",       "bam_flag",     "flag", "smallint",     16,     0,      1,      
"name", "clob", 0,      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    
]
@@ -3709,7 +3715,7 @@ drop function pcre_replace(string, strin
 [ "sys",       "ltrim",        "arg_1",        "clob", 0,      0,      1,      
"arg_2",        "clob", 0,      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",       "ltrim",        "arg_1",        "varchar",      0,      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,   NULL,   NULL,   NULL,   NULL,   
NULL    ]
 [ "sys",       "ltrim",        "arg_1",        "varchar",      0,      0,      
1,      "arg_2",        "varchar",      0,      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",       "malfunctions", "address",      "clob", 0,      0,      0,      
"comment",      "clob", 0,      0,      0,      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",       "malfunctions", "function",     "clob", 0,      0,      0,      
"signature",    "clob", 0,      0,      0,      "address",      "clob", 0,      
0,      0,      "comment",      "clob", 0,      0,      0,      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",       "masklen",      "p",    "inet", 0,      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,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys",       "max",  "arg",  "any",  0,      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,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys",       "mbr",  "geom", "geometry",     0,      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,   NULL,   NULL,   NULL,   NULL,   NULL    ]
@@ -4807,11 +4813,11 @@ drop function pcre_replace(string, strin
 [ "sys",       "stddev_samp",  "val",  "tinyint",      8,      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,   NULL,   NULL,   NULL,   NULL,   NULL    
]
 [ "sys",       "stop", 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,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys",       "stop", 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,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
-[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"orderidx",     "bigint",       64,     0,      0,      NULL,   NULL,   NULL,   
NULL,   NULL    ]
-[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"orderidx",     "bigint",       64,     0,      0,      "sname",        "clob", 
0,      0,      1       ]
-[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"orderidx",     "bigint",       64,     0,      0,      "sname",        "clob", 
0,      0,      1       ]
-[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"orderidx",     "bigint",       64,     0,      0,      "sname",        "clob", 
0,      0,      1       ]
-[ "sys",       "storagemodel", "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "count",        "bigint",       64,     0,      0,      "columnsize",   
"bigint",       64,     0,      0,      "heapsize",     "bigint",       64,     
0,      0,      "hashes",       "bigint",       64,     0,      0,      
"imprints",     "bigint",       64,     0,      0,      "sorted",       
"boolean",      1,      0,      0,      "orderidx",     "bigint",       64,     
0,      0,      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",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"revsorted",    "boolean",      1,      0,      0,      "unique",       
"boolean",      1,      0,      0       ]
+[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"revsorted",    "boolean",      1,      0,      0,      "unique",       
"boolean",      1,      0,      0       ]
+[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"revsorted",    "boolean",      1,      0,      0,      "unique",       
"boolean",      1,      0,      0       ]
+[ "sys",       "storage",      "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "mode", "clob", 0,      0,      0,      "location",     "clob", 0,      
0,      0,      "count",        "bigint",       64,     0,      0,      
"typewidth",    "int",  32,     0,      0,      "columnsize",   "bigint",       
64,     0,      0,      "heapsize",     "bigint",       64,     0,      0,      
"hashes",       "bigint",       64,     0,      0,      "phash",        
"boolean",      1,      0,      0,      "imprints",     "bigint",       64,     
0,      0,      "sorted",       "boolean",      1,      0,      0,      
"revsorted",    "boolean",      1,      0,      0,      "unique",       
"boolean",      1,      0,      0       ]
+[ "sys",       "storagemodel", "table",        "clob", 0,      0,      0,      
"column",       "clob", 0,      0,      0,      "type", "clob", 0,      0,      
0,      "count",        "bigint",       64,     0,      0,      "columnsize",   
"bigint",       64,     0,      0,      "heapsize",     "bigint",       64,     
0,      0,      "hashes",       "bigint",       64,     0,      0,      
"imprints",     "bigint",       64,     0,      0,      "sorted",       
"boolean",      1,      0,      0,      "revsorted",    "boolean",      1,      
0,      0,      "unique",       "boolean",      1,      0,      0,      
"orderidx",     "bigint",       64,     0,      0,      NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL    ]
 [ "sys",       "storagemodelinit",     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,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL    
]
 [ "sys",       "str_to_date",  "s",    "clob", 0,      0,      1,      
"format",       "clob", 0,      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",       "str_to_time",  "s",    "clob", 0,      0,      1,      
"format",       "clob", 0,      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    ]
@@ -5076,21 +5082,25 @@ drop function pcre_replace(string, strin
 [ "sys",       "storagemodelinput",    "distinct",     "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "orderidx",     "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "reference",    "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
+[ "sys",       "storagemodelinput",    "revsorted",    "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "schema",       "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "sorted",       "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "table",        "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "type", "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
+[ "sys",       "storagemodelinput",    "unique",       "sys",  "storagemodel", 
"FUNC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "atomwidth",    "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "column",       "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "count",        "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "distinct",     "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "orderidx",     "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "reference",    "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
+[ "sys",       "storagemodelinput",    "revsorted",    "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "schema",       "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "sorted",       "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "table",        "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "type", "sys",  "storagemodelinit",     
"PROC_DEPENDENCY"       ]
 [ "sys",       "storagemodelinput",    "typewidth",    "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
+[ "sys",       "storagemodelinput",    "unique",       "sys",  
"storagemodelinit",     "PROC_DEPENDENCY"       ]
 #select s1.name, f1.name, s2.name, t2.name, dt.name from (values (1, 
'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 
'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 
'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 
'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 
'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as 
dt (id, name), schemas s1, functions f1, schemas s2, _tables t2, dependencies d 
where d.depend_type = dt.id and d.id = f1.id and f1.schema_id = s1.id and 
d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, 
s1.name, f1.name;
 % sys.s1,      sys.f1, sys.s2, sys.t2, .dt # table_name
 % name,        name,   name,   name,   name # name
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
@@ -177,11 +177,8 @@ BAT *BATunique(BAT *b, BAT *s);
 BBPrec *BBP[N_BBPINIT];
 void BBPaddfarm(const char *dirname, int rolemask);
 void BBPclear(bat bid);
-void BBPcold(bat b);
-int BBPcurstamp(void);
 int BBPdecref(bat b, int logical);
 BAT *BBPdescriptor(bat b);
-void BBPhot(bat b);
 int BBPin;
 int BBPincref(bat b, int logical);
 bat BBPindex(const char *nme);
@@ -907,7 +904,6 @@ str CLTquit(Client cntxt, MalBlkPtr mb, 
 str CLTremoveUser(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
 str CLTripemd160sum(str *ret, str *pw);
 str CLTsessions(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
-str CLTsetHistory(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
 str CLTsetListing(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
 str CLTsetPassword(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
 str CLTsetScenario(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
@@ -976,7 +972,6 @@ str CMDbbp(bat *ID, bat *NS, bat *TT, ba
 str CMDbbpCount(bat *ret);
 str CMDbbpDirty(bat *ret);
 str CMDbbpDiskSpace(lng *ret);
-str CMDbbpHeat(bat *ret);
 str CMDbbpKind(bat *ret);
 str CMDbbpLRefCount(bat *ret);
 str CMDbbpLocation(bat *ret);
@@ -1284,7 +1279,6 @@ str MANIFOLDevaluate(Client cntxt, MalBl
 str MANIFOLDremapMultiplex(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr 
p);
 MALfcn MANIFOLDtypecheck(Client cntxt, MalBlkPtr mb, InstrPtr pci);
 str MANUALcreateOverview(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr 
pci);
-str MANUALhelp(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci);
 str MATHbinary_ATAN2dbl(dbl *res, const dbl *a, const dbl *b);
 str MATHbinary_ATAN2flt(flt *res, const flt *a, const flt *b);
 str MATHbinary_POWdbl(dbl *res, const dbl *a, const dbl *b);
@@ -2032,14 +2026,11 @@ void deleteSymbol(Module scope, Symbol p
 str deltaRef;
 str dense_rankRef;
 str depositRef;
-void deriveModule(Module scope, str nme);
 malType destinationType(MalBlkPtr mb, InstrPtr p);
 str diffRef;
 str disconnectRef;
 str divRef;
 void dumpExceptionsToStream(stream *out, str msg);
-void dumpHelpTable(stream *f, Module s, str text, int flag);
-void dumpSearchTable(stream *f, str text);
 str eqRef;
 str errorRef;
 str escape_str(str *retval, str s);
@@ -2070,7 +2061,6 @@ void freeException(str);
 void freeInstruction(InstrPtr p);
 void freeMalBlk(MalBlkPtr mb);
 void freeModule(Module cur);
-void freeModuleList(Module cur);
 void freeStack(MalStkPtr stk);
 void freeSymbol(Symbol s);
 void freeSymbolList(Symbol s);
@@ -2080,7 +2070,7 @@ str fstrcmp_impl(dbl *ret, str *string1,
 void garbageCollector(Client cntxt, MalBlkPtr mb, MalStkPtr stk, int flag);
 void garbageElement(Client cntxt, ValPtr v);
 str generatorRef;
-MALfcn getAddress(stream *out, str filename, str modnme, str fcnname, int 
silent);
+MALfcn getAddress(stream *out, str filename, str fcnname, int silent);
 str getArgDefault(MalBlkPtr mb, InstrPtr p, int idx);
 ptr getArgReference(MalStkPtr stk, InstrPtr pci, int k);
 int getAtomIndex(str nme, int len, int deftpe);
@@ -2100,13 +2090,12 @@ enum malexception getExceptionType(str);
 int getFltConstant(MalBlkPtr mb, flt val);
 Scenario getFreeScenario(void);
 Symbol getFunctionSymbol(Module scope, InstrPtr p);
-char **getHelp(Module m, str pat, int flag);
-char **getHelpMatch(char *pat);
 int getHgeConstant(MalBlkPtr mb, hge val);
 int getIntConstant(MalBlkPtr mb, int val);
 int getLngConstant(MalBlkPtr mb, lng val);
 MalBlkPtr getMalBlkHistory(MalBlkPtr mb, int idx);
 lng getMemoryClaim(MalBlkPtr mb, MalStkPtr stk, InstrPtr pci, int i, int flag);
+Module getModuleChain(void);
 str getName(const char *nme);
 str getNameLen(const char *nme, size_t len);
 int getOidConstant(MalBlkPtr mb, oid val);
@@ -2143,7 +2132,6 @@ str ilikesubselectRef;
 str ilikethetasubselectRef;
 str ilikeuselectRef;
 void initHeartbeat(void);
-void initLibraries(void);
 void initNamespace(void);
 void initParser(void);
 void initProfiler(void);
@@ -2172,7 +2160,6 @@ int isFragmentGroup2(InstrPtr q);
 int isIdentifier(str s);
 int isInvariant(MalBlkPtr mb, int pcf, int pcl, int varid);
 int isLikeOp(InstrPtr q);
-int isLoaded(str modulename);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to