Changeset: 418f4230dbea for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=418f4230dbea Modified Files: MonetDB.spec NT/Makefile NT/rules.msc NT/wincompile.py bootstrap buildtools/ChangeLog-Archive clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/exports.stable.out clients/examples/perl/countries.sql clients/mapiclient/Tests/mclient--help.stable.err clients/mapiclient/Tests/mclient--help.stable.err.Windows clients/mapiclient/dump.c clients/mapiclient/mclient.1 clients/mapiclient/mclient.c clients/mapiclient/mhelp.c clients/mapiclient/msqldump.c clients/mapiclient/msqldump.h clients/mapilib/mapi.c clients/odbc/driver/ODBCError.c clients/odbc/driver/SQLGetInfo.c common/stream/stream.c common/utils/Makefile.ag common/utils/mutils.h configure.ag debian/changelog debian/monetdb5-server.install debian/monetdb5-sql.install gdk/ChangeLog gdk/Makefile.ag gdk/gdk.h gdk/gdk_aggr.c gdk/gdk_align.c gdk/gdk_atoms.c gdk/gdk_atoms.h gdk/gdk_bat.c gdk/gdk_batop.c gdk/gdk_bbp.c gdk/gdk_calc.c gdk/gdk_calc.h gdk/gdk_calc_private.h gdk/gdk_cand.h gdk/gdk_cross.c gdk/gdk_delta.c gdk/gdk_firstn.c gdk/gdk_group.c gdk/gdk_hash.c gdk/gdk_hash.h gdk/gdk_heap.c gdk/gdk_imprints.c gdk/gdk_join.c gdk/gdk_logger.c gdk/gdk_logger.h gdk/gdk_orderidx.c gdk/gdk_posix.c gdk/gdk_posix.h gdk/gdk_private.h gdk/gdk_project.c gdk/gdk_qsort.c gdk/gdk_qsort_impl.h gdk/gdk_sample.c gdk/gdk_search.c gdk/gdk_select.c gdk/gdk_ssort.c gdk/gdk_ssort_impl.h gdk/gdk_storage.c gdk/gdk_system.c gdk/gdk_tm.c gdk/gdk_unique.c gdk/gdk_utils.c gdk/gdk_value.c geom/BugTracker/Tests/copy_into_crash.SF-1975402.sql geom/BugTracker/Tests/copy_into_crash.SF-1975402.stable.err geom/monetdb5/geom.c geom/monetdb5/geom.h geom/monetdb5/geomBulk.c geom/monetdb5/geom_upgrade.c geom/sql/conformance/Tests/T1.sql geom/sql/conformance/Tests/T1.stable.out geom/sql/conformance/Tests/T13.stable.out geom/sql/conformance/Tests/T14.stable.out geom/sql/conformance/Tests/T17.stable.out geom/sql/conformance/Tests/T18.stable.out geom/sql/conformance/Tests/T23.stable.out geom/sql/conformance/Tests/T24.stable.out geom/sql/conformance/Tests/T27.stable.out geom/sql/conformance/Tests/T29.stable.out geom/sql/conformance/Tests/T31.stable.out geom/sql/conformance/Tests/T34.stable.out geom/sql/conformance/Tests/T47.stable.out geom/sql/conformance/Tests/T48.stable.out geom/sql/conformance/Tests/T49.stable.out geom/sql/conformance/Tests/T50.stable.out geom/sql/conformance/Tests/T52.stable.out geom/sql/conformance/Tests/T8.stable.out geom/sql/functions/Tests/ST_AsEWKT.stable.out geom/sql/functions/Tests/ST_AsText.stable.out geom/sql/pg_regression/Tests/binary.sql.in geom/sql/pg_regression/Tests/boundary.stable.out geom/sql/pg_regression/Tests/clean.sql geom/sql/pg_regression/Tests/delaunaytriangles.stable.out monetdb5/ChangeLog monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.sql monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err.Windows monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows monetdb5/extras/rapi/converters.c.h monetdb5/mal/Tests/tst1200.stable.out monetdb5/mal/Tests/tst1205.stable.out monetdb5/mal/Tests/tst1502.malC monetdb5/mal/Tests/tst233.malC monetdb5/mal/Tests/tst234.malC monetdb5/mal/Tests/tst235.malC monetdb5/mal/Tests/tst903.malC monetdb5/mal/Tests/tst903.stable.out monetdb5/mal/mal_atom.c monetdb5/mal/mal_authorize.c monetdb5/mal/mal_debugger.c monetdb5/mal/mal_instruction.c monetdb5/mal/mal_parser.c monetdb5/mal/mal_profiler.c monetdb5/modules/atoms/Makefile.ag monetdb5/modules/atoms/Tests/All monetdb5/modules/atoms/Tests/xml10.malC monetdb5/modules/atoms/batxml.c monetdb5/modules/atoms/blob.c monetdb5/modules/atoms/blob.h monetdb5/modules/atoms/color.c monetdb5/modules/atoms/color.h monetdb5/modules/atoms/identifier.c monetdb5/modules/atoms/inet.c monetdb5/modules/atoms/json.c monetdb5/modules/atoms/json.h monetdb5/modules/atoms/mtime.c monetdb5/modules/atoms/mtime.h monetdb5/modules/atoms/url.c monetdb5/modules/atoms/url.h monetdb5/modules/atoms/uuid.c monetdb5/modules/atoms/xml.c monetdb5/modules/atoms/xml.h monetdb5/modules/kernel/Tests/select.malC monetdb5/modules/kernel/Tests/time01.malC monetdb5/modules/kernel/aggr.c monetdb5/modules/kernel/alarm.c monetdb5/modules/kernel/algebra.c monetdb5/modules/kernel/algebra.h monetdb5/modules/kernel/algebra.mal monetdb5/modules/kernel/bat5.c monetdb5/modules/kernel/batcolor.c monetdb5/modules/kernel/batmmath.c monetdb5/modules/kernel/batstr.c monetdb5/modules/kernel/logger.c monetdb5/modules/kernel/microbenchmark.c monetdb5/modules/kernel/mmath.c monetdb5/modules/mal/Makefile.ag monetdb5/modules/mal/Tests/inspect05.malC monetdb5/modules/mal/Tests/orderidx00.malC monetdb5/modules/mal/Tests/orderidx04.malC monetdb5/modules/mal/Tests/pqueue.malC monetdb5/modules/mal/Tests/pqueue2.malC monetdb5/modules/mal/Tests/pqueue3.malC monetdb5/modules/mal/batcalc.c monetdb5/modules/mal/calc.c monetdb5/modules/mal/clients.c monetdb5/modules/mal/factories.c monetdb5/modules/mal/language.c monetdb5/modules/mal/mal_init.mal monetdb5/modules/mal/mal_io.c monetdb5/modules/mal/mal_mapi.c monetdb5/modules/mal/manifold.c monetdb5/modules/mal/mat.c monetdb5/modules/mal/mdb.c monetdb5/modules/mal/mkey.c monetdb5/modules/mal/orderidx.c monetdb5/modules/mal/pcre.c monetdb5/modules/mal/remote.c monetdb5/modules/mal/tablet.c monetdb5/modules/mal/tokenizer.c monetdb5/modules/mal/wlc.c monetdb5/modules/mal/wlc.mal monetdb5/optimizer/Tests/DCexample2.malC monetdb5/optimizer/Tests/reorder00.malC monetdb5/optimizer/Tests/reorder00.stable.out monetdb5/optimizer/Tests/tst4700.malC monetdb5/optimizer/opt_costModel.c monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h monetdb5/optimizer/opt_support.c monetdb5/tools/Makefile.ag monetdb5/tools/Tests/mserver5--help.stable.err monetdb5/tools/Tests/mserver5--help.stable.err.Windows rpm.mk.in sql/ChangeLog sql/ChangeLog.Aug2018 sql/backends/monet5/Makefile.ag sql/backends/monet5/Tests/limithack.sql sql/backends/monet5/Tests/rapi15.sql sql/backends/monet5/UDF/capi/capi.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/pyloader.c sql/backends/monet5/UDF/pyapi/type_conversion.c sql/backends/monet5/UDF/udf/udf.c sql/backends/monet5/generator/generator.c sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql.h sql/backends/monet5/sql_bat2time.c sql/backends/monet5/sql_cast.c sql/backends/monet5/sql_cast_impl_down_from_flt.h sql/backends/monet5/sql_cast_impl_int.h sql/backends/monet5/sql_cast_impl_up_to_flt.h sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_cat.h sql/backends/monet5/sql_fround_impl.h sql/backends/monet5/sql_hge.mal sql/backends/monet5/sql_rank.c sql/backends/monet5/sql_rank.h sql/backends/monet5/sql_rank.mal sql/backends/monet5/sql_result.c sql/backends/monet5/sql_result.h sql/backends/monet5/sql_round_impl.h sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_statement.c sql/backends/monet5/sql_statement.h sql/backends/monet5/sql_statistics.c sql/backends/monet5/sql_upgrades.c sql/backends/monet5/sql_user.c sql/backends/monet5/sqlcatalog.mal sql/backends/monet5/vaults/Makefile.ag sql/backends/monet5/vaults/bam/Tests/query1.1.sql sql/backends/monet5/vaults/bam/Tests/query1.1.stable.out sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out sql/backends/monet5/vaults/bam/Tests/query2.11.sql sql/backends/monet5/vaults/bam/Tests/query2.11.stable.out sql/backends/monet5/vaults/bam/Tests/query2.2.sql sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128 sql/backends/monet5/vaults/bam/Tests/query2.6.sql sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out sql/backends/monet5/vaults/bam/bam_db_interface.c sql/backends/monet5/vaults/bam/bam_export.c sql/backends/monet5/vaults/bam/bam_lib.c sql/backends/monet5/vaults/fits/fits.c sql/backends/monet5/vaults/lidar/lidar.c sql/backends/monet5/vaults/netcdf/netcdf.c sql/backends/monet5/wlr.c sql/backends/monet5/wlr.mal sql/benchmarks/ATIS/load.sql sql/benchmarks/VOC/voc_dump.sql sql/benchmarks/alex/load.sql sql/benchmarks/arno/load.int.sql sql/benchmarks/arno_flt/load.flt.sql sql/benchmarks/hist-uva/ground/load.sql sql/benchmarks/moa/load1.sql sql/benchmarks/ssbm/Tests/load-sf-0.01.sql sql/benchmarks/tpch/load-sf-0.01-LOCKED.sql sql/benchmarks/tpch/load-sf-0.01.sql sql/benchmarks/tpch/load-sf-1.sql sql/benchmarks/viam/Tests/dump.sql sql/common/sql_backend.c sql/common/sql_backend.h sql/common/sql_changeset.c sql/common/sql_list.c sql/common/sql_string.c sql/common/sql_string.h sql/common/sql_types.c sql/common/sql_types.h sql/include/sql_catalog.h sql/include/sql_list.h sql/include/sql_relation.h sql/jdbc/tests/Tests/BugResultSetMetaData_Bug_6183.stable.out sql/scripts/51_sys_schema_extension.sql sql/scripts/75_storagemodel.sql sql/server/rel_dump.c sql/server/rel_exp.c sql/server/rel_optimizer.c sql/server/rel_propagate.c sql/server/rel_psm.c sql/server/rel_schema.c sql/server/rel_select.c sql/server/rel_semantic.c sql/server/rel_sequence.c sql/server/rel_updates.c sql/server/sql_atom.c sql/server/sql_atom.h sql/server/sql_mvc.c sql/server/sql_mvc.h sql/server/sql_parser.h sql/server/sql_parser.y sql/server/sql_partition.c sql/server/sql_privileges.c sql/server/sql_privileges.h sql/server/sql_scan.c sql/server/sql_semantic.c sql/server/sql_symbol.c sql/server/sql_symbol.h sql/storage/bat/bat_logger.c sql/storage/bat/bat_logger.h sql/storage/bat/bat_storage.c sql/storage/bat/bat_table.c sql/storage/bat/res_table.c sql/storage/sql_catalog.c sql/storage/sql_storage.h sql/storage/store.c sql/storage/store_dependency.c sql/storage/store_sequence.c sql/test/ADT2006/Tests/sander.stable.err sql/test/ADT2006/benesamo.sql sql/test/ADT2006/bram.sql sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.sql sql/test/BugDay_2005-10-06_2.9.3/Tests/UNION_JOIN_vs_plain_set_UNION-2.SF-920585.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/foreign_key_in_frontend_crashes_backend.SF-935578.sql sql/test/BugDay_2005-10-06_2.9.3/Tests/inlined_copy_into.SF-922392.sql sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.sql sql/test/BugDay_2005-11-09_2.9.3/Tests/hang_on_copy_into.SF-1100504.stable.err sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.sql sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.sql sql/test/BugTracker-2008/Tests/copy-format.SF-2468513.sql sql/test/BugTracker-2008/Tests/copy-format.SF-2468513.stable.err sql/test/BugTracker-2008/Tests/varchar.SF-2471371.sql sql/test/BugTracker-2008/Tests/varchar.SF-2471371.stable.err sql/test/BugTracker-2008/insert-null-byte.sql sql/test/BugTracker-2009/Tests/COPY_INTO_char_NULL.SF-2560780.sql.in sql/test/BugTracker-2009/Tests/copy_into_error_off_by_one.SF-2833696.sql 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.sql sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.err.Windows sql/test/BugTracker-2009/Tests/copy_multiple_files.SF-2902320.stable.out.Windows sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.err sql/test/BugTracker-2009/Tests/drop-sequence-crash.SF-2854195.stable.out sql/test/BugTracker-2009/Tests/nullstr.SF-2704016.sql sql/test/BugTracker-2009/Tests/orderby_with_row_number.SF-2895791.stable.out sql/test/BugTracker-2009/Tests/parallel_bulk-load.SF-2771052.test.sql.in sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql sql/test/BugTracker-2009/Tests/union_leak.SF-2540169.1.sql.in sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out sql/test/BugTracker-2010/Tests/cast-varchar.Bug-2682.sql sql/test/BugTracker-2010/Tests/delete_insert.Bug-2529.sql sql/test/BugTracker-2010/Tests/embedded_record_seperator.SF-2991400.sql sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.sql sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err.Darwin sql/test/BugTracker-2010/Tests/error-truncated.Bug-2615.stable.err.Windows sql/test/BugTracker-2010/Tests/heap_combine_crash.SF-2947763.sql sql/test/BugTracker-2010/Tests/incomplete-utf8-sequence.Bug-2575.sql sql/test/BugTracker-2010/Tests/incomplete-utf8-sequence.Bug-2575.stable.err sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql sql/test/BugTracker-2010/Tests/multiple-common-table-expressions.Bug-2664.sql sql/test/BugTracker-2010/Tests/reorder.SF-2995671.sql sql/test/BugTracker-2011/Tests/FK_self_reference.Bug-2862.sql sql/test/BugTracker-2011/Tests/copy-into-file-error.Bug-2722.sql sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql sql/test/BugTracker-2011/Tests/device-self-ref-fk.sql sql/test/BugTracker-2011/Tests/double_erange.Bug-2774.sql sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875.py sql/test/BugTracker-2011/Tests/jena-optional-1-test.Bug-2915.sql sql/test/BugTracker-2011/Tests/operands-not-synced.Bug-2346.sql sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.sql sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.sql sql/test/BugTracker-2012/Tests/hash_select.Bug-2947.sql sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.sql sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.sql sql/test/BugTracker-2012/Tests/strange_escaping_in_csv.Bug-2133.sql sql/test/BugTracker-2012/Tests/strange_escaping_in_csv.Bug-2133.stable.out sql/test/BugTracker-2012/Tests/time-export-bug.Bug-2963.sql sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.err sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.out sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.sql sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in sql/test/BugTracker-2013/Tests/copy-into-decimal.Bug-3265.sql sql/test/BugTracker-2013/Tests/copy-out-quote.Bug-3393.sql sql/test/BugTracker-2013/Tests/crash-from-optimizer.Bug-3241.sql sql/test/BugTracker-2013/Tests/create_table_with_func.Bug-3286.sql sql/test/BugTracker-2013/Tests/create_table_with_func.Bug-3286.stable.out sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.err sql/test/BugTracker-2013/Tests/median-null.Bug-3280.sql sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.sql sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql sql/test/BugTracker-2013/Tests/restore-uuid.Bug-3407.sql sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.sql sql/test/BugTracker-2014/Tests/copy_decimal_into.Bug-3596.sql sql/test/BugTracker-2014/Tests/null_in_string.Bug-2014.sql sql/test/BugTracker-2014/Tests/oid-table-assert.Bug-3514.sql sql/test/BugTracker-2014/Tests/select-distinct-order-limit.Bug-3527.sql sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.stable.out sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.sql sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.stable.err sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out sql/test/BugTracker-2015/Tests/dump-DELETE.Bug-3850.stable.out sql/test/BugTracker-2015/Tests/float-space-parse.Bug-3691.sql sql/test/BugTracker-2015/Tests/float-space-parse.Bug-3691.stable.err sql/test/BugTracker-2015/Tests/import-non-ascii.Bug-3864.sql sql/test/BugTracker-2015/Tests/is_null_limit.Bug-3684.sql sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.sql sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.sql sql/test/BugTracker-2015/Tests/msqldump-merge-and-remote-tables.Bug-3774.stable.out sql/test/BugTracker-2015/Tests/project_rewrite.Bug-3693_2.sql sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.stable.out sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.sql sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.sql sql/test/BugTracker-2016/Tests/assert-on-push-project-up.Bug-6077.stable.out sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.sql sql/test/BugTracker-2016/Tests/malformed-copy-int.Bug-3987.sql.in sql/test/BugTracker-2016/Tests/outer_constant_predicate.Bug-4070.sql sql/test/BugTracker-2016/Tests/storagemodel.sql sql/test/BugTracker-2016/Tests/storagemodel.stable.out sql/test/BugTracker-2016/Tests/wrong-nonil-property-with-copy-binary-into.Bug-3937.sql.in sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.sql sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.FreeBSD sql/test/BugTracker-2017/Tests/cleanup_statistics.Bug-6439.stable.out.Windows sql/test/BugTracker-2017/Tests/crash-in-topn.Bug-6478.sql sql/test/BugTracker-2017/Tests/crash-on-limit-rename.Bug-6502.sql sql/test/BugTracker-2017/Tests/crash_correlated_subqueries_in_select.Bug-6254.stable.out sql/test/BugTracker-2017/Tests/crash_in_null_cast.Bug-6186.sql sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.sql sql/test/BugTracker-2017/Tests/create_view_order_by.Bug-3465.stable.out sql/test/BugTracker-2017/Tests/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/empty-interval.Bug-6184.sql sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out sql/test/BugTracker-2017/Tests/heapextend.Bug-6134.sql.in sql/test/BugTracker-2017/Tests/semijoinunion.Bug-6150.sql sql/test/BugTracker-2017/Tests/spurious_error.Bug-6344.sql sql/test/BugTracker-2017/Tests/sqlsmith.Bug-6423.stable.out sql/test/BugTracker-2017/Tests/type-resolution-error.Bugs-6313.sql sql/test/BugTracker-2017/Tests/type-resolution-error.Bugs-6313.stable.err sql/test/BugTracker-2018/Tests/All sql/test/BugTracker-2018/Tests/case_with_orderby_limit.Bug-6512.sql sql/test/BugTracker-2018/Tests/copy-into-ignore-column-1.Bug-6532.sql sql/test/BugTracker-2018/Tests/count_from_commented_function_signatures.Bug-6542.stable.out sql/test/BugTracker-2018/Tests/dependency_column_on_sequence.Bug-6618.SQL.py sql/test/BugTracker-2018/Tests/dependency_column_on_sequence.Bug-6618.stable.err sql/test/BugTracker-2018/Tests/dependency_column_on_sequence.Bug-6618.stable.out sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.sql sql/test/BugTracker-2018/Tests/groupby_having_orderby_count.Bug-6624.stable.out sql/test/BugTracker-2018/Tests/in-subquery-having-Bug-6651.sql sql/test/BugTracker-2018/Tests/in-subquery-having-Bug-6651.stable.out sql/test/BugTracker-2018/Tests/multiple-insertinto-table-Bug-6578.sql sql/test/BugTracker-2018/Tests/prepared-statement-with-udf.Bug-6650.sql sql/test/BugTracker-2018/Tests/procedure-create-table.Bug-6604.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.sql sql/test/BugTracker-2018/Tests/sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.out sql/test/BugTracker/Tests/copy_decimal.SF-1582957.sql sql/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err sql/test/BugTracker/Tests/copy_into_crash.SF-1993999.sql sql/test/BugTracker/Tests/copy_overflow_null_bug.SF-1842550.sql sql/test/BugTracker/Tests/copy_overflow_null_bug.SF-1842550.stable.err sql/test/BugTracker/Tests/variable_stack_crash_load.SF-1711251.sql sql/test/BugTracker/Tests/with_row_number.SF-1898089.sql sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/Dependencies/Tests/dependency_loop.stable.out sql/test/Dependencies/Tests/dependency_loop.stable.out.int128 sql/test/Dump/Tests/dump.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 sql/test/Skyserver/Skyserver_functions.sql sql/test/Skyserver/Skyserver_functions_v6.sql sql/test/Skyserver/Skyserver_import.sql sql/test/Skyserver/Skyserver_import_v6.sql sql/test/Skyserver/bugs/Tests/load_dbobjects.sql sql/test/Skyserver/bugs/Tests/load_objmask.sql sql/test/Tests/bincopycollist.sql.in sql/test/Tests/copy-from-compressed.sql.in sql/test/Tests/copy-into-fwf.sql.in sql/test/Tests/copy-into-lz4.sql.in sql/test/Tests/copy_into.sql.in sql/test/Tests/fsum.sql sql/test/Tests/identifiers.stable.err sql/test/Tests/identifiers.stable.out sql/test/Tests/load_with_offset.sql sql/test/Tests/lz4-dump.sql sql/test/Tests/order_by_complex_exp.stable.out sql/test/Tests/rank.stable.out sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/Users/Tests/grantMonetdb.stable.err sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.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/VOC/VOCinsert.sql sql/test/VOC/load.sql sql/test/Via-m/create-viam.sql sql/test/bugs/Tests/copy_into_quote.sql sql/test/bugs/Tests/copy_into_with_schema.sql sql/test/bugs/Tests/crash_order_by.sql sql/test/bugs/Tests/decimal_copy_into_bug.sql sql/test/bugs/Tests/ifthenelse_bug.sql sql/test/bugs/Tests/in.sql sql/test/bugs/Tests/innerjoin_multiple-bug-sf-943661.stable.out sql/test/bugs/Tests/order_limit_offset_bug.sql sql/test/bugs/Tests/rangejoin_optimize_bug.sql sql/test/bugs/Tests/simple_view.sql sql/test/bugs/Tests/substring_limit_bug.sql sql/test/bugs/escape_quote-bug-sf-1006469.sql sql/test/bugs/insert_delete-bug-sf-904025.sql sql/test/copy/Tests/columns.sql sql/test/copy/Tests/columns.stable.err sql/test/copy/Tests/embedded_sep.sql sql/test/copy/Tests/escaped_char.sql sql/test/copy/Tests/format_date.sql sql/test/copy/Tests/incorrect_columns.sql sql/test/copy/Tests/ingestion.sql sql/test/copy/Tests/int_parse.sql sql/test/copy/Tests/int_parse.stable.err sql/test/copy/Tests/int_parse_best.sql sql/test/copy/Tests/key_copy.sql sql/test/copy/Tests/key_copy.stable.err sql/test/copy/Tests/load_stdin_incorrect_line_nr.sql sql/test/copy/Tests/load_stdin_incorrect_line_nr.stable.err sql/test/copy/Tests/null_as_string.sql sql/test/copy/Tests/null_as_string_errors.sql sql/test/copy/Tests/null_as_string_errors.stable.err sql/test/copy/Tests/null_as_string_output.sql sql/test/copy/Tests/overflow_error.sql sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128 sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128 sql/test/emptydb/Tests/check.SQL.py sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/group-concat/Tests/groupconcat01.stable.out sql/test/group-concat/Tests/groupconcat02.stable.out sql/test/group-concat/Tests/groupconcat03.stable.out sql/test/group-concat/Tests/groupconcat04.sql sql/test/group-concat/Tests/groupconcat04.stable.out sql/test/group-concat/Tests/groupconcat05.sql sql/test/group-concat/Tests/groupconcat05.stable.out sql/test/json/Tests/coercions.sql sql/test/json/Tests/coercions.stable.out sql/test/json/Tests/jsonvalidity.Bug-3753.sql sql/test/json/Tests/jsonvalidity.Bug-3753.stable.out sql/test/json/Tests/pgexample.sql sql/test/merge-partitions/Tests/mergepart28.sql.in sql/test/mergetables/Tests/crash0.sql sql/test/mergetables/Tests/forex.sql sql/test/mergetables/Tests/mergedb_create.sql sql/test/mergetables/Tests/mergedrop.sql sql/test/mergetables/Tests/mergedropcascade.sql sql/test/mergetables/Tests/mergekey.sql sql/test/mergetables/Tests/mergeload.sql sql/test/mergetables/Tests/mergeloadidx.sql sql/test/mergetables/Tests/mergemergeload.sql sql/test/mergetables/Tests/mergemergeload.stable.err sql/test/mergetables/Tests/mergequery.sql sql/test/mergetables/Tests/singlekeyconstraint.sql sql/test/mergetables/Tests/sqlsmith-apply-outer-join-or.sql sql/test/miscellaneous/Tests/All sql/test/news.sql sql/test/order_by_complex_exp.sql sql/test/orderidx/Tests/imprints_all_types.stable.out sql/test/orderidx/Tests/imprints_hge_type.stable.out.int128 sql/test/orderidx/Tests/oidx_all_types.stable.out sql/test/orderidx/Tests/oidx_hge_type.stable.out.int128 sql/test/orderidx/Tests/simpletable.stable.out sql/test/orderidx/Tests/simpletable.stable.out.32bit sql/test/orderidx/Tests/smalltable.stable.out sql/test/orderidx/Tests/smalltable.stable.out.32bit sql/test/osm/Tests/delete_alter_bug.sql sql/test/pg_regress/Tests/alter_table.stable.err sql/test/pg_regress/Tests/alter_table.stable.out sql/test/pg_regress/Tests/arrays.sql sql/test/pg_regress/Tests/arrays.stable.err sql/test/pg_regress/Tests/box.stable.out sql/test/pg_regress/Tests/drop.stable.err sql/test/pg_regress/Tests/int8.sql sql/test/pg_regress/Tests/int8.stable.err sql/test/pg_regress/Tests/int8.stable.err.int128 sql/test/pg_regress/Tests/numeric.sql sql/test/pg_regress/Tests/numeric.stable.err sql/test/pg_regress/Tests/numeric.stable.out.FreeBSD.int128 sql/test/pg_regress/Tests/numeric.stable.out.int128 sql/test/pg_regress/Tests/oid.sql sql/test/pg_regress/Tests/oid.stable.err sql/test/pg_regress/Tests/oid.stable.err.32bit sql/test/pg_regress/Tests/oid.stable.err.int128 sql/test/pg_regress/Tests/oid.stable.out sql/test/pg_regress/Tests/oid.stable.out.32bit sql/test/pg_regress/Tests/path.stable.out sql/test/pg_regress/Tests/point.sql sql/test/pg_regress/Tests/point.stable.out sql/test/pg_regress/Tests/polygon.stable.out sql/test/pg_regress/Tests/timestamp.sql sql/test/pg_regress/Tests/timestamp.stable.err sql/test/pg_regress/Tests/timestamptz.sql sql/test/pg_regress/Tests/timestamptz.stable.err sql/test/pg_regress/Tests/type_sanity.sql sql/test/pg_regress/Tests/vacuum.stable.out sql/test/pg_regress/Tests/without_oid.stable.out sql/test/pg_regress/Tests/without_oid.stable.out.32bit sql/test/quantiles/Tests/quantiles.sql sql/test/rank.sql sql/test/remote/Tests/ssbm.SQL.py sql/test/sql_xml/load.sql sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.sql sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.stable.out sql/test/sys-schema/Tests/check_PrimaryKey_uniqueness.stable.out sql/test/testdb-upgrade-chain-hge/Tests/dump.stable.out.int128 sql/test/testdb-upgrade-chain/Tests/dump.stable.out sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128 sql/test/testdb-upgrade/Tests/dump.stable.out sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128 sql/test/testdb-upgrade/Tests/upgrade.stable.out.powerpc64.int128 sql/test/testdb/Tests/All sql/test/thinksql-load.sql sql/test/utf8/load.sql sql/test/wlcr/Tests/wlc01.py sql/test/wlcr/Tests/wlc100.py sql/test/wlcr/Tests/wlc20.py sql/test/wlcr/Tests/wlc21.py sql/test/wlcr/Tests/wlc30.py sql/test/wlcr/Tests/wlc40.py sql/test/wlcr/Tests/wlc50.py sql/test/wlcr/Tests/wlc70.py sql/test/wlcr/Tests/wlr01.py sql/test/wlcr/Tests/wlr100.py sql/test/wlcr/Tests/wlr20.py sql/test/wlcr/Tests/wlr30.py sql/test/wlcr/Tests/wlr40.py sql/test/wlcr/Tests/wlr50.py sql/test/wlcr/Tests/wlr70.py sql/test/xquery/Tests/create.sql testing/Mfilter.py testing/Mtest.py.in testing/README testing/malcheck.py testing/process.py tools/merovingian/client/monetdb.c tools/merovingian/daemon/argvcmds.c tools/merovingian/daemon/controlrunner.c tools/merovingian/daemon/merovingian.c tools/merovingian/daemon/merovingian.h tools/merovingian/daemon/proxy.c tools/mserver/monet_version.c.in tools/mserver/mserver5.1.in tools/mserver/mserver5.c Branch: delete_in_vlist Log Message:
Fix merge. diffs (truncated from 160943 to 300 lines): diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -112,6 +112,7 @@ Vendor: MonetDB BV <i...@monetdb.org> Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ +BugURL: https://bugs.monetdb.org/ Source: https://www.monetdb.org/downloads/sources/Aug2018-SP1/%{name}-%{version}.tar.bz2 # we need systemd for the _unitdir macro to exist @@ -689,7 +690,6 @@ exit 0 %{_libdir}/monetdb5/lib_generator.so %{_libdir}/monetdb5/lib_opt_sql_append.so %{_libdir}/monetdb5/lib_udf.so -%{_libdir}/monetdb5/lib_vault.so %doc %{_mandir}/man1/mserver5.1.gz %dir %{_datadir}/doc/MonetDB %docdir %{_datadir}/doc/MonetDB @@ -780,7 +780,6 @@ use SQL with MonetDB, you will need to i %config(noreplace) %attr(644,root,root) %{_sysconfdir}/logrotate.d/monetdbd %{_libdir}/monetdb5/autoload/??_sql.mal %{_libdir}/monetdb5/lib_sql.so -%{_libdir}/monetdb5/*.sql %dir %{_libdir}/monetdb5/createdb %if %{with geos} %exclude %{_libdir}/monetdb5/createdb/*_geom.sql @@ -1080,7 +1079,7 @@ done * Wed Oct 3 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.9-20181005 - buildtools: On Ubuntu 18.10 (Cosmic Cuttlefish), the libmonetdb5-server-bam package cannot be built because of an incompatibility in the libbam library - (it cannot be used in a shared object. + (it cannot be used in a shared object). * Wed Aug 29 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.7-20180829 - Rebuilt. diff --git a/NT/Makefile b/NT/Makefile --- a/NT/Makefile +++ b/NT/Makefile @@ -19,7 +19,7 @@ all: _all !INCLUDE "$(NT)\rules.msc" -_all: update_winconfig_conds_py "$(srcdir)\Makefile.msc" monetdb_config.h unistd.h .monetdb +_all: update_winconfig_conds_py "$(srcdir)\Makefile.msc" monetdb_config.h unistd.h .monetdb monetdb_hgversion.h $(MAKE) /nologo /f "$(srcdir)\Makefile.msc" "prefix=$(prefix)" "bits=$(bits)" all install: targetdirs all @@ -34,6 +34,9 @@ install: targetdirs all monetdb_config.h: "$(TOPDIR)\winconfig_conds.py" "$(NT)\monetdb_config.h.in" $(CONFIGURE) "$(NT)\monetdb_config.h.in" > monetdb_config.h +monetdb_hgversion.h: + $(ECHO) #undef MERCURIAL_ID > monetdb_hgversion.h + unistd.h: $(ECHO) #ifndef UNISTD_H > unistd.h $(ECHO) #define UNISTD_H >> unistd.h diff --git a/NT/rules.msc b/NT/rules.msc --- a/NT/rules.msc +++ b/NT/rules.msc @@ -138,7 +138,13 @@ zlib_CFLAGS = -DHAVE_LIBZ "-I$(LIBZLIB)\ !IFNDEF LIBBZIP2 LIBBZIP2 = C:\bzip2-1.0.5.win$(bits) !ENDIF -bzip2_LIBS = "$(LIBBZIP2)\lib\libbz2.lib" +!IFDEF DEBUG +# in a debug build of MonetDB, we need to use a debug build of libbz2 +# since it seems that the FILE pointer cannot be carried over from a +# debug build to a non-debug build. +BZIPDEBUGEXT = d +!endif +bzip2_LIBS = "$(LIBBZIP2)\lib\libbz2$(BZIPDEBUGEXT).lib" bzip2_CFLAGS = -DHAVE_LIBBZ2 "-I$(LIBBZIP2)\include" !ENDIF diff --git a/NT/wincompile.py b/NT/wincompile.py --- a/NT/wincompile.py +++ b/NT/wincompile.py @@ -51,7 +51,7 @@ def splitcommand(cmd): del command[0] return command -def process(args, recursive = False): +def process(args, recursive=False): argv = [] for arg in args: if not recursive and arg[:1] == '@': @@ -64,9 +64,9 @@ def process(args, recursive = False): else: dirname = os.path.dirname(arg) p = subprocess.Popen(['lib', '/nologo', '/list', arg], - shell = False, - universal_newlines = True, - stdout = subprocess.PIPE) + shell=False, + universal_newlines=True, + stdout=subprocess.PIPE) for f in p.stdout: argv.append(os.path.join(dirname, f.strip())) p.wait() @@ -79,12 +79,8 @@ argv = process(sys.argv[1:]) if verbose: sys.stdout.write('EXECUTE: %s\n' % ' '.join(argv)) sys.stdout.flush() -p = subprocess.Popen(argv, shell = False, universal_newlines = True, - stdout = subprocess.PIPE, stderr = subprocess.PIPE) -out, err = p.communicate() -sys.stdout.write(out) -sys.stderr.write(err) -if p.returncode and not verbose: +returncode = subprocess.call(argv, shell=False) +if returncode and not verbose: sys.stderr.write('failed invocation: %s\n' % ' '.join(argv)) sys.stderr.flush() -sys.exit(p.returncode) +sys.exit(returncode) diff --git a/bootstrap b/bootstrap --- a/bootstrap +++ b/bootstrap @@ -62,6 +62,8 @@ aclocal$amv ${_m4_extra_dirs} || exit $? autoheader || exit $? automake$amv --add-missing --copy --foreign || exit $? autoconf || exit $? +# a bit hacky: add dependency on monetdb_hgversion.h for common/utils/revision.c +sed -i~ '/revision.*:/s;$; ../../monetdb_hgversion.h;' common/utils/Makefile.am if [ -f buildtools/conf/install-sh -a ! -x buildtools/conf/install-sh ]; then chmod +x buildtools/conf/install-sh fi diff --git a/buildtools/ChangeLog-Archive b/buildtools/ChangeLog-Archive --- a/buildtools/ChangeLog-Archive +++ b/buildtools/ChangeLog-Archive @@ -4,7 +4,7 @@ * Wed Oct 3 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.9-20181005 - On Ubuntu 18.10 (Cosmic Cuttlefish), the libmonetdb5-server-bam package cannot be built because of an incompatibility in the libbam library - (it cannot be used in a shared object. + (it cannot be used in a shared object). * Tue Aug 28 2018 Sjoerd Mullender <sjo...@acm.org> - 11.31.5-20180829 - Build the MonetDB-cfitsio RPM and libmonetdb5-server-cfitsio diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -527,12 +527,12 @@ Ready. [ "algebra", "exist", "command algebra.exist(b:bat[:any_1], val:any_1):bit ", "ALGexist;", "Returns whether 'val' occurs in b." ] [ "algebra", "fetch", "command algebra.fetch(b:bat[:any_1], x:oid):any_1 ", "ALGfetchoid;", "Returns the value of the BUN at x-th position with 0 <= x < b.count" ] [ "algebra", "find", "command algebra.find(b:bat[:any_1], t:any_1):oid ", "ALGfind;", "Returns the index position of a value. If no such BUN exists return OID-nil." ] -[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "Calculate first N values of B" ] -[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], n:lng, asc:bit, distinct:bit):bat[:oid] ", "ALGfirstn;", "Calculate first N values of B" ] -[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], g:bat[:oid], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] -[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], g:bat[:oid], n:lng, asc:bit, distinct:bit):bat[:oid] ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] -[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], n:lng, asc:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] -[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], n:lng, asc:bit, distinct:bit):bat[:oid] ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] +[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], n:lng, asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "Calculate first N values of B" ] +[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] ", "ALGfirstn;", "Calculate first N values of B" ] +[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], g:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] +[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], g:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] +[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] +[ "algebra", "firstn", "pattern algebra.firstn(b:bat[:any], s:bat[:oid], n:lng, asc:bit, nilslast:bit, distinct:bit):bat[:oid] ", "ALGfirstn;", "Calculate first N values of B with candidate list S" ] [ "algebra", "groupby", "command algebra.groupby(gids:bat[:oid], cnts:bat[:lng]):bat[:oid] ", "ALGgroupby;", "Produces a new BAT with groups identified by the head column. The result contains tail times the head value, ie the tail contains the result group sizes." ] [ "algebra", "ilike", "command algebra.ilike(s:str, pat:str):bit ", "PCREilike2;", "" ] [ "algebra", "ilike", "command algebra.ilike(s:str, pat:str, esc:str):bit ", "PCREilike3;", "" ] @@ -569,15 +569,15 @@ Ready. [ "algebra", "slice", "command algebra.slice(b:bat[:any_1], x:int, y:int):bat[:any_1] ", "ALGslice_int;", "Return the slice with the BUNs at position x till y." ] [ "algebra", "slice", "command algebra.slice(b:bat[:any_1], x:lng, y:lng):bat[:any_1] ", "ALGslice_lng;", "Return the slice with the BUNs at position x till y." ] [ "algebra", "slice", "command algebra.slice(b:bat[:any_1], x:oid, y:oid):bat[:any_1] ", "ALGslice_oid;", "Return the slice based on head oid x till y (exclusive)." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, stable:bit):bat[:any_1] ", "ALGsort11;", "Returns a copy of the BAT sorted on tail values.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort12;", "Returns a copy of the BAT sorted on tail values and a BAT that\n specifies how the input was reordered.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ", "ALGsort13;", "Returns a copy of the BAT sorted on tail values, a BAT that specifies\n how the input was reordered, and a BAT with group information.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], reverse:bit, stable:bit):bat[:any_1] ", "ALGsort21;", "Returns a copy of the BAT sorted on tail values.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort22;", "Returns a copy of the BAT sorted on tail values and a BAT that\n specifies how the input was reordered.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ", "ALGsort23;", "Returns a copy of the BAT sorted on tail values, a BAT that specifies\n how the input was reordered, and a BAT with group information.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], g:bat[:oid], reverse:bit, stable:bit):bat[:any_1] ", "ALGsort31;", "Returns a copy of the BAT sorted on tail values.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], g:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort32;", "Returns a copy of the BAT sorted on tail values and a BAT that\n specifies how the input was reordered.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] -[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], g:bat[:oid], reverse:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ", "ALGsort33;", "Returns a copy of the BAT sorted on tail values, a BAT that specifies\n how the input was reordered, and a BAT with group information.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ", "ALGsort11;", "Returns a copy of the BAT sorted on tail values.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort12;", "Returns a copy of the BAT sorted on tail values and a BAT that\n specifies how the input was reordered.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ", "ALGsort13;", "Returns a copy of the BAT sorted on tail values, a BAT that specifies\n how the input was reordered, and a BAT with group information.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ", "ALGsort21;", "Returns a copy of the BAT sorted on tail values.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort22;", "Returns a copy of the BAT sorted on tail values and a BAT that\n specifies how the input was reordered.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ", "ALGsort23;", "Returns a copy of the BAT sorted on tail values, a BAT that specifies\n how the input was reordered, and a BAT with group information.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], g:bat[:oid], reverse:bit, nilslast:bit, stable:bit):bat[:any_1] ", "ALGsort31;", "Returns a copy of the BAT sorted on tail values.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], g:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid]) ", "ALGsort32;", "Returns a copy of the BAT sorted on tail values and a BAT that\n specifies how the input was reordered.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] +[ "algebra", "sort", "command algebra.sort(b:bat[:any_1], o:bat[:oid], g:bat[:oid], reverse:bit, nilslast:bit, stable:bit) (X_0:bat[:any_1], X_1:bat[:oid], X_2:bat[:oid]) ", "ALGsort33;", "Returns a copy of the BAT sorted on tail values, a BAT that specifies\n how the input was reordered, and a BAT with group information.\n The input and output are (must be) dense headed.\n The order is descending if the reverse bit is set.\n\t\t This is a stable sort if the stable bit is set." ] [ "algebra", "subslice", "command algebra.subslice(b:bat[:any_1], x:lng, y:lng):bat[:oid] ", "ALGsubslice_lng;", "Return the oids of the slice with the BUNs at position x till y." ] [ "algebra", "thetajoin", "command algebra.thetajoin(l:bat[:any_1], r:bat[:any_1], sl:bat[:oid], sr:bat[:oid], op:int, nil_matches:bit, estimate:lng) (X_0:bat[:oid], X_1:bat[:oid]) ", "ALGthetajoin;", "Theta join with candidate lists" ] [ "algebra", "thetaselect", "command algebra.thetaselect(b:bat[:any_1], val:any_1, op:str):bat[:oid] ", "ALGthetaselect1;", "Select all head values for which the tail value obeys the relation\n\tvalue OP VAL.\n\tInput is a dense-headed BAT, output is a dense-headed BAT with in\n\tthe tail the head value of the input BAT for which the\n\trelationship holds. The output BAT is sorted on the tail value." ] @@ -8377,6 +8377,14 @@ Ready. [ "batrapi", "subeval_aggr", "pattern batrapi.subeval_aggr(fptr:ptr, expr:str, arg:any...):any... ", "RAPIevalAggr;", "grouped aggregates through R" ] [ "batsql", "alpha", "command batsql.alpha(dec:bat[:dbl], theta:dbl):bat[:dbl] ", "SQLbat_alpha_cst;", "BAT implementation of astronomy alpha function" ] [ "batsql", "alpha", "command batsql.alpha(dec:dbl, theta:bat[:dbl]):bat[:dbl] ", "SQLcst_alpha_bat;", "BAT implementation of astronomy alpha function" ] +[ "batsql", "avg", "pattern batsql.avg(b:bat[:bte], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ] +[ "batsql", "avg", "pattern batsql.avg(b:bat[:dbl], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ] +[ "batsql", "avg", "pattern batsql.avg(b:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ] +[ "batsql", "avg", "pattern batsql.avg(b:bat[:int], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ] +[ "batsql", "avg", "pattern batsql.avg(b:bat[:lng], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ] +[ "batsql", "avg", "pattern batsql.avg(b:bat[:sht], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLavg;", "return the average of groups" ] +[ "batsql", "count", "pattern batsql.count(b:bat[:any_1], ignils:bit, s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLcount;", "return count of groups" ] +[ "batsql", "cume_dist", "pattern batsql.cume_dist(b:bat[:any_1], p:any_2, o:any_3):bat[:dbl] ", "SQLcume_dist;", "return the accumulated distribution of the number of rows per group to the total number of partition rows" ] [ "batsql", "dec_round", "command batsql.dec_round(v:bat[:bte], r:bte):bat[:bte] ", "bte_bat_dec_round_wrap;", "round off the value v to nearests multiple of r" ] [ "batsql", "dec_round", "command batsql.dec_round(v:bat[:dbl], r:dbl):bat[:dbl] ", "dbl_bat_dec_round_wrap;", "round off the value v to nearests multiple of r" ] [ "batsql", "dec_round", "command batsql.dec_round(v:bat[:flt], r:flt):bat[:flt] ", "flt_bat_dec_round_wrap;", "round off the value v to nearests multiple of r" ] @@ -8386,8 +8394,38 @@ Ready. [ "batsql", "dense_rank", "pattern batsql.dense_rank(b:bat[:any_1], p:any_2, o:any_3):bat[:int] ", "SQLdense_rank;", "return the densely ranked groups" ] [ "batsql", "diff", "pattern batsql.diff(b:bat[:any_1]):bat[:bit] ", "SQLdiff;", "return true if cur != prev row" ] [ "batsql", "diff", "pattern batsql.diff(p:bat[:bit], b:bat[:any_1]):bat[:bit] ", "SQLdiff;", "return true if cur != prev row" ] +[ "batsql", "first_value", "pattern batsql.first_value(b:bat[:any_1], s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLfirst_value;", "return the first value of groups" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:any_2, d:any_1, p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:any_2, d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:any_2, p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous 'l' row in the partition or NULL if non existent" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:bat[:any_2], d:any_1, p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:bat[:any_2], d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], l:bat[:any_2], p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous 'l' row in the partition or NULL if non existent" ] +[ "batsql", "lag", "pattern batsql.lag(b:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlag;", "return the value in the previous row in the partition or NULL if non existent" ] +[ "batsql", "last_value", "pattern batsql.last_value(b:bat[:any_1], s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLlast_value;", "return the last value of groups" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:any_2, d:any_1, p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:any_2, d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:any_2, p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row in the partition or NULL if non existent" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:bat[:any_2], d:any_1, p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:bat[:any_2], d:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row in the partition or 'd' if non existent" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], l:bat[:any_2], p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next 'l' row in the partition or NULL if non existent" ] +[ "batsql", "lead", "pattern batsql.lead(b:bat[:any_1], p:any_3, o:any_4):bat[:any_1] ", "SQLlead;", "return the value in the next row in the partition or NULL if non existent" ] +[ "batsql", "max", "pattern batsql.max(b:bat[:any_1], s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLmax;", "return the maximum of groups" ] +[ "batsql", "min", "pattern batsql.min(b:bat[:any_1], s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLmin;", "return the minimum of groups" ] [ "batsql", "next_value", "pattern batsql.next_value(sname:bat[:str], sequence:str):bat[:lng] ", "mvc_bat_next_value;", "return the next value of the sequence" ] +[ "batsql", "nth_value", "pattern batsql.nth_value(b:bat[:any_1], n:any_2, s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLnth_value;", "return the nth value of each group" ] +[ "batsql", "nth_value", "pattern batsql.nth_value(b:bat[:any_1], n:bat[:any_2], s:bat[:lng], e:bat[:lng]):bat[:any_1] ", "SQLnth_value;", "return the nth value of each group" ] +[ "batsql", "ntile", "pattern batsql.ntile(b:bat[:any_1], n:any_2, p:any_3, o:any_4):bat[:any_2] ", "SQLntile;", "return the groups divided as equally as possible" ] +[ "batsql", "ntile", "pattern batsql.ntile(b:bat[:any_1], n:bat[:any_2], p:any_3, o:any_4):bat[:any_2] ", "SQLntile;", "return the groups divided as equally as possible" ] [ "batsql", "password", "pattern batsql.password(user:bat[:str]):bat[:str] ", "db_password_wrap;", "Return password hash of user" ] +[ "batsql", "percent_rank", "pattern batsql.percent_rank(b:bat[:any_1], p:any_2, o:any_3):bat[:dbl] ", "SQLpercent_rank;", "return the percentage into the total number of groups for each row" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:bte], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:dbl], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLprod;", "return the product of groups" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLprod;", "return the product of groups" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:flt] ", "SQLprod;", "return the product of groups" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:int], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:lng], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups" ] +[ "batsql", "prod", "pattern batsql.prod(b:bat[:sht], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLprod;", "return the product of groups" ] [ "batsql", "rank", "pattern batsql.rank(b:bat[:any_1], p:any_2, o:any_3):bat[:int] ", "SQLrank;", "return the ranked groups" ] [ "batsql", "round", "command batsql.round(v:bat[:bte], d:int, s:int, r:bte):bat[:bte] ", "bte_bat_round_wrap;", "round off the decimal v(d,s) to r digits behind the dot (if r < 0, before the dot)" ] [ "batsql", "round", "command batsql.round(v:bat[:dbl], r:bte):bat[:dbl] ", "dbl_bat_round_wrap;", "round off the floating point v to r digits behind the dot (if r < 0, before the dot)" ] @@ -8396,6 +8434,37 @@ Ready. [ "batsql", "round", "command batsql.round(v:bat[:lng], d:int, s:int, r:bte):bat[:lng] ", "lng_bat_round_wrap;", "round off the decimal v(d,s) to r digits behind the dot (if r < 0, before the dot)" ] [ "batsql", "round", "command batsql.round(v:bat[:sht], d:int, s:int, r:bte):bat[:sht] ", "sht_bat_round_wrap;", "round off the decimal v(d,s) to r digits behind the dot (if r < 0, before the dot)" ] [ "batsql", "row_number", "pattern batsql.row_number(b:bat[:any_1], p:any_2, o:any_3):bat[:int] ", "SQLrow_number;", "return the row_numer-ed groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:bte], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:dbl], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:dbl] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:flt], s:bat[:lng], e:bat[:lng]):bat[:flt] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:int], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:lng], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "sum", "pattern batsql.sum(b:bat[:sht], s:bat[:lng], e:bat[:lng]):bat[:lng] ", "SQLsum;", "return the sum of groups" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:bte]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:dbl]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:flt]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:int]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:lng]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:sht]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:bte):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:dbl):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:flt):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:int):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:lng):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(b:bat[:any_1], unit:int, bound:int, excl:int, limit:sht):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:bte]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:dbl]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:flt]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:int]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:lng]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bat[:sht]):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:bte):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:dbl):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:flt):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:int):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:lng):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] +[ "batsql", "window_bound", "pattern batsql.window_bound(p:bat[:bit], b:bat[:any_1], unit:int, bound:int, excl:int, limit:sht):bat[:lng] ", "SQLwindow_bound;", "computes window ranges for each row" ] [ "batstr", "endsWith", "command batstr.endsWith(s:bat[:str], suffix:bat[:str]):bat[:bit] ", "STRbatSuffix;", "Suffix check." ] [ "batstr", "endsWith", "command batstr.endsWith(s:bat[:str], suffix:str):bat[:bit] ", "STRbatSuffixcst;", "Suffix check." ] [ "batstr", "length", "command batstr.length(s:bat[:str]):bat[:int] ", "STRbatLength;", "Return the length of a string." ] @@ -10523,10 +10592,6 @@ Ready. [ "mbr", "#read", "command mbr.#read():void ", "mbrREAD;", "" ] [ "mbr", "#tostr", "command mbr.#tostr():void ", "mbrTOSTR;", "" ] [ "mbr", "#write", "command mbr.#write():void ", "mbrWRITE;", "" ] -[ "mcurl", "deleterequest", "command mcurl.deleterequest(s:str):str ", "CURLdeleteRequest;", "Perform a http delete request" ] -[ "mcurl", "getrequest", "command mcurl.getrequest(s:str):str ", "CURLgetRequest;", "Perform a http get request" ] -[ "mcurl", "postrequest", "command mcurl.postrequest(s:str):str ", "CURLpostRequest;", "Perform a http post request" ] -[ "mcurl", "putrequest", "command mcurl.putrequest(s:str):str ", "CURLputRequest;", "Perform a http put request" ] [ "mdb", "List", "pattern mdb.List(M:str, F:str):void ", "MDBlist3Detail;", "Dump the routine M.F on standard out." ] [ "mdb", "List", "pattern mdb.List():void ", "MDBlistDetail;", "Dump the current routine on standard out." ] [ "mdb", "dump", "pattern mdb.dump():void ", "MDBdump;", "Dump instruction, stacktrace, and stack" ] @@ -10919,6 +10984,12 @@ Ready. [ "sql", "assert", "pattern sql.assert(b:bit, msg:str):void ", "SQLassert;", "Generate an exception when b==true" ] [ "sql", "assert", "pattern sql.assert(b:int, msg:str):void ", "SQLassertInt;", "Generate an exception when b!=0" ] [ "sql", "assert", "pattern sql.assert(b:lng, msg:str):void ", "SQLassertLng;", "Generate an exception when b!=0" ] +[ "sql", "avg", "pattern sql.avg(b:bte, s:lng, e:lng):dbl ", "SQLavg;", "return the average of groups" ] +[ "sql", "avg", "pattern sql.avg(b:dbl, s:lng, e:lng):dbl ", "SQLavg;", "return the average of groups" ] +[ "sql", "avg", "pattern sql.avg(b:flt, s:lng, e:lng):dbl ", "SQLavg;", "return the average of groups" ] +[ "sql", "avg", "pattern sql.avg(b:int, s:lng, e:lng):dbl ", "SQLavg;", "return the average of groups" ] +[ "sql", "avg", "pattern sql.avg(b:lng, s:lng, e:lng):dbl ", "SQLavg;", "return the average of groups" ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
