Changeset: d5fea730a2e1 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d5fea730a2e1
Added Files:
monetdb5/mal/Tests/tst023.malC
monetdb5/mal/Tests/tst023.stable.err
monetdb5/mal/Tests/tst023.stable.out
monetdb5/optimizer/opt_emptybind.c
monetdb5/optimizer/opt_emptybind.h
monetdb5/optimizer/opt_jit.c
monetdb5/optimizer/opt_jit.h
sql/test/BugTracker-2016/Tests/like_in_non_sys_schema.Bug-4062.sql
sql/test/BugTracker-2016/Tests/like_in_non_sys_schema.Bug-4062.stable.err
sql/test/BugTracker-2016/Tests/like_in_non_sys_schema.Bug-4062.stable.out
sql/test/BugTracker-2016/Tests/simpletest.stable.err
sql/test/BugTracker-2016/Tests/simpletest.stable.out
Removed Files:
sql/test/pg_regress/Tests/oid.stable.err.Windows
Modified Files:
NT/installer64/MonetDB5-SQL-Installer.vdproj
NT/monetdb_config.h.in
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SQL-dump.SQL.py
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
clients/Tests/exports.stable.out
configure.ag
gdk/gdk.h
gdk/gdk_aggr.c
gdk/gdk_atoms.c
gdk/gdk_batop.c
gdk/gdk_bbp.c
gdk/gdk_calc.c
gdk/gdk_calc_compare.h
gdk/gdk_calc_private.h
gdk/gdk_firstn.c
gdk/gdk_group.c
gdk/gdk_hash.h
gdk/gdk_join.c
gdk/gdk_logger.c
gdk/gdk_posix.c
gdk/gdk_private.h
gdk/gdk_project.c
gdk/gdk_select.c
gdk/gdk_storage.c
gdk/gdk_system.c
gdk/gdk_system.h
gdk/gdk_system_private.h
gdk/gdk_utils.c
gdk/gdk_value.c
geom/BugTracker/Tests/copy_into_crash.SF-1975402.stable.err
geom/sql/40_geom.sql
java/ChangeLog
java/ChangeLog.Jun2016
java/src/main/java/nl/cwi/monetdb/client/JdbcClient.java
java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
java/src/main/java/nl/cwi/monetdb/jdbc/MonetResultSet.java
java/src/main/java/nl/cwi/monetdb/util/CmdLineOpts.java
java/src/main/java/nl/cwi/monetdb/util/OptionsException.java
java/src/main/java/nl/cwi/monetdb/util/SQLExporter.java
java/tests/BugDatabaseMetaData_Bug_3356.java
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/mal_optimizer_template/Tests/opt_sql_append.stable.out.single
monetdb5/extras/mal_optimizer_template/opt_sql_append.c
monetdb5/extras/rapi/Tests/rapi02.malC
monetdb5/extras/rapi/Tests/rapi02.stable.out
monetdb5/extras/rapi/rapi.c
monetdb5/mal/Tests/All
monetdb5/mal/Tests/tst901a.stable.out
monetdb5/mal/mal.c
monetdb5/mal/mal_builder.c
monetdb5/mal/mal_builder.h
monetdb5/mal/mal_dataflow.c
monetdb5/mal/mal_debugger.c
monetdb5/mal/mal_function.c
monetdb5/mal/mal_function.h
monetdb5/mal/mal_import.c
monetdb5/mal/mal_instruction.c
monetdb5/mal/mal_interpreter.c
monetdb5/mal/mal_interpreter.h
monetdb5/mal/mal_linker.c
monetdb5/mal/mal_listing.c
monetdb5/mal/mal_listing.h
monetdb5/mal/mal_module.c
monetdb5/mal/mal_namespace.c
monetdb5/mal/mal_parser.c
monetdb5/mal/mal_private.h
monetdb5/mal/mal_profiler.c
monetdb5/mal/mal_resolve.c
monetdb5/mal/mal_runtime.c
monetdb5/mal/mal_session.c
monetdb5/mal/mal_stack.h
monetdb5/modules/atoms/blob.c
monetdb5/modules/atoms/color.c
monetdb5/modules/atoms/identifier.c
monetdb5/modules/atoms/inet.c
monetdb5/modules/atoms/json.c
monetdb5/modules/atoms/mtime.c
monetdb5/modules/atoms/str.c
monetdb5/modules/atoms/streams.c
monetdb5/modules/kernel/aggr.c
monetdb5/modules/kernel/aggr.mal
monetdb5/modules/kernel/aggr.mal.sh
monetdb5/modules/kernel/algebra.c
monetdb5/modules/kernel/algebra.h
monetdb5/modules/kernel/algebra.mal
monetdb5/modules/kernel/bat5.c
monetdb5/modules/kernel/bat5.h
monetdb5/modules/kernel/bat5.mal
monetdb5/modules/kernel/microbenchmark.c
monetdb5/modules/kernel/microbenchmark.h
monetdb5/modules/kernel/status.c
monetdb5/modules/mal/00_calc_hge.mal
monetdb5/modules/mal/00_mkey_hge.mal
monetdb5/modules/mal/01_batcalc.mal
monetdb5/modules/mal/Tests/inspect05.stable.out
monetdb5/modules/mal/Tests/inspect05.stable.out.int128
monetdb5/modules/mal/Tests/remote03.stable.err
monetdb5/modules/mal/batExtensions.c
monetdb5/modules/mal/batcalc.c
monetdb5/modules/mal/calc.c
monetdb5/modules/mal/groupby.c
monetdb5/modules/mal/inspect.c
monetdb5/modules/mal/iterator.c
monetdb5/modules/mal/mal_io.c
monetdb5/modules/mal/mal_mapi.c
monetdb5/modules/mal/manifold.c
monetdb5/modules/mal/mkey.c
monetdb5/modules/mal/mkey.h
monetdb5/modules/mal/mkey.mal
monetdb5/modules/mal/projectionpath.c
monetdb5/modules/mal/querylog.c
monetdb5/modules/mal/querylog.mal
monetdb5/modules/mal/sample.c
monetdb5/modules/mal/sample.mal
monetdb5/modules/mal/tablet.c
monetdb5/modules/mal/tokenizer.c
monetdb5/optimizer/Makefile.ag
monetdb5/optimizer/Tests/dataflow.stable.out
monetdb5/optimizer/Tests/dataflow3.malC
monetdb5/optimizer/Tests/dataflow3.stable.out
monetdb5/optimizer/Tests/manifold2.stable.out
monetdb5/optimizer/Tests/manifold2.stable.out.single
monetdb5/optimizer/opt_aliases.c
monetdb5/optimizer/opt_candidates.c
monetdb5/optimizer/opt_evaluate.c
monetdb5/optimizer/opt_mergetable.c
monetdb5/optimizer/opt_pipes.c
monetdb5/optimizer/opt_prelude.c
monetdb5/optimizer/opt_prelude.h
monetdb5/optimizer/opt_pushselect.c
monetdb5/optimizer/opt_querylog.c
monetdb5/optimizer/opt_remap.c
monetdb5/optimizer/opt_support.c
monetdb5/optimizer/opt_support.h
monetdb5/optimizer/opt_wrapper.c
monetdb5/optimizer/optimizer.mal
sql/backends/monet5/Makefile.ag
sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out
sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out
sql/backends/monet5/UDF/pyapi/Tests/pyapi_types_numeric.malC
sql/backends/monet5/UDF/pyapi/Tests/pyapi_types_string.malC
sql/backends/monet5/UDF/pyapi/pyapi.c
sql/backends/monet5/rel_bin.c
sql/backends/monet5/sql.c
sql/backends/monet5/sql.h
sql/backends/monet5/sql.mal
sql/backends/monet5/sql_cast.c
sql/backends/monet5/sql_cast.h
sql/backends/monet5/sql_cast_impl_down_from_int.h
sql/backends/monet5/sql_decimal.mal
sql/backends/monet5/sql_decimal.mal.sh
sql/backends/monet5/sql_decimal_hge.mal
sql/backends/monet5/sql_decimal_hge.mal.sh
sql/backends/monet5/sql_execute.c
sql/backends/monet5/sql_execute.h
sql/backends/monet5/sql_gencode.c
sql/backends/monet5/sql_optimizer.c
sql/backends/monet5/sql_optimizer.h
sql/backends/monet5/sql_round.c
sql/backends/monet5/sql_round_impl.h
sql/backends/monet5/sql_scenario.c
sql/backends/monet5/sql_scenario.h
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_upgrades.c
sql/backends/monet5/vaults/bam/Tests/mergetable.stable.out
sql/backends/monet5/vaults/lidar/lidar.c
sql/benchmarks/ssbm/Tests/01-explain.stable.out
sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/02-explain.stable.out
sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/03-explain.stable.out
sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/04-explain.stable.out
sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/05-explain.stable.out
sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/06-explain.stable.out
sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/11-explain.stable.out
sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/12-explain.stable.out
sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128
sql/benchmarks/ssbm/Tests/13-explain.stable.out
sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-explain.stable.out
sql/benchmarks/tpch/Tests/01-explain.stable.out.int128
sql/benchmarks/tpch/Tests/01-plan.stable.out
sql/benchmarks/tpch/Tests/02-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out
sql/benchmarks/tpch/Tests/03-explain.stable.out.int128
sql/benchmarks/tpch/Tests/03-plan.stable.out
sql/benchmarks/tpch/Tests/04-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out
sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/05-explain.stable.out.int128
sql/benchmarks/tpch/Tests/05-plan.stable.out
sql/benchmarks/tpch/Tests/06-explain.stable.out.int128
sql/benchmarks/tpch/Tests/06-plan.stable.out
sql/benchmarks/tpch/Tests/07-explain.stable.out.int128
sql/benchmarks/tpch/Tests/07-plan.stable.out
sql/benchmarks/tpch/Tests/08-explain.stable.out
sql/benchmarks/tpch/Tests/08-explain.stable.out.int128
sql/benchmarks/tpch/Tests/08-plan.stable.out
sql/benchmarks/tpch/Tests/09-explain.stable.out.int128
sql/benchmarks/tpch/Tests/09-plan.stable.out
sql/benchmarks/tpch/Tests/10-explain.stable.out
sql/benchmarks/tpch/Tests/10-explain.stable.out.int128
sql/benchmarks/tpch/Tests/10-plan.stable.out
sql/benchmarks/tpch/Tests/10-plan.stable.out.int128
sql/benchmarks/tpch/Tests/11-explain.stable.out.int128
sql/benchmarks/tpch/Tests/11-plan.stable.out
sql/benchmarks/tpch/Tests/12-explain.stable.out
sql/benchmarks/tpch/Tests/12-explain.stable.out.int128
sql/benchmarks/tpch/Tests/13-explain.stable.out
sql/benchmarks/tpch/Tests/14-explain.stable.out
sql/benchmarks/tpch/Tests/14-explain.stable.out.int128
sql/benchmarks/tpch/Tests/14-plan.stable.out
sql/benchmarks/tpch/Tests/15-explain.stable.out.int128
sql/benchmarks/tpch/Tests/16-explain.stable.out
sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/17-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-explain.stable.out
sql/benchmarks/tpch/Tests/18-explain.stable.out.int128
sql/benchmarks/tpch/Tests/18-plan.stable.out.int128
sql/benchmarks/tpch/Tests/19-explain.stable.out.int128
sql/benchmarks/tpch/Tests/19-plan.stable.out
sql/benchmarks/tpch/Tests/20-explain.stable.out
sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit
sql/benchmarks/tpch/Tests/20-explain.stable.out.int128
sql/benchmarks/tpch/Tests/21-explain.stable.out
sql/benchmarks/tpch/Tests/21-plan.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out
sql/benchmarks/tpch/Tests/22-explain.stable.out.int128
sql/common/sql_types.c
sql/jdbc/tests/Tests/BugDatabaseMetaData_Bug_3356.stable.out
sql/jdbc/tests/Tests/Test_Dobjects.stable.out
sql/jdbc/tests/Tests/Test_JdbcClient.stable.out
sql/scripts/12_url.sql
sql/scripts/14_inet.sql
sql/scripts/39_analytics.sql
sql/scripts/39_analytics_hge.sql
sql/scripts/40_json.sql
sql/scripts/40_json_hge.sql
sql/scripts/45_uuid.sql
sql/server/rel_exp.c
sql/server/rel_exp.h
sql/server/rel_optimizer.c
sql/server/rel_rel.c
sql/server/rel_select.c
sql/server/rel_updates.c
sql/server/sql_atom.c
sql/server/sql_mvc.h
sql/server/sql_parser.y
sql/server/sql_qc.c
sql/server/sql_qc.h
sql/server/sql_symbol.h
sql/storage/bat/bat_logger.c
sql/storage/bat/bat_storage.c
sql/storage/store.c
sql/test/ADT2006/Tests/bram.stable.out
sql/test/BugTracker-2009/Tests/All
sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.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/primekeyconstraint.SF-2783425.stable.err
sql/test/BugTracker-2009/Tests/segfault_when_quitting_debugger.SF-2538837.stable.out
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out
sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.err
sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out
sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128
sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out
sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out
sql/test/BugTracker-2013/Tests/between.Bug-3259.sql
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128.single
sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single
sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out
sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out
sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single
sql/test/BugTracker-2014/Tests/temporary.Bug-3430.stable.err
sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.stable.err
sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.stable.out
sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out
sql/test/BugTracker-2016/Tests/All
sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out
sql/test/BugTracker-2016/Tests/simpletest.sql
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/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_system_tables.SF-1550768.stable.err
sql/test/BugTracker/Tests/explain.SF-1739353.stable.out
sql/test/BugTracker/Tests/insert_date.SF-1838785.stable.err
sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out
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.out
sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit
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/dependency_loop.stable.out
sql/test/Dependencies/Tests/dependency_loop.stable.out.int128
sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out
sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out
sql/test/Tests/median_stdev.stable.out
sql/test/Tests/setoptimizer.stable.out
sql/test/Tests/setoptimizer.stable.out.Windows
sql/test/Tests/systemfunctions.stable.out
sql/test/Tests/systemfunctions.stable.out.int128
sql/test/Triggers/trigger_insert.sql
sql/test/bugs/Tests/alter_add_column-bug.stable.err
sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/check.stable.out
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/check.stable.out
sql/test/emptydb-upgrade/Tests/check.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/leaks/Tests/check0.stable.out
sql/test/leaks/Tests/check0.stable.out.int128
sql/test/leaks/Tests/check1.stable.out
sql/test/leaks/Tests/check1.stable.out.int128
sql/test/leaks/Tests/check2.stable.out
sql/test/leaks/Tests/check2.stable.out.int128
sql/test/leaks/Tests/check3.stable.out
sql/test/leaks/Tests/check3.stable.out.int128
sql/test/leaks/Tests/check4.stable.out
sql/test/leaks/Tests/check4.stable.out.int128
sql/test/leaks/Tests/check5.stable.out
sql/test/leaks/Tests/check5.stable.out.int128
sql/test/leaks/Tests/drop3.stable.out
sql/test/leaks/Tests/drop3.stable.out.int128
sql/test/leaks/Tests/select1.stable.out
sql/test/leaks/Tests/select1.stable.out.int128
sql/test/leaks/Tests/select2.stable.out
sql/test/leaks/Tests/select2.stable.out.int128
sql/test/leaks/Tests/temp1.stable.out
sql/test/leaks/Tests/temp1.stable.out.int128
sql/test/leaks/Tests/temp2.stable.out
sql/test/leaks/Tests/temp2.stable.out.int128
sql/test/leaks/Tests/temp3.stable.out
sql/test/leaks/Tests/temp3.stable.out.int128
sql/test/mapi/Tests/sql_int128.stable.out
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/pg_regress/Tests/boolean.stable.err
sql/test/pg_regress/Tests/char.stable.err
sql/test/pg_regress/Tests/comments.stable.err
sql/test/pg_regress/Tests/create_aggregate.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.out
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/interval.stable.out
sql/test/pg_regress/Tests/limit.stable.err
sql/test/pg_regress/Tests/numeric.stable.err
sql/test/pg_regress/Tests/numerology.stable.err
sql/test/pg_regress/Tests/oid.stable.err.int128
sql/test/pg_regress/Tests/random.stable.out
sql/test/pg_regress/Tests/strings_concat.stable.err
sql/test/pg_regress/Tests/timestamp.stable.err
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.stable.err
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/pg_regress/Tests/vacuum.stable.out
sql/test/pg_regress/Tests/varchar.stable.err
sql/test/pg_regress/Tests/without_oid.stable.err
sql/test/pg_regress/Tests/without_oid.stable.out
sql/test/remote/Tests/partition_elim.stable.out
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb/Tests/testdb-dump.stable.out
sql/test/testdb/Tests/testdb-dump.stable.out.Windows
sql/test/testdb/Tests/testdb-load.sql
testing/Mtest.py.in
tools/merovingian/utils/utils.c
Branch: mosaic
Log Message:
Merge with default
diffs (truncated from 27298 to 300 lines):
diff --git a/NT/monetdb_config.h.in b/NT/monetdb_config.h.in
--- a/NT/monetdb_config.h.in
+++ b/NT/monetdb_config.h.in
@@ -517,6 +517,9 @@
/* Define to 1 if you have the `strcasestr' function. */
/* #undef HAVE_STRCASESTR */
+/* Define to 1 if you have the `strcpy_s' function. */
+#define HAVE_STRCPY_S 1
+
/* Define to 1 if you have the `strftime' function. */
#if !defined(_MSC_VER) || _MSC_VER >= 1500
#define HAVE_STRFTIME 1
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
@@ -8140,7 +8140,6 @@ Ready.
[ "optimizer", "aliases", "pattern optimizer.aliases(mod:str,fcn:str):str
", "OPTwrapper;", "Alias removal optimizer" ]
[ "optimizer", "candidates", "pattern optimizer.candidates():str ",
"OPTwrapper;", "" ]
[ "optimizer", "candidates", "pattern
optimizer.candidates(mod:str,fcn:str):str ", "OPTwrapper;", "Mark candidate
list variables" ]
-[ "optimizer", "clrDebug", "pattern optimizer.clrDebug():void ",
"QOTclrdebugOptimizers;", "" ]
[ "optimizer", "coercions", "pattern optimizer.coercions():str ",
"OPTwrapper;", "" ]
[ "optimizer", "coercions", "pattern
optimizer.coercions(mod:str,fcn:str):str ", "OPTwrapper;", "Handle simple
type coercions" ]
[ "optimizer", "commonTerms", "pattern optimizer.commonTerms():str ",
"OPTwrapper;", "" ]
@@ -8157,6 +8156,8 @@ Ready.
[ "optimizer", "deadcode", "pattern
optimizer.deadcode(mod:str,fcn:str):str ", "OPTwrapper;", "Dead code
optimizer" ]
[ "optimizer", "derivePath", "pattern optimizer.derivePath():str ",
"OPTwrapper;", "" ]
[ "optimizer", "derivePath", "pattern
optimizer.derivePath(mod:str,fcn:str):str ", "OPTwrapper;", "Join path
constructor" ]
+[ "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;", "" ]
[ "optimizer", "evaluate", "pattern
optimizer.evaluate(mod:str,fcn:str):str ", "OPTwrapper;", "Evaluate
constant expressions once." ]
[ "optimizer", "factorize", "pattern optimizer.factorize():str ",
"OPTwrapper;", "" ]
@@ -8167,6 +8168,8 @@ Ready.
[ "optimizer", "generator", "pattern
optimizer.generator(mod:str,fcn:str):str ", "OPTwrapper;", "Sequence
generator optimizer" ]
[ "optimizer", "inline", "pattern optimizer.inline():str ",
"OPTwrapper;", "" ]
[ "optimizer", "inline", "pattern optimizer.inline(mod:str,fcn:str):str
", "OPTwrapper;", "Expand inline functions" ]
+[ "optimizer", "jit", "pattern optimizer.jit():str ", "OPTwrapper;", ""
]
+[ "optimizer", "jit", "pattern optimizer.jit(mod:str,fcn:str):str ",
"OPTwrapper;", "Propagate candidate lists in just-in-time optimization"
]
[ "optimizer", "joinselect", "pattern optimizer.joinselect():str ",
"OPTwrapper;", "" ]
[ "optimizer", "joinselect", "pattern
optimizer.joinselect(mod:str,fcn:str):str ", "OPTwrapper;", "Replace select
with join select" ]
[ "optimizer", "json", "pattern optimizer.json():str ", "OPTwrapper;",
"" ]
@@ -8211,7 +8214,6 @@ Ready.
[ "optimizer", "reorder", "pattern optimizer.reorder(mod:str,fcn:str):str
", "OPTwrapper;", "Reorder by dataflow dependencies" ]
[ "optimizer", "selcrack", "pattern optimizer.selcrack():str ",
"OPTwrapper;", "" ]
[ "optimizer", "selcrack", "pattern
optimizer.selcrack(mod:str,fcn:str):str ", "OPTwrapper;", "Selection
cracking" ]
-[ "optimizer", "setDebug", "pattern optimizer.setDebug():void ",
"QOTdebugOptimizers;", "" ]
[ "optimizer", "showFlowGraph", "pattern
optimizer.showFlowGraph(M:str,F:str,s:str):void ", "QOTshowFlowGraph;",
"Dump the data flow of the function \n\tM.F in a format recognizable by the
\n\tcommand 'dot' on the file s" ]
[ "optimizer", "showPlan", "pattern optimizer.showPlan():void ",
"QOTshowPlan;", "Illustrate the plan derived so far" ]
[ "optimizer", "showPlan", "pattern
optimizer.showPlan(M:str,F:str,s:str):void ", "QOTshowPlan;", "" ]
@@ -8383,6 +8385,14 @@ Ready.
[ "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" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int)
(uid:bat[:oid],uval:bat[:any_1]) ", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int):bat[:any_1]
", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int)
(uid:bat[:oid],uval:bat[:any_1]) ", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int):bat[:any_1]
", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(mvc:int,schema:str,table:str,index:str,access:int)
(uid:bat[:oid],uval:bat[:any_1]) ", "mvc_bind_idxbat_wrap;", ""
]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(mvc:int,schema:str,table:str,index:str,access:int):bat[:any_1]
", "mvc_bind_idxbat_wrap;", "" ]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(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;", ""
]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(mvc:int,schema:str,table:str,index:str,access:int,part_nr:int,nr_parts:int):bat[:any_1]
", "mvc_bind_idxbat_wrap;", "" ]
[ "sql", "epilogue", "command sql.epilogue():void ", "SQLepilogue;",
"" ]
[ "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)" ]
@@ -8632,7 +8642,7 @@ Ready.
[ "url", "url", "command url.url(s:str):url ", "URLnew;", "Create
an URL from a string literal" ]
[ "url", "url", "command url.url(s:url):url ", "URLnoop;", "Create
an URL from a string literal" ]
[ "user", "main", "function user.main():void;", "", "" ]
-[ "user", "s1_1", "function user.s1_1():void;", "", "" ]
+[ "user", "s2_1", "function user.s2_1():void;", "", "" ]
[ "user", "sql.init", "function user.sql.init():void;", "",
"" ]
[ "uuid", "#cmp", "command uuid.#cmp():void ", "UUIDcompare;", ""
]
[ "uuid", "#fromstr", "command uuid.#fromstr():void ",
"UUIDfromString;", "" ]
@@ -8694,6 +8704,28 @@ Ready.
[ "zrule", "define", "command
zrule.define(m:int,d:int,w:int,h:int,min:int):zrule ", "MTIMEruleDef0;",
"Introduce a synomym timezone rule." ]
[ "zrule", "define", "command
zrule.define(m:int,d:str,w:int,h:int,min:int):zrule ", "MTIMEruleDef1;",
"Introduce a synomym timezone rule." ]
[ "zrule", "define", "command
zrule.define(m:int,d:str,w:int,min:int):zrule ", "MTIMEruleDef2;",
"Introduce a synomym timezone rule." ]
+pattern optimizer.emptycolumn(mod:str,fcn:str):str
+address OPTwrapper;
+comment Evaluate empty set expressions.
+
+pattern optimizer.emptycolumn():str
+address OPTwrapper;
+pattern
sql.emptycolumn(mvc:int,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int)
(uid:bat[:oid],uval:bat[:any_1])
+address mvc_bind_wrap;
+pattern
sql.emptycolumn(mvc:int,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int):bat[:any_1]
+address mvc_bind_wrap;
+pattern sql.emptycolumn(mvc:int,schema:str,table:str,column:str,access:int)
(uid:bat[:oid],uval:bat[:any_1])
+address mvc_bind_wrap;
+pattern
sql.emptycolumn(mvc:int,schema:str,table:str,column:str,access:int):bat[:any_1]
+address mvc_bind_wrap;
+pattern
sql.emptycolumnidx(mvc:int,schema:str,table:str,index:str,access:int,part_nr:int,nr_parts:int)
(uid:bat[:oid],uval:bat[:any_1])
+address mvc_bind_idxbat_wrap;
+pattern
sql.emptycolumnidx(mvc:int,schema:str,table:str,index:str,access:int,part_nr:int,nr_parts:int):bat[:any_1]
+address mvc_bind_idxbat_wrap;
+pattern sql.emptycolumnidx(mvc:int,schema:str,table:str,index:str,access:int)
(uid:bat[:oid],uval:bat[:any_1])
+address mvc_bind_idxbat_wrap;
+pattern
sql.emptycolumnidx(mvc:int,schema:str,table:str,index:str,access:int):bat[:any_1]
+address mvc_bind_idxbat_wrap;
# 14:39:23 >
# 14:39:23 > "Done."
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -10507,7 +10507,6 @@ Ready.
[ "optimizer", "aliases", "pattern optimizer.aliases(mod:str,fcn:str):str
", "OPTwrapper;", "Alias removal optimizer" ]
[ "optimizer", "candidates", "pattern optimizer.candidates():str ",
"OPTwrapper;", "" ]
[ "optimizer", "candidates", "pattern
optimizer.candidates(mod:str,fcn:str):str ", "OPTwrapper;", "Mark candidate
list variables" ]
-[ "optimizer", "clrDebug", "pattern optimizer.clrDebug():void ",
"QOTclrdebugOptimizers;", "" ]
[ "optimizer", "coercions", "pattern optimizer.coercions():str ",
"OPTwrapper;", "" ]
[ "optimizer", "coercions", "pattern
optimizer.coercions(mod:str,fcn:str):str ", "OPTwrapper;", "Handle simple
type coercions" ]
[ "optimizer", "commonTerms", "pattern optimizer.commonTerms():str ",
"OPTwrapper;", "" ]
@@ -10524,6 +10523,8 @@ Ready.
[ "optimizer", "deadcode", "pattern
optimizer.deadcode(mod:str,fcn:str):str ", "OPTwrapper;", "Dead code
optimizer" ]
[ "optimizer", "derivePath", "pattern optimizer.derivePath():str ",
"OPTwrapper;", "" ]
[ "optimizer", "derivePath", "pattern
optimizer.derivePath(mod:str,fcn:str):str ", "OPTwrapper;", "Join path
constructor" ]
+[ "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;", "" ]
[ "optimizer", "evaluate", "pattern
optimizer.evaluate(mod:str,fcn:str):str ", "OPTwrapper;", "Evaluate
constant expressions once." ]
[ "optimizer", "factorize", "pattern optimizer.factorize():str ",
"OPTwrapper;", "" ]
@@ -10534,6 +10535,8 @@ Ready.
[ "optimizer", "generator", "pattern
optimizer.generator(mod:str,fcn:str):str ", "OPTwrapper;", "Sequence
generator optimizer" ]
[ "optimizer", "inline", "pattern optimizer.inline():str ",
"OPTwrapper;", "" ]
[ "optimizer", "inline", "pattern optimizer.inline(mod:str,fcn:str):str
", "OPTwrapper;", "Expand inline functions" ]
+[ "optimizer", "jit", "pattern optimizer.jit():str ", "OPTwrapper;", ""
]
+[ "optimizer", "jit", "pattern optimizer.jit(mod:str,fcn:str):str ",
"OPTwrapper;", "Propagate candidate lists in just-in-time optimization"
]
[ "optimizer", "joinselect", "pattern optimizer.joinselect():str ",
"OPTwrapper;", "" ]
[ "optimizer", "joinselect", "pattern
optimizer.joinselect(mod:str,fcn:str):str ", "OPTwrapper;", "Replace select
with join select" ]
[ "optimizer", "json", "pattern optimizer.json():str ", "OPTwrapper;",
"" ]
@@ -10578,7 +10581,6 @@ Ready.
[ "optimizer", "reorder", "pattern optimizer.reorder(mod:str,fcn:str):str
", "OPTwrapper;", "Reorder by dataflow dependencies" ]
[ "optimizer", "selcrack", "pattern optimizer.selcrack():str ",
"OPTwrapper;", "" ]
[ "optimizer", "selcrack", "pattern
optimizer.selcrack(mod:str,fcn:str):str ", "OPTwrapper;", "Selection
cracking" ]
-[ "optimizer", "setDebug", "pattern optimizer.setDebug():void ",
"QOTdebugOptimizers;", "" ]
[ "optimizer", "showFlowGraph", "pattern
optimizer.showFlowGraph(M:str,F:str,s:str):void ", "QOTshowFlowGraph;",
"Dump the data flow of the function \n\tM.F in a format recognizable by the
\n\tcommand 'dot' on the file s" ]
[ "optimizer", "showPlan", "pattern optimizer.showPlan():void ",
"QOTshowPlan;", "Illustrate the plan derived so far" ]
[ "optimizer", "showPlan", "pattern
optimizer.showPlan(M:str,F:str,s:str):void ", "QOTshowPlan;", "" ]
@@ -10751,6 +10753,14 @@ Ready.
[ "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" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int)
(uid:bat[:oid],uval:bat[:any_1]) ", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int):bat[:any_1]
", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int)
(uid:bat[:oid],uval:bat[:any_1]) ", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybind", "pattern
sql.emptybind(mvc:int,schema:str,table:str,column:str,access:int,part_nr:int,nr_parts:int):bat[:any_1]
", "mvc_bind_wrap;", "" ]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(mvc:int,schema:str,table:str,index:str,access:int)
(uid:bat[:oid],uval:bat[:any_1]) ", "mvc_bind_idxbat_wrap;", ""
]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(mvc:int,schema:str,table:str,index:str,access:int):bat[:any_1]
", "mvc_bind_idxbat_wrap;", "" ]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(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;", ""
]
+[ "sql", "emptybindidx", "pattern
sql.emptybindidx(mvc:int,schema:str,table:str,index:str,access:int,part_nr:int,nr_parts:int):bat[:any_1]
", "mvc_bind_idxbat_wrap;", "" ]
[ "sql", "epilogue", "command sql.epilogue():void ", "SQLepilogue;",
"" ]
[ "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)" ]
@@ -11002,7 +11012,7 @@ Ready.
[ "url", "url", "command url.url(s:str):url ", "URLnew;", "Create
an URL from a string literal" ]
[ "url", "url", "command url.url(s:url):url ", "URLnoop;", "Create
an URL from a string literal" ]
[ "user", "main", "function user.main():void;", "", "" ]
-[ "user", "s1_1", "function user.s1_1():void;", "", "" ]
+[ "user", "s2_1", "function user.s2_1():void;", "", "" ]
[ "user", "sql.init", "function user.sql.init():void;", "",
"" ]
[ "uuid", "#cmp", "command uuid.#cmp():void ", "UUIDcompare;", ""
]
[ "uuid", "#fromstr", "command uuid.#fromstr():void ",
"UUIDfromString;", "" ]
diff --git a/clients/Tests/SQL-dump.SQL.py b/clients/Tests/SQL-dump.SQL.py
--- a/clients/Tests/SQL-dump.SQL.py
+++ b/clients/Tests/SQL-dump.SQL.py
@@ -61,7 +61,7 @@ sys.stderr.write(err)
# add queries to dump the system tables, but avoid dumping IDs since
# they are too volatile, and if it makes sense, dump an identifier
# from a referenced table
-out = '''
+out = r'''
-- helper function
create function pcre_replace(origin string, pat string, repl string, flags
string) returns string external name pcre.replace;
-- schemas
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -1190,15 +1190,11 @@ create function pcre_replace(origin stri
-- schemas
select name, authorization, owner, system from sys.schemas order by name;
-- _tables
-select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*
-', '', ''), '[
-]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query, t.type,
t.system, t.commit_action, t.access from sys._tables t left outer join
sys.schemas s on t.schema_id = s.id order by s.name, t.name;
+select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
t.type, t.system, t.commit_action, t.access from sys._tables t left outer join
sys.schemas s on t.schema_id = s.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
-- functions
-select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*
-', '', ''), '[
-]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query, f.mod,
f.language, f.type, f.side_effect, f.varres, f.vararg from sys.functions f left
outer join sys.schemas s on f.schema_id = s.id order by s.name, f.name, query;
+select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, f.language, f.type, f.side_effect, f.varres, f.vararg from sys.functions
f left outer join sys.schemas s on f.schema_id = s.id order by s.name, f.name,
query;
-- args
with
arg1 (id, id1, name1, type1, type_digits1, type_scale1, inout1) as (select
f.id, a1.id, a1.name, a1.type, a1.type_digits, a1.type_scale, a1.inout from
sys.functions f left outer join args a1 on a1.func_id = f.id and a1.number = 1),
@@ -5231,7 +5227,7 @@ drop function pcre_replace(string, strin
% sys.t, sys.a, .p, .g, .p # table_name
% name, name, privileges, name, grantable # name
% varchar, varchar, int, varchar, int # type
-% 15, 6, 1, 7, 1 # length
+% 16, 6, 1, 7, 1 # length
[ "_columns", "public", 1, NULL, 0 ]
[ "_tables", "public", 1, NULL, 0 ]
[ "args", "public", 1, NULL, 0 ]
@@ -5240,12 +5236,14 @@ drop function pcre_replace(string, strin
[ "connections", "public", 1, NULL, 0 ]
[ "dependencies", "public", 1, NULL, 0 ]
[ "functions", "public", 1, NULL, 0 ]
+[ "geometry_columns", "public", 1, "monetdb", 0 ]
[ "idxs", "public", 1, NULL, 0 ]
[ "keys", "public", 1, NULL, 0 ]
[ "objects", "public", 1, NULL, 0 ]
[ "privileges", "public", 1, NULL, 0 ]
[ "schemas", "public", 1, NULL, 0 ]
[ "sequences", "public", 1, NULL, 0 ]
+[ "spatial_ref_sys", "public", 1, "monetdb", 0 ]
[ "systemfunctions", "public", 1, "monetdb", 0 ]
[ "tables", "public", 1, NULL, 0 ]
[ "triggers", "public", 1, NULL, 0 ]
@@ -5260,8 +5258,17 @@ drop function pcre_replace(string, strin
% sys.f, sys.a, .p, .g, .p # table_name
% name, name, privileges, name, grantable # name
% varchar, varchar, int, varchar, int # type
-% 16, 6, 2, 7, 1 # length
+% 20, 6, 2, 7, 1 # length
+[ "abbrev", "public", 16, "monetdb", 0 ]
[ "alpha", "public", 16, "monetdb", 0 ]
+[ "broadcast", "public", 16, "monetdb", 0 ]
+[ "contains", "public", 16, "monetdb", 0 ]
+[ "corr", "public", 16, "monetdb", 0 ]
+[ "corr", "public", 16, "monetdb", 0 ]
+[ "corr", "public", 16, "monetdb", 0 ]
+[ "corr", "public", 16, "monetdb", 0 ]
+[ "corr", "public", 16, "monetdb", 0 ]
+[ "corr", "public", 16, "monetdb", 0 ]
[ "date_to_str", "public", 16, "monetdb", 0 ]
[ "degrees", "public", 16, "monetdb", 0 ]
[ "env", "public", 16, NULL, 0 ]
@@ -5269,23 +5276,251 @@ drop function pcre_replace(string, strin
[ "epoch", "public", 16, "monetdb", 0 ]
[ "epoch", "public", 16, "monetdb", 0 ]
[ "epoch", "public", 16, "monetdb", 0 ]
+[ "filter", "public", 16, "monetdb", 0 ]
+[ "filter", "public", 16, "monetdb", 0 ]
+[ "filter", "public", 16, "monetdb", 0 ]
+[ "filter", "public", 16, "monetdb", 0 ]
+[ "geometrytype", "public", 16, "monetdb", 0 ]
+[ "get_type", "public", 16, "monetdb", 0 ]
+[ "getanchor", "public", 16, "monetdb", 0 ]
+[ "getbasename", "public", 16, "monetdb", 0 ]
+[ "getcontent", "public", 16, "monetdb", 0 ]
+[ "getcontext", "public", 16, "monetdb", 0 ]
+[ "getdomain", "public", 16, "monetdb", 0 ]
+[ "getextension", "public", 16, "monetdb", 0 ]
+[ "getfile", "public", 16, "monetdb", 0 ]
+[ "gethost", "public", 16, "monetdb", 0 ]
+[ "getport", "public", 16, "monetdb", 0 ]
+[ "getproj4", "public", 16, "monetdb", 0 ]
+[ "getprotocol", "public", 16, "monetdb", 0 ]
+[ "getquery", "public", 16, "monetdb", 0 ]
+[ "getroboturl", "public", 16, "monetdb", 0 ]
+[ "getuser", "public", 16, "monetdb", 0 ]
+[ "has_m", "public", 16, "monetdb", 0 ]
+[ "has_z", "public", 16, "monetdb", 0 ]
+[ "host", "public", 16, "monetdb", 0 ]
+[ "hostmask", "public", 16, "monetdb", 0 ]
[ "ilike", "public", 16, "monetdb", 0 ]
[ "ilike", "public", 16, "monetdb", 0 ]
+[ "integer", "public", 16, "monetdb", 0 ]
+[ "internaltransform", "public", 16, "monetdb", 0 ]
+[ "isarray", "public", 16, "monetdb", 0 ]
+[ "isarray", "public", 16, "monetdb", 0 ]
+[ "isaurl", "public", 16, "monetdb", 0 ]
+[ "isauuid", "public", 16, "monetdb", 0 ]
+[ "isobject", "public", 16, "monetdb", 0 ]
+[ "isobject", "public", 16, "monetdb", 0 ]
+[ "isvalid", "public", 16, "monetdb", 0 ]
+[ "isvalid", "public", 16, "monetdb", 0 ]
+[ "keyarray", "public", 16, "monetdb", 0 ]
+[ "left_shift", "public", 16, "monetdb", 0 ]
+[ "left_shift_assign", "public", 16, "monetdb", 0 ]
+[ "length", "public", 16, "monetdb", 0 ]
[ "like", "public", 16, "monetdb", 0 ]
[ "like", "public", 16, "monetdb", 0 ]
+[ "masklen", "public", 16, "monetdb", 0 ]
+[ "mbr", "public", 16, "monetdb", 0 ]
[ "md5", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
+[ "median", "public", 16, "monetdb", 0 ]
[ "ms_round", "public", 16, "monetdb", 0 ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
