Changeset: 268c16546969 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=268c16546969
Added Files:
        sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.sql
        sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.err
        sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.out
        sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.stable.err
        sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.stable.out
        sql/test/BugTracker-2017/Tests/parsererror.Bug-6381.sql
        sql/test/BugTracker-2017/Tests/spurious_error.Bug-6344.stable.err
        sql/test/BugTracker-2017/Tests/spurious_error.Bug-6344.stable.out
Modified Files:
        clients/Tests/MAL-signatures.stable.out
        clients/Tests/MAL-signatures.stable.out.int128
        clients/mapiclient/mclient.c
        common/stream/stream.c
        geom/BugTracker/Tests/X_crash.SF-1971632.stable.err
        geom/BugTracker/Tests/copy_into_crash.SF-1975402.stable.err
        geom/monetdb5/geom.c
        geom/monetdb5/geomBulk.c
        geom/sql/functions/Tests/ST_AsEWKT.stable.out
        geom/sql/functions/Tests/ST_AsText.stable.out
        geom/sql/functions/Tests/ST_Boundary.stable.out
        geom/sql/functions/Tests/ST_Contains.stable.out
        geom/sql/functions/Tests/ST_CoordDim.stable.out
        geom/sql/functions/Tests/ST_Dimension.stable.out
        geom/sql/functions/Tests/ST_GeomFromText.stable.err
        geom/sql/functions/Tests/ST_GeomFromText.stable.out
        geom/sql/functions/Tests/ST_GeometryN.stable.out
        geom/sql/functions/Tests/ST_GeometryType.stable.out
        geom/sql/functions/Tests/ST_IsClosed.stable.out
        geom/sql/functions/Tests/ST_IsEmpty.stable.out
        geom/sql/functions/Tests/ST_IsRing.stable.out
        geom/sql/functions/Tests/ST_IsSimple.stable.out
        geom/sql/functions/Tests/ST_IsValid.stable.out
        geom/sql/functions/Tests/ST_LineFromText.stable.err
        geom/sql/functions/Tests/ST_LineFromText.stable.out
        geom/sql/functions/Tests/ST_MLineFromText.stable.err
        geom/sql/functions/Tests/ST_MLineFromText.stable.out
        geom/sql/functions/Tests/ST_MPointFromText.stable.err
        geom/sql/functions/Tests/ST_MPointFromText.stable.out
        geom/sql/functions/Tests/ST_MPolygonFromText.stable.err
        geom/sql/functions/Tests/ST_MPolygonFromText.stable.out
        geom/sql/functions/Tests/ST_MakeBox2D.stable.err
        geom/sql/functions/Tests/ST_MakeBox2D.stable.out
        geom/sql/functions/Tests/ST_MakePoint.stable.err
        geom/sql/functions/Tests/ST_MakePoint.stable.out
        geom/sql/functions/Tests/ST_NPoints.stable.out
        geom/sql/functions/Tests/ST_NRings.stable.out
        geom/sql/functions/Tests/ST_NumGeometries.stable.out
        geom/sql/functions/Tests/ST_NumPoints.stable.err
        geom/sql/functions/Tests/ST_NumPoints.stable.out
        geom/sql/functions/Tests/ST_PointFromText.stable.err
        geom/sql/functions/Tests/ST_PointFromText.stable.out
        geom/sql/functions/Tests/ST_PolygonFromText.stable.err
        geom/sql/functions/Tests/ST_PolygonFromText.stable.out
        geom/sql/functions/Tests/XYZ.stable.err
        geom/sql/functions/Tests/XYZ.stable.out
        geom/sql/functions/Tests/XYZMinMax.stable.out
        monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err
        monetdb5/extras/mal_optimizer_template/opt_sql_append.c
        monetdb5/extras/rapi/Tests/rapi10.malC
        monetdb5/mal/Tests/parseErrors.stable.err
        monetdb5/mal/Tests/tst002.stable.err
        monetdb5/mal/Tests/tst008.stable.err
        monetdb5/mal/Tests/tst010.malC
        monetdb5/mal/Tests/tst010.stable.err
        monetdb5/mal/Tests/tst013.stable.err
        monetdb5/mal/Tests/tst019.stable.err
        monetdb5/mal/Tests/tst036.stable.err
        monetdb5/mal/Tests/tst038.stable.err
        monetdb5/mal/Tests/tst054.stable.err
        monetdb5/mal/Tests/tst058.stable.err
        monetdb5/mal/Tests/tst070.stable.err
        monetdb5/mal/Tests/tst108.stable.err
        monetdb5/mal/Tests/tst109.stable.err
        monetdb5/mal/Tests/tst116.stable.err
        monetdb5/mal/Tests/tst161.stable.err
        monetdb5/mal/Tests/tst163.stable.err
        monetdb5/mal/Tests/tst2504.malC
        monetdb5/mal/Tests/tst2510.malC
        monetdb5/mal/Tests/tst2570.malC
        monetdb5/mal/Tests/tst301.malC
        monetdb5/mal/Tests/tst301.stable.out
        monetdb5/mal/Tests/tst302.stable.err
        monetdb5/mal/Tests/tst303.stable.err
        monetdb5/mal/Tests/tst305.stable.err
        monetdb5/mal/Tests/tst755.stable.err
        monetdb5/mal/Tests/tst760.stable.err
        monetdb5/mal/Tests/tst804.stable.err
        monetdb5/mal/Tests/tst900.stable.err
        monetdb5/mal/mal.c
        monetdb5/mal/mal.h
        monetdb5/mal/mal_atom.c
        monetdb5/mal/mal_atom.h
        monetdb5/mal/mal_builder.c
        monetdb5/mal/mal_client.c
        monetdb5/mal/mal_client.h
        monetdb5/mal/mal_debugger.c
        monetdb5/mal/mal_exception.c
        monetdb5/mal/mal_exception.h
        monetdb5/mal/mal_factory.c
        monetdb5/mal/mal_function.c
        monetdb5/mal/mal_function.h
        monetdb5/mal/mal_import.c
        monetdb5/mal/mal_import.h
        monetdb5/mal/mal_instruction.c
        monetdb5/mal/mal_instruction.h
        monetdb5/mal/mal_interpreter.c
        monetdb5/mal/mal_interpreter.h
        monetdb5/mal/mal_linker.c
        monetdb5/mal/mal_linker.h
        monetdb5/mal/mal_listing.c
        monetdb5/mal/mal_module.c
        monetdb5/mal/mal_module.h
        monetdb5/mal/mal_parser.c
        monetdb5/mal/mal_parser.h
        monetdb5/mal/mal_private.h
        monetdb5/mal/mal_profiler.c
        monetdb5/mal/mal_resolve.c
        monetdb5/mal/mal_resolve.h
        monetdb5/mal/mal_runtime.c
        monetdb5/mal/mal_scenario.c
        monetdb5/mal/mal_scenario.h
        monetdb5/mal/mal_session.c
        monetdb5/mal/mal_session.h
        monetdb5/mal/mal_stack.c
        monetdb5/modules/atoms/mtime.c
        monetdb5/modules/atoms/uuid.c
        monetdb5/modules/mal/clients.c
        monetdb5/modules/mal/clients.h
        monetdb5/modules/mal/clients.mal
        monetdb5/modules/mal/factories.c
        monetdb5/modules/mal/inspect.c
        monetdb5/modules/mal/language.c
        monetdb5/modules/mal/manifold.c
        monetdb5/modules/mal/manual.c
        monetdb5/modules/mal/mdb.c
        monetdb5/modules/mal/orderidx.c
        monetdb5/modules/mal/remote.c
        monetdb5/modules/mal/tablet.c
        monetdb5/optimizer/Tests/GCexample01.stable.out
        monetdb5/optimizer/Tests/dataflow.stable.out
        monetdb5/optimizer/Tests/inline06.stable.out
        monetdb5/optimizer/Tests/tst4006.stable.out
        monetdb5/optimizer/Tests/tst4630.stable.out
        monetdb5/optimizer/opt_aliases.c
        monetdb5/optimizer/opt_candidates.c
        monetdb5/optimizer/opt_coercion.c
        monetdb5/optimizer/opt_commonTerms.c
        monetdb5/optimizer/opt_constants.c
        monetdb5/optimizer/opt_costModel.c
        monetdb5/optimizer/opt_dataflow.c
        monetdb5/optimizer/opt_deadcode.c
        monetdb5/optimizer/opt_emptybind.c
        monetdb5/optimizer/opt_evaluate.c
        monetdb5/optimizer/opt_garbageCollector.c
        monetdb5/optimizer/opt_generator.c
        monetdb5/optimizer/opt_inline.c
        monetdb5/optimizer/opt_jit.c
        monetdb5/optimizer/opt_json.c
        monetdb5/optimizer/opt_macro.c
        monetdb5/optimizer/opt_matpack.c
        monetdb5/optimizer/opt_mergetable.c
        monetdb5/optimizer/opt_mitosis.c
        monetdb5/optimizer/opt_multiplex.c
        monetdb5/optimizer/opt_oltp.c
        monetdb5/optimizer/opt_pipes.c
        monetdb5/optimizer/opt_pipes.h
        monetdb5/optimizer/opt_profiler.c
        monetdb5/optimizer/opt_projectionpath.c
        monetdb5/optimizer/opt_pushselect.c
        monetdb5/optimizer/opt_querylog.c
        monetdb5/optimizer/opt_reduce.c
        monetdb5/optimizer/opt_remap.c
        monetdb5/optimizer/opt_remoteQueries.c
        monetdb5/optimizer/opt_reorder.c
        monetdb5/optimizer/opt_support.c
        monetdb5/optimizer/opt_volcano.c
        monetdb5/optimizer/opt_wlc.c
        monetdb5/optimizer/opt_wrapper.c
        monetdb5/optimizer/optimizer.c
        monetdb5/scheduler/run_adder.c
        sql/backends/monet5/LSST/lsst.c
        sql/backends/monet5/UDF/cudf/udf.c
        sql/backends/monet5/UDF/pyapi/connection.c
        sql/backends/monet5/UDF/pyapi/conversion.c
        sql/backends/monet5/UDF/pyapi/convert_loops.h
        sql/backends/monet5/UDF/pyapi/emit.c
        sql/backends/monet5/UDF/pyapi/formatinput.c
        sql/backends/monet5/UDF/pyapi/pyapi.c
        sql/backends/monet5/UDF/pyapi/pyheader.h
        sql/backends/monet5/UDF/pyapi/pyloader.c
        sql/backends/monet5/UDF/pyapi/type_conversion.c
        sql/backends/monet5/generator/Tests/crash.Bug-3609.stable.err
        sql/backends/monet5/generator/Tests/generator01.stable.err
        sql/backends/monet5/generator/Tests/generator04.stable.err
        sql/backends/monet5/generator/generator.c
        sql/backends/monet5/rel_bin.c
        sql/backends/monet5/sql.c
        sql/backends/monet5/sql_assert.c
        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_execute.c
        sql/backends/monet5/sql_fround_impl.h
        sql/backends/monet5/sql_gencode.c
        sql/backends/monet5/sql_optimizer.c
        sql/backends/monet5/sql_orderidx.c
        sql/backends/monet5/sql_rank.c
        sql/backends/monet5/sql_result.c
        sql/backends/monet5/sql_round_impl.h
        sql/backends/monet5/sql_scenario.c
        sql/backends/monet5/sql_scenario.h
        sql/backends/monet5/sql_statistics.c
        sql/backends/monet5/sql_transaction.c
        sql/backends/monet5/sql_upgrades.c
        sql/backends/monet5/sql_user.c
        sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.err
        sql/backends/monet5/vaults/bam/Tests/mergetable.stable.err
        sql/backends/monet5/vaults/bam/Tests/verify_load.stable.err
        sql/backends/monet5/vaults/bam/bam_export.c
        sql/backends/monet5/vaults/bam/bam_lib.c
        sql/backends/monet5/vaults/bam/bam_loader.c
        sql/backends/monet5/vaults/bam/bam_wrapper.c
        sql/backends/monet5/vaults/fits/fits.c
        sql/backends/monet5/vaults/lidar/lidar.c
        sql/backends/monet5/vaults/netcdf/netcdf.c
        sql/backends/monet5/vaults/shp/shp.c
        sql/backends/monet5/vaults/vault.c
        sql/backends/monet5/wlr.c
        sql/benchmarks/nobench/Tests/nobench.stable.err
        sql/benchmarks/nobench/Tests/nobench.stable.out
        sql/common/sql_string.c
        sql/server/rel_dump.c
        sql/server/rel_optimizer.c
        sql/server/rel_psm.c
        sql/server/rel_rel.c
        sql/server/rel_schema.c
        sql/server/rel_select.c
        sql/server/rel_semantic.c
        sql/server/rel_sequence.c
        sql/server/rel_trans.c
        sql/server/rel_updates.c
        sql/server/rel_xml.c
        sql/server/sql_env.c
        sql/server/sql_mvc.c
        sql/server/sql_parser.y
        sql/server/sql_privileges.c
        sql/server/sql_scan.c
        sql/test/ADT2006/Tests/sander.stable.err
        sql/test/BugConstraints/Tests/add_constraint_1643522.stable.err
        sql/test/BugConstraints/Tests/delete_primarykey_1643845.stable.err
        sql/test/BugConstraints/Tests/drop_column_1643542.stable.err
        sql/test/BugConstraints/Tests/update_primarykey_1643375.stable.err
        sql/test/BugDay_2005-10-06_2.8/Tests/double_commit.SF-916584.stable.err
        sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.err
        sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out
        
sql/test/BugDay_2005-10-06_2.8/Tests/string_truncate.SF-919542.stable.err
        sql/test/BugDay_2005-10-06_2.9.3/Tests/case.SF-929151.stable.err
        sql/test/BugDay_2005-10-06_2.9.3/Tests/div_by_zero.SF-987304.stable.err
        sql/test/BugDay_2005-10-06_2.9.3/Tests/having.SF-922614.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/index_management.SF-927326.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/inserts_with_defaults.SF-921977.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/limit_in_create_view.SF-924448.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/parser_crashes_server.SF-921996.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/rollback_and_autocommit.SF-926453.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/timestamp_parsing.SF-927300.stable.err
        
sql/test/BugDay_2005-10-06_2.9.3/Tests/view_on_deleted_table.SF-938583.stable.err
        
sql/test/BugDay_2005-11-09_2.8/Tests/crash_with_wrong_nesting.SF-1097883.stable.err
        
sql/test/BugDay_2005-11-09_2.8/Tests/insert_from_no-existing_tables.SF-1037020.stable.err
        
sql/test/BugDay_2005-11-09_2.8/Tests/overflow_checking.SF-1089334.stable.err
        
sql/test/BugDay_2005-11-09_2.8/Tests/updating_views.SF-1023645.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/drop_column_alter_table.SF-1114557.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/grant_public.SF-1114580.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/having_clause_quirks.SF-947601.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/history_table_escape.SF-1072089.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/integer_overflow.SF-1048671.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.err
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out
        
sql/test/BugDay_2005-11-09_2.9.3/Tests/schema_change_grant_crash.SF-963620.stable.err
        
sql/test/BugDay_2005-12-19_2.9.3/Tests/bogus_prepare.SF-1377079.stable.err
        
sql/test/BugDay_2005-12-19_2.9.3/Tests/crash_on_incorrect_SQL.SF-1314904.stable.err
        
sql/test/BugDay_2005-12-19_2.9.3/Tests/default_next_value_for_non_ex_seq.SF.1246631.stable.err
        
sql/test/BugDay_2005-12-19_2.9.3/Tests/prepare-where.SF-1238867.1238959.1238965.1240124.stable.err
        
sql/test/BugDay_2005-12-19_2.9.3/Tests/subselect_cardinality.SF-1240701.1242164.stable.err
        
sql/test/BugTracker-2008/Tests/alter_add_constraint_should_check_existing_data.SF-2075241.stable.err
        
sql/test/BugTracker-2008/Tests/alter_view_not_allowed.SF-2075195.stable.err
        sql/test/BugTracker-2008/Tests/copy-format.SF-2468513.stable.err
        
sql/test/BugTracker-2008/Tests/count_with_order_by_and_limit_crashes.SF-2229936.stable.err
        sql/test/BugTracker-2008/Tests/insert-null-byte.SF-2233581.stable.err
        
sql/test/BugTracker-2008/Tests/insert_into_unique_column.SF-2075180.stable.err
        
sql/test/BugTracker-2008/Tests/invalid_qualified_column_name.SF-2183288.stable.err
        
sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677.stable.err
        
sql/test/BugTracker-2008/Tests/string_length_not_checked.SF-2075078.stable.err
        
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.err
        sql/test/BugTracker-2008/Tests/varchar.SF-2471371.stable.err
        sql/test/BugTracker-2009/Tests/ambiguous_order_by.SF-2827916.stable.err
        sql/test/BugTracker-2009/Tests/ambiguous_view.stable.err
        sql/test/BugTracker-2009/Tests/assert_in_update.SF-2807336.stable.err
        
sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.stable.err
        sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err
        
sql/test/BugTracker-2009/Tests/create_on_ro_db_crash.SF-2830238.stable.err
        
sql/test/BugTracker-2009/Tests/create_table_dup_name.SF-2879005.stable.err
        sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err
        sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.err
        sql/test/BugTracker-2009/Tests/except_error_wrong.SF-2808409.stable.out
        sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.err
        sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out
        sql/test/BugTracker-2009/Tests/incomplete.SF.2536893.stable.err
        
sql/test/BugTracker-2009/Tests/insert_into_values_bug.SF-2807609.stable.err
        sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.stable.err
        
sql/test/BugTracker-2009/Tests/not_invalidtable_crash.SF-2927174.stable.err
        sql/test/BugTracker-2009/Tests/overflow.SF-2853458.stable.err
        sql/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.err
        sql/test/BugTracker-2009/Tests/rollback_bug.stable.err
        sql/test/BugTracker-2009/Tests/rollback_mistake.SF-2814622.stable.err
        
sql/test/BugTracker-2009/Tests/segv_for_unknown_identifier_in_subquery.SF-2874045.stable.err
        
sql/test/BugTracker-2009/Tests/select_X_where_bla_EQ_whatever.SF-282597.stable.err
        sql/test/BugTracker-2009/Tests/select_from_history.SF-2556566.stable.err
        
sql/test/BugTracker-2009/Tests/subquery_returns_table_crash.SF-2513620.stable.err
        
sql/test/BugTracker-2009/Tests/temp_table_fail_leaves_data.SF-2793286.stable.err
        
sql/test/BugTracker-2009/Tests/temporary_table_leftover.SF-2734713.stable.err
        
sql/test/BugTracker-2009/Tests/unique_constraint_on_char.SF-2873564.stable.err
        sql/test/BugTracker-2009/Tests/wrong_error_message.SF-2637051.stable.err
        
sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.err
        
sql/test/BugTracker-2010/Tests/call_function_without_warning.Bug-2752.stable.err
        sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.stable.err
        
sql/test/BugTracker-2010/Tests/copy-into-too-long-string.Bug-2358.stable.err
        
sql/test/BugTracker-2010/Tests/crash_default_unlocked.Bug-2744.stable.err
        sql/test/BugTracker-2010/Tests/crash_on_in_2.Bug-2604.stable.err
        sql/test/BugTracker-2010/Tests/crashonschema.Bug-2547.stable.err
        sql/test/BugTracker-2010/Tests/duplicate-key.Bug-2667.stable.err
        sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err
        
sql/test/BugTracker-2010/Tests/incomplete-utf8-sequence.Bug-2575.stable.err
        sql/test/BugTracker-2010/Tests/new-readonly-db.Bug-2695.stable.err
        sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
        
sql/test/BugTracker-2010/Tests/second_function_existing_signature.Bug-2611.stable.err
        sql/test/BugTracker-2010/Tests/select_from_seq.Bug-2730.stable.err
        sql/test/BugTracker-2010/Tests/select_star.Bug-2563.stable.err
        
sql/test/BugTracker-2010/Tests/sequence-restart-with-null.Bug-2648.stable.err
        sql/test/BugTracker-2010/Tests/subselect.Bug-2537.stable.err
        sql/test/BugTracker-2010/Tests/sum_on_date_crash.Bug-2643.stable.err
        sql/test/BugTracker-2010/Tests/times-crash.Bug-2586.stable.err
        sql/test/BugTracker-2010/Tests/unicode-bom.Bug-2641.stable.err
        
sql/test/BugTracker-2010/Tests/wrong_error_message_dropping_view.Bug-2713.stable.err
        
sql/test/BugTracker-2011/Tests/UNIQUE_Constraint_reference.Bug-2835.stable.err
        
sql/test/BugTracker-2011/Tests/alter-table-set-read-only.bug-2906.stable.err
        
sql/test/BugTracker-2011/Tests/alter_incorrect_syntax_crash.Bug-2795.stable.err
        
sql/test/BugTracker-2011/Tests/multicolumn_constraints.Bug-2849.stable.err
        
sql/test/BugTracker-2011/Tests/user_create_temp_table.Bug-2916.stable.err
        sql/test/BugTracker-2012/Tests/create_function.Bug-3172.stable.err
        sql/test/BugTracker-2012/Tests/foreign_key.Bug-3114.stable.err
        sql/test/BugTracker-2012/Tests/interval_timestamp.Bug-3002.stable.err
        
sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err.int128
        
sql/test/BugTracker-2012/Tests/name_resolution_in_proc.Bug-3074.stable.err
        sql/test/BugTracker-2012/Tests/nested-select-crash.Bug-3009.stable.err
        sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.err
        sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.err
        
sql/test/BugTracker-2012/Tests/table_function_with_column_subselects.Bug-3172.stable.err
        
sql/test/BugTracker-2012/Tests/table_returning_func_returns_too_many_columns.Bug-3077.stable.err
        sql/test/BugTracker-2012/Tests/timestamp_minus_date.Bug-2977.stable.err
        
sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.err
        
sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out.int128
        
sql/test/BugTracker-2013/Tests/avg_needs_abort_on_error.Bug-3329.stable.err
        sql/test/BugTracker-2013/Tests/binary_copy_into.Bug-3345.stable.err
        
sql/test/BugTracker-2013/Tests/cannot_use_columns_after_groupby.Bug-3340.stable.err
        sql/test/BugTracker-2013/Tests/duplicate_column_name.Bug-3349.stable.err
        sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err
        sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.out
        
sql/test/BugTracker-2013/Tests/incorrect_subquery_delete.Bug-3315.stable.err
        sql/test/BugTracker-2013/Tests/pivot.Bug-3339.stable.err
        sql/test/BugTracker-2013/Tests/pivot.Bug-3339.stable.out
        
sql/test/BugTracker-2013/Tests/psm_functions_and_accessrights.Bug-3300.stable.err
        sql/test/BugTracker-2013/Tests/syntaxerror.Bug-3399.stable.err
        sql/test/BugTracker-2013/Tests/syntaxerror.Bug-3399.stable.out
        sql/test/BugTracker-2013/Tests/timestamp.Bug-3401.stable.err
        
sql/test/BugTracker-2013/Tests/unique_constraint_on_declared_table.Bug-3319.stable.err
        
sql/test/BugTracker-2013/Tests/update_on_declared_table.Bug-3318.stable.err
        sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.err
        
sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.stable.err
        
sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.err.int128
        sql/test/BugTracker-2014/Tests/in_incorrect_multi.Bug-3462.stable.err
        sql/test/BugTracker-2014/Tests/inet_error_handling.Bug-3624.stable.err
        sql/test/BugTracker-2014/Tests/integer-cast.Bug-3424.stable.err
        
sql/test/BugTracker-2014/Tests/nested_common_table_exp.Bug-3417.stable.err
        sql/test/BugTracker-2014/Tests/non_groupby_column.Bug-3524.stable.err
        sql/test/BugTracker-2014/Tests/number_4_4.Bug-3543.stable.err
        
sql/test/BugTracker-2014/Tests/order_by_incorrect_error.Bug-3630.stable.err
        sql/test/BugTracker-2014/Tests/queueError.Bug-3604.stable.err
        sql/test/BugTracker-2014/Tests/temporary.Bug-3430.stable.err
        sql/test/BugTracker-2014/Tests/too_general_errmsg.Bug-3605.stable.err
        sql/test/BugTracker-2015/Tests/acidity2-fail.Bug-3635.SQL.py
        sql/test/BugTracker-2015/Tests/acidity2-fail.Bug-3635.stable.out
        sql/test/BugTracker-2015/Tests/adddrop_unknown_table.Bug-3718.stable.err
        
sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.stable.err
        sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.err
        
sql/test/BugTracker-2015/Tests/create-temp-table-using-like.Bug-3767.stable.err
        sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err
        sql/test/BugTracker-2015/Tests/float-space-parse.Bug-3691.stable.err
        sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.stable.err
        sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.stable.out
        
sql/test/BugTracker-2015/Tests/insert_into_merge_table_crash.Bug-3703.stable.err
        sql/test/BugTracker-2015/Tests/limit_too_large_value.Bug-3857.stable.err
        
sql/test/BugTracker-2015/Tests/local-remotetable-crash.Bug-3754.stable.err
        sql/test/BugTracker-2015/Tests/name_conflict.Bug-3650.stable.err
        sql/test/BugTracker-2015/Tests/negative_oid_crash.Bug-3667.stable.err
        sql/test/BugTracker-2015/Tests/readonly.Bug-3709.stable.err
        sql/test/BugTracker-2015/Tests/schema_view2.Bug-3766.stable.err
        sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.err
        sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.stable.err
        sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.stable.out
        sql/test/BugTracker-2015/Tests/with-columns-mismatch.Bug-3697.stable.err
        
sql/test/BugTracker-2016/Tests/RELEASE_SAVEPOINT_after_UPDATE_crash.Bug-4010.stable.err
        
sql/test/BugTracker-2016/Tests/catalog_name_qualifier.Bug-3948.stable.err
        
sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.err
        sql/test/BugTracker-2016/Tests/column_name_conflict.Bug-3912.stable.err
        
sql/test/BugTracker-2016/Tests/convert-function-test-hge.Bug-3460.stable.err
        
sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.stable.err.int128
        
sql/test/BugTracker-2016/Tests/create_merge_table_withdata.Bug-4041.stable.err
        sql/test/BugTracker-2016/Tests/fk-smaller-pk.Bug-3983.stable.err
        sql/test/BugTracker-2016/Tests/foreign_key.Bug-3938.stable.err
        
sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.err
        
sql/test/BugTracker-2016/Tests/incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909.stable.err
        sql/test/BugTracker-2016/Tests/invalidcolumns.Bug-3968.stable.err
        sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.err
        sql/test/BugTracker-2016/Tests/merge-table-edit.Bug-6084.stable.err
        
sql/test/BugTracker-2016/Tests/set-negative-querytimeout.Bug-6070.stable.err
        sql/test/BugTracker-2016/Tests/stream_table_crash.Bug-3952.stable.err
        
sql/test/BugTracker-2016/Tests/timestamp_with_tz_fromstr.Bug-4019.stable.err
        sql/test/BugTracker-2016/Tests/trigger_bulk.Bug-4045.stable.err
        sql/test/BugTracker-2017/Tests/All
        
sql/test/BugTracker-2017/Tests/cast_boolean_to_string.Bug-6110.stable.err
        sql/test/BugTracker-2017/Tests/crash_in_in_handling.Bug-6260.stable.err
        sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.err
        
sql/test/BugTracker-2017/Tests/delete_from_merge_table.Bug-3743.stable.err
        
sql/test/BugTracker-2017/Tests/delete_from_merge_table.Bug-3743.stable.out
        sql/test/BugTracker-2017/Tests/drop_not_null_on_pkey.Bug-6189.stable.err
        sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.err
        sql/test/BugTracker-2017/Tests/incorrect_error.Bug-6141.stable.err
        sql/test/BugTracker-2017/Tests/lateral.Bug-6310.stable.err
        sql/test/BugTracker-2017/Tests/lateral02.Bug-6314.stable.err
        sql/test/BugTracker-2017/Tests/name-interference.Bug-6348.sql
        sql/test/BugTracker-2017/Tests/oidx-on-strings.Bug-6202.stable.err
        sql/test/BugTracker-2017/Tests/prepare.Bug-6133.stable.err
        sql/test/BugTracker-2017/Tests/push_subslice.Bug-6322.stable.err
        sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6219.stable.err
        sql/test/BugTracker-2017/Tests/too-large-decimals.Bug-6192.stable.err
        
sql/test/BugTracker-2017/Tests/type-resolution-error.Bugs-6313.stable.err
        sql/test/BugTracker-2017/Tests/union_func_crash.Bug-6196.stable.err
        
sql/test/BugTracker-2017/Tests/unknown_col_in_order_by.Bug-3535.stable.err
        sql/test/BugTracker-2017/Tests/with-alias-bug.6246.stable.err
        
sql/test/BugTracker/Tests/alter_col_to_set_same_constraint.SF-1850781.stable.err
        sql/test/BugTracker/Tests/alter_table_add_fkey.SF-1737668.stable.err
        sql/test/BugTracker/Tests/alter_table_set_not_null.SF-1997030.stable.err
        sql/test/BugTracker/Tests/ambiguous_join.SF-1580565.stable.err
        sql/test/BugTracker/Tests/auto_increment.SF-1834820.stable.err
        sql/test/BugTracker/Tests/between_having_problem.SF-1959391.stable.err
        sql/test/BugTracker/Tests/between_with_column.SF-1959410.stable.err
        sql/test/BugTracker/Tests/bind_with_cast.SF-1720934.stable.err
        sql/test/BugTracker/Tests/broken_join.SF-1373391.stable.err
        sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.err
        sql/test/BugTracker/Tests/coalesce_equal_coalesce.SF-1907905.stable.err
        sql/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err
        sql/test/BugTracker/Tests/copy_overflow_null_bug.SF-1842550.stable.err
        sql/test/BugTracker/Tests/crash_on_fkey_update.SF-1703497.stable.err
        sql/test/BugTracker/Tests/crash_on_fkey_update2.SF-1703497.stable.err
        sql/test/BugTracker/Tests/create_column.SF-1643542.stable.err
        
sql/test/BugTracker/Tests/create_same_temp_tab_after_its_drop.SF-1850809.stable.err
        
sql/test/BugTracker/Tests/creation_of_exeception_for_select.SF-1841749.stable.err
        sql/test/BugTracker/Tests/drop_schema_crash.SF-1504794.stable.err
        sql/test/BugTracker/Tests/drop_system_tables.SF-1550768.stable.err
        
sql/test/BugTracker/Tests/groupby_orderby_nonselected.SF-1723863.stable.err
        sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
        sql/test/BugTracker/Tests/insert_values.SF-1578838.stable.err
        
sql/test/BugTracker/Tests/inserting_invalid_timestamp.SF-1363557.stable.err
        sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.err
        sql/test/BugTracker/Tests/limits_of_decimal.SF-1685357.stable.err.int128
        sql/test/BugTracker/Tests/multivalue_insert.SF-1509864.stable.err
        sql/test/BugTracker/Tests/number_null_first_row.SF-1833286.stable.err
        sql/test/BugTracker/Tests/reset_session_vars.SF-1505987.stable.err
        sql/test/BugTracker/Tests/revoke_role.SF-1691646.stable.err
        sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.err
        sql/test/BugTracker/Tests/set_operation_coersions.SF-1543216.stable.err
        sql/test/BugTracker/Tests/string2int_conversion.SF-1356068.stable.err
        
sql/test/BugTracker/Tests/table_dependency_inside_union.SF-1884382.stable.err
        sql/test/BugTracker/Tests/temporary_tables.SF-1715669.stable.err
        
sql/test/BugTracker/Tests/update_fkey_with_value_not_in_the_pkey.SF-1734143.stable.err
        sql/test/BugTracker/Tests/update_pkey_bug.SF-1733712.stable.err
        sql/test/BugTracker/Tests/variables.SF-1508160.stable.err
        sql/test/BugTracker/Tests/view_creation_using_func.SF-1714814.stable.err
        sql/test/Dependencies/Tests/Dependencies.stable.err
        sql/test/LSST/Tests/dbQuery036.stable.err
        sql/test/Tests/50ways.stable.err
        sql/test/Tests/bincopycollist.stable.err
        sql/test/Tests/create_in_schema.stable.err
        sql/test/Tests/decimal.stable.err
        sql/test/Tests/default.stable.err
        sql/test/Tests/function_syntax.stable.err
        sql/test/Tests/ifexists-views.stable.err
        sql/test/Tests/ifexists.stable.err
        sql/test/Tests/marcin2.stable.err
        sql/test/Tests/marcin3.stable.err
        sql/test/Tests/null.stable.err
        sql/test/Tests/procedure_syntax.stable.err
        sql/test/Tests/session_vars.stable.err
        sql/test/Tests/setoptimizer.stable.err
        sql/test/Triggers/Tests/trigger_owner.stable.err
        sql/test/Triggers/Tests/triggers_schema_operations.stable.err
        sql/test/Update_Delete_action/Tests/delete_restrict.stable.err
        sql/test/Update_Delete_action/Tests/delete_set_default.stable.err
        sql/test/Update_Delete_action/Tests/delete_set_null.stable.err
        sql/test/Update_Delete_action/Tests/update_delete_set_null.stable.err
        
sql/test/Update_Delete_action/Tests/update_delete_set_null_crash.stable.err
        sql/test/Update_Delete_action/Tests/update_restrict.stable.err
        sql/test/Update_Delete_action/Tests/update_set_default.stable.err
        sql/test/Update_Delete_action/Tests/update_set_default_crash.stable.err
        sql/test/Update_Delete_action/Tests/update_set_null.stable.err
        sql/test/Users/Tests/changePasswordUser.stable.err
        sql/test/Users/Tests/changePasswordUser.stable.out
        sql/test/Users/Tests/changeSchemaUser.stable.err
        sql/test/Users/Tests/columnRights.stable.err
        sql/test/Users/Tests/copyinto.stable.err
        sql/test/Users/Tests/copyinto.stable.out
        sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.out
        sql/test/Users/Tests/grantMonetdb.stable.err
        sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err
        sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.stable.err
        sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.err
        sql/test/Users/Tests/grantRole.Bug-3772.stable.err
        sql/test/Users/Tests/renameUser.stable.err
        sql/test/Users/Tests/role.stable.err
        sql/test/Users/Tests/role2.stable.err
        sql/test/Users/Tests/schema.stable.err
        sql/test/Users/Tests/test_privs2_p2.stable.err
        sql/test/Users/Tests/test_privs_p2.stable.err
        sql/test/Via-m/Tests/event_s07.stable.err
        sql/test/Via-m/Tests/event_s07.stable.out
        sql/test/Via-m/Tests/event_s11.stable.err
        sql/test/Via-m/Tests/event_s11.stable.out
        sql/test/Via-m/Tests/file_s10.stable.err
        sql/test/Via-m/Tests/file_s10.stable.out
        sql/test/Via-m/Tests/file_s12.stable.err
        sql/test/Via-m/Tests/file_s12.stable.out
        sql/test/Via-m/Tests/media_s12.stable.err
        sql/test/Via-m/Tests/media_s12.stable.out
        sql/test/Via-m/Tests/media_s14.stable.err
        sql/test/Via-m/Tests/media_s14.stable.out
        sql/test/Via-m/Tests/media_s16.stable.err
        sql/test/Via-m/Tests/media_s16.stable.out
        sql/test/Via-m/Tests/media_s18.stable.err
        sql/test/Via-m/Tests/media_s18.stable.out
        sql/test/Via-m/Tests/media_s19.stable.err
        sql/test/Via-m/Tests/media_s19.stable.out
        sql/test/Views/Tests/Views.stable.err
        sql/test/bugs/Tests/alter_add_column-bug.stable.err
        sql/test/bugs/Tests/alter_table_add_column.stable.err
        sql/test/bugs/Tests/alter_view.stable.err
        
sql/test/bugs/Tests/autocommit_illegal_statements-bug-sf-953545.stable.err
        sql/test/bugs/Tests/crash_order_by.stable.err
        sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.err
        sql/test/bugs/Tests/drop_foreignkey_selfreferencing.stable.err
        sql/test/bugs/Tests/filter_error.stable.err
        sql/test/bugs/Tests/foreignkey_leftjoin-bug-sf-854312.stable.err
        sql/test/bugs/Tests/groupby_having-bug-sf-947600.stable.err
        sql/test/bugs/Tests/groupby_having-bug-sf-947600.stable.out
        sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out
        sql/test/bugs/Tests/interval_convert_bugs-sf-1274077-1274085.stable.err
        sql/test/bugs/Tests/primary_key-bug-sf-975308.stable.err
        sql/test/bugs/Tests/procedure_resolution_bug.stable.err
        sql/test/bugs/Tests/profile_bug-SF.1314649.stable.err
        sql/test/bugs/Tests/savepoint_rollback-bug-sf-953553.stable.err
        
sql/test/bugs/Tests/select_constant_from_where_1=1-bug-sf-1019529.stable.err
        sql/test/bugs/Tests/select_from_values.stable.err
        sql/test/bugs/Tests/unique-bug-sf-1043512.stable.err
        sql/test/copy/Tests/columns.stable.err
        sql/test/copy/Tests/int_parse.stable.err
        sql/test/copy/Tests/key_copy.stable.err
        sql/test/copy/Tests/load_stdin_incorrect_line_nr.stable.err
        sql/test/copy/Tests/nonutf8.stable.err
        sql/test/copy/Tests/null_as_string_errors.stable.err
        sql/test/json/Tests/parsing.stable.err
        sql/test/json/Tests/pathexpr.stable.err
        sql/test/mapi/Tests/perl_dbi.stable.out
        sql/test/mapi/Tests/python2_dbapi.stable.out
        sql/test/mapi/Tests/python3_dbapi.stable.out
        sql/test/mergetables/Tests/addtable.stable.err
        sql/test/mergetables/Tests/alter.stable.err
        sql/test/mergetables/Tests/crash0.stable.err
        sql/test/mergetables/Tests/doubletable.stable.err
        sql/test/mergetables/Tests/emptymergequery.stable.err
        sql/test/mergetables/Tests/mergedrop.stable.err
        sql/test/mergetables/Tests/mergedrop1.stable.err
        sql/test/mergetables/Tests/mergedropcrash.stable.err
        sql/test/mergetables/Tests/mergemergeload.stable.err
        sql/test/mergetables/Tests/mergequery.stable.out
        sql/test/mergetables/Tests/types.stable.err
        
sql/test/mserver5-sql-readonly/Tests/mserver5-sql-readonly-table.stable.err
        
sql/test/mserver5-sql-readonly/Tests/mserver5-sql-readonly-view.stable.err
        sql/test/orderidx/Tests/oidx_all_types.stable.err
        sql/test/osm/Tests/drop_constraint_bug.stable.err
        sql/test/osm/Tests/drop_constraint_bug.stable.out
        sql/test/pg_regress/Tests/alter_table.stable.err
        sql/test/pg_regress/Tests/arrays.stable.err
        sql/test/pg_regress/Tests/boolean.stable.err
        sql/test/pg_regress/Tests/box.stable.err
        sql/test/pg_regress/Tests/char.stable.err
        sql/test/pg_regress/Tests/create_aggregate.stable.err
        sql/test/pg_regress/Tests/create_misc.stable.err
        sql/test/pg_regress/Tests/create_view.stable.err
        sql/test/pg_regress/Tests/date.stable.err
        sql/test/pg_regress/Tests/drop.stable.err
        sql/test/pg_regress/Tests/float4.stable.err
        sql/test/pg_regress/Tests/float8.stable.err.int128
        sql/test/pg_regress/Tests/horology.stable.err
        sql/test/pg_regress/Tests/inet.stable.err
        sql/test/pg_regress/Tests/insert.stable.err
        sql/test/pg_regress/Tests/int2.stable.err
        sql/test/pg_regress/Tests/int4.stable.err
        sql/test/pg_regress/Tests/int8.stable.err.int128
        sql/test/pg_regress/Tests/interval.stable.err.int128
        sql/test/pg_regress/Tests/limit.stable.err
        sql/test/pg_regress/Tests/numeric.stable.err
        sql/test/pg_regress/Tests/numeric_big.stable.err.int128
        sql/test/pg_regress/Tests/numerology.stable.err
        sql/test/pg_regress/Tests/oid.stable.err.int128
        sql/test/pg_regress/Tests/path.stable.err
        sql/test/pg_regress/Tests/point.stable.err
        sql/test/pg_regress/Tests/polygon.stable.err
        sql/test/pg_regress/Tests/reltime.stable.err
        sql/test/pg_regress/Tests/select_into.stable.err
        sql/test/pg_regress/Tests/strings.stable.err.int128
        sql/test/pg_regress/Tests/strings_concat.stable.err
        sql/test/pg_regress/Tests/time.stable.err
        sql/test/pg_regress/Tests/timestamp.stable.err
        sql/test/pg_regress/Tests/timestamptz.stable.err
        sql/test/pg_regress/Tests/timetz.stable.err
        sql/test/pg_regress/Tests/varchar.stable.err
        sql/test/pg_regress/Tests/without_oid.stable.err
        sql/test/quantiles/Tests/quantiles.stable.err
        sql/test/remote/Tests/partition_elim.stable.out
        sql/test/remote/Tests/ssbm.stable.err
        sql/test/remote/Tests/ssbm.stable.out.int128
        sql/test/snodgrass/Tests/cast_select.stable.err
        sql/test/snodgrass/Tests/cast_select.stable.out
        sql/test/snodgrass/Tests/cast_table.stable.err
        sql/test/snodgrass/Tests/interval_select.stable.err
        sql/test/snodgrass/Tests/interval_select.stable.out
        sql/test/ssqq/Tests/insert_query.stable.err
        sql/test/ssqq/Tests/insert_queue.stable.err
        sql/test/ssqq/Tests/insert_quser.stable.err
        tools/mserver/mserver5.c
        tools/mserver/shutdowntest.c
Branch: data-vaults
Log Message:

Merge with default

lidar.c has diverged a lot. The change in the default branch is that the string
SQLSTATE LI000! has been prepended to every error message. We need to find
meaningful codes from the SQL standard to replace the LI000


diffs (truncated from 51647 to 300 lines):

diff --git a/clients/Tests/MAL-signatures.stable.out 
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -456,13 +456,13 @@ Ready.
 [ "aggr",      "variancep",    "command aggr.variancep(b:bat[:lng], 
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ",   "AGGRvariancep3_dbl;",  "Grouped 
tail variance (population/biased) on lng"      ]
 [ "aggr",      "variancep",    "command aggr.variancep(b:bat[:sht], 
g:bat[:oid], e:bat[:any_1]):bat[:dbl] ",   "AGGRvariancep3_dbl;",  "Grouped 
tail variance (population/biased) on sht"      ]
 [ "aggr",      "variancep",    "command aggr.variancep(b:bat[:any_2]):dbl ",   
"ALGvariancep;",        "Gives the variance of all tail values" ]
-[ "alarm",     "ctime",        "unsafe command alarm.ctime():str ",    
"ALARMctime;",  "Return the current time as a C-time string."   ]
+[ "alarm",     "ctime",        "command alarm.ctime():str ",   "ALARMctime;",  
"Return the current time as a C-time string."   ]
 [ "alarm",     "epilogue",     "command alarm.epilogue():void ",       
"ALARMepilogue;",       "Finalize alarm module."        ]
-[ "alarm",     "epoch",        "unsafe command alarm.epoch():int ",    
"ALARMepoch;",  "Return the current time as UNIX epoch."        ]
+[ "alarm",     "epoch",        "command alarm.epoch():int ",   "ALARMepoch;",  
"Return the current time as UNIX epoch."        ]
 [ "alarm",     "prelude",      "command alarm.prelude():void ",        
"ALARMprelude;",        "Initialize alarm module."      ]
-[ "alarm",     "sleep",        "unsafe command alarm.sleep(secs:int):void ",   
"ALARMsleep;",  "Sleep a few seconds"   ]
-[ "alarm",     "time", "unsafe command alarm.time():int ",     "ALARMtime;",   
"Return time in milliseconds."  ]
-[ "alarm",     "usec", "unsafe command alarm.usec():lng ",     "ALARMusec;",   
"Return time in microseconds."  ]
+[ "alarm",     "sleep",        "command alarm.sleep(secs:int):void ",  
"ALARMsleep;",  "Sleep a few seconds"   ]
+[ "alarm",     "time", "command alarm.time():int ",    "ALARMtime;",   "Return 
time in milliseconds."  ]
+[ "alarm",     "usec", "command alarm.usec():lng ",    "ALARMusec;",   "Return 
time in microseconds."  ]
 [ "algebra",   "antijoin",     "function algebra.antijoin(l:bat[:any_1], 
r:bat[:any_1], sl:bat[:oid], sr:bat[:oid], nil_matches:bit, estimate:lng) 
(X_0:bat[:oid], X_1:bat[:oid]);",   "",     ""      ]
 [ "algebra",   "bandjoin",     "command algebra.bandjoin(l:bat[:any_1], 
r:bat[:any_1], sl:bat[:oid], sr:bat[:oid], c1:any_1, c2:any_1, li:bit, hi:bit, 
estimate:lng) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGbandjoin;", "Band join: 
values in l and r match if r - c1 <[=] l <[=] r + c2"       ]
 [ "algebra",   "copy", "command algebra.copy(b:bat[:any_1]):bat[:any_1] ",     
"ALGcopy;",     "Returns physical copy of a BAT."       ]
@@ -6077,11 +6077,11 @@ Ready.
 [ "batmtime",  "seconds",      "command 
batmtime.seconds(d:bat[:daytime]):bat[:int] ", 
"MTIMEdaytime_extract_seconds_bulk;",   ""      ]
 [ "batmtime",  "sql_seconds",  "command 
batmtime.sql_seconds(d:bat[:daytime]):bat[:int] ",     
"MTIMEdaytime_extract_sql_seconds_bulk;",       ""      ]
 [ "batmtime",  "year", "command batmtime.year(d:bat[:date]):bat[:int] ",       
"MTIMEdate_extract_year_bulk;", ""      ]
-[ "batpyapi",  "eval", "unsafe pattern batpyapi.eval(fptr:ptr, expr:str, 
arg:any...):any... ", "PYAPI2PyAPIevalStd;",  "Execute a simple Python script 
value"  ]
-[ "batpyapi",  "eval_aggr",    "unsafe pattern batpyapi.eval_aggr(fptr:ptr, 
expr:str, arg:any...):any... ",    "PYAPI2PyAPIevalAggr;", "grouped aggregates 
through Python"     ]
-[ "batpyapi",  "eval_loader",  "unsafe pattern batpyapi.eval_loader(fptr:ptr, 
expr:str):any... ",      "PYAPI2PyAPIevalLoader;",       "loader functions 
through Python"       ]
-[ "batpyapi",  "eval_loader",  "unsafe pattern batpyapi.eval_loader(fptr:ptr, 
expr:str, arg:any...):any... ",  "PYAPI2PyAPIevalLoader;",       "loader 
functions through Python"       ]
-[ "batpyapi",  "subeval_aggr", "unsafe pattern batpyapi.subeval_aggr(fptr:ptr, 
expr:str, arg:any...):any... ", "PYAPI2PyAPIevalAggr;", "grouped aggregates 
through Python"     ]
+[ "batpyapi",  "eval", "pattern batpyapi.eval(fptr:ptr, expr:str, 
arg:any...):any... ",        "PYAPI2PyAPIevalStd;",  "Execute a simple Python 
script value"  ]
+[ "batpyapi",  "eval_aggr",    "pattern batpyapi.eval_aggr(fptr:ptr, expr:str, 
arg:any...):any... ",   "PYAPI2PyAPIevalAggr;", "grouped aggregates through 
Python"     ]
+[ "batpyapi",  "eval_loader",  "pattern batpyapi.eval_loader(fptr:ptr, 
expr:str):any... ",     "PYAPI2PyAPIevalLoader;",       "loader functions 
through Python"       ]
+[ "batpyapi",  "eval_loader",  "pattern batpyapi.eval_loader(fptr:ptr, 
expr:str, arg:any...):any... ", "PYAPI2PyAPIevalLoader;",       "loader 
functions through Python"       ]
+[ "batpyapi",  "subeval_aggr", "pattern batpyapi.subeval_aggr(fptr:ptr, 
expr:str, arg:any...):any... ",        "PYAPI2PyAPIevalAggr;", "grouped 
aggregates through Python"     ]
 [ "batpyapimap",       "eval", "pattern batpyapimap.eval(fptr:ptr, expr:str, 
arg:any...):any... ",     "PYAPI2PyAPIevalStdMap;",       "Execute a simple 
Python script value"  ]
 [ "batpyapimap",       "eval_aggr",    "pattern 
batpyapimap.eval_aggr(fptr:ptr, expr:str, arg:any...):any... ",        
"PYAPI2PyAPIevalAggrMap;",      "grouped aggregates through Python"     ]
 [ "batpyapimap",       "subeval_aggr", "pattern 
batpyapimap.subeval_aggr(fptr:ptr, expr:str, arg:any...):any... ",     
"PYAPI2PyAPIevalAggrMap;",      "grouped aggregates through Python"     ]
@@ -6205,9 +6205,9 @@ Ready.
 [ "blob",      "toblob",       "command blob.toblob(v:str):blob ",     
"BLOBtoblob;",  "store a string as a blob."     ]
 [ "blob",      "tostring",     "command blob.tostring(v:blob):str ",   
"BLOBfromblob;",        "get the bytes from blob as a string, till\n\tthe first 
0 byte or the end of the blob"  ]
 [ "blob",      "tostring",     "command blob.tostring(v:blob, index:int):str 
",        "BLOBfromidx;", "get the bytes from blob as a string,\n\t starting at 
byte 'index' till the first\n\t0 byte or the end of the blob."    ]
-[ "bstream",   "create",       "unsafe command bstream.create(s:streams, 
bufsize:int):bstream ",       "bstream_create_wrapwrap;",     "create a 
buffered stream"      ]
-[ "bstream",   "destroy",      "unsafe command bstream.destroy(s:bstream):void 
",      "bstream_destroy_wrapwrap;",    "destroy bstream"       ]
-[ "bstream",   "read", "unsafe command bstream.read(s:bstream, size:int):int 
",        "bstream_read_wrapwrap;",       "read at least size bytes into the 
buffer of s" ]
+[ "bstream",   "create",       "command bstream.create(s:streams, 
bufsize:int):bstream ",      "bstream_create_wrapwrap;",     "create a buffered 
stream"      ]
+[ "bstream",   "destroy",      "command bstream.destroy(s:bstream):void ",     
"bstream_destroy_wrapwrap;",    "destroy bstream"       ]
+[ "bstream",   "read", "command bstream.read(s:bstream, size:int):int ",       
"bstream_read_wrapwrap;",       "read at least size bytes into the buffer of s" 
]
 [ "calc",      "!=",   "pattern calc.!=(l:json, r:json):bit ", "CMDvarNE;",    
"Return V1 != V2"       ]
 [ "calc",      "!=",   "pattern calc.!=(l:uuid, r:uuid):bit ", "CMDvarNE;",    
"Return V1 != V2"       ]
 [ "calc",      "!=",   "pattern calc.!=(v1:bit, v2:bit):bit ", "CMDvarNE;",    
"Return V1 != V2"       ]
@@ -7390,7 +7390,6 @@ Ready.
 [ "clients",   "getLogins",    "command clients.getLogins() (user:bat[:oid], 
start:bat[:str]) ",       "CLTLogin;",    "Pseudo bat of client id and login 
time."       ]
 [ "clients",   "getPasswordHash",      "pattern 
clients.getPasswordHash(user:str):str ",       "CLTgetPasswordHash;",  "Return 
the password hash of the given user"    ]
 [ "clients",   "getScenario",  "pattern clients.getScenario():str ",   
"CLTgetScenario;",      "Retrieve current scenario name."       ]
-[ "clients",   "getTime",      "command clients.getTime():bat[:lng] ", 
"CLTTime;",     "Pseudo bat of client's total time usage(in usec)."     ]
 [ "clients",   "getTimeout",   "pattern clients.getTimeout() (q:lng, s:lng) ", 
"CLTgetTimeout;",       "A query is aborted after q milliseconds (q=0 means run 
undisturbed).\nThe session timeout aborts the connection after spending 
too\nmany seconds on query processing." ]
 [ "clients",   "getUsername",  "pattern clients.getUsername():str ",   
"CLTgetUsername;",      "Return the username of the currently logged in user"   
]
 [ "clients",   "getUsers",     "pattern clients.getUsers() (X_0:bat[:oid], 
X_1:bat[:str]) ",   "CLTgetUsers;", "return a BAT with user id and one with 
name available in the system"   ]
@@ -8023,8 +8022,8 @@ Ready.
 [ "mmath",     "pow",  "command mmath.pow(x:flt, y:flt):flt ", 
"MATHbinary_POWflt;",   ""      ]
 [ "mmath",     "radians",      "command mmath.radians(x:dbl):dbl ",    
"MATHunary_RADIANSdbl;",        "The radians() function converts degrees into 
radians"  ]
 [ "mmath",     "radians",      "command mmath.radians(x:flt):flt ",    
"MATHunary_RADIANSflt;",        ""      ]
-[ "mmath",     "rand", "unsafe command mmath.rand():int ",     "MATHrandint;", 
"return a random number"        ]
-[ "mmath",     "rand", "unsafe command mmath.rand(v:int):int ",        
"MATHrandintarg;",      "return a random number"        ]
+[ "mmath",     "rand", "command mmath.rand():int ",    "MATHrandint;", "return 
a random number"        ]
+[ "mmath",     "rand", "command mmath.rand(v:int):int ",       
"MATHrandintarg;",      "return a random number"        ]
 [ "mmath",     "round",        "command mmath.round(x:dbl, y:int):dbl ",       
"MATHbinary_ROUNDdbl;", "The round(n, m) returns n rounded to m places to the 
right \n        of the decimal point; if m is omitted, to 0 places. m can be 
\n\tnegative to round off digits left of the decimal point. \n        m must be 
an integer." ]
 [ "mmath",     "round",        "command mmath.round(x:flt, y:int):flt ",       
"MATHbinary_ROUNDflt;", ""      ]
 [ "mmath",     "sin",  "command mmath.sin(x:dbl):dbl ",        
"MATHunary_SINdbl;",    "The sin(x) function returns the cosine of x, where x 
is given in \n        radians. The return value is between -1 and 1."     ]
@@ -8100,7 +8099,7 @@ Ready.
 [ "mtime",     "month",        "command mtime.month(t:timestamp):int ",        
"MTIMEtimestamp_month;",        ""      ]
 [ "mtime",     "monthname",    "command mtime.monthname(month:int):str ",      
"MTIMEmonth_to_str;",   "Returns month name from a number\n\tbetween [1-12], 
str(nil) otherwise."       ]
 [ "mtime",     "monthnum",     "command mtime.monthnum(month:str):int ",       
"MTIMEmonth_from_str;", "Returns month number [1-12] from a string\n\t or nil 
if does not match any."   ]
-[ "mtime",     "msec", "unsafe command mtime.msec():lng ",     "MTIMEmsec;",   
"get time of day in msec since 1-1-1970."       ]
+[ "mtime",     "msec", "command mtime.msec():lng ",    "MTIMEmsec;",   "get 
time of day in msec since 1-1-1970."       ]
 [ "mtime",     "msecs",        "command mtime.msecs(d:int, h:int, m:int, 
s:int, ms:int):lng ", "MTIMEmsecs;",  "convert date components to milliseconds" 
      ]
 [ "mtime",     "prelude",      "command mtime.prelude():void ",        
"MTIMEprelude;",        ""      ]
 [ "mtime",     "quarter",      "command mtime.quarter(d:date):int ",   
"MTIMEdate_extract_quarter;",   "extracts quarter from date"    ]
@@ -8148,14 +8147,14 @@ Ready.
 [ "netcdf",    "importvar",    "command netcdf.importvar(filename:str, 
varid:int):str ",       "NCDFimportVarStmt;",   "Import variable: compose 
create array string"  ]
 [ "netcdf",    "importvariable",       "pattern 
netcdf.importvariable(fileid:int, varname:str):void ", "NCDFimportVariable;",  
"Import variable: create array and load data from variable varname of file 
fileid"      ]
 [ "netcdf",    "test", "command netcdf.test(filename:str):int ",       
"NCDFtest;",    "Returns number of variables in a given NetCDF dataset (file)"  
]
-[ "oltp",      "disable",      "unsafe pattern oltp.disable():void ",  
"OLTPdisable;", "Disable the OLTP delay monitor"        ]
-[ "oltp",      "enable",       "unsafe pattern oltp.enable():void ",   
"OLTPenable;",  "Enable the OLTP delay monitor" ]
-[ "oltp",      "init", "unsafe pattern oltp.init():void ",     "OLTPinit;",    
"Initialize the lock table"     ]
-[ "oltp",      "isenabled",    "unsafe command oltp.isenabled():int ", 
"OLTPis_enabled;",      "Query the OLTP state"  ]
-[ "oltp",      "lock", "unsafe pattern oltp.lock(lck:int...):void ",   
"OLTPlock;",    "Wait for all write locks needed"       ]
-[ "oltp",      "release",      "unsafe pattern oltp.release(lck:int...):void 
",        "OLTPrelease;", "Release for all write locks needed"    ]
-[ "oltp",      "reset",        "unsafe pattern oltp.reset():void ",    
"OLTPreset;",   "Reset the OLTP lock table"     ]
-[ "oltp",      "table",        "unsafe pattern oltp.table() 
(start:bat[:timestamp], usr:bat[:str], unit:bat[:int], cnt:bat[:int]) ",   
"OLTPtable;",   "Show status of lock table"     ]
+[ "oltp",      "disable",      "pattern oltp.disable():void ", "OLTPdisable;", 
"Disable the OLTP delay monitor"        ]
+[ "oltp",      "enable",       "pattern oltp.enable():void ",  "OLTPenable;",  
"Enable the OLTP delay monitor" ]
+[ "oltp",      "init", "pattern oltp.init():void ",    "OLTPinit;",    
"Initialize the lock table"     ]
+[ "oltp",      "isenabled",    "command oltp.isenabled():int ",        
"OLTPis_enabled;",      "Query the OLTP state"  ]
+[ "oltp",      "lock", "pattern oltp.lock(lck:int...):void ",  "OLTPlock;",    
"Wait for all write locks needed"       ]
+[ "oltp",      "release",      "pattern oltp.release(lck:int...):void ",       
"OLTPrelease;", "Release for all write locks needed"    ]
+[ "oltp",      "reset",        "pattern oltp.reset():void ",   "OLTPreset;",   
"Reset the OLTP lock table"     ]
+[ "oltp",      "table",        "pattern oltp.table() (start:bat[:timestamp], 
usr:bat[:str], unit:bat[:int], cnt:bat[:int]) ",  "OLTPtable;",   "Show status 
of lock table"     ]
 [ "optimizer", "aliases",      "pattern optimizer.aliases():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "aliases",      "pattern optimizer.aliases(mod:str, 
fcn:str):str ",     "OPTwrapper;",  "Alias removal optimizer"       ]
 [ "optimizer", "candidates",   "pattern optimizer.candidates():str ",  
"OPTwrapper;",  ""      ]
@@ -8174,6 +8173,7 @@ Ready.
 [ "optimizer", "datavaults",   "pattern optimizer.datavaults(mod:str, 
fcn:str):str ",  "OPTwrapper;",  "Lazy load of datavaults files" ]
 [ "optimizer", "deadcode",     "pattern optimizer.deadcode():str ",    
"OPTwrapper;",  ""      ]
 [ "optimizer", "deadcode",     "pattern optimizer.deadcode(mod:str, 
fcn:str):str ",    "OPTwrapper;",  "Dead code optimizer"   ]
+[ "optimizer", "default_pipe", "function optimizer.default_pipe():void;",      
"",     ""      ]
 [ "optimizer", "emptybind",    "pattern optimizer.emptybind():str ",   
"OPTwrapper;",  ""      ]
 [ "optimizer", "emptybind",    "pattern optimizer.emptybind(mod:str, 
fcn:str):str ",   "OPTwrapper;",  "Evaluate empty set expressions."       ]
 [ "optimizer", "evaluate",     "pattern optimizer.evaluate():str ",    
"OPTwrapper;",  ""      ]
@@ -8194,10 +8194,12 @@ Ready.
 [ "optimizer", "matpack",      "pattern optimizer.matpack(mod:str, 
fcn:str):str ",     "OPTwrapper;",  "Unroll the mat.pack operation" ]
 [ "optimizer", "mergetable",   "pattern optimizer.mergetable():str ",  
"OPTwrapper;",  ""      ]
 [ "optimizer", "mergetable",   "pattern optimizer.mergetable(mod:str, 
fcn:str):str ",  "OPTwrapper;",  "Resolve the multi-table definitions"   ]
+[ "optimizer", "minimal_pipe", "function optimizer.minimal_pipe():void;",      
"",     ""      ]
 [ "optimizer", "mitosis",      "pattern optimizer.mitosis():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "mitosis",      "pattern optimizer.mitosis(mod:str, 
fcn:str):str ",     "OPTwrapper;",  "Modify the plan to exploit parallel 
processing on multiple cores"      ]
 [ "optimizer", "multiplex",    "pattern optimizer.multiplex():void ",  
"OPTwrapper;",  "Compiler for multiplexed instructions."        ]
 [ "optimizer", "multiplex",    "pattern optimizer.multiplex(mod:str, 
fcn:str):void ",  "OPTwrapper;",  "Compiler for multiplexed instructions."      
  ]
+[ "optimizer", "no_mitosis_pipe",      "function 
optimizer.no_mitosis_pipe():void;",   "",     ""      ]
 [ "optimizer", "oltp", "pattern optimizer.oltp():str ",        "OPTwrapper;",  
""      ]
 [ "optimizer", "oltp", "pattern optimizer.oltp(mod:str, fcn:str):str ",        
"OPTwrapper;",  "Inject the OLTP locking primitives."   ]
 [ "optimizer", "optimize",     "pattern optimizer.optimize(mod:str, 
fcn:str):void ",   "QOToptimize;", "Optimize a specific operation" ]
@@ -8220,10 +8222,12 @@ Ready.
 [ "optimizer", "remoteQueries",        "pattern 
optimizer.remoteQueries(mod:str, fcn:str):str ",       "OPTwrapper;",  "Resolve 
the multi-table definitions"   ]
 [ "optimizer", "reorder",      "pattern optimizer.reorder():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "reorder",      "pattern optimizer.reorder(mod:str, 
fcn:str):str ",     "OPTwrapper;",  "Reorder by dataflow dependencies"      ]
+[ "optimizer", "sequential_pipe",      "function 
optimizer.sequential_pipe():void;",   "",     ""      ]
 [ "optimizer", "sql_append",   "pattern optimizer.sql_append():str ",  
"OPTsql_append;",       "Avoid extra BAT copy with sql.append() whenever 
possible."     ]
 [ "optimizer", "sql_append",   "pattern optimizer.sql_append(mod:str, 
fcn:str):str ",  "OPTsql_append;",       "Avoid extra BAT copy with 
sql.append() whenever possible."     ]
 [ "optimizer", "volcano",      "pattern optimizer.volcano():str ",     
"OPTwrapper;",  ""      ]
 [ "optimizer", "volcano",      "pattern optimizer.volcano(mod:str, 
fcn:str):str ",     "OPTwrapper;",  "Simulate volcano style execution"      ]
+[ "optimizer", "volcano_pipe", "function optimizer.volcano_pipe():void;",      
"",     ""      ]
 [ "optimizer", "wlc",  "pattern optimizer.wlc():str ", "OPTwrapper;",  ""      
]
 [ "optimizer", "wlc",  "pattern optimizer.wlc(mod:str, fcn:str):str ", 
"OPTwrapper;",  "Inject the workload capture-replay primitives."        ]
 [ "pcre",      "imatch",       "command pcre.imatch(s:str, pat:str):bit ",     
"PCREimatch;",  "Caseless Perl Compatible Regular Expression pattern matching 
against a string" ]
@@ -8255,13 +8259,13 @@ Ready.
 [ "profiler",  "stop", "pattern profiler.stop():void ",        
"CMDstopProfiler;",     "Stop offline performance profiling"    ]
 [ "profiler",  "stoptrace",    "command profiler.stoptrace():void ",   
"CMDstopTrace;",        "Stop collecting trace information"     ]
 [ "profiler",  "stoptrace",    "command profiler.stoptrace(path:str):void ",   
"CMDstopTracePath;",    "Stop collecting trace information"     ]
-[ "pyapi",     "eval", "unsafe pattern pyapi.eval(fptr:ptr, expr:str):any ",   
"PYAPI2PyAPIevalStd;",  "Execute a simple Python script returning a single 
value"       ]
-[ "pyapi",     "eval", "unsafe pattern pyapi.eval(fptr:ptr, expr:str, 
arg:any...):any... ",    "PYAPI2PyAPIevalStd;",  "Execute a simple Python 
script value"  ]
-[ "pyapi",     "eval_aggr",    "unsafe pattern pyapi.eval_aggr(fptr:ptr, 
expr:str, arg:any...):any... ",       "PYAPI2PyAPIevalAggr;", "grouped 
aggregates through Python"     ]
-[ "pyapi",     "eval_loader",  "unsafe pattern pyapi.eval_loader(fptr:ptr, 
expr:str):any... ", "PYAPI2PyAPIevalLoader;",       "loader functions through 
Python"       ]
-[ "pyapi",     "eval_loader",  "unsafe pattern pyapi.eval_loader(fptr:ptr, 
expr:str, arg:any...):any... ",     "PYAPI2PyAPIevalLoader;",       "loader 
functions through Python"       ]
+[ "pyapi",     "eval", "pattern pyapi.eval(fptr:ptr, expr:str):any ",  
"PYAPI2PyAPIevalStd;",  "Execute a simple Python script returning a single 
value"       ]
+[ "pyapi",     "eval", "pattern pyapi.eval(fptr:ptr, expr:str, 
arg:any...):any... ",   "PYAPI2PyAPIevalStd;",  "Execute a simple Python script 
value"  ]
+[ "pyapi",     "eval_aggr",    "pattern pyapi.eval_aggr(fptr:ptr, expr:str, 
arg:any...):any... ",      "PYAPI2PyAPIevalAggr;", "grouped aggregates through 
Python"     ]
+[ "pyapi",     "eval_loader",  "pattern pyapi.eval_loader(fptr:ptr, 
expr:str):any... ",        "PYAPI2PyAPIevalLoader;",       "loader functions 
through Python"       ]
+[ "pyapi",     "eval_loader",  "pattern pyapi.eval_loader(fptr:ptr, expr:str, 
arg:any...):any... ",    "PYAPI2PyAPIevalLoader;",       "loader functions 
through Python"       ]
 [ "pyapi",     "prelude",      "command pyapi.prelude():void ",        
"PYAPI2PyAPIprelude;",  ""      ]
-[ "pyapi",     "subeval_aggr", "unsafe pattern pyapi.subeval_aggr(fptr:ptr, 
expr:str, arg:any...):any... ",    "PYAPI2PyAPIevalAggr;", "grouped aggregates 
through Python"     ]
+[ "pyapi",     "subeval_aggr", "pattern pyapi.subeval_aggr(fptr:ptr, expr:str, 
arg:any...):any... ",   "PYAPI2PyAPIevalAggr;", "grouped aggregates through 
Python"     ]
 [ "pyapimap",  "eval", "pattern pyapimap.eval(fptr:ptr, expr:str):any ",       
"PYAPI2PyAPIevalStdMap;",       "Execute a simple Python script returning a 
single value"       ]
 [ "pyapimap",  "eval", "pattern pyapimap.eval(fptr:ptr, expr:str, 
arg:any...):any... ",        "PYAPI2PyAPIevalStdMap;",       "Execute a simple 
Python script value"  ]
 [ "pyapimap",  "eval_aggr",    "pattern pyapimap.eval_aggr(fptr:ptr, expr:str, 
arg:any...):any... ",   "PYAPI2PyAPIevalAggrMap;",      "grouped aggregates 
through Python"     ]
@@ -8311,7 +8315,7 @@ Ready.
 [ "shp",       "import",       "pattern shp.import(fileid:int):void ", 
"SHPimport;",   "Import an ESRI Shapefile with given id into the vault" ]
 [ "shp",       "import",       "pattern shp.import(fileid:int, po:wkb):void ", 
"SHPpartialimport;",    "Partially import an ESRI Shapefile with given id into 
the vault"       ]
 [ "sql",       "abort",        "pattern sql.abort():void ",    "SQLabort;",    
"Trigger the abort operation for a MAL block"   ]
-[ "sql",       "affectedRows", "unsafe pattern sql.affectedRows(mvc:int, 
nr:lng):int ",        "mvc_affected_rows_wrap;",      "export the number of 
affected rows by the current query"       ]
+[ "sql",       "affectedRows", "pattern sql.affectedRows(mvc:int, nr:lng):int 
",       "mvc_affected_rows_wrap;",      "export the number of affected rows by 
the current query"       ]
 [ "sql",       "all",  "inline function sql.all(b:bat[:any_1], gp:bat[:oid], 
gpe:bat[:oid], no_nil:bit):bat[:any_1];", "",     ""      ]
 [ "sql",       "all",  "command sql.all(col:bat[:any_1]):any_1 ",      
"SQLall;",      "if col contains exactly one value return this. Incase of more 
raise an exception else return nil"      ]
 [ "sql",       "alpha",        "command sql.alpha(dec:dbl, theta:dbl):dbl ",   
"SQLcst_alpha_cst;",    "Implementation of astronomy alpha function: expands 
the radius theta depending on the declination"     ]
@@ -8333,9 +8337,9 @@ Ready.
 [ "sql",       "bind_idxbat",  "pattern sql.bind_idxbat(mvc:int, schema:str, 
table:str, index:str, access: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",       "bind_idxbat",  "pattern sql.bind_idxbat(mvc:int, schema:str, 
table:str, index:str, access:int, part_nr:int, nr_parts:int) (uid:bat[:oid], 
uval: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",       "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",  "unsafe pattern sql.clear_table(sname:str, 
tname:str):lng ",    "mvc_clear_table_wrap;",        "Clear the table 
sname.tname."  ]
+[ "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",    "unsafe 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):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",       "create_func_upgrade_oct2014",  "pattern 
sql.create_func_upgrade_oct2014(sname:str, f:str):int ",       
"UPGcreate_func;",      "Create the function described by f, needed for the 
Oct2014 upgrade"    ]
@@ -8350,19 +8354,19 @@ 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",        "unsafe pattern 
sql.declaredTable(name:str):int ",      "mvc_declared_table_wrap;",     
"Prepare a declared table"      ]
-[ "sql",       "delete",       "unsafe 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",       "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",    "unsafe pattern 
sql.dropDeclaredTable(name:str):void ", "mvc_drop_declared_table_wrap;",        
"drop a declared table" ]
-[ "sql",       "dropDeclaredTables",   "unsafe pattern 
sql.dropDeclaredTables(nr:int):void ",  "mvc_drop_declared_tables_wrap;",       
"drop top n declared tables"    ]
+[ "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",     "unsafe pattern sql.dtColumn(rs:int, tname:str, 
name:str, typename:str, digits:int, scale:int):void ",  
"mvc_declared_table_column_wrap;",      ""      ]
+[ "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"     ]
@@ -8378,21 +8382,21 @@ Ready.
 [ "sql",       "eval", "pattern sql.eval(cmd:str):void ",      
"SQLstatement;",        "Compile and execute a single sql statement"    ]
 [ "sql",       "eval", "pattern sql.eval(cmd:str, output:bit):void ",  
"SQLstatement;",        "Compile and execute a single sql statement (and 
optionaly send output on the output stream)"   ]
 [ "sql",       "evalAlgebra",  "pattern sql.evalAlgebra(cmd:str, 
optimize:bit):void ", "RAstatement;", "Compile and execute a single 'relational 
algebra' statement"   ]
-[ "sql",       "exportChunk",  "unsafe pattern sql.exportChunk(s:streams, 
res_id:int):void ",  "mvc_export_chunk_wrap;",       "Export a chunk of the 
result set (in order) to stream s"       ]
-[ "sql",       "exportChunk",  "unsafe pattern sql.exportChunk(s:streams, 
res_id:int, offset:int, nr:int):void ",      "mvc_export_chunk_wrap;",       
"Export a chunk of the result set (in order) to stream s"       ]
-[ "sql",       "exportHead",   "unsafe pattern sql.exportHead(s:streams, 
res_id:int):void ",   "mvc_export_head_wrap;",        "Export a result (in 
order) to stream s"        ]
-[ "sql",       "exportOperation",      "unsafe pattern 
sql.exportOperation():void ",   "mvc_export_operation_wrap;",   "Export result 
of schema/transaction queries"   ]
-[ "sql",       "exportResult", "unsafe pattern sql.exportResult(s:streams, 
res_id:int):void ", "mvc_export_result_wrap;",      "Export a result (in order) 
to stream s"        ]
-[ "sql",       "export_table", "unsafe 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", "unsafe 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",       "exportChunk",  "pattern sql.exportChunk(s:streams, 
res_id:int):void ", "mvc_export_chunk_wrap;",       "Export a chunk of the 
result set (in order) to stream s"       ]
+[ "sql",       "exportChunk",  "pattern sql.exportChunk(s:streams, res_id:int, 
offset:int, nr:int):void ",     "mvc_export_chunk_wrap;",       "Export a chunk 
of the result set (in order) to stream s"       ]
+[ "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",       "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",       "importTable",  "unsafe 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, 
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",      "unsafe pattern sql.logfile(filename:str):void 
",       "mvc_logfile;", "Enable/disable saving the sql statement traces"       
 ]
+[ "sql",       "logfile",      "pattern sql.logfile(filename:str):void ",      
"mvc_logfile;", "Enable/disable saving the sql statement traces"        ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(v:dbl, r:int):dbl ",      
"dbl_trunc_wrap;",      "truncate the floating point v to r digits behind the 
dot (if r < 0, before the dot)"   ]
 [ "sql",       "ms_trunc",     "command sql.ms_trunc(v:flt, r:int):flt ",      
"flt_trunc_wrap;",      "truncate the floating point v to r digits behind the 
dot (if r < 0, before the dot)"   ]
 [ "sql",       "mvc",  "pattern sql.mvc():int ",       "SQLmvc;",      "Get 
the multiversion catalog context. \nNeeded for correct statement 
dependencies\n(ie sql.update, should be after sql.bind in concurrent 
execution)"  ]
@@ -8413,10 +8417,10 @@ Ready.
 [ "sql",       "querylog_enable",      "command 
sql.querylog_enable(thres:int):void ", "QLOGenableThreshold;", ""      ]
 [ "sql",       "rank", "pattern sql.rank(b:any_1, p:bit, o:bit):int ", 
"SQLrank;",     "return the ranked groups"      ]
 [ "sql",       "register",     "pattern sql.register(mod:str, fname:str, 
rel_stmt:str, sig:str):int ", "RAstatement2;",        "Compile the relational 
statement (rel_smt) and register it as mal function, mod.fname(signature)"      
]
-[ "sql",       "restart",      "unsafe pattern sql.restart(sname:str, 
sequence:str, start:lng):lng ",  "mvc_restart_seq;",     "restart the sequence 
with value start" ]
-[ "sql",       "resultSet",    "unsafe pattern sql.resultSet(tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:any...):int 
", "mvc_row_result_wrap;", "Prepare a table result set for the client 
front-end"   ]
-[ "sql",       "resultSet",    "unsafe pattern sql.resultSet(tbl:str, 
attr:str, tpe:str, len:int, scale:int, eclass:int, val:any):int ",       
"mvc_scalar_value_wrap;",       "Prepare a table result set for the client 
front-end."  ]
-[ "sql",       "resultSet",    "unsafe pattern sql.resultSet(tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], 
cols:bat[:any]...):int ",   "mvc_table_result_wrap;",       "Prepare a table 
result set for the client in default CSV format"       ]
+[ "sql",       "restart",      "pattern sql.restart(sname:str, sequence:str, 
start:lng):lng ", "mvc_restart_seq;",     "restart the sequence with value 
start" ]
+[ "sql",       "resultSet",    "pattern sql.resultSet(tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], cols:any...):int 
",        "mvc_row_result_wrap;", "Prepare a table result set for the client 
front-end"   ]
+[ "sql",       "resultSet",    "pattern sql.resultSet(tbl:str, attr:str, 
tpe:str, len:int, scale:int, eclass:int, val:any):int ",      
"mvc_scalar_value_wrap;",       "Prepare a table result set for the client 
front-end."  ]
+[ "sql",       "resultSet",    "pattern sql.resultSet(tbl:bat[:str], 
attr:bat[:str], tpe:bat[:str], len:bat[:int], scale:bat[:int], 
cols:bat[:any]...):int ",  "mvc_table_result_wrap;",       "Prepare a table 
result set for the client in default CSV format"       ]
 [ "sql",       "reuse",        "pattern sql.reuse(sch:str, tbl:str):void ",    
"SQLreuse;",    "Consolidate the deletion table over all columns reusing 
deleted slots" ]
 [ "sql",       "round",        "command sql.round(v:bte, d:int, s:int, 
r:bte):bte ",   "bte_round_wrap;",      "round off the decimal v(d,s) to r 
digits behind the dot (if r < 0, before the dot)"    ]
 [ "sql",       "round",        "command sql.round(v:dbl, r:bte):dbl ", 
"dbl_round_wrap;",      "round off the floating point v to r digits behind the 
dot (if r < 0, before the dot)"  ]
@@ -8458,8 +8462,8 @@ Ready.
 [ "sql",       "sysmon_stop",  "pattern sql.sysmon_stop(tag:sht):void ",       
"SYSMONstop;",  ""      ]
 [ "sql",       "tid",  "pattern sql.tid(mvc:int, sname:str, 
tname:str):bat[:oid] ",    "SQLtid;",      "Return a column with the valid 
tuple identifiers associated with the table sname.tname."       ]
 [ "sql",       "tid",  "pattern sql.tid(mvc:int, sname:str, tname:str, 
part_nr:int, nr_parts:int):bat[:oid] ", "SQLtid;",      "Return the tables tid 
column." ]
-[ "sql",       "transaction",  "unsafe pattern sql.transaction():void ",       
"SQLtransaction2;",     "Start an autocommit transaction"       ]
-[ "sql",       "transaction",  "unsafe pattern sql.transaction():void ",       
"SQLtransaction2;",     "Start an autocommit transaction"       ]
+[ "sql",       "transaction",  "pattern sql.transaction():void ",      
"SQLtransaction2;",     "Start an autocommit transaction"       ]
+[ "sql",       "transaction",  "pattern sql.transaction():void ",      
"SQLtransaction2;",     "Start an autocommit transaction"       ]
 [ "sql",       "transaction_begin",    "pattern 
sql.transaction_begin(chain:int, name:str):void ",     "SQLtransaction_begin;", 
       "A transaction statement (type can be commit,release,rollback or start)" 
       ]
 [ "sql",       "transaction_commit",   "pattern 
sql.transaction_commit(chain:int, name:str):void ",    
"SQLtransaction_commit;",       "A transaction statement (type can be 
commit,release,rollback or start)"        ]
 [ "sql",       "transaction_release",  "pattern 
sql.transaction_release(chain:int, name:str):void ",   
"SQLtransaction_release;",      "A transaction statement (type can be 
commit,release,rollback or start)"        ]
@@ -8566,23 +8570,23 @@ Ready.
 [ "str",       "trim", "command str.trim(s:str):str ", "STRStrip;",    "Strip 
whitespaces around a string."    ]
 [ "str",       "unicode",      "command str.unicode(wchar:int):str ",  
"STRFromWChr;", "convert a unicode to a character."     ]
 [ "str",       "unicodeAt",    "command str.unicodeAt(s:str, index:int):int ", 
"STRWChrAt;",   "get a unicode character\n\t(as an int) from a string 
position."        ]
-[ "streams",   "blocked",      "unsafe command 
streams.blocked(s:streams):streams ",   "open_block_streamwrap;",       "open a 
block based stream"     ]
-[ "streams",   "close",        "unsafe command streams.close(s:streams):void 
",        "mnstr_close_streamwrap;",      "close and destroy the stream s"      
  ]
-[ "streams",   "flush",        "unsafe command streams.flush(s:streams):void 
",        "mnstr_flush_streamwrap;",      "flush the stream"      ]
-[ "streams",   "openRead",     "unsafe command 
streams.openRead(filename:str):streams ",       "mnstr_open_rastreamwrap;",     
"open ascii file stream for reading"    ]
-[ "streams",   "openRead",     "unsafe command 
streams.openRead(s:streams):streams ",  "mnstr_stream_rstreamwrap;",    
"convert an ascii stream to binary"     ]
-[ "streams",   "openReadBytes",        "unsafe command 
streams.openReadBytes(filename:str):streams ",  "mnstr_open_rstreamwrap;",      
"open a file stream for reading"        ]
-[ "streams",   "openWrite",    "unsafe command 
streams.openWrite(filename:str):streams ",      "mnstr_open_wastreamwrap;",     
"open ascii file stream for writing"    ]
-[ "streams",   "openWrite",    "unsafe command 
streams.openWrite(s:streams):streams ", "mnstr_stream_wstreamwrap;",    
"convert an ascii stream to binary"     ]
-[ "streams",   "openWriteBytes",       "unsafe command 
streams.openWriteBytes(filename:str):streams ", "mnstr_open_wstreamwrap;",      
"open a file stream for writing"        ]
-[ "streams",   "readInt",      "unsafe command streams.readInt(s:streams):int 
",       "mnstr_readIntwrap;",   "read integer data from the stream"     ]
-[ "streams",   "readStr",      "unsafe command streams.readStr(s:streams):str 
",       "mnstr_read_stringwrap;",       "read string data from the stream"     
 ]
-[ "streams",   "socketRead",   "unsafe command streams.socketRead(skt:int, 
name:str):streams ",        "mnstr_socket_rastreamwrap;",   "open ascii socket 
stream for reading"  ]
-[ "streams",   "socketReadBytes",      "unsafe command 
streams.socketReadBytes(skt:int, name:str):streams ",   
"mnstr_socket_rstreamwrap;",    "open a socket stream for reading"      ]
-[ "streams",   "socketWrite",  "unsafe command streams.socketWrite(skt:int, 
name:str):streams ",       "mnstr_socket_wastreamwrap;",   "open ascii socket 
stream for writing"  ]
-[ "streams",   "socketWriteBytes",     "unsafe command 
streams.socketWriteBytes(skt:int, name:str):streams ",  
"mnstr_socket_wstreamwrap;",    "open a socket stream for writing"      ]
-[ "streams",   "writeInt",     "unsafe command streams.writeInt(s:streams, 
data:int):void ",   "mnstr_writeIntwrap;",  "write data on the stream"      ]
-[ "streams",   "writeStr",     "unsafe command streams.writeStr(s:streams, 
data:str):void ",   "mnstr_write_stringwrap;",      "write data on the stream"  
    ]
+[ "streams",   "blocked",      "command streams.blocked(s:streams):streams ",  
"open_block_streamwrap;",       "open a block based stream"     ]
+[ "streams",   "close",        "command streams.close(s:streams):void ",       
"mnstr_close_streamwrap;",      "close and destroy the stream s"        ]
+[ "streams",   "flush",        "command streams.flush(s:streams):void ",       
"mnstr_flush_streamwrap;",      "flush the stream"      ]
+[ "streams",   "openRead",     "command streams.openRead(filename:str):streams 
",      "mnstr_open_rastreamwrap;",     "open ascii file stream for reading"    
]
+[ "streams",   "openRead",     "command streams.openRead(s:streams):streams ", 
"mnstr_stream_rstreamwrap;",    "convert an ascii stream to binary"     ]
+[ "streams",   "openReadBytes",        "command 
streams.openReadBytes(filename:str):streams ", "mnstr_open_rstreamwrap;",      
"open a file stream for reading"        ]
+[ "streams",   "openWrite",    "command 
streams.openWrite(filename:str):streams ",     "mnstr_open_wastreamwrap;",     
"open ascii file stream for writing"    ]
+[ "streams",   "openWrite",    "command streams.openWrite(s:streams):streams 
",        "mnstr_stream_wstreamwrap;",    "convert an ascii stream to binary"   
  ]
+[ "streams",   "openWriteBytes",       "command 
streams.openWriteBytes(filename:str):streams ",        
"mnstr_open_wstreamwrap;",      "open a file stream for writing"        ]
+[ "streams",   "readInt",      "command streams.readInt(s:streams):int ",      
"mnstr_readIntwrap;",   "read integer data from the stream"     ]
+[ "streams",   "readStr",      "command streams.readStr(s:streams):str ",      
"mnstr_read_stringwrap;",       "read string data from the stream"      ]
+[ "streams",   "socketRead",   "command streams.socketRead(skt:int, 
name:str):streams ",       "mnstr_socket_rastreamwrap;",   "open ascii socket 
stream for reading"  ]
+[ "streams",   "socketReadBytes",      "command 
streams.socketReadBytes(skt:int, name:str):streams ",  
"mnstr_socket_rstreamwrap;",    "open a socket stream for reading"      ]
+[ "streams",   "socketWrite",  "command streams.socketWrite(skt:int, 
name:str):streams ",      "mnstr_socket_wastreamwrap;",   "open ascii socket 
stream for writing"  ]
+[ "streams",   "socketWriteBytes",     "command 
streams.socketWriteBytes(skt:int, name:str):streams ", 
"mnstr_socket_wstreamwrap;",    "open a socket stream for writing"      ]
+[ "streams",   "writeInt",     "command streams.writeInt(s:streams, 
data:int):void ",  "mnstr_writeIntwrap;",  "write data on the stream"      ]
+[ "streams",   "writeStr",     "command streams.writeStr(s:streams, 
data:str):void ",  "mnstr_write_stringwrap;",      "write data on the stream"   
   ]
 [ "sysmon",    "pause",        "pattern sysmon.pause(id:int):void ",   
"SYSMONpause;", "Suspend a running query"       ]
 [ "sysmon",    "pause",        "pattern sysmon.pause(id:lng):void ",   
"SYSMONpause;", "Suspend a running query"       ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to