Changeset: a0bf81a2be08 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a0bf81a2be08
Added Files:
        monetdb5/modules/mal/Tests/remote13.malC
        sql/jdbc/tests/Tests/Bug_PrepStmtSetString_6382.SQL.bat
        sql/jdbc/tests/Tests/Bug_PrepStmtSetString_6382.SQL.sh
        sql/jdbc/tests/Tests/Bug_PrepStmtSetString_6382.stable.err
        sql/jdbc/tests/Tests/Bug_PrepStmtSetString_6382.stable.out
        sql/test/BugTracker-2017/Tests/case.Bug-6386.sql
        sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.err
        sql/test/BugTracker-2017/Tests/case.Bug-6386.stable.out
        sql/test/BugTracker-2017/Tests/copy_into_crash.Bug-6404.sql
        sql/test/BugTracker-2017/Tests/copy_into_crash.Bug-6404.stable.err
        sql/test/BugTracker-2017/Tests/copy_into_crash.Bug-6404.stable.out
        sql/test/BugTracker-2017/Tests/exists.Bug-6392.sql
        sql/test/BugTracker-2017/Tests/exists.Bug-6392.stable.err
        sql/test/BugTracker-2017/Tests/exists.Bug-6392.stable.out
        sql/test/BugTracker-2017/Tests/null_matches_in_outer.Bug-6398.sql
        sql/test/BugTracker-2017/Tests/null_matches_in_outer.Bug-6398.stable.err
        sql/test/BugTracker-2017/Tests/null_matches_in_outer.Bug-6398.stable.out
        sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.sql
        sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.err
        sql/test/BugTracker-2017/Tests/side-effect.Bug-6397.stable.out
        sql/test/BugTracker-2017/Tests/sqllitelogistest_case.Bug-6335.sql
        
sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err.int128
        
sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.sql
        
sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.err
        
sql/test/BugTracker-2017/Tests/udf_crash_subquery_scalar_paramters.Bug-6399.stable.out
        sql/test/Tests/constant-not-in.sql
        sql/test/Tests/constant-not-in.stable.err
        sql/test/Tests/constant-not-in.stable.out
        
sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out.Windows
Removed Files:
        geom/sql/conformance/Tests/T3.stable.out.int128
Modified Files:
        NT/monetdb_config.h.in
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
        clients/mapiclient/ReadlineTools.c
        clients/mapiclient/eventparser.c
        clients/mapiclient/mclient.c
        clients/mapiclient/mhelp.c
        clients/mapiclient/tomograph.c
        clients/mapilib/mapi.c
        clients/odbc/driver/ODBCConvert.c
        clients/odbc/driver/ODBCUtil.c
        common/options/monet_options.c
        common/stream/stream.c
        common/utils/mutils.c
        common/utils/strptime.c
        configure.ag
        gdk/ChangeLog
        gdk/gdk.h
        gdk/gdk_aggr.c
        gdk/gdk_atoms.c
        gdk/gdk_atoms.h
        gdk/gdk_bat.c
        gdk/gdk_batop.c
        gdk/gdk_bbp.c
        gdk/gdk_calc.c
        gdk/gdk_firstn.c
        gdk/gdk_group.c
        gdk/gdk_hash.c
        gdk/gdk_hash.h
        gdk/gdk_heap.c
        gdk/gdk_imprints.c
        gdk/gdk_join.c
        gdk/gdk_logger.c
        gdk/gdk_orderidx.c
        gdk/gdk_sample.c
        gdk/gdk_select.c
        gdk/gdk_storage.c
        gdk/gdk_unique.c
        gdk/gdk_utils.c
        gdk/gdk_value.c
        geom/lib/libgeom.c
        geom/lib/libgeom.h
        geom/monetdb5/geom.c
        geom/monetdb5/geom.h
        geom/monetdb5/geomBulk.c
        geom/sql/40_geom.sql
        geom/sql/conformance/Tests/T3.stable.out
        monetdb5/ChangeLog
        
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows
        monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out
        
monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows
        monetdb5/extras/rapi/rapi.c
        monetdb5/mal/Tests/dataflow01.malC
        monetdb5/mal/Tests/tst023.malC
        monetdb5/mal/Tests/tst033.malC
        monetdb5/mal/Tests/tst034.malC
        monetdb5/mal/Tests/tst039.malC
        monetdb5/mal/Tests/tst1200.malC
        monetdb5/mal/Tests/tst1200.stable.out
        monetdb5/mal/Tests/tst1203.malC
        monetdb5/mal/Tests/tst1203.stable.out
        monetdb5/mal/Tests/tst1205.malC
        monetdb5/mal/Tests/tst220.malC
        monetdb5/mal/Tests/tst4003.malC
        monetdb5/mal/Tests/tst903.malC
        monetdb5/mal/Tests/tst903.stable.out
        monetdb5/mal/Tests/tst911.malC
        monetdb5/mal/Tests/tst911.stable.out
        monetdb5/mal/Tests/tst912.malC
        monetdb5/mal/mal.h
        monetdb5/mal/mal_atom.c
        monetdb5/mal/mal_atom.h
        monetdb5/mal/mal_authorize.c
        monetdb5/mal/mal_client.c
        monetdb5/mal/mal_client.h
        monetdb5/mal/mal_debugger.c
        monetdb5/mal/mal_exception.c
        monetdb5/mal/mal_instruction.c
        monetdb5/mal/mal_instruction.h
        monetdb5/mal/mal_interpreter.c
        monetdb5/mal/mal_listing.c
        monetdb5/mal/mal_module.c
        monetdb5/mal/mal_parser.c
        monetdb5/mal/mal_profiler.c
        monetdb5/mal/mal_readline.c
        monetdb5/mal/mal_scenario.c
        monetdb5/mal/mal_type.c
        monetdb5/modules/atoms/Tests/inet01.stable.out
        monetdb5/modules/atoms/Tests/json04.stable.out
        monetdb5/modules/atoms/blob.c
        monetdb5/modules/atoms/blob.h
        monetdb5/modules/atoms/color.c
        monetdb5/modules/atoms/color.h
        monetdb5/modules/atoms/identifier.c
        monetdb5/modules/atoms/inet.c
        monetdb5/modules/atoms/json.c
        monetdb5/modules/atoms/json.h
        monetdb5/modules/atoms/mtime.c
        monetdb5/modules/atoms/mtime.h
        monetdb5/modules/atoms/str.c
        monetdb5/modules/atoms/url.c
        monetdb5/modules/atoms/url.h
        monetdb5/modules/atoms/uuid.c
        monetdb5/modules/atoms/xml.c
        monetdb5/modules/atoms/xml.h
        monetdb5/modules/kernel/Tests/select.malC
        monetdb5/modules/kernel/aggr.c
        monetdb5/modules/kernel/algebra.c
        monetdb5/modules/kernel/bat5.c
        monetdb5/modules/kernel/batcolor.c
        monetdb5/modules/kernel/batmmath.c
        monetdb5/modules/kernel/batstr.c
        monetdb5/modules/kernel/group.c
        monetdb5/modules/kernel/group.h
        monetdb5/modules/kernel/group.mal
        monetdb5/modules/kernel/microbenchmark.c
        monetdb5/modules/kernel/mmath.h
        monetdb5/modules/mal/Tests/All
        monetdb5/modules/mal/Tests/mapi01.malC
        monetdb5/modules/mal/Tests/mapi02.malC
        monetdb5/modules/mal/Tests/mapi07.malC
        monetdb5/modules/mal/Tests/remote04.malC
        monetdb5/modules/mal/Tests/remote04.stable.out
        monetdb5/modules/mal/Tests/remote12.malC
        monetdb5/modules/mal/Tests/remote12.stable.err
        monetdb5/modules/mal/Tests/remote12.stable.out
        monetdb5/modules/mal/batExtensions.c
        monetdb5/modules/mal/batcalc.c
        monetdb5/modules/mal/inspect.c
        monetdb5/modules/mal/mal_io.c
        monetdb5/modules/mal/mal_mapi.c
        monetdb5/modules/mal/mat.c
        monetdb5/modules/mal/mdb.c
        monetdb5/modules/mal/oltp.c
        monetdb5/modules/mal/pcre.c
        monetdb5/modules/mal/remote.c
        monetdb5/modules/mal/sample.c
        monetdb5/modules/mal/tablet.c
        monetdb5/modules/mal/tablet.h
        monetdb5/modules/mal/txtsim.c
        monetdb5/modules/mal/wlc.c
        monetdb5/optimizer/Tests/CRexample.malC
        monetdb5/optimizer/Tests/CXexample.malC
        monetdb5/optimizer/Tests/CXexample.stable.out
        monetdb5/optimizer/Tests/FTexample.malC
        monetdb5/optimizer/Tests/GCexample01.stable.out
        monetdb5/optimizer/Tests/dataflow.malC
        monetdb5/optimizer/Tests/dataflow.stable.out
        monetdb5/optimizer/Tests/mat00.malC
        monetdb5/optimizer/Tests/mat01.malC
        monetdb5/optimizer/Tests/qep00.malC
        monetdb5/optimizer/Tests/qep01.malC
        monetdb5/optimizer/Tests/qep02.malC
        monetdb5/optimizer/Tests/reorder00.malC
        monetdb5/optimizer/Tests/reorder00.stable.out
        monetdb5/optimizer/Tests/tst4000.malC
        monetdb5/optimizer/Tests/tst4000.stable.out
        monetdb5/optimizer/Tests/tst4003.malC
        monetdb5/optimizer/Tests/tst4003.stable.out
        monetdb5/optimizer/Tests/tst4006.stable.out
        monetdb5/optimizer/Tests/tst4030.malC
        monetdb5/optimizer/Tests/tst4030.stable.out
        monetdb5/optimizer/Tests/tst4700.malC
        monetdb5/optimizer/opt_deadcode.c
        monetdb5/optimizer/opt_evaluate.c
        monetdb5/optimizer/opt_json.c
        monetdb5/optimizer/opt_macro.c
        monetdb5/optimizer/opt_mergetable.c
        monetdb5/optimizer/opt_multiplex.c
        monetdb5/optimizer/opt_oltp.c
        monetdb5/optimizer/opt_pipes.c
        monetdb5/optimizer/opt_pipes.h
        monetdb5/optimizer/opt_prelude.h
        monetdb5/optimizer/opt_remap.c
        monetdb5/optimizer/opt_remoteQueries.c
        monetdb5/optimizer/opt_support.c
        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/Tests/pyapi_returntypes.stable.out
        sql/backends/monet5/UDF/pyapi/connection.c
        sql/backends/monet5/UDF/pyapi/conversion.c
        sql/backends/monet5/UDF/pyapi/emit.c
        sql/backends/monet5/UDF/pyapi/type_conversion.c
        sql/backends/monet5/generator/generator.c
        sql/backends/monet5/prog.c
        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_cast_impl_int.h
        sql/backends/monet5/sql_cat.c
        sql/backends/monet5/sql_execute.c
        sql/backends/monet5/sql_gencode.c
        sql/backends/monet5/sql_optimizer.c
        sql/backends/monet5/sql_rank.c
        sql/backends/monet5/sql_rank.mal
        sql/backends/monet5/sql_result.c
        sql/backends/monet5/sql_result.h
        sql/backends/monet5/sql_scenario.c
        sql/backends/monet5/sql_statement.c
        sql/backends/monet5/sql_statistics.c
        sql/backends/monet5/sql_upgrades.c
        sql/backends/monet5/vaults/bam/bam_export.c
        sql/backends/monet5/vaults/bam/bam_lib.c
        sql/backends/monet5/vaults/bam/mykstring.h
        sql/backends/monet5/wlr.c
        sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out
        sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out.Windows
        sql/common/sql_keyword.c
        sql/common/sql_list.c
        sql/common/sql_mem.c
        sql/common/sql_stack.c
        sql/common/sql_string.c
        sql/common/sql_types.c
        sql/include/sql_keyword.h
        sql/include/sql_relation.h
        sql/jdbc/tests/Tests/All
        
sql/jdbc/tests/Tests/Bug_Connect_as_voc_getMetaData_Failure_Bug_6388.stable.err
        
sql/jdbc/tests/Tests/Bug_Connect_as_voc_getMetaData_Failure_Bug_6388.stable.out
        sql/jdbc/tests/Tests/Test_CisValid.stable.out
        sql/scripts/25_debug.sql
        sql/scripts/51_sys_schema_extension.sql
        sql/server/rel_dump.c
        sql/server/rel_exp.c
        sql/server/rel_optimizer.c
        sql/server/rel_planner.c
        sql/server/rel_psm.c
        sql/server/rel_rel.c
        sql/server/rel_schema.c
        sql/server/rel_select.c
        sql/server/rel_select.h
        sql/server/rel_semantic.c
        sql/server/rel_sequence.c
        sql/server/rel_trans.c
        sql/server/rel_updates.c
        sql/server/sql_atom.c
        sql/server/sql_decimal.c
        sql/server/sql_env.c
        sql/server/sql_env.h
        sql/server/sql_mvc.c
        sql/server/sql_parser.y
        sql/server/sql_qc.c
        sql/server/sql_scan.c
        sql/server/sql_scan.h
        sql/server/sql_semantic.c
        sql/storage/bat/bat_storage.c
        sql/storage/bat/bat_table.c
        sql/storage/bat/bat_utils.c
        sql/storage/bat/res_table.c
        sql/storage/store.c
        sql/storage/store_dependency.c
        sql/storage/store_sequence.c
        sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.err
        
sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err.Windows
        
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
        
sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err.Darwin
        
sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err.Windows
        sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out
        sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
        
sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err
        
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
        sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err
        sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out
        sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
        sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.err
        sql/test/BugTracker-2015/Tests/large_join.Bug-3809.sql
        sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.sql
        
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out
        
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out.int128
        sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err
        sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out
        sql/test/BugTracker-2016/Tests/storagemodel.stable.out
        sql/test/BugTracker-2016/Tests/storagemodel.stable.out.Darwin
        sql/test/BugTracker-2017/Tests/All
        
sql/test/BugTracker-2017/Tests/create_table_as-missing_not_null.Bug-6329.stable.out
        sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err
        sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out
        sql/test/BugTracker/Tests/limits_of_decimal.SF-1685357.stable.err
        sql/test/Tests/All
        sql/test/Tests/coalesce.stable.out
        sql/test/Tests/comment-on-index.stable.out
        sql/test/Tests/systemfunctions.stable.out
        sql/test/Tests/systemfunctions.stable.out.int128
        sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.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/upgrade.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.32bit
        sql/test/emptydb/Tests/check.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/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/mapi/Tests/sql_int128.stable.out.int128
        sql/test/mergetables/Tests/mergequery.stable.out
        sql/test/pg_regress/Tests/float8.stable.err
        sql/test/pg_regress/Tests/float8.stable.err.Windows
        sql/test/pg_regress/Tests/int8.stable.err
        sql/test/pg_regress/Tests/int8.stable.out
        sql/test/pg_regress/Tests/interval.stable.err
        sql/test/pg_regress/Tests/interval.stable.out
        sql/test/pg_regress/Tests/numeric_big.stable.err
        sql/test/pg_regress/Tests/oid.stable.err
        sql/test/pg_regress/Tests/oid.stable.err.32bit
        sql/test/pg_regress/Tests/strings.stable.err
        sql/test/remote/Tests/partition_elim.stable.out
        sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
        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.int128
        sql/test/testdb-upgrade/Tests/upgrade.stable.out
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
        testing/difflib.c
        testing/helpers.h
        testing/malcheck.py
        tools/merovingian/daemon/controlrunner.c
Branch: comment-on
Log Message:

Merge default into comment-on branch


diffs (truncated from 40460 to 300 lines):

diff --git a/NT/monetdb_config.h.in b/NT/monetdb_config.h.in
--- a/NT/monetdb_config.h.in
+++ b/NT/monetdb_config.h.in
@@ -755,9 +755,6 @@
 /* Release name or "unreleased" */
 #define MONETDB_RELEASE "unreleased"
 
-/* Suffix for C++ files */
-#define MX_CXX_SUFFIX "cxx"
-
 /* Define if you do not want assertions */
 /* #undef NDEBUG */
 
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
@@ -95,7 +95,7 @@ Ready.
 [ "aggr",      "covar",        "function aggr.covar(e1:bat[:sht], 
e2:bat[:sht]):sht;", "",     ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2], h:any_1):bit 
",      "ALGexist;",    ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2]):bit ",       
"SQLexist;",    ""      ]
-[ "aggr",      "exist",        "command aggr.exist(v:any_2):bit ",     
"SQLexist_val;",        ""      ]
+[ "aggr",      "exist",        "pattern aggr.exist(v:any_2):bit ",     
"SQLexist_val;",        ""      ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(val:bat[:dbl]):str ",    
"JSONgroupStr;",        "Aggregate the double values to array." ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(val:bat[:str]):str ",    
"JSONgroupStr;",        "Aggregate the string values to array." ]
 [ "aggr",      "max",  "command aggr.max(b:bat[:any_1], g:bat[:oid], 
e:bat[:any_2]):bat[:any_1] ",     "AGGRmax3;",    ""      ]
@@ -7689,17 +7689,29 @@ Ready.
 [ "geom",      "setSRID",      "command geom.setSRID(w:wkb, srid:int):wkb ",   
"wkbSetSRID;",  "Sets the Reference System ID for this Geometry."       ]
 [ "group",     "group",        "command group.group(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",   "GRPgroup1;",   ""  
    ]
 [ "group",     "group",        "command group.group(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",      
"GRPgroup2;",   ""      ]
+[ "group",     "group",        "command group.group(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid]) ",    "GRPgroup3;",   ""      ]
+[ "group",     "group",        "command group.group(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",       "GRPgroup4;",   ""  
    ]
 [ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",       "GRPgroup1;",   
""      ]
 [ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",  
"GRPgroup2;",   ""      ]
+[ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid]) ",        "GRPgroup3;",   ""      ]
+[ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",   "GRPgroup4;",   ""      
]
 [ "group",     "multicolumn",  "pattern group.multicolumn(b:bat[:any]...) 
(ref:bat[:oid], grp:bat[:oid], hist:bat[:any]) ",    "GROUPmulticolumngroup;",  
     "Derivation of a group index over multiple columns."    ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",   
"GRPsubgroup2;",        ""      ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ",      "GRPsubgroup3;",        ""      ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ", "GRPsubgroup4;",        ""      ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid], histo:bat[:lng]) ",    "GRPsubgroup5;",        ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",    "GRPsubgroup6;",       
 ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",       
"GRPsubgroup7;",        ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid]) ", 
 "GRPsubgroup8;",        ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid]) ",     "GRPsubgroup9;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",       
"GRPsubgroup2;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ",  "GRPsubgroup3;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ",     "GRPsubgroup4;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid], histo:bat[:lng]) ",        "GRPsubgroup5;",        ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",        "GRPsubgroup6;",   
     ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",   
"GRPsubgroup7;",        ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid]) ", 
     "GRPsubgroup8;",        ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid]) ", "GRPsubgroup9;",        ""      ]
 [ "identifier",        "#fromstr",     "command identifier.#fromstr():void ",  
"IDfromString;",        "Convert a string to an identifier without any check"   
]
 [ "identifier",        "#tostr",       "command identifier.#tostr():void ",    
"IDtoString;",  "Convert identifier to string equivalent"       ]
 [ "identifier",        "identifier",   "command 
identifier.identifier(s:str):identifier ",     "IDentifier;",  "Cast a string 
to an identifer "        ]
@@ -7813,20 +7825,20 @@ Ready.
 [ "json",      "unfold",       "pattern json.unfold(val:json) (o:bat[:oid], 
k:bat[:str], v:bat[:json]) ",      "JSONunfold;",  "Expands the outermost JSON 
object into key-value pairs."       ]
 [ "json",      "valuearray",   "command json.valuearray(val:json):json ",      
"JSONvalueArray;",      "Expands the outermost JSON object values into a JSON 
value array."     ]
 [ "json",      "values",       "command json.values(val:json):bat[:json] ",    
"JSONvalueTable;",      "Expands the outermost JSON values."    ]
-[ "language",  "assert",       "unsafe command language.assert(v:bit, 
term:str):void ",        "MALassertBit;",        ""      ]
-[ "language",  "assert",       "unsafe command language.assert(v:int, 
term:str):void ",        "MALassertInt;",        ""      ]
-[ "language",  "assert",       "unsafe command language.assert(v:lng, 
term:str):void ",        "MALassertLng;",        ""      ]
-[ "language",  "assert",       "unsafe command language.assert(v:oid, 
term:str):void ",        "MALassertOid;",        ""      ]
-[ "language",  "assert",       "unsafe command language.assert(v:sht, 
term:str):void ",        "MALassertSht;",        ""      ]
-[ "language",  "assert",       "unsafe command language.assert(v:str, 
term:str):void ",        "MALassertStr;",        ""      ]
-[ "language",  "assert",       "unsafe pattern language.assert(v:any_1, 
pname:str, oper:str, val:any_2):void ",        "MALassertTriple;",     
"Assertion test."       ]
+[ "language",  "assert",       "command language.assert(v:bit, term:str):void 
",       "MALassertBit;",        ""      ]
+[ "language",  "assert",       "command language.assert(v:int, term:str):void 
",       "MALassertInt;",        ""      ]
+[ "language",  "assert",       "command language.assert(v:lng, term:str):void 
",       "MALassertLng;",        ""      ]
+[ "language",  "assert",       "command language.assert(v:oid, term:str):void 
",       "MALassertOid;",        ""      ]
+[ "language",  "assert",       "command language.assert(v:sht, term:str):void 
",       "MALassertSht;",        ""      ]
+[ "language",  "assert",       "command language.assert(v:str, term:str):void 
",       "MALassertStr;",        ""      ]
+[ "language",  "assert",       "pattern language.assert(v:any_1, pname:str, 
oper:str, val:any_2):void ",       "MALassertTriple;",     "Assertion test."    
   ]
 [ "language",  "block",        "pattern language.block(v:int, w:any...):int ", 
"deblockdataflow;",     "Block on availability of all variables w, and then 
pass on v"  ]
 [ "language",  "call", "pattern language.call(s:bat[:str]):void ",     
"CMDcallBAT;",  "Evaluate a program stored in a BAT."   ]
 [ "language",  "call", "pattern language.call(m:str, f:str):void ",    
"CMDcallFunction;",     ""      ]
 [ "language",  "call", "pattern language.call(s:str):void ",   
"CMDcallString;",       "Evaluate a MAL string program."        ]
 [ "language",  "dataflow",     "pattern language.dataflow():bit ",     
"MALstartDataflow;",    "The current guarded block is executed using dataflow 
control. "        ]
 [ "language",  "pass", "pattern language.pass(v:any_1):void ", "MALpass;",     
"Cheap instruction to disgard storage while retaining the dataflow dependency"  
]
-[ "language",  "raise",        "unsafe command language.raise(msg:str):str ",  
"CMDraise;",    "Raise an exception labeled \n\twith a specific message."       
]
+[ "language",  "raise",        "command language.raise(msg:str):str ", 
"CMDraise;",    "Raise an exception labeled \n\twith a specific message."       
]
 [ "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."   ]
@@ -8323,19 +8335,15 @@ Ready.
 [ "sql",       "dec_round",    "command sql.dec_round(v:int, r:int):int ",     
"int_dec_round_wrap;",  "round off the value v to nearests multiple of r"       
]
 [ "sql",       "dec_round",    "command sql.dec_round(v:lng, r:lng):lng ",     
"lng_dec_round_wrap;",  "round off the value v to nearests multiple of r"       
]
 [ "sql",       "dec_round",    "command sql.dec_round(v:sht, r:sht):sht ",     
"sht_dec_round_wrap;",  "round off the value v to nearests multiple of r"       
]
-[ "sql",       "declaredTable",        "pattern 
sql.declaredTable(name:str):int ",     "mvc_declared_table_wrap;",     "Prepare 
a declared table"      ]
 [ "sql",       "delete",       "pattern sql.delete(mvc:int, sname:str, 
tname:str, b:any):int ",        "mvc_delete_wrap;",     "Delete a row from a 
table. Returns sequence number for order dependece."       ]
 [ "sql",       "delta",        "command sql.delta(col:bat[:any_3], 
uid:bat[:oid], uval:bat[:any_3]):bat[:any_3] ",     "DELTAbat2;",   "Return 
column bat with delta's applied."       ]
 [ "sql",       "delta",        "command sql.delta(col:bat[:any_3], 
uid:bat[:oid], uval:bat[:any_3], ins:bat[:any_3]):bat[:any_3] ",    
"DELTAbat;",    "Return column bat with delta's applied."       ]
 [ "sql",       "dense_rank",   "pattern sql.dense_rank(b:any_1, p:bit, 
o:bit):int ",   "SQLdense_rank;",       "return the densely ranked groups"      
]
 [ "sql",       "diff", "pattern sql.diff(b:any_1):bit ",       "SQLdiff;",     
"return true if cur != prev row"        ]
 [ "sql",       "diff", "pattern sql.diff(p:bit, b:any_1):bit ",        
"SQLdiff;",     "return true if cur != prev row"        ]
-[ "sql",       "dropDeclaredTable",    "pattern 
sql.dropDeclaredTable(name:str):void ",        "mvc_drop_declared_table_wrap;", 
       "drop a declared table" ]
-[ "sql",       "dropDeclaredTables",   "pattern 
sql.dropDeclaredTables(nr:int):void ", "mvc_drop_declared_tables_wrap;",       
"drop top n declared tables"    ]
 [ "sql",       "drop_func_upgrade_oct2014",    "pattern 
sql.drop_func_upgrade_oct2014(id:int):int ",   "UPGdrop_func;",        "Drop 
the function identified by id, needed for the Oct2014 upgrade"    ]
 [ "sql",       "drop_hash",    "pattern sql.drop_hash(sch:str, tbl:str):void 
",        "SQLdrop_hash;",        "Drop hash indices for the given table" ]
 [ "sql",       "droporderindex",       "pattern sql.droporderindex(sch:str, 
tbl:str, col:str):void ",  "sql_droporderindex;",  "Drop the order index on a 
column"      ]
-[ "sql",       "dtColumn",     "pattern sql.dtColumn(rs:int, tname:str, 
name:str, typename:str, digits:int, scale:int):void ", 
"mvc_declared_table_column_wrap;",      ""      ]
 [ "sql",       "dump_cache",   "pattern sql.dump_cache() (query:bat[:str], 
count:bat[:int]) ", "dump_cache;",  "dump the content of the query cache"   ]
 [ "sql",       "dump_opt_stats",       "pattern sql.dump_opt_stats() 
(rewrite:bat[:str], count:bat[:int]) ",   "dump_opt_stats;",      "dump the 
optimizer rewrite statistics" ]
 [ "sql",       "dump_trace",   "pattern sql.dump_trace() (event:bat[:int], 
clk:bat[:str], pc:bat[:str], thread:bat[:int], ticks:bat[:lng], 
rssMB:bat[:lng], vmMB:bat[:lng], reads:bat[:lng], writes:bat[:lng], 
minflt:bat[:lng], majflt:bat[:lng], nvcsw:bat[:lng], stmt:bat[:str]) ", 
"dump_trace;",  "dump the trace statistics"     ]
@@ -8362,6 +8370,7 @@ Ready.
 [ "sql",       "getVariable",  "pattern sql.getVariable(mvc:int, 
varname:str):any_1 ", "getVariable;", "Get the value of a session variable"   ]
 [ "sql",       "getVersion",   "command sql.getVersion(clientid:int):lng ",    
"mvc_getVersion;",      "Return the database version identifier for a client."  
]
 [ "sql",       "get_value",    "pattern sql.get_value(sname:str, 
sequence:str):lng ",  "mvc_get_value;",       "return the current value of the 
sequence"      ]
+[ "sql",       "grow", "pattern sql.grow(tid:bat[:oid], X_0:any_1):int ",      
"mvc_grow_wrap;",       "Resize the tid column of a declared table."    ]
 [ "sql",       "importTable",  "pattern sql.importTable(sname:str, tname:str, 
fname:str...):bat[:any]... ",    "mvc_bin_import_table_wrap;",   "Import a 
table from the files (fname)" ]
 [ "sql",       "include",      "pattern sql.include(fname:str):void ", 
"SQLinclude;",  "Compile and execute a sql statements on the file"      ]
 [ "sql",       "init", "pattern sql.init():void ",     "SQLinitEnvironment;",  
"Initialize the environment for MAL"    ]
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
@@ -103,7 +103,7 @@ Ready.
 [ "aggr",      "covar",        "function aggr.covar(e1:bat[:sht], 
e2:bat[:sht]):sht;", "",     ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2], h:any_1):bit 
",      "ALGexist;",    ""      ]
 [ "aggr",      "exist",        "command aggr.exist(b:bat[:any_2]):bit ",       
"SQLexist;",    ""      ]
-[ "aggr",      "exist",        "command aggr.exist(v:any_2):bit ",     
"SQLexist_val;",        ""      ]
+[ "aggr",      "exist",        "pattern aggr.exist(v:any_2):bit ",     
"SQLexist_val;",        ""      ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(val:bat[:dbl]):str ",    
"JSONgroupStr;",        "Aggregate the double values to array." ]
 [ "aggr",      "jsonaggr",     "command aggr.jsonaggr(val:bat[:str]):str ",    
"JSONgroupStr;",        "Aggregate the string values to array." ]
 [ "aggr",      "max",  "command aggr.max(b:bat[:any_1], g:bat[:oid], 
e:bat[:any_2]):bat[:any_1] ",     "AGGRmax3;",    ""      ]
@@ -10045,17 +10045,29 @@ Ready.
 [ "geom",      "setSRID",      "command geom.setSRID(w:wkb, srid:int):wkb ",   
"wkbSetSRID;",  "Sets the Reference System ID for this Geometry."       ]
 [ "group",     "group",        "command group.group(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",   "GRPgroup1;",   ""  
    ]
 [ "group",     "group",        "command group.group(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",      
"GRPgroup2;",   ""      ]
+[ "group",     "group",        "command group.group(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid]) ",    "GRPgroup3;",   ""      ]
+[ "group",     "group",        "command group.group(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",       "GRPgroup4;",   ""  
    ]
 [ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",       "GRPgroup1;",   
""      ]
 [ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",  
"GRPgroup2;",   ""      ]
+[ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1]) 
(groups:bat[:oid], extents:bat[:oid]) ",        "GRPgroup3;",   ""      ]
+[ "group",     "groupdone",    "command group.groupdone(b:bat[:any_1], 
s:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",   "GRPgroup4;",   ""      
]
 [ "group",     "multicolumn",  "pattern group.multicolumn(b:bat[:any]...) 
(ref:bat[:oid], grp:bat[:oid], hist:bat[:any]) ",    "GROUPmulticolumngroup;",  
     "Derivation of a group index over multiple columns."    ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",   
"GRPsubgroup2;",        ""      ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ",      "GRPsubgroup3;",        ""      ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ", "GRPsubgroup4;",        ""      ]
 [ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid], histo:bat[:lng]) ",    "GRPsubgroup5;",        ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",    "GRPsubgroup6;",       
 ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",       
"GRPsubgroup7;",        ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid]) ", 
 "GRPsubgroup8;",        ""      ]
+[ "group",     "subgroup",     "command group.subgroup(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid]) ",     "GRPsubgroup9;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], histo:bat[:lng]) ",       
"GRPsubgroup2;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ",  "GRPsubgroup3;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid], 
histo:bat[:lng]) ",     "GRPsubgroup4;",        ""      ]
 [ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid], histo:bat[:lng]) ",        "GRPsubgroup5;",        ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",        "GRPsubgroup6;",   
     ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid]) (groups:bat[:oid], extents:bat[:oid]) ",   
"GRPsubgroup7;",        ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], extents:bat[:oid]) ", 
     "GRPsubgroup8;",        ""      ]
+[ "group",     "subgroupdone", "command group.subgroupdone(b:bat[:any_1], 
s:bat[:oid], g:bat[:oid], e:bat[:oid], h:bat[:lng]) (groups:bat[:oid], 
extents:bat[:oid]) ", "GRPsubgroup9;",        ""      ]
 [ "identifier",        "#fromstr",     "command identifier.#fromstr():void ",  
"IDfromString;",        "Convert a string to an identifier without any check"   
]
 [ "identifier",        "#tostr",       "command identifier.#tostr():void ",    
"IDtoString;",  "Convert identifier to string equivalent"       ]
 [ "identifier",        "identifier",   "command 
identifier.identifier(s:str):identifier ",     "IDentifier;",  "Cast a string 
to an identifer "        ]
@@ -10686,19 +10698,15 @@ Ready.
 [ "sql",       "dec_round",    "command sql.dec_round(v:int, r:int):int ",     
"int_dec_round_wrap;",  "round off the value v to nearests multiple of r"       
]
 [ "sql",       "dec_round",    "command sql.dec_round(v:lng, r:lng):lng ",     
"lng_dec_round_wrap;",  "round off the value v to nearests multiple of r"       
]
 [ "sql",       "dec_round",    "command sql.dec_round(v:sht, r:sht):sht ",     
"sht_dec_round_wrap;",  "round off the value v to nearests multiple of r"       
]
-[ "sql",       "declaredTable",        "pattern 
sql.declaredTable(name:str):int ",     "mvc_declared_table_wrap;",     "Prepare 
a declared table"      ]
 [ "sql",       "delete",       "pattern sql.delete(mvc:int, sname:str, 
tname:str, b:any):int ",        "mvc_delete_wrap;",     "Delete a row from a 
table. Returns sequence number for order dependece."       ]
 [ "sql",       "delta",        "command sql.delta(col:bat[:any_3], 
uid:bat[:oid], uval:bat[:any_3]):bat[:any_3] ",     "DELTAbat2;",   "Return 
column bat with delta's applied."       ]
 [ "sql",       "delta",        "command sql.delta(col:bat[:any_3], 
uid:bat[:oid], uval:bat[:any_3], ins:bat[:any_3]):bat[:any_3] ",    
"DELTAbat;",    "Return column bat with delta's applied."       ]
 [ "sql",       "dense_rank",   "pattern sql.dense_rank(b:any_1, p:bit, 
o:bit):int ",   "SQLdense_rank;",       "return the densely ranked groups"      
]
 [ "sql",       "diff", "pattern sql.diff(b:any_1):bit ",       "SQLdiff;",     
"return true if cur != prev row"        ]
 [ "sql",       "diff", "pattern sql.diff(p:bit, b:any_1):bit ",        
"SQLdiff;",     "return true if cur != prev row"        ]
-[ "sql",       "dropDeclaredTable",    "pattern 
sql.dropDeclaredTable(name:str):void ",        "mvc_drop_declared_table_wrap;", 
       "drop a declared table" ]
-[ "sql",       "dropDeclaredTables",   "pattern 
sql.dropDeclaredTables(nr:int):void ", "mvc_drop_declared_tables_wrap;",       
"drop top n declared tables"    ]
 [ "sql",       "drop_func_upgrade_oct2014",    "pattern 
sql.drop_func_upgrade_oct2014(id:int):int ",   "UPGdrop_func;",        "Drop 
the function identified by id, needed for the Oct2014 upgrade"    ]
 [ "sql",       "drop_hash",    "pattern sql.drop_hash(sch:str, tbl:str):void 
",        "SQLdrop_hash;",        "Drop hash indices for the given table" ]
 [ "sql",       "droporderindex",       "pattern sql.droporderindex(sch:str, 
tbl:str, col:str):void ",  "sql_droporderindex;",  "Drop the order index on a 
column"      ]
-[ "sql",       "dtColumn",     "pattern sql.dtColumn(rs:int, tname:str, 
name:str, typename:str, digits:int, scale:int):void ", 
"mvc_declared_table_column_wrap;",      ""      ]
 [ "sql",       "dump_cache",   "pattern sql.dump_cache() (query:bat[:str], 
count:bat[:int]) ", "dump_cache;",  "dump the content of the query cache"   ]
 [ "sql",       "dump_opt_stats",       "pattern sql.dump_opt_stats() 
(rewrite:bat[:str], count:bat[:int]) ",   "dump_opt_stats;",      "dump the 
optimizer rewrite statistics" ]
 [ "sql",       "dump_trace",   "pattern sql.dump_trace() (event:bat[:int], 
clk:bat[:str], pc:bat[:str], thread:bat[:int], ticks:bat[:lng], 
rssMB:bat[:lng], vmMB:bat[:lng], reads:bat[:lng], writes:bat[:lng], 
minflt:bat[:lng], majflt:bat[:lng], nvcsw:bat[:lng], stmt:bat[:str]) ", 
"dump_trace;",  "dump the trace statistics"     ]
@@ -10725,6 +10733,7 @@ Ready.
 [ "sql",       "getVariable",  "pattern sql.getVariable(mvc:int, 
varname:str):any_1 ", "getVariable;", "Get the value of a session variable"   ]
 [ "sql",       "getVersion",   "command sql.getVersion(clientid:int):lng ",    
"mvc_getVersion;",      "Return the database version identifier for a client."  
]
 [ "sql",       "get_value",    "pattern sql.get_value(sname:str, 
sequence:str):lng ",  "mvc_get_value;",       "return the current value of the 
sequence"      ]
+[ "sql",       "grow", "pattern sql.grow(tid:bat[:oid], X_0:any_1):int ",      
"mvc_grow_wrap;",       "Resize the tid column of a declared table."    ]
 [ "sql",       "importTable",  "pattern sql.importTable(sname:str, tname:str, 
fname:str...):bat[:any]... ",    "mvc_bin_import_table_wrap;",   "Import a 
table from the files (fname)" ]
 [ "sql",       "include",      "pattern sql.include(fname:str):void ", 
"SQLinclude;",  "Compile and execute a sql statements on the file"      ]
 [ "sql",       "init", "pattern sql.init():void ",     "SQLinitEnvironment;",  
"Initialize the environment for MAL"    ]
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
@@ -13,9 +13,9 @@ int ATOMallocate(const char *nme);
 int ATOMcmp(int id, const void *v_1, const void *v_2);
 ptr ATOMdup(int id, const void *val);
 bte ATOMelmshift(int sz);
-int ATOMformat(int id, const void *val, char **buf);
+ssize_t ATOMformat(int id, const void *val, char **buf);
 int ATOMindex(const char *nme);
-int ATOMlen(int id, const void *v);
+size_t ATOMlen(int id, const void *v);
 str ATOMname(int id);
 ptr ATOMnil(int id);
 int ATOMprint(int id, const void *val, stream *fd);
@@ -303,8 +303,8 @@ int MT_munmap(void *p, size_t len);
 int MT_path_absolute(const char *path);
 void MT_sleep_ms(unsigned int ms);
 void OIDXdestroy(BAT *b);
-int OIDfromStr(const char *src, int *len, oid **dst);
-int OIDtoStr(str *dst, int *len, const oid *src);
+ssize_t OIDfromStr(const char *src, size_t *len, oid **dst);
+ssize_t OIDtoStr(str *dst, size_t *len, const oid *src);
 BUN ORDERfnd(BAT *b, const void *v);
 BUN ORDERfndfirst(BAT *b, const void *v);
 BUN ORDERfndlast(BAT *b, const void *v);
@@ -330,7 +330,7 @@ int VALcmp(const ValRecord *p, const Val
 ptr VALconvert(int typ, ValPtr t);
 ValPtr VALcopy(ValPtr dst, const ValRecord *src);
 void VALempty(ValPtr v);
-int VALformat(char **buf, const ValRecord *res);
+ssize_t VALformat(char **buf, const ValRecord *res);
 void *VALget(ValPtr v);
 ValPtr VALinit(ValPtr d, int tpe, const void *s);
 int VALisnil(const ValRecord *v);
@@ -368,26 +368,26 @@ BAT *VIEWcreate(oid seq, BAT *b);
 BAT *VIEWcreate_(oid seq, BAT *b, int stable);
 size_t _MT_npages;
 size_t _MT_pagesize;
-int batFromStr(const char *src, int *len, bat **dst);
-int batToStr(str *dst, int *len, const bat *src);
-int bitFromStr(const char *src, int *len, bit **dst);
-int bitToStr(str *dst, int *len, const bit *src);
-int bteFromStr(const char *src, int *len, bte **dst);
-int bteToStr(str *dst, int *len, const bte *src);
+ssize_t batFromStr(const char *src, size_t *len, bat **dst);
+ssize_t batToStr(str *dst, size_t *len, const bat *src);
+ssize_t bitFromStr(const char *src, size_t *len, bit **dst);
+ssize_t bitToStr(str *dst, size_t *len, const bit *src);
+ssize_t bteFromStr(const char *src, size_t *len, bte **dst);
+ssize_t bteToStr(str *dst, size_t *len, const bte *src);
 const bte bte_nil;
 int closedir(DIR *dir);
-int dblFromStr(const char *src, int *len, dbl **dst);
-int dblToStr(str *dst, int *len, const dbl *src);
+ssize_t dblFromStr(const char *src, size_t *len, dbl **dst);
+ssize_t dblToStr(str *dst, size_t *len, const dbl *src);
 const dbl dbl_nil;
 char *dirname(char *path);
 int dlclose(void *handle);
 char *dlerror(void);
 void *dlopen(const char *file, int mode);
 void *dlsym(void *handle, const char *name);
-int escapedStr(char *dst, const char *src, int dstlen, const char *sep1, const 
char *sep2, int quote);
-int escapedStrlen(const char *src, const char *sep1, const char *sep2, int 
quote);
-int fltFromStr(const char *src, int *len, flt **dst);
-int fltToStr(str *dst, int *len, const flt *src);
+size_t escapedStr(char *dst, const char *src, size_t dstlen, const char *sep1, 
const char *sep2, int quote);
+size_t escapedStrlen(const char *src, const char *sep1, const char *sep2, int 
quote);
+ssize_t fltFromStr(const char *src, size_t *len, flt **dst);
+ssize_t fltToStr(str *dst, size_t *len, const flt *src);
 const flt flt_nil;
 geomcatalogfix_fptr geomcatalogfix_get(void);
 void geomcatalogfix_set(geomcatalogfix_fptr);
@@ -399,14 +399,14 @@ bat getBBPsize(void);
 char *get_bin_path(void);
 int gettimeofday(struct timeval *tv, int *ignore_zone);
 int gprof_pthread_create(pthread_t *__restrict, __const pthread_attr_t 
*__restrict, void *( *fcn)(void *), void *__restrict);
-int hgeFromStr(const char *src, int *len, hge **dst);
-int hgeToStr(str *dst, int *len, const hge *src);
+ssize_t hgeFromStr(const char *src, size_t *len, hge **dst);
+ssize_t hgeToStr(str *dst, size_t *len, const hge *src);
 const hge hge_nil;
-int intFromStr(const char *src, int *len, int **dst);
-int intToStr(str *dst, int *len, const int *src);
+ssize_t intFromStr(const char *src, size_t *len, int **dst);
+ssize_t intToStr(str *dst, size_t *len, const int *src);
 const int int_nil;
-int lngFromStr(const char *src, int *len, lng **dst);
-int lngToStr(str *dst, int *len, const lng *src);
+ssize_t lngFromStr(const char *src, size_t *len, lng **dst);
+ssize_t lngToStr(str *dst, size_t *len, const lng *src);
 const lng lng_nil;
 gdk_return log_abort(logger *lg);
 gdk_return log_bat(logger *lg, BAT *b, const char *n);
@@ -471,17 +471,17 @@ void pthread_sema_init(pthread_sema_t *s
 void pthread_sema_init(pthread_sema_t *s, int flag, int nresources);
 void pthread_sema_up(pthread_sema_t *s);
 void pthread_sema_up(pthread_sema_t *s);
-int ptrFromStr(const char *src, int *len, ptr **dst);
-int ptrToStr(str *dst, int *len, const ptr *src);
+ssize_t ptrFromStr(const char *src, size_t *len, ptr **dst);
+ssize_t ptrToStr(str *dst, size_t *len, const ptr *src);
 const ptr ptr_nil;
 struct dirent *readdir(DIR *dir);
 void rewinddir(DIR *dir);
-int shtFromStr(const char *src, int *len, sht **dst);
-int shtToStr(str *dst, int *len, const sht *src);
+ssize_t shtFromStr(const char *src, size_t *len, sht **dst);
+ssize_t shtToStr(str *dst, size_t *len, const sht *src);
 const sht sht_nil;
-int strFromStr(const char *src, int *len, str *dst);
+ssize_t strFromStr(const char *src, size_t *len, str *dst);
 BUN strHash(const char *s);
-int strLen(const char *s);
+size_t strLen(const char *s);
 int strNil(const char *s);
 const char str_nil[2];
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to