Changeset: feb5440b8f81 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=feb5440b8f81
Added Files:
        common/utils/revision.c
        gdk/gdk_string.c
        sql/benchmarks/tpcds/Tests/11.reqtests
        sql/benchmarks/tpcds/Tests/11.sql
        sql/benchmarks/tpcds/Tests/38.reqtests
        sql/benchmarks/tpcds/Tests/38.sql
        sql/benchmarks/tpcds/Tests/72.reqtests
        sql/benchmarks/tpcds/Tests/72.sql
        sql/benchmarks/tpcds/Tests/83.reqtests
        sql/benchmarks/tpcds/Tests/83.sql
        sql/benchmarks/tpcds/Tests/98.reqtests
        sql/benchmarks/tpcds/Tests/98.sql
        sql/benchmarks/tpcds/Tests/99.reqtests
        sql/benchmarks/tpcds/Tests/99.sql
        sql/benchmarks/tpcds/Tests/All
        sql/benchmarks/tpcds/Tests/alter.reqtests
        sql/benchmarks/tpcds/Tests/alter.sql
        sql/benchmarks/tpcds/Tests/alter.stable.err
        sql/benchmarks/tpcds/Tests/alter.stable.out
        sql/benchmarks/tpcds/Tests/check0.reqtests
        sql/benchmarks/tpcds/Tests/check0.sql
        sql/benchmarks/tpcds/Tests/check0.stable.err
        sql/benchmarks/tpcds/Tests/check0.stable.out
        sql/benchmarks/tpcds/Tests/check1.reqtests
        sql/benchmarks/tpcds/Tests/check1.sql
        sql/benchmarks/tpcds/Tests/check1.stable.err
        sql/benchmarks/tpcds/Tests/check1.stable.out
        sql/benchmarks/tpcds/Tests/create.sql
        sql/benchmarks/tpcds/Tests/create.stable.err
        sql/benchmarks/tpcds/Tests/create.stable.out
        sql/benchmarks/tpcds/Tests/drop.sql
        sql/benchmarks/tpcds/Tests/drop.stable.err
        sql/benchmarks/tpcds/Tests/drop.stable.out
        sql/benchmarks/tpcds/Tests/load.reqtests
        sql/benchmarks/tpcds/Tests/load.sql.in
        sql/benchmarks/tpcds/Tests/load.stable.err
        sql/benchmarks/tpcds/Tests/load.stable.out
        
sql/test/BugTracker-2009/Tests/dumping_tables.SF-2776908--optimizers.options5
        
sql/test/BugTracker-2009/Tests/dumping_tables.SF-2776908--performance.options5
        sql/test/BugTracker-2018/Tests/alter-sequence-subquery.Bug-6657.sql
        
sql/test/BugTracker-2018/Tests/alter-sequence-subquery.Bug-6657.stable.err
        
sql/test/BugTracker-2018/Tests/alter-sequence-subquery.Bug-6657.stable.out
        
sql/test/BugTracker-2018/Tests/create_table_empty_column_name.Bug-6653.sql
        
sql/test/BugTracker-2018/Tests/create_table_empty_column_name.Bug-6653.stable.err
        
sql/test/BugTracker-2018/Tests/create_table_empty_column_name.Bug-6653.stable.out
        sql/test/BugTracker-2018/Tests/in-subquery-having-Bug-6651.sql
        sql/test/BugTracker-2018/Tests/in-subquery-having-Bug-6651.stable.err
        sql/test/BugTracker-2018/Tests/in-subquery-having-Bug-6651.stable.out
        sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.sql
        
sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.stable.err
        
sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.stable.out
        sql/test/BugTracker-2018/Tests/quantile-crash.Bug-6658.sql
        sql/test/BugTracker-2018/Tests/quantile-crash.Bug-6658.stable.err
        sql/test/BugTracker-2018/Tests/quantile-crash.Bug-6658.stable.out
        sql/test/BugTracker-2018/Tests/select_where_true.Bug-6654.sql
        sql/test/BugTracker-2018/Tests/select_where_true.Bug-6654.stable.err
        sql/test/BugTracker-2018/Tests/select_where_true.Bug-6654.stable.out
        sql/test/rename/Tests/All
        sql/test/rename/Tests/rename00.py
        sql/test/rename/Tests/rename00.stable.err
        sql/test/rename/Tests/rename00.stable.out
        sql/test/rename/Tests/rename01.sql
        sql/test/rename/Tests/rename01.stable.err
        sql/test/rename/Tests/rename01.stable.out
        sql/test/rename/Tests/rename02.sql
        sql/test/rename/Tests/rename02.stable.err
        sql/test/rename/Tests/rename02.stable.out
        sql/test/rename/Tests/rename03.sql
        sql/test/rename/Tests/rename03.stable.err
        sql/test/rename/Tests/rename03.stable.out
        sql/test/rename/Tests/rename04.sql
        sql/test/rename/Tests/rename04.stable.err
        sql/test/rename/Tests/rename04.stable.out
        sql/test/rename/Tests/rename05.sql
        sql/test/rename/Tests/rename05.stable.err
        sql/test/rename/Tests/rename05.stable.out
        sql/test/rename/Tests/rename06.sql
        sql/test/rename/Tests/rename06.stable.err
        sql/test/rename/Tests/rename06.stable.out
        sql/test/testdb/Tests/dump-nogeom.reqtests
        sql/test/testdb/Tests/dump-nogeom.sql
        sql/test/testdb/Tests/dump-nogeom.stable.err
        sql/test/testdb/Tests/dump-nogeom.stable.out
        sql/test/testdb/Tests/dump.reqtests
        sql/test/testdb/Tests/dump.sql
        sql/test/testdb/Tests/dump.stable.err
        sql/test/testdb/Tests/dump.stable.out
        sql/test/testdb/Tests/dump.timeout
        sql/test/testdb/Tests/load-geom.reqtests
        sql/test/testdb/Tests/load-geom.sql
        sql/test/testdb/Tests/load-geom.stable.err
        sql/test/testdb/Tests/load-geom.stable.out
        sql/test/testdb/Tests/load.sql
        sql/test/testdb/Tests/load.stable.err
        sql/test/testdb/Tests/load.stable.out
        sql/test/testdb/Tests/load.timeout
        sql/test/testdb/Tests/package-hge.py
        sql/test/testdb/Tests/package-hge.stable.err
        sql/test/testdb/Tests/package-hge.stable.out.int128
        sql/test/testdb/Tests/package.py
        sql/test/testdb/Tests/package.reqtests
        sql/test/testdb/Tests/package.stable.err
        sql/test/testdb/Tests/package.stable.out
Removed Files:
        monetdb5/modules/atoms/Tests/curl00.malC
        monetdb5/modules/atoms/Tests/curl00.stable.err
        monetdb5/modules/atoms/Tests/curl00.stable.out
        monetdb5/modules/atoms/mcurl.c
        monetdb5/modules/atoms/mcurl.mal
        sql/backends/monet5/vaults/70_vault.mal
        sql/backends/monet5/vaults/Tests/vault00.malC
        sql/backends/monet5/vaults/vault.c
        sql/backends/monet5/vaults/vault.h
        sql/backends/monet5/vaults/vault.mal
        sql/backends/monet5/vaults/vault.sql
        
sql/test/BugTracker-2009/Tests/dumping_tables.SF-2776908--optimizers.dbinit5
        
sql/test/BugTracker-2009/Tests/dumping_tables.SF-2776908--performance.dbinit5
        sql/test/testdb/Tests/testdb-dump.reqtests
        sql/test/testdb/Tests/testdb-dump.sql
        sql/test/testdb/Tests/testdb-dump.stable.err
        sql/test/testdb/Tests/testdb-dump.stable.out
        sql/test/testdb/Tests/testdb-dump.timeout
        sql/test/testdb/Tests/testdb-load.sql
        sql/test/testdb/Tests/testdb-load.stable.err
        sql/test/testdb/Tests/testdb-load.stable.out
        sql/test/testdb/Tests/testdb-load.timeout
        sql/test/testdb/Tests/testdb-package-hge.py
        sql/test/testdb/Tests/testdb-package-hge.stable.err
        sql/test/testdb/Tests/testdb-package-hge.stable.out.int128
        sql/test/testdb/Tests/testdb-package.py
        sql/test/testdb/Tests/testdb-package.reqtests
        sql/test/testdb/Tests/testdb-package.stable.err
        sql/test/testdb/Tests/testdb-package.stable.out
Modified Files:
        MonetDB.spec
        NT/Makefile
        NT/monetdb_config.h.in
        bootstrap
        buildtools/ChangeLog-Archive
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/Tests/exports.stable.out
        clients/mapiclient/Tests/mclient--help.stable.err
        clients/mapiclient/Tests/mclient--help.stable.err.Windows
        clients/mapiclient/dump.c
        clients/mapiclient/mclient.1
        clients/mapiclient/mclient.c
        clients/mapiclient/mhelp.c
        clients/mapiclient/msqldump.c
        clients/mapilib/mapi.c
        clients/mapilib/mapi.h
        clients/odbc/driver/ODBCError.c
        common/stream/stream.c
        common/utils/Makefile.ag
        common/utils/mutils.h
        configure.ag
        debian/changelog
        debian/monetdb5-server.install
        debian/monetdb5-sql.install
        gdk/ChangeLog
        gdk/Makefile.ag
        gdk/gdk.h
        gdk/gdk_aggr.c
        gdk/gdk_align.c
        gdk/gdk_atoms.c
        gdk/gdk_bat.c
        gdk/gdk_batop.c
        gdk/gdk_bbp.c
        gdk/gdk_calc.c
        gdk/gdk_calc.h
        gdk/gdk_calc_private.h
        gdk/gdk_cand.h
        gdk/gdk_delta.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_logger.h
        gdk/gdk_orderidx.c
        gdk/gdk_private.h
        gdk/gdk_qsort.c
        gdk/gdk_qsort_impl.h
        gdk/gdk_search.c
        gdk/gdk_select.c
        gdk/gdk_ssort.c
        gdk/gdk_ssort_impl.h
        gdk/gdk_storage.c
        gdk/gdk_tm.c
        gdk/gdk_utils.c
        gdk/gdk_value.c
        geom/monetdb5/geom.c
        geom/monetdb5/geomBulk.c
        geom/monetdb5/geom_upgrade.c
        geom/sql/conformance/Tests/T1.sql
        geom/sql/conformance/Tests/T1.stable.out
        monetdb5/ChangeLog
        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/converters.c.h
        monetdb5/mal/Tests/tst1502.malC
        monetdb5/mal/Tests/tst233.malC
        monetdb5/mal/Tests/tst234.malC
        monetdb5/mal/Tests/tst235.malC
        monetdb5/mal/Tests/tst903.malC
        monetdb5/mal/Tests/tst903.stable.out
        monetdb5/mal/mal_authorize.c
        monetdb5/mal/mal_client.c
        monetdb5/mal/mal_client.h
        monetdb5/mal/mal_debugger.c
        monetdb5/mal/mal_session.c
        monetdb5/modules/atoms/Makefile.ag
        monetdb5/modules/atoms/Tests/All
        monetdb5/modules/atoms/Tests/xml10.malC
        monetdb5/modules/atoms/batxml.c
        monetdb5/modules/atoms/json.c
        monetdb5/modules/atoms/mtime.c
        monetdb5/modules/atoms/url.c
        monetdb5/modules/kernel/Tests/select.malC
        monetdb5/modules/kernel/Tests/time01.malC
        monetdb5/modules/kernel/aggr.c
        monetdb5/modules/kernel/alarm.c
        monetdb5/modules/kernel/algebra.c
        monetdb5/modules/kernel/algebra.h
        monetdb5/modules/kernel/algebra.mal
        monetdb5/modules/kernel/bat5.c
        monetdb5/modules/kernel/batmmath.c
        monetdb5/modules/kernel/batstr.c
        monetdb5/modules/kernel/logger.c
        monetdb5/modules/kernel/mmath.c
        monetdb5/modules/mal/Tests/inspect05.malC
        monetdb5/modules/mal/Tests/orderidx00.malC
        monetdb5/modules/mal/Tests/orderidx04.malC
        monetdb5/modules/mal/Tests/pqueue.malC
        monetdb5/modules/mal/Tests/pqueue2.malC
        monetdb5/modules/mal/Tests/pqueue3.malC
        monetdb5/modules/mal/batcalc.c
        monetdb5/modules/mal/calc.c
        monetdb5/modules/mal/clients.c
        monetdb5/modules/mal/factories.c
        monetdb5/modules/mal/language.c
        monetdb5/modules/mal/mal_init.mal
        monetdb5/modules/mal/mal_mapi.c
        monetdb5/modules/mal/mdb.c
        monetdb5/modules/mal/mkey.c
        monetdb5/modules/mal/pcre.c
        monetdb5/modules/mal/tablet.c
        monetdb5/modules/mal/tokenizer.c
        monetdb5/modules/mal/wlc.c
        monetdb5/modules/mal/wlc.mal
        monetdb5/optimizer/Tests/DCexample2.malC
        monetdb5/optimizer/Tests/reorder00.malC
        monetdb5/optimizer/Tests/reorder00.stable.out
        monetdb5/optimizer/Tests/tst4700.malC
        monetdb5/optimizer/opt_costModel.c
        monetdb5/optimizer/opt_prelude.c
        monetdb5/optimizer/opt_prelude.h
        monetdb5/optimizer/opt_projectionpath.c
        monetdb5/optimizer/opt_support.c
        monetdb5/tools/Tests/mserver5--help.stable.err
        monetdb5/tools/Tests/mserver5--help.stable.err.Windows
        rpm.mk.in
        sql/ChangeLog
        sql/ChangeLog.Aug2018
        sql/backends/monet5/UDF/capi/capi.c
        sql/backends/monet5/UDF/pyapi/conversion.c
        sql/backends/monet5/UDF/udf/udf.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_bat2time.c
        sql/backends/monet5/sql_cast.c
        sql/backends/monet5/sql_cast_impl_down_from_flt.h
        sql/backends/monet5/sql_cast_impl_int.h
        sql/backends/monet5/sql_cast_impl_up_to_flt.h
        sql/backends/monet5/sql_cat.c
        sql/backends/monet5/sql_cat.h
        sql/backends/monet5/sql_result.c
        sql/backends/monet5/sql_result.h
        sql/backends/monet5/sql_round_impl.h
        sql/backends/monet5/sql_statement.c
        sql/backends/monet5/sql_statement.h
        sql/backends/monet5/sql_upgrades.c
        sql/backends/monet5/sqlcatalog.mal
        sql/backends/monet5/vaults/Makefile.ag
        sql/backends/monet5/vaults/bam/Tests/query1.1.sql
        sql/backends/monet5/vaults/bam/Tests/query1.1.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.11.sql
        sql/backends/monet5/vaults/bam/Tests/query2.11.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.2.sql
        sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
        sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
        sql/backends/monet5/vaults/bam/Tests/query2.6.sql
        sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
        sql/backends/monet5/vaults/bam/bam_db_interface.c
        sql/backends/monet5/vaults/bam/bam_export.c
        sql/backends/monet5/vaults/bam/bam_lib.c
        sql/backends/monet5/wlr.mal
        sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql
        sql/benchmarks/tpch/load-sf-0.01.sql
        sql/benchmarks/tpch/load-sf-1.sql
        sql/common/sql_changeset.c
        sql/common/sql_list.c
        sql/common/sql_string.c
        sql/common/sql_types.c
        sql/include/sql_catalog.h
        sql/include/sql_list.h
        sql/include/sql_relation.h
        sql/scripts/75_storagemodel.sql
        sql/server/rel_dump.c
        sql/server/rel_optimizer.c
        sql/server/rel_schema.c
        sql/server/rel_semantic.c
        sql/server/rel_sequence.c
        sql/server/rel_updates.c
        sql/server/sql_mvc.c
        sql/server/sql_mvc.h
        sql/server/sql_parser.h
        sql/server/sql_parser.y
        sql/server/sql_partition.c
        sql/server/sql_partition.h
        sql/server/sql_scan.c
        sql/storage/bat/bat_logger.c
        sql/storage/bat/bat_logger.h
        sql/storage/bat/bat_storage.c
        sql/storage/bat/bat_table.c
        sql/storage/sql_storage.h
        sql/storage/store.c
        sql/storage/store_sequence.c
        sql/test/ADT2006/Tests/sander.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.sql
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out
        sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out
        
sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out.Windows
        
sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
        
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
        sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.err
        sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.out
        sql/test/BugTracker-2013/Tests/create_table_with_func.Bug-3286.sql
        
sql/test/BugTracker-2013/Tests/create_table_with_func.Bug-3286.stable.out
        sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.stable.out
        sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out
        
sql/test/BugTracker-2016/Tests/assert-on-push-project-up.Bug-6077.stable.out
        sql/test/BugTracker-2016/Tests/storagemodel.sql
        sql/test/BugTracker-2016/Tests/storagemodel.stable.out
        
sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_in_select.Bug-6254.stable.out
        sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.sql
        sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.stable.out
        sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql
        sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
        sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.stable.out
        sql/test/BugTracker-2018/Tests/All
        
sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.stable.out
        sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.sql
        sql/test/BugTracker-2018/Tests/remote-table-where-is-null.Bug-6601.py
        sql/test/Dependencies/Tests/Dependencies.stable.out
        sql/test/Dependencies/Tests/Dependencies.stable.out.int128
        sql/test/Dependencies/Tests/dependency_loop.stable.out
        sql/test/Dependencies/Tests/dependency_loop.stable.out.int128
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out
        
sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out
        sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out
        
sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128
        sql/test/Tests/order_by_complex_exp.stable.out
        sql/test/Tests/rank.stable.out
        sql/test/Tests/systemfunctions.stable.out
        sql/test/Tests/systemfunctions.stable.out.int128
        sql/test/Users/Tests/copyinto.stable.err
        sql/test/Users/Tests/copyinto.stable.out
        sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out
        sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
        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/group-concat/Tests/groupconcat01.stable.out
        sql/test/group-concat/Tests/groupconcat02.stable.out
        sql/test/group-concat/Tests/groupconcat03.stable.out
        sql/test/group-concat/Tests/groupconcat04.stable.out
        sql/test/group-concat/Tests/groupconcat05.stable.out
        sql/test/mergetables/Tests/sqlsmith-apply-outer-join-or.sql
        sql/test/order_by_complex_exp.sql
        sql/test/orderidx/Tests/simpletable.stable.out
        sql/test/orderidx/Tests/simpletable.stable.out.32bit
        sql/test/orderidx/Tests/smalltable.stable.out
        sql/test/orderidx/Tests/smalltable.stable.out.32bit
        sql/test/pg_regress/Tests/alter_table.stable.err
        sql/test/pg_regress/Tests/alter_table.stable.out
        sql/test/pg_regress/Tests/drop.stable.err
        sql/test/pg_regress/Tests/point.sql
        sql/test/pg_regress/Tests/point.stable.out
        sql/test/pg_regress/Tests/vacuum.stable.out
        sql/test/pg_regress/Tests/without_oid.stable.out
        sql/test/pg_regress/Tests/without_oid.stable.out.32bit
        sql/test/rank.sql
        sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql
        
sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out
        sql/test/sys-schema/Tests/check_PrimaryKey_uniqueness.stable.out
        sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
        sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
        sql/test/testdb-upgrade/Tests/dump.stable.out
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
        sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128
        sql/test/testdb/Tests/All
        testing/Mtest.py.in
        testing/README
        testing/exportutils.py
        testing/listexports.py.in
        testing/process.py
        tools/merovingian/client/monetdb.c
        tools/merovingian/daemon/argvcmds.c
        tools/merovingian/daemon/controlrunner.c
        tools/merovingian/daemon/merovingian.c
        tools/merovingian/daemon/merovingian.h
        tools/merovingian/daemon/proxy.c
        tools/mserver/monet_version.c.in
        tools/mserver/mserver5.1.in
        tools/mserver/mserver5.c
Branch: mosaic
Log Message:

Merge with default.


diffs (truncated from 186095 to 300 lines):

diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -112,6 +112,7 @@ Vendor: MonetDB BV <i...@monetdb.org>
 Group: Applications/Databases
 License: MPLv2.0
 URL: https://www.monetdb.org/
+BugURL: https://bugs.monetdb.org/
 Source: 
https://www.monetdb.org/downloads/sources/Aug2018-SP1/%{name}-%{version}.tar.bz2
 
 # we need systemd for the _unitdir macro to exist
@@ -689,7 +690,6 @@ exit 0
 %{_libdir}/monetdb5/lib_generator.so
 %{_libdir}/monetdb5/lib_opt_sql_append.so
 %{_libdir}/monetdb5/lib_udf.so
-%{_libdir}/monetdb5/lib_vault.so
 %doc %{_mandir}/man1/mserver5.1.gz
 %dir %{_datadir}/doc/MonetDB
 %docdir %{_datadir}/doc/MonetDB
@@ -780,7 +780,6 @@ use SQL with MonetDB, you will need to i
 %config(noreplace) %attr(644,root,root) %{_sysconfdir}/logrotate.d/monetdbd
 %{_libdir}/monetdb5/autoload/??_sql.mal
 %{_libdir}/monetdb5/lib_sql.so
-%{_libdir}/monetdb5/*.sql
 %dir %{_libdir}/monetdb5/createdb
 %if %{with geos}
 %exclude %{_libdir}/monetdb5/createdb/*_geom.sql
@@ -878,10 +877,10 @@ Group: Applications/Databases
 %if "%{?_selinux_policy_version}" != ""
 Requires:       selinux-policy >= %{?_selinux_policy_version}
 %endif
-Requires(post):   MonetDB5-server = %{version}-%{release}
-Requires(postun): MonetDB5-server
-Requires(post):   %{name}-SQL-server5 = %{version}-%{release}
-Requires(postun): %{name}-SQL-server5
+Requires(post):   MonetDB5-server%{?_isa} = %{version}-%{release}
+Requires(postun): MonetDB5-server%{?_isa} = %{version}-%{release}
+Requires(post):   %{name}-SQL-server5%{?_isa} = %{version}-%{release}
+Requires(postun): %{name}-SQL-server5%{?_isa} = %{version}-%{release}
 Requires(post):   /usr/sbin/semodule, /sbin/restorecon, /sbin/fixfiles
 Requires(postun): /usr/sbin/semodule, /sbin/restorecon, /sbin/fixfiles
 BuildArch: noarch
@@ -1080,7 +1079,7 @@ done
 * Wed Oct  3 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.9-20181005
 - buildtools: On Ubuntu 18.10 (Cosmic Cuttlefish), the libmonetdb5-server-bam 
package
   cannot be built because of an incompatibility in the libbam library
-  (it cannot be used in a shared object.
+  (it cannot be used in a shared object).
 
 * Wed Aug 29 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.7-20180829
 - Rebuilt.
diff --git a/NT/Makefile b/NT/Makefile
--- a/NT/Makefile
+++ b/NT/Makefile
@@ -19,7 +19,7 @@ all: _all
 
 !INCLUDE "$(NT)\rules.msc"
 
-_all: update_winconfig_conds_py "$(srcdir)\Makefile.msc" monetdb_config.h 
unistd.h .monetdb
+_all: update_winconfig_conds_py "$(srcdir)\Makefile.msc" monetdb_config.h 
unistd.h .monetdb monetdb_hgversion.h
        $(MAKE) /nologo /f "$(srcdir)\Makefile.msc" "prefix=$(prefix)" 
"bits=$(bits)" all
 
 install: targetdirs all
@@ -34,6 +34,9 @@ install: targetdirs all
 monetdb_config.h: "$(TOPDIR)\winconfig_conds.py" "$(NT)\monetdb_config.h.in"
        $(CONFIGURE) "$(NT)\monetdb_config.h.in" > monetdb_config.h
 
+monetdb_hgversion.h:
+       $(ECHO) #undef MERCURIAL_ID > monetdb_hgversion.h
+
 unistd.h:
        $(ECHO) #ifndef UNISTD_H > unistd.h
        $(ECHO) #define UNISTD_H >> unistd.h
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
@@ -910,5 +910,6 @@ typedef __uint128_t uhge;
 
 #define PROMPT1                "\001\001\n"    /* prompt: ready for new query 
*/
 #define PROMPT2                "\001\002\n"    /* prompt: more data needed */
+#define PROMPT3                "\001\003\n"    /* prompt: get file content */
 
 #endif /* _SEEN_MONETDB_CONFIG_H */
diff --git a/bootstrap b/bootstrap
--- a/bootstrap
+++ b/bootstrap
@@ -62,6 +62,8 @@ aclocal$amv ${_m4_extra_dirs} || exit $?
 autoheader  || exit $?
 automake$amv --add-missing --copy --foreign  || exit $?
 autoconf || exit $?
+# a bit hacky: add dependency on monetdb_hgversion.h for 
common/utils/revision.c
+sed -i~ '/revision.*:/s;$; ../../monetdb_hgversion.h;' common/utils/Makefile.am
 if [ -f buildtools/conf/install-sh -a ! -x buildtools/conf/install-sh ]; then
     chmod +x buildtools/conf/install-sh
 fi
diff --git a/buildtools/ChangeLog-Archive b/buildtools/ChangeLog-Archive
--- a/buildtools/ChangeLog-Archive
+++ b/buildtools/ChangeLog-Archive
@@ -4,7 +4,7 @@
 * Wed Oct  3 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.9-20181005
 - On Ubuntu 18.10 (Cosmic Cuttlefish), the libmonetdb5-server-bam package
   cannot be built because of an incompatibility in the libbam library
-  (it cannot be used in a shared object.
+  (it cannot be used in a shared object).
 
 * Tue Aug 28 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.5-20180829
 - Build the MonetDB-cfitsio RPM and libmonetdb5-server-cfitsio
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
@@ -527,12 +527,12 @@ Ready.
 [ "algebra",   "exist",        "command algebra.exist(b:bat[:any_1], 
val:any_1):bit ", "ALGexist;",    "Returns whether 'val' occurs in b."    ]
 [ "algebra",   "fetch",        "command algebra.fetch(b:bat[:any_1], 
x:oid):any_1 ",   "ALGfetchoid;", "Returns the value of the BUN at x-th 
position with 0 <= x < b.count"   ]
 [ "algebra",   "find", "command algebra.find(b:bat[:any_1], t:any_1):oid ",    
"ALGfind;",     "Returns the index position of a value.  If no such BUN exists 
return OID-nil." ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGfirstn;",   
"Calculate first N values of B" ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, distinct:bit):bat[:oid] ", "ALGfirstn;",   "Calculate first N values 
of B" ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], 
X_1:bat[:oid]) ",  "ALGfirstn;",   "Calculate first N values of B with 
candidate list S"   ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, distinct:bit):bat[:oid] ",       
"ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    
   "ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, distinct:bit):bat[:oid] ",    "ALGfirstn;",   
"Calculate first N values of B with candidate list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",      
"ALGfirstn;",   "Calculate first N values of B" ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, nilslast:bit, distinct:bit):bat[:oid] ",   "ALGfirstn;",   "Calculate 
first N values of B" ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGfirstn;",   "Calculate first N values 
of B with candidate list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] 
", "ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], 
X_1:bat[:oid]) ", "ALGfirstn;",   "Calculate first N values of B with candidate 
list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] ",      
"ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
 [ "algebra",   "groupby",      "command algebra.groupby(gids:bat[:oid], 
cnts:bat[:lng]):bat[:oid] ",   "ALGgroupby;",  "Produces a new BAT with groups 
identified by the head column. The result contains tail times the head value, 
ie the tail contains the result group sizes."     ]
 [ "algebra",   "ilike",        "command algebra.ilike(s:str, pat:str):bit ",   
"PCREilike2;",  ""      ]
 [ "algebra",   "ilike",        "command algebra.ilike(s:str, pat:str, 
esc:str):bit ",  "PCREilike3;",  ""      ]
@@ -569,15 +569,15 @@ Ready.
 [ "algebra",   "slice",        "command algebra.slice(b:bat[:any_1], x:int, 
y:int):bat[:any_1] ",      "ALGslice_int;",        "Return the slice with the 
BUNs at position x till y."  ]
 [ "algebra",   "slice",        "command algebra.slice(b:bat[:any_1], x:lng, 
y:lng):bat[:any_1] ",      "ALGslice_lng;",        "Return the slice with the 
BUNs at position x till y."  ]
 [ "algebra",   "slice",        "command algebra.slice(b:bat[:any_1], x:oid, 
y:oid):bat[:any_1] ",      "ALGslice_oid;",        "Return the slice based on 
head oid x till y (exclusive)."      ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
stable:bit):bat[:any_1] ",    "ALGsort11;",   "Returns a copy of the BAT sorted 
on tail values.\n         The input and output are (must be) dense headed.\n    
     The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."        ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",       "ALGsort12;",   "Returns 
a copy of the BAT sorted on tail values and a BAT that\n         specifies how 
the input was reordered.\n         The input and output are (must be) dense 
headed.\n         The order is descending if the reverse bit is set.\n\t\t This 
is a stable sort if the stable bit is set." ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ",        
"ALGsort13;",   "Returns a copy of the BAT sorted on tail values, a BAT that 
specifies\n         how the input was reordered, and a BAT with group 
information.\n         The input and output are (must be) dense headed.\n       
  The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."  ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, stable:bit):bat[:any_1] ",       "ALGsort21;",   "Returns a copy 
of the BAT sorted on tail values.\n         The input and output are (must be) 
dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",  "ALGsort22;",   
"Returns a copy of the BAT sorted on tail values and a BAT that\n         
specifies how the input was reordered.\n         The input and output are (must 
be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set." ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ",   
"ALGsort23;",   "Returns a copy of the BAT sorted on tail values, a BAT that 
specifies\n         how the input was reordered, and a BAT with group 
information.\n         The input and output are (must be) dense headed.\n       
  The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."  ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, stable:bit):bat[:any_1] ",  "ALGsort31;",   "Returns 
a copy of the BAT sorted on tail values.\n         The input and output are 
(must be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",     
"ALGsort32;",   "Returns a copy of the BAT sorted on tail values and a BAT 
that\n         specifies how the input was reordered.\n         The input and 
output are (must be) dense headed.\n         The order is descending if the 
reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], 
X_2:bat[:oid]) ",      "ALGsort33;",   "Returns a copy of the BAT sorted on 
tail values, a BAT that specifies\n         how the input was reordered, and a 
BAT with group information.\n         The input and output are (must be) dense 
headed.\n         The order is descending if the reverse bit is set.\n\t\t This 
is a stable sort if the stable bit is set."  ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
nilslast:bit, stable:bit):bat[:any_1] ",      "ALGsort11;",   "Returns a copy 
of the BAT sorted on tail values.\n         The input and output are (must be) 
dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort12;",   
"Returns a copy of the BAT sorted on tail values and a BAT that\n         
specifies how the input was reordered.\n         The input and output are (must 
be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set." ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ",  
"ALGsort13;",   "Returns a copy of the BAT sorted on tail values, a BAT that 
specifies\n         how the input was reordered, and a BAT with group 
information.\n         The input and output are (must be) dense headed.\n       
  The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."  ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ", "ALGsort21;",   "Returns 
a copy of the BAT sorted on tail values.\n         The input and output are 
(must be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",    
"ALGsort22;",   "Returns a copy of the BAT sorted on tail values and a BAT 
that\n         specifies how the input was reordered.\n         The input and 
output are (must be) dense headed.\n         The order is descending if the 
reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], 
X_2:bat[:oid]) ",     "ALGsort23;",   "Returns a copy of the BAT sorted on tail 
values, a BAT that specifies\n         how the input was reordered, and a BAT 
with group information.\n         The input and output are (must be) dense 
headed.\n         The order is descending if the reverse bit is set.\n\t\t This 
is a stable sort if the stable bit is set."  ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ",    
"ALGsort31;",   "Returns a copy of the BAT sorted on tail values.\n         The 
input and output are (must be) dense headed.\n         The order is descending 
if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is 
set."        ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], 
X_1:bat[:oid]) ",       "ALGsort32;",   "Returns a copy of the BAT sorted on 
tail values and a BAT that\n         specifies how the input was reordered.\n   
      The input and output are (must be) dense headed.\n         The order is 
descending if the reverse bit is set.\n\t\t This is a stable sort if the stable 
bit is set." ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], 
X_1:bat[:oid], X_2:bat[:oid]) ",        "ALGsort33;",   "Returns a copy of the 
BAT sorted on tail values, a BAT that specifies\n         how the input was 
reordered, and a BAT with group information.\n         The input and output are 
(must be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."  ]
 [ "algebra",   "subslice",     "command algebra.subslice(b:bat[:any_1], x:lng, 
y:lng):bat[:oid] ",     "ALGsubslice_lng;",     "Return the oids of the slice 
with the BUNs at position x till y."      ]
 [ "algebra",   "thetajoin",    "command algebra.thetajoin(l:bat[:any_1], 
r:bat[:any_1], sl:bat[:oid], sr:bat[:oid], op:int, nil_matches:bit, 
estimate:lng) (X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGthetajoin;",        
"Theta join with candidate lists"       ]
 [ "algebra",   "thetaselect",  "command algebra.thetaselect(b:bat[:any_1], 
val:any_1, op:str):bat[:oid] ",     "ALGthetaselect1;",     "Select all head 
values for which the tail value obeys the relation\n\tvalue OP VAL.\n\tInput is 
a dense-headed BAT, output is a dense-headed BAT with in\n\tthe tail the head 
value of the input BAT for which the\n\trelationship holds.  The output BAT is 
sorted on the tail value."        ]
@@ -10523,10 +10523,6 @@ Ready.
 [ "mbr",       "#read",        "command mbr.#read():void ",    "mbrREAD;",     
""      ]
 [ "mbr",       "#tostr",       "command mbr.#tostr():void ",   "mbrTOSTR;",    
""      ]
 [ "mbr",       "#write",       "command mbr.#write():void ",   "mbrWRITE;",    
""      ]
-[ "mcurl",     "deleterequest",        "command mcurl.deleterequest(s:str):str 
",      "CURLdeleteRequest;",   "Perform a http delete request" ]
-[ "mcurl",     "getrequest",   "command mcurl.getrequest(s:str):str ", 
"CURLgetRequest;",      "Perform a http get request"    ]
-[ "mcurl",     "postrequest",  "command mcurl.postrequest(s:str):str ",        
"CURLpostRequest;",     "Perform a http post request"   ]
-[ "mcurl",     "putrequest",   "command mcurl.putrequest(s:str):str ", 
"CURLputRequest;",      "Perform a http put request"    ]
 [ "mdb",       "List", "pattern mdb.List(M:str, F:str):void ", 
"MDBlist3Detail;",      "Dump the routine M.F on standard out." ]
 [ "mdb",       "List", "pattern mdb.List():void ",     "MDBlistDetail;",       
"Dump the current routine on standard out."     ]
 [ "mdb",       "dump", "pattern mdb.dump():void ",     "MDBdump;",     "Dump 
instruction, stacktrace, and stack"       ]
@@ -11006,7 +11002,7 @@ Ready.
 [ "sql",       "bind_idxbat",  "pattern sql.bind_idxbat(mvc:int, schema:str, 
table:str, index:str, access:int, part_nr:int, nr_parts:int):bat[:any_1] ",     
  "mvc_bind_idxbat_wrap;",        "Bind the 'schema.table.index' BAT with 
access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates"   ]
 [ "sql",       "clear_table",  "pattern sql.clear_table(sname:str, 
tname:str):lng ",   "mvc_clear_table_wrap;",        "Clear the table 
sname.tname."  ]
 [ "sql",       "commit",       "pattern sql.commit():void ",   "SQLcommit;",   
"Trigger the commit operation for a MAL block"  ]
-[ "sql",       "copy_from",    "pattern sql.copy_from(t:ptr, sep:str, 
rsep:str, ssep:str, ns:str, fname:str, nr:lng, offset:lng, locked:int, 
best:int, fwf:str):bat[:any]... ",        "mvc_import_table_wrap;",       
"Import a table from bstream s with the \n\tgiven tuple and seperators 
(sep/rsep)"      ]
+[ "sql",       "copy_from",    "pattern sql.copy_from(t:ptr, sep:str, 
rsep:str, ssep:str, ns:str, fname:str, nr:lng, offset:lng, locked:int, 
best:int, fwf:str, onclient:int):bat[:any]... ",  "mvc_import_table_wrap;",     
  "Import a table from bstream s with the \n\tgiven tuple and seperators 
(sep/rsep)"      ]
 [ "sql",       "copy_rejects", "pattern sql.copy_rejects() (rowid:bat[:lng], 
fldid:bat[:int], msg:bat[:str], inp:bat[:str]) ", "COPYrejects;", ""      ]
 [ "sql",       "copy_rejects_clear",   "pattern sql.copy_rejects_clear():void 
",       "COPYrejects_clear;",   ""      ]
 [ "sql",       "createorderindex",     "pattern sql.createorderindex(sch:str, 
tbl:str, col:str):void ",        "sql_createorderindex;",        "Instantiate 
the order index on a column"       ]
@@ -11047,14 +11043,14 @@ Ready.
 [ "sql",       "exportHead",   "pattern sql.exportHead(s:streams, 
res_id:int):void ",  "mvc_export_head_wrap;",        "Export a result (in 
order) to stream s"        ]
 [ "sql",       "exportOperation",      "pattern sql.exportOperation():void ",  
"mvc_export_operation_wrap;",   "Export result of schema/transaction queries"   
]
 [ "sql",       "exportResult", "pattern sql.exportResult(s:streams, 
res_id:int):void ",        "mvc_export_result_wrap;",      "Export a result (in 
order) to stream s"        ]
-[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, tbl:bat[:str], attr:bat[:str], 
tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:any...):int ",  
"mvc_export_row_wrap;", "Prepare a table result set for the COPY INTO stream"   
]
-[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, tbl:bat[:str], attr:bat[:str], 
tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:bat[:any]...):int ",    
"mvc_export_table_wrap;",       "Prepare a table result set for the COPY INTO 
stream"   ]
+[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, onclient:int, tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:any...):int 
",    "mvc_export_row_wrap;", "Prepare a table result set for the COPY INTO 
stream"   ]
+[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, onclient:int, tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], 
cols:bat[:any]...):int ",      "mvc_export_table_wrap;",       "Prepare a table 
result set for the COPY INTO stream"   ]
 [ "sql",       "flush_log",    "command sql.flush_log():void ",        
"SQLflush_log;",        "flush the log now"     ]
 [ "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",       "importTable",  "pattern sql.importTable(sname:str, tname:str, 
onclient:int, 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"    ]
 [ "sql",       "logfile",      "pattern sql.logfile(filename:str):void ",      
"mvc_logfile;", "Enable/disable saving the sql statement traces"        ]
@@ -11174,6 +11170,9 @@ Ready.
 [ "sqlcatalog",        "grant",        "pattern sqlcatalog.grant(sname:str, 
tbl:str, grantee:str, privs:int, cname:str, gr:int, grantor:int):void ",   
"SQLgrant;",    "Catalog operation grant"       ]
 [ "sqlcatalog",        "grant_function",       "pattern 
sqlcatalog.grant_function(sname:str, fcnid:int, grantee:str, privs:int, 
grant:int, grantor:int):void ",        "SQLgrant_function;",   "Catalog 
operation grant_function"      ]
 [ "sqlcatalog",        "grant_roles",  "pattern 
sqlcatalog.grant_roles(sname:str, auth:str, grantor:int, admin:int):void ",    
"SQLgrant_roles;",      "Catalog operation grant_roles" ]
+[ "sqlcatalog",        "rename_column",        "pattern 
sqlcatalog.rename_column(sname:str, tname:str, cname:str, newnme:str):void ",  
"SQLrename_column;",    "Catalog operation rename_column"       ]
+[ "sqlcatalog",        "rename_schema",        "pattern 
sqlcatalog.rename_schema(sname:str, newnme:str):void ",        
"SQLrename_schema;",    "Catalog operation rename_schema"       ]
+[ "sqlcatalog",        "rename_table", "pattern 
sqlcatalog.rename_table(sname:str, tname:str, newnme:str):void ",      
"SQLrename_table;",     "Catalog operation rename_table"        ]
 [ "sqlcatalog",        "rename_user",  "pattern 
sqlcatalog.rename_user(sname:str, newnme:str, action:int):void ",      
"SQLrename_user;",      "Catalog operation rename_user" ]
 [ "sqlcatalog",        "revoke",       "pattern sqlcatalog.revoke(sname:str, 
tbl:str, grantee:str, privs:int, cname:str, grant:int, grantor:int):void ",     
  "SQLrevoke;",   "Catalog operation revoke"      ]
 [ "sqlcatalog",        "revoke_function",      "pattern 
sqlcatalog.revoke_function(sname:str, fcnid:int, grantee:str, privs:int, 
grant:int, grantor:int):void ",       "SQLrevoke_function;",  "Catalog 
operation revoke_function"     ]
@@ -11405,6 +11404,9 @@ Ready.
 [ "wlc",       "master",       "pattern wlc.master():void ",   "WLCmaster;",   
"Activate the workload-capture-replay process"  ]
 [ "wlc",       "master",       "pattern wlc.master(path:str):void ",   
"WLCmaster;",   "Activate the workload-capture-replay process. Use a different 
location for the logs."  ]
 [ "wlc",       "query",        "pattern wlc.query(q:str):void ",       
"WLCquery;",    "Keep the queries for replay."  ]
+[ "wlc",       "rename_column",        "pattern wlc.rename_column(sname:str, 
tname:str, cname:str, newnme:str):void ", "WLCgeneric;",  "Catalog operation 
rename_column"       ]
+[ "wlc",       "rename_schema",        "pattern wlc.rename_schema(sname:str, 
newnme:str):void ",       "WLCgeneric;",  "Catalog operation rename_schema"     
  ]
+[ "wlc",       "rename_table", "pattern wlc.rename_table(sname:str, tname:str, 
newnme:str):void ",     "WLCgeneric;",  "Catalog operation rename_table"        
]
 [ "wlc",       "rename_user",  "pattern wlc.rename_user(sname:str, newnme:str, 
action:int):void ",     "WLCgeneric;",  "Catalog operation rename_user" ]
 [ "wlc",       "revoke",       "pattern wlc.revoke(sname:str, tbl:str, 
grantee:str, privs:int, cname:str, grant:int, grantor:int):void ",      
"WLCgeneric;",  "Catalog operation revoke"      ]
 [ "wlc",       "revoke_function",      "pattern wlc.revoke_function(sname:str, 
fcnid:int, grantee:str, privs:int, grant:int, grantor:int):void ",      
"WLCgeneric;",  "Catalog operation revoke_function"     ]
@@ -11462,6 +11464,9 @@ Ready.
 [ "wlr",       "grant",        "pattern wlr.grant(sname:str, tbl:str, 
grantee:str, privs:int, cname:str, gr:int, grantor:int):void ",  "WLRgeneric;", 
 "Catalog operation grant"       ]
 [ "wlr",       "grant_function",       "pattern wlr.grant_function(sname:str, 
fcnid:int, grantee:str, privs:int, grant:int, grantor:int):void ",       
"WLRgeneric;",  "Catalog operation grant_function"      ]
 [ "wlr",       "grant_roles",  "pattern wlr.grant_roles(sname:str, auth:str, 
grantor:int, admin:int):void ",   "WLRgeneric;",  "Catalog operation 
grant_roles" ]
+[ "wlr",       "rename_column",        "pattern wlr.rename_column(sname:str, 
tname:str, cname:str, newnme:str):void ", "WLRgeneric;",  "Catalog operation 
rename_column"       ]
+[ "wlr",       "rename_schema",        "pattern wlr.rename_schema(sname:str, 
newnme:str):void ",       "WLRgeneric;",  "Catalog operation rename_schema"     
  ]
+[ "wlr",       "rename_table", "pattern wlr.rename_table(sname:str, tname:str, 
newnme:str):void ",     "WLRgeneric;",  "Catalog operation rename_table"        
]
 [ "wlr",       "rename_user",  "pattern wlr.rename_user(sname:str, newnme:str, 
action:int):void ",     "WLRgeneric;",  "Catalog operation rename_user" ]
 [ "wlr",       "replicate",    "pattern wlr.replicate():void ",        
"WLRreplicate;",        "Roll the snapshot forward to an up-to-date clone"      
]
 [ "wlr",       "replicate",    "pattern wlr.replicate(dbname:str):void ",      
"WLRreplicate;",        "Roll the snapshot forward to an up-to-date clone"      
]
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
@@ -631,12 +631,12 @@ Ready.
 [ "algebra",   "exist",        "command algebra.exist(b:bat[:any_1], 
val:any_1):bit ", "ALGexist;",    "Returns whether 'val' occurs in b."    ]
 [ "algebra",   "fetch",        "command algebra.fetch(b:bat[:any_1], 
x:oid):any_1 ",   "ALGfetchoid;", "Returns the value of the BUN at x-th 
position with 0 <= x < b.count"   ]
 [ "algebra",   "find", "command algebra.find(b:bat[:any_1], t:any_1):oid ",    
"ALGfind;",     "Returns the index position of a value.  If no such BUN exists 
return OID-nil." ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGfirstn;",   
"Calculate first N values of B" ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, distinct:bit):bat[:oid] ", "ALGfirstn;",   "Calculate first N values 
of B" ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], 
X_1:bat[:oid]) ",  "ALGfirstn;",   "Calculate first N values of B with 
candidate list S"   ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, distinct:bit):bat[:oid] ",       
"ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",    
   "ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
-[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, distinct:bit):bat[:oid] ",    "ALGfirstn;",   
"Calculate first N values of B with candidate list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ",      
"ALGfirstn;",   "Calculate first N values of B" ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], n:lng, 
asc:bit, nilslast:bit, distinct:bit):bat[:oid] ",   "ALGfirstn;",   "Calculate 
first N values of B" ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit) 
(X_0:bat[:oid], X_1:bat[:oid]) ",    "ALGfirstn;",   "Calculate first N values 
of B with candidate list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], g:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] 
", "ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], 
X_1:bat[:oid]) ", "ALGfirstn;",   "Calculate first N values of B with candidate 
list S"   ]
+[ "algebra",   "firstn",       "pattern algebra.firstn(b:bat[:any], 
s:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] ",      
"ALGfirstn;",   "Calculate first N values of B with candidate list S"   ]
 [ "algebra",   "groupby",      "command algebra.groupby(gids:bat[:oid], 
cnts:bat[:lng]):bat[:oid] ",   "ALGgroupby;",  "Produces a new BAT with groups 
identified by the head column. The result contains tail times the head value, 
ie the tail contains the result group sizes."     ]
 [ "algebra",   "ilike",        "command algebra.ilike(s:str, pat:str):bit ",   
"PCREilike2;",  ""      ]
 [ "algebra",   "ilike",        "command algebra.ilike(s:str, pat:str, 
esc:str):bit ",  "PCREilike3;",  ""      ]
@@ -673,15 +673,15 @@ Ready.
 [ "algebra",   "slice",        "command algebra.slice(b:bat[:any_1], x:int, 
y:int):bat[:any_1] ",      "ALGslice_int;",        "Return the slice with the 
BUNs at position x till y."  ]
 [ "algebra",   "slice",        "command algebra.slice(b:bat[:any_1], x:lng, 
y:lng):bat[:any_1] ",      "ALGslice_lng;",        "Return the slice with the 
BUNs at position x till y."  ]
 [ "algebra",   "slice",        "command algebra.slice(b:bat[:any_1], x:oid, 
y:oid):bat[:any_1] ",      "ALGslice_oid;",        "Return the slice based on 
head oid x till y (exclusive)."      ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
stable:bit):bat[:any_1] ",    "ALGsort11;",   "Returns a copy of the BAT sorted 
on tail values.\n         The input and output are (must be) dense headed.\n    
     The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."        ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",       "ALGsort12;",   "Returns 
a copy of the BAT sorted on tail values and a BAT that\n         specifies how 
the input was reordered.\n         The input and output are (must be) dense 
headed.\n         The order is descending if the reverse bit is set.\n\t\t This 
is a stable sort if the stable bit is set." ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ",        
"ALGsort13;",   "Returns a copy of the BAT sorted on tail values, a BAT that 
specifies\n         how the input was reordered, and a BAT with group 
information.\n         The input and output are (must be) dense headed.\n       
  The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."  ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, stable:bit):bat[:any_1] ",       "ALGsort21;",   "Returns a copy 
of the BAT sorted on tail values.\n         The input and output are (must be) 
dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",  "ALGsort22;",   
"Returns a copy of the BAT sorted on tail values and a BAT that\n         
specifies how the input was reordered.\n         The input and output are (must 
be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set." ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ",   
"ALGsort23;",   "Returns a copy of the BAT sorted on tail values, a BAT that 
specifies\n         how the input was reordered, and a BAT with group 
information.\n         The input and output are (must be) dense headed.\n       
  The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."  ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, stable:bit):bat[:any_1] ",  "ALGsort31;",   "Returns 
a copy of the BAT sorted on tail values.\n         The input and output are 
(must be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",     
"ALGsort32;",   "Returns a copy of the BAT sorted on tail values and a BAT 
that\n         specifies how the input was reordered.\n         The input and 
output are (must be) dense headed.\n         The order is descending if the 
reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ]
-[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], 
X_2:bat[:oid]) ",      "ALGsort33;",   "Returns a copy of the BAT sorted on 
tail values, a BAT that specifies\n         how the input was reordered, and a 
BAT with group information.\n         The input and output are (must be) dense 
headed.\n         The order is descending if the reverse bit is set.\n\t\t This 
is a stable sort if the stable bit is set."  ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
nilslast:bit, stable:bit):bat[:any_1] ",      "ALGsort11;",   "Returns a copy 
of the BAT sorted on tail values.\n         The input and output are (must be) 
dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort12;",   
"Returns a copy of the BAT sorted on tail values and a BAT that\n         
specifies how the input was reordered.\n         The input and output are (must 
be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set." ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, 
nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ",  
"ALGsort13;",   "Returns a copy of the BAT sorted on tail values, a BAT that 
specifies\n         how the input was reordered, and a BAT with group 
information.\n         The input and output are (must be) dense headed.\n       
  The order is descending if the reverse bit is set.\n\t\t This is a stable 
sort if the stable bit is set."  ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ", "ALGsort21;",   "Returns 
a copy of the BAT sorted on tail values.\n         The input and output are 
(must be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."        ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ",    
"ALGsort22;",   "Returns a copy of the BAT sorted on tail values and a BAT 
that\n         specifies how the input was reordered.\n         The input and 
output are (must be) dense headed.\n         The order is descending if the 
reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], 
X_2:bat[:oid]) ",     "ALGsort23;",   "Returns a copy of the BAT sorted on tail 
values, a BAT that specifies\n         how the input was reordered, and a BAT 
with group information.\n         The input and output are (must be) dense 
headed.\n         The order is descending if the reverse bit is set.\n\t\t This 
is a stable sort if the stable bit is set."  ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ",    
"ALGsort31;",   "Returns a copy of the BAT sorted on tail values.\n         The 
input and output are (must be) dense headed.\n         The order is descending 
if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is 
set."        ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], 
X_1:bat[:oid]) ",       "ALGsort32;",   "Returns a copy of the BAT sorted on 
tail values and a BAT that\n         specifies how the input was reordered.\n   
      The input and output are (must be) dense headed.\n         The order is 
descending if the reverse bit is set.\n\t\t This is a stable sort if the stable 
bit is set." ]
+[ "algebra",   "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], 
g:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], 
X_1:bat[:oid], X_2:bat[:oid]) ",        "ALGsort33;",   "Returns a copy of the 
BAT sorted on tail values, a BAT that specifies\n         how the input was 
reordered, and a BAT with group information.\n         The input and output are 
(must be) dense headed.\n         The order is descending if the reverse bit is 
set.\n\t\t This is a stable sort if the stable bit is set."  ]
 [ "algebra",   "subslice",     "command algebra.subslice(b:bat[:any_1], x:lng, 
y:lng):bat[:oid] ",     "ALGsubslice_lng;",     "Return the oids of the slice 
with the BUNs at position x till y."      ]
 [ "algebra",   "thetajoin",    "command algebra.thetajoin(l:bat[:any_1], 
r:bat[:any_1], sl:bat[:oid], sr:bat[:oid], op:int, nil_matches:bit, 
estimate:lng) (X_0:bat[:oid], X_1:bat[:oid]) ",   "ALGthetajoin;",        
"Theta join with candidate lists"       ]
 [ "algebra",   "thetaselect",  "command algebra.thetaselect(b:bat[:any_1], 
val:any_1, op:str):bat[:oid] ",     "ALGthetaselect1;",     "Select all head 
values for which the tail value obeys the relation\n\tvalue OP VAL.\n\tInput is 
a dense-headed BAT, output is a dense-headed BAT with in\n\tthe tail the head 
value of the input BAT for which the\n\trelationship holds.  The output BAT is 
sorted on the tail value."        ]
@@ -14737,10 +14737,6 @@ Ready.
 [ "mbr",       "#read",        "command mbr.#read():void ",    "mbrREAD;",     
""      ]
 [ "mbr",       "#tostr",       "command mbr.#tostr():void ",   "mbrTOSTR;",    
""      ]
 [ "mbr",       "#write",       "command mbr.#write():void ",   "mbrWRITE;",    
""      ]
-[ "mcurl",     "deleterequest",        "command mcurl.deleterequest(s:str):str 
",      "CURLdeleteRequest;",   "Perform a http delete request" ]
-[ "mcurl",     "getrequest",   "command mcurl.getrequest(s:str):str ", 
"CURLgetRequest;",      "Perform a http get request"    ]
-[ "mcurl",     "postrequest",  "command mcurl.postrequest(s:str):str ",        
"CURLpostRequest;",     "Perform a http post request"   ]
-[ "mcurl",     "putrequest",   "command mcurl.putrequest(s:str):str ", 
"CURLputRequest;",      "Perform a http put request"    ]
 [ "mdb",       "List", "pattern mdb.List(M:str, F:str):void ", 
"MDBlist3Detail;",      "Dump the routine M.F on standard out." ]
 [ "mdb",       "List", "pattern mdb.List():void ",     "MDBlistDetail;",       
"Dump the current routine on standard out."     ]
 [ "mdb",       "dump", "pattern mdb.dump():void ",     "MDBdump;",     "Dump 
instruction, stacktrace, and stack"       ]
@@ -15221,7 +15217,7 @@ Ready.
 [ "sql",       "bind_idxbat",  "pattern sql.bind_idxbat(mvc:int, schema:str, 
table:str, index:str, access:int, part_nr:int, nr_parts:int):bat[:any_1] ",     
  "mvc_bind_idxbat_wrap;",        "Bind the 'schema.table.index' BAT with 
access kind:\n\t0 - base table\n\t1 - inserts\n\t2 - updates"   ]
 [ "sql",       "clear_table",  "pattern sql.clear_table(sname:str, 
tname:str):lng ",   "mvc_clear_table_wrap;",        "Clear the table 
sname.tname."  ]
 [ "sql",       "commit",       "pattern sql.commit():void ",   "SQLcommit;",   
"Trigger the commit operation for a MAL block"  ]
-[ "sql",       "copy_from",    "pattern sql.copy_from(t:ptr, sep:str, 
rsep:str, ssep:str, ns:str, fname:str, nr:lng, offset:lng, locked:int, 
best:int, fwf:str):bat[:any]... ",        "mvc_import_table_wrap;",       
"Import a table from bstream s with the \n\tgiven tuple and seperators 
(sep/rsep)"      ]
+[ "sql",       "copy_from",    "pattern sql.copy_from(t:ptr, sep:str, 
rsep:str, ssep:str, ns:str, fname:str, nr:lng, offset:lng, locked:int, 
best:int, fwf:str, onclient:int):bat[:any]... ",  "mvc_import_table_wrap;",     
  "Import a table from bstream s with the \n\tgiven tuple and seperators 
(sep/rsep)"      ]
 [ "sql",       "copy_rejects", "pattern sql.copy_rejects() (rowid:bat[:lng], 
fldid:bat[:int], msg:bat[:str], inp:bat[:str]) ", "COPYrejects;", ""      ]
 [ "sql",       "copy_rejects_clear",   "pattern sql.copy_rejects_clear():void 
",       "COPYrejects_clear;",   ""      ]
 [ "sql",       "createorderindex",     "pattern sql.createorderindex(sch:str, 
tbl:str, col:str):void ",        "sql_createorderindex;",        "Instantiate 
the order index on a column"       ]
@@ -15263,14 +15259,14 @@ Ready.
 [ "sql",       "exportHead",   "pattern sql.exportHead(s:streams, 
res_id:int):void ",  "mvc_export_head_wrap;",        "Export a result (in 
order) to stream s"        ]
 [ "sql",       "exportOperation",      "pattern sql.exportOperation():void ",  
"mvc_export_operation_wrap;",   "Export result of schema/transaction queries"   
]
 [ "sql",       "exportResult", "pattern sql.exportResult(s:streams, 
res_id:int):void ",        "mvc_export_result_wrap;",      "Export a result (in 
order) to stream s"        ]
-[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, tbl:bat[:str], attr:bat[:str], 
tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:any...):int ",  
"mvc_export_row_wrap;", "Prepare a table result set for the COPY INTO stream"   
]
-[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, tbl:bat[:str], attr:bat[:str], 
tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:bat[:any]...):int ",    
"mvc_export_table_wrap;",       "Prepare a table result set for the COPY INTO 
stream"   ]
+[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, onclient:int, tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:any...):int 
",    "mvc_export_row_wrap;", "Prepare a table result set for the COPY INTO 
stream"   ]
+[ "sql",       "export_table", "pattern sql.export_table(fname:str, fmt:str, 
colsep:str, recsep:str, qout:str, nullrep:str, onclient:int, tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], 
cols:bat[:any]...):int ",      "mvc_export_table_wrap;",       "Prepare a table 
result set for the COPY INTO stream"   ]
 [ "sql",       "flush_log",    "command sql.flush_log():void ",        
"SQLflush_log;",        "flush the log now"     ]
 [ "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."  
]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to