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