Changeset: ec20c6a000a1 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ec20c6a000a1 Added Files: 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 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_bbp.c gdk/gdk_calc.c gdk/gdk_calc_compare.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/mal/Tests/tst901a.stable.out 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_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/groupby.c monetdb5/modules/mal/inspect.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/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_statement.h sql/backends/monet5/sql_upgrades.c sql/backends/monet5/vaults/bam/Tests/mergetable.stable.out sql/backends/monet5/vaults/bam/Tests/query2.5.stable.out sql/backends/monet5/vaults/bam/Tests/query2.5.stable.out.int128 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/02-plan.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 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_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-2013/Tests/correlated_select.Bug-3250.stable.out 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/ambiguous.Bug-3803.stable.out.int128 sql/test/BugTracker-2015/Tests/apply_merge_distinct.Bug-3760.stable.out 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/missed-error.Bug-3842.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/select1.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 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 tools/merovingian/utils/utils.c Branch: iot Log Message:
Merged with default diffs (truncated from 24332 to 300 lines): 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 @@ -1197,15 +1197,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), @@ -5287,7 +5283,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 ] @@ -5296,12 +5292,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 ] @@ -5316,8 +5314,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 ] @@ -5325,23 +5332,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 ] [ "ms_str", "public", 16, "monetdb", 0 ] [ "ms_stuff", "public", 16, "monetdb", 0 ] [ "ms_trunc", "public", 16, "monetdb", 0 ] +[ "netmask", "public", 16, "monetdb", 0 ] +[ "network", "public", 16, "monetdb", 0 ] +[ "newurl", "public", 16, "monetdb", 0 ] +[ "newurl", "public", 16, "monetdb", 0 ] +[ "number", "public", 16, "monetdb", 0 ] +[ "output", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] +[ "quantile", "public", 16, "monetdb", 0 ] [ "radians", "public", 16, "monetdb", 0 ] [ "rejects", "public", 16, "monetdb", 0 ] +[ "right_shift", "public", 16, "monetdb", 0 ] +[ "right_shift_assign", "public", 16, "monetdb", 0 ] +[ "setmasklen", "public", 16, "monetdb", 0 ] +[ "st_area", "public", 16, "monetdb", 0 ] +[ "st_asbinary", "public", 16, "monetdb", 0 ] +[ "st_asewkt", "public", 16, "monetdb", 0 ] +[ "st_astext", "public", 16, "monetdb", 0 ] +[ "st_bdmpolyfromtext", "public", 16, "monetdb", 0 ] +[ "st_bdpolyfromtext", "public", 16, "monetdb", 0 ] +[ "st_boundary", "public", 16, "monetdb", 0 ] +[ "st_buffer", "public", 16, "monetdb", 0 ] +[ "st_centroid", "public", 16, "monetdb", 0 ] +[ "st_collect", "public", 16, "monetdb", 0 ] +[ "st_contains", "public", 16, "monetdb", 0 ] +[ "st_contains", "public", 16, "monetdb", 0 ] +[ "st_convexhull", "public", 16, "monetdb", 0 ] +[ "st_coorddim", "public", 16, "monetdb", 0 ] +[ "st_coveredby", "public", 16, "monetdb", 0 ] +[ "st_covers", "public", 16, "monetdb", 0 ] +[ "st_crosses", "public", 16, "monetdb", 0 ] +[ "st_delaunaytriangles", "public", 16, "monetdb", 0 ] +[ "st_difference", "public", 16, "monetdb", 0 ] +[ "st_dimension", "public", 16, "monetdb", 0 ] +[ "st_disjoint", "public", 16, "monetdb", 0 ] +[ "st_distance", "public", 16, "monetdb", 0 ] +[ "st_distance", "public", 16, "monetdb", 0 ] +[ "st_dump", "public", 16, "monetdb", 0 ] +[ "st_dumppoints", "public", 16, "monetdb", 0 ] +[ "st_dwithin", "public", 16, "monetdb", 0 ] +[ "st_endpoint", "public", 16, "monetdb", 0 ] +[ "st_envelope", "public", 16, "monetdb", 0 ] +[ "st_equals", "public", 16, "monetdb", 0 ] +[ "st_equals", "public", 16, "monetdb", 0 ] +[ "st_exteriorring", "public", 16, "monetdb", 0 ] +[ "st_force2d", "public", 16, "monetdb", 0 ] +[ "st_force3d", "public", 16, "monetdb", 0 ] +[ "st_geomcollfromtext", "public", 16, "monetdb", 0 ] +[ "st_geomcollfromtext", "public", 16, "monetdb", 0 ] +[ "st_geometryfromtext", "public", 16, "monetdb", 0 ] +[ "st_geometryfromtext", "public", 16, "monetdb", 0 ] +[ "st_geometryn", "public", 16, "monetdb", 0 ] +[ "st_geometrytype", "public", 16, "monetdb", 0 ] +[ "st_geomfromtext", "public", 16, "monetdb", 0 ] +[ "st_geomfromtext", "public", 16, "monetdb", 0 ] +[ "st_interiorringn", "public", 16, "monetdb", 0 ] +[ "st_interiorrings", "public", 16, "monetdb", 0 ] +[ "st_intersection", "public", 16, "monetdb", 0 ] +[ "st_intersects", "public", 16, "monetdb", 0 ] +[ "st_isclosed", "public", 16, "monetdb", 0 ] +[ "st_isempty", "public", 16, "monetdb", 0 ] +[ "st_isring", "public", 16, "monetdb", 0 ] +[ "st_issimple", "public", 16, "monetdb", 0 ] +[ "st_isvalid", "public", 16, "monetdb", 0 ] +[ "st_isvalidreason", "public", 16, "monetdb", 0 ] +[ "st_length", "public", 16, "monetdb", 0 ] +[ "st_length2d", "public", 16, "monetdb", 0 ] +[ "st_linefromtext", "public", 16, "monetdb", 0 ] +[ "st_linefromtext", "public", 16, "monetdb", 0 ] +[ "st_makebox2d", "public", 16, "monetdb", 0 ] +[ "st_makeenvelope", "public", 16, "monetdb", 0 ] +[ "st_makeenvelope", "public", 16, "monetdb", 0 ] +[ "st_makeline", "public", 16, "monetdb", 0 ] +[ "st_makepoint", "public", 16, "monetdb", 0 ] +[ "st_makepoint", "public", 16, "monetdb", 0 ] +[ "st_makepoint", "public", 16, "monetdb", 0 ] +[ "st_makepointm", "public", 16, "monetdb", 0 ] +[ "st_makepolygon", "public", 16, "monetdb", 0 ] +[ "st_mlinefromtext", "public", 16, "monetdb", 0 ] +[ "st_mlinefromtext", "public", 16, "monetdb", 0 ] +[ "st_mpointfromtext", "public", 16, "monetdb", 0 ] +[ "st_mpointfromtext", "public", 16, "monetdb", 0 ] +[ "st_mpolyfromtext", "public", 16, "monetdb", 0 ] +[ "st_mpolyfromtext", "public", 16, "monetdb", 0 ] +[ "st_npoints", "public", 16, "monetdb", 0 ] +[ "st_nrings", "public", 16, "monetdb", 0 ] +[ "st_numgeometries", "public", 16, "monetdb", 0 ] +[ "st_numinteriorring", "public", 16, "monetdb", 0 ] +[ "st_numinteriorrings", "public", 16, "monetdb", 0 ] +[ "st_numpatches", "public", 16, "monetdb", 0 ] +[ "st_numpoints", "public", 16, "monetdb", 0 ] +[ "st_overlaps", "public", 16, "monetdb", 0 ] +[ "st_overlaps", "public", 16, "monetdb", 0 ] +[ "st_patchn", "public", 16, "monetdb", 0 ] +[ "st_point", "public", 16, "monetdb", 0 ] +[ "st_pointfromtext", "public", 16, "monetdb", 0 ] +[ "st_pointfromtext", "public", 16, "monetdb", 0 ] +[ "st_pointn", "public", 16, "monetdb", 0 ] +[ "st_pointonsurface", "public", 16, "monetdb", 0 ] +[ "st_polygon", "public", 16, "monetdb", 0 ] +[ "st_polygonfromtext", "public", 16, "monetdb", 0 ] +[ "st_polygonfromtext", "public", 16, "monetdb", 0 ] +[ "st_relate", "public", 16, "monetdb", 0 ] +[ "st_segmentize", "public", 16, "monetdb", 0 ] +[ "st_setexteriorring", "public", 16, "monetdb", 0 ] +[ "st_setsrid", "public", 16, "monetdb", 0 ] +[ "st_srid", "public", 16, "monetdb", 0 ] +[ "st_startpoint", "public", 16, "monetdb", 0 ] +[ "st_symdifference", "public", 16, "monetdb", 0 ] +[ "st_touches", "public", 16, "monetdb", 0 ] +[ "st_transform", "public", 16, "monetdb", 0 ] +[ "st_translate", "public", 16, "monetdb", 0 ] +[ "st_translate", "public", 16, "monetdb", 0 ] +[ "st_union", "public", 16, "monetdb", 0 ] +[ "st_within", "public", 16, "monetdb", 0 ] +[ "st_wkbtosql", "public", 16, "monetdb", 0 ] +[ "st_wkttosql", "public", 16, "monetdb", 0 ] +[ "st_x", "public", 16, "monetdb", 0 ] +[ "st_xmax", "public", 16, "monetdb", 0 ] +[ "st_xmax", "public", 16, "monetdb", 0 ] +[ "st_xmin", "public", 16, "monetdb", 0 ] +[ "st_xmin", "public", 16, "monetdb", 0 ] +[ "st_y", "public", 16, "monetdb", 0 ] +[ "st_ymax", "public", 16, "monetdb", 0 ] +[ "st_ymax", "public", 16, "monetdb", 0 ] +[ "st_ymin", "public", 16, "monetdb", 0 ] +[ "st_ymin", "public", 16, "monetdb", 0 ] +[ "st_z", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_pop", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] +[ "stddev_samp", "public", 16, "monetdb", 0 ] [ "str_to_date", "public", 16, "monetdb", 0 ] [ "str_to_time", "public", 16, "monetdb", 0 ] [ "str_to_timestamp", "public", 16, "monetdb", 0 ] +[ "text", "public", 16, "monetdb", 0 ] +[ "text", "public", 16, "monetdb", 0 ] +[ "text", "public", 16, "monetdb", 0 ] +[ "text", "public", 16, "monetdb", 0 ] +[ "text", "public", 16, "monetdb", 0 ] _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list