Changeset: 1fe91aa316da for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1fe91aa316da Added Files: gdk/gdk_project.c java/tests/BugDecimalRound_Bug_3561.java monetdb5/modules/mal/projectionpath.c monetdb5/modules/mal/projectionpath.h monetdb5/optimizer/Tests/projectionchain.malC monetdb5/optimizer/Tests/projectionchain.stable.err monetdb5/optimizer/Tests/projectionchain.stable.out monetdb5/optimizer/opt_projectionpath.c monetdb5/optimizer/opt_projectionpath.h monetdb5/optimizer/opt_volcano.c monetdb5/optimizer/opt_volcano.h sql/jdbc/tests/Tests/BugDecimalRound_Bug_3561.SQL.bat sql/jdbc/tests/Tests/BugDecimalRound_Bug_3561.SQL.sh sql/jdbc/tests/Tests/BugDecimalRound_Bug_3561.stable.err sql/jdbc/tests/Tests/BugDecimalRound_Bug_3561.stable.out sql/test/BugTracker-2016/Tests/All sql/test/BugTracker-2016/Tests/LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908.sql sql/test/BugTracker-2016/Tests/LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908.stable.err sql/test/BugTracker-2016/Tests/LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908.stable.out sql/test/BugTracker-2016/Tests/incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909.sql sql/test/BugTracker-2016/Tests/incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909.stable.err sql/test/BugTracker-2016/Tests/incorrect_column_name_in_OR_condition_of_LEFT-JOIN_crashes_mserver.Bug-3909.stable.out sql/test/pg_regress/Tests/oid.stable.err.oid32.int128 sql/test/rdf/Tests/q8_v_small.reqtests sql/test/rdf/Tests/q8_v_small.sql sql/test/rdf/Tests/q8_v_small.stable.err sql/test/rdf/Tests/q8_v_small.stable.out tools/merovingian/daemon/monetdbd.service.in Removed Files: monetdb5/mal/Tests/tst104.malC monetdb5/mal/Tests/tst104.stable.err monetdb5/mal/Tests/tst104.stable.out monetdb5/mal/Tests/tst105.malC monetdb5/mal/Tests/tst105.stable.err monetdb5/mal/Tests/tst105.stable.out monetdb5/mal/Tests/tst105a.malC monetdb5/mal/Tests/tst105a.stable.err monetdb5/mal/Tests/tst105a.stable.out monetdb5/mal/Tests/tst106.malC monetdb5/mal/Tests/tst106.stable.err monetdb5/mal/Tests/tst106.stable.out monetdb5/mal/Tests/tst150.malC monetdb5/mal/Tests/tst150.stable.err monetdb5/mal/Tests/tst150.stable.out monetdb5/modules/mal/joinpath.c monetdb5/modules/mal/joinpath.h monetdb5/optimizer/Tests/joinchain.malC monetdb5/optimizer/Tests/joinchain.stable.err monetdb5/optimizer/Tests/joinchain.stable.out monetdb5/optimizer/opt_joinpath.c monetdb5/optimizer/opt_joinpath.h Modified Files: .hgtags MonetDB.spec NT/installer32/MonetDB-ODBC-Installer.vdproj NT/installer32/MonetDB5-Geom-Module.vdproj NT/installer32/MonetDB5-SQL-Installer.vdproj NT/installer64/MonetDB-ODBC-Installer.vdproj NT/installer64/MonetDB5-Geom-Module.vdproj NT/installer64/MonetDB5-SQL-Installer.vdproj NT/monetdb_config.h.in NT/rules.msc buildtools/ChangeLog clients/R/Tests/survey.R clients/R/Tests/survey.stable.out clients/Tests/All clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.err clients/Tests/exports.stable.out clients/Tests/malcheck.stable.err clients/mapiclient/eventparser.c clients/mapiclient/stethoscope.c clients/mapilib/mapi.c clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc clients/python2/setup.py clients/python3/setup.py common/stream/stream.c configure.ag debian/changelog gdk/ChangeLog gdk/Makefile.ag gdk/gdk.h gdk/gdk_align.c gdk/gdk_bat.c gdk/gdk_batop.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.c gdk/gdk_heap.c gdk/gdk_imprints.c gdk/gdk_join.c gdk/gdk_private.h gdk/gdk_search.c gdk/gdk_search.h gdk/gdk_select.c gdk/gdk_storage.c gdk/gdk_storage.h gdk/gdk_system.c gdk/gdk_unique.c gdk/gdk_utils.c gdk/gdk_utils.h gdk/libbat.rc geom/monetdb5/30_geom.mal java/ChangeLog java/Makefile.ag java/build.properties java/pom.xml java/release.txt java/src/main/java/nl/cwi/monetdb/jdbc/MonetConnection.java java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java java/tests/Makefile.ag java/tests/build.xml libversions monetdb5/extras/mal_optimizer_template/91_opt_sql_append.mal monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.err monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single monetdb5/extras/rapi/50_rapi.mal monetdb5/extras/sphinx/30_sphinx.mal monetdb5/mal/Tests/All monetdb5/mal/Tests/dataflow01.malC monetdb5/mal/Tests/dynamicload.stable.err monetdb5/mal/Tests/tst102.malC monetdb5/mal/Tests/tst102.stable.err monetdb5/mal/Tests/tst115.malC monetdb5/mal/Tests/tst115.stable.err monetdb5/mal/mal.c monetdb5/mal/mal.h monetdb5/mal/mal_authorize.c monetdb5/mal/mal_client.c monetdb5/mal/mal_dataflow.c monetdb5/mal/mal_dataflow.h monetdb5/mal/mal_factory.c monetdb5/mal/mal_linker.c 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_profiler.h monetdb5/mal/mal_recycle.c monetdb5/mal/mal_resource.c monetdb5/mal/mal_resource.h monetdb5/mal/mal_runtime.c monetdb5/mal/mal_runtime.h monetdb5/mal/mal_scenario.c monetdb5/modules/atoms/str.c monetdb5/modules/kernel/00_aggr_hge.mal monetdb5/modules/kernel/00_aggr_hge.mal.sh monetdb5/modules/kernel/aggr.mal monetdb5/modules/kernel/aggr.mal.sh monetdb5/modules/kernel/bat5.c monetdb5/modules/mal/01_batcalc.mal monetdb5/modules/mal/01_batcalc.mal.sh monetdb5/modules/mal/01_calc.mal monetdb5/modules/mal/Makefile.ag monetdb5/modules/mal/Tests/All monetdb5/modules/mal/Tests/inspect05.stable.out monetdb5/modules/mal/Tests/manifold.malC monetdb5/modules/mal/Tests/remote03.malC monetdb5/modules/mal/Tests/remote03.stable.err monetdb5/modules/mal/Tests/remote03.stable.out monetdb5/modules/mal/language.mal monetdb5/modules/mal/mal_mapi.c monetdb5/modules/mal/profiler.c monetdb5/modules/mal/profiler.h monetdb5/modules/mal/profiler.mal monetdb5/optimizer/Makefile.ag monetdb5/optimizer/Tests/All monetdb5/optimizer/Tests/JPexample.malC monetdb5/optimizer/Tests/JPexample.stable.out monetdb5/optimizer/Tests/dataflow.malC monetdb5/optimizer/Tests/dataflow.stable.out monetdb5/optimizer/Tests/dataflow3.malC monetdb5/optimizer/Tests/joinpath.malC monetdb5/optimizer/Tests/leftjoinpath.malC monetdb5/optimizer/Tests/manifold2.stable.out.single monetdb5/optimizer/Tests/tst4005.malC monetdb5/optimizer/Tests/tst4630.malC monetdb5/optimizer/opt_costModel.c monetdb5/optimizer/opt_pipes.c monetdb5/optimizer/opt_prelude.c monetdb5/optimizer/opt_prelude.h monetdb5/optimizer/opt_profiler.c monetdb5/optimizer/opt_support.c monetdb5/optimizer/opt_support.h monetdb5/optimizer/opt_wrapper.c monetdb5/optimizer/optimizer.mal monetdb5/scheduler/Tests/All monetdb5/tools/libmonetdb5.rc sql/backends/monet5/40_sql.mal sql/backends/monet5/Makefile.ag sql/backends/monet5/Tests/optimizers.sql sql/backends/monet5/Tests/optimizers.stable.err sql/backends/monet5/UDF/80_udf.mal sql/backends/monet5/UDF/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/Tests/udf-reverse.stable.out sql/backends/monet5/generator/90_generator.mal sql/backends/monet5/generator/Tests/joins00.sql sql/backends/monet5/generator/Tests/joins01.sql sql/backends/monet5/generator/Tests/joins01.stable.out sql/backends/monet5/gsl/73_gsl.mal sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql.mal sql/backends/monet5/sql_decimal.mal.sh sql/backends/monet5/sql_decimal_hge.mal.sh sql/backends/monet5/sql_optimizer.c sql/backends/monet5/sql_scenario.c sql/backends/monet5/sql_upgrades.c sql/backends/monet5/vaults/70_vault.mal sql/backends/monet5/vaults/bam/85_bam.mal sql/backends/monet5/vaults/bam/85_bam.sql sql/backends/monet5/vaults/bam/Tests/bam_lib_mal.stable.out sql/backends/monet5/vaults/bam/bam.mal sql/backends/monet5/vaults/lidar/75_lidar.mal sql/backends/monet5/vaults/lidar/lidar.c sql/backends/monet5/vaults/lidar/lidar.h sql/backends/monet5/vaults/lidar/lidar.mal sql/benchmarks/ATIS/Tests/load.stable.out sql/benchmarks/arno/Tests/insert_ATOM.stable.out sql/benchmarks/arno/Tests/insert_BOND.stable.out sql/benchmarks/arno_flt/Tests/init.stable.out sql/benchmarks/moa/Tests/load.stable.out sql/benchmarks/ssbm/Tests/01-explain.stable.out sql/benchmarks/ssbm/Tests/02-explain.stable.out sql/benchmarks/ssbm/Tests/03-explain.stable.out 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 sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/10-explain.stable.out 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.32bit 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/04-explain.stable.out sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit 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/06-explain.stable.out sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/07-explain.stable.out.int128 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/08-plan.stable.out.int128 sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out.int128 sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/11-explain.stable.out.int128 sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/15-explain.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 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/19-explain.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 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-explain.stable.out.32bit sql/benchmarks/tpch/Tests/22-explain.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit sql/benchmarks/tpch/Tests/22-explain.stable.out.int128 sql/benchmarks/wisconsin/Tests/All sql/benchmarks/wisconsin/Tests/load.stable.out sql/jdbc/tests/Tests/All sql/jdbc/tests/Tests/Test_Dobjects.stable.out sql/jdbc/tests/Tests/Test_PSmetadata.stable.out sql/jdbc/tests/Tests/Test_Rmetadata.stable.out sql/jdbc/tests/Tests/Test_Rsqldata.stable.out sql/server/rel_optimizer.c sql/server/rel_psm.c sql/server/rel_select.c sql/server/rel_select.h sql/server/sql_mvc.c sql/server/sql_parser.y sql/storage/bat/bat_storage.c sql/storage/bat/bat_utils.c sql/storage/bat/bat_utils.h sql/storage/sql_storage.h sql/storage/store.c sql/test/BugTracker-2009/Tests/lost_update.SF-2790020.py sql/test/BugTracker-2009/Tests/reorder.SF-2770608.sql sql/test/BugTracker-2009/Tests/table-leftovers.SF-2779462.sql 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/group-by_ordered_column.Bug-2564.stable.out.32bit sql/test/BugTracker-2011/Tests/bulk_rotate_xor_hash-error.Bug-2734.stable.out sql/test/BugTracker-2011/Tests/cast-crash.Bug-2678.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out sql/test/BugTracker-2011/Tests/sqltables.Bug-2921.stable.out sql/test/BugTracker-2012/Tests/querycache.Bug-3212.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.stable.out.single sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out sql/test/BugTracker/Tests/caching.SF-1651599.stable.out sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out 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/rank_over.SF-1691098.stable.out sql/test/Skyserver/Tests/Skyserver.stable.out sql/test/Tests/All sql/test/Tests/decimal2.stable.out sql/test/Tests/median_stdev.sql sql/test/Tests/setoptimizer.stable.err 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/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out sql/test/leaks/Tests/All 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.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.int128 sql/test/leaks/Tests/temp3.stable.out sql/test/leaks/Tests/temp3.stable.out.int128 sql/test/pg_regress/Tests/int8.sql sql/test/pg_regress/Tests/int8.stable.err sql/test/pg_regress/Tests/int8.stable.out sql/test/pg_regress/Tests/int8.stable.out.int128 sql/test/pg_regress/Tests/random.sql sql/test/pg_regress/Tests/random.stable.out sql/test/pg_regress/Tests/strings.stable.out sql/test/rdf/Tests/All testing/Makefile.ag testing/Mfilter.py testing/Mtest.py.in tools/merovingian/daemon/Makefile.ag tools/merovingian/daemon/connections.c tools/merovingian/daemon/connections.h tools/merovingian/daemon/merovingian.c tools/mserver/Makefile.ag tools/mserver/mserver5.1.in tools/mserver/mserver5.c vertoo.data Branch: partitioned-hash Log Message:
Merge with default branch. diffs (truncated from 82072 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -613,3 +613,5 @@ d1dd6e5b7a5acfe14a33070e08c776341996deb2 2ca94cddcdf52121541eff4bf706b1b7c451f511 Jul2015_11 d1dd6e5b7a5acfe14a33070e08c776341996deb2 Jul2015_SP1_release 2ca94cddcdf52121541eff4bf706b1b7c451f511 Jul2015_SP1_release +25c9f569add9c341d40920f30936890ae6ea68a8 Jul2015_13 +25c9f569add9c341d40920f30936890ae6ea68a8 Jul2015_SP2_release diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -91,7 +91,7 @@ Vendor: MonetDB BV <[email protected]> Group: Applications/Databases License: MPL - http://www.monetdb.org/Legal/MonetDBLicense URL: http://www.monetdb.org/ -Source: http://dev.monetdb.org/downloads/sources/Jul2015-SP1/%{name}-%{version}.tar.bz2 +Source: http://dev.monetdb.org/downloads/sources/Jul2015-SP2/%{name}-%{version}.tar.bz2 BuildRequires: bison BuildRequires: bzip2-devel @@ -754,6 +754,7 @@ systemd-tmpfiles --create %{_sysconfdir} %exclude %{_sysconfdir}/tmpfiles.d/monetdbd.conf %endif %config(noreplace) %{_localstatedir}/monetdb5/dbfarm/.merovingian_properties +%{_unitdir}/monetdbd.service %{_libdir}/monetdb5/autoload/??_sql.mal %{_libdir}/monetdb5/lib_sql.so %{_libdir}/monetdb5/*.sql @@ -891,9 +892,6 @@ developer, but if you do want to test, t %files testing-python %defattr(-,root,root) -# at least F12 doesn't produce these -# %exclude %{_bindir}/*.pyc -# %exclude %{_bindir}/*.pyo %{_bindir}/Mapprove.py %{_bindir}/Mtest.py %dir %{python_sitelib}/MonetDBtesting @@ -970,6 +968,45 @@ rm -f %{buildroot}%{_bindir}/Maddlog %postun -p /sbin/ldconfig %changelog +* Tue Jan 05 2016 Sjoerd Mullender <[email protected]> - 11.21.13-20160105 +- Rebuilt. +- BZ#2014: 'null' from copy into gets wrong +- BZ#3817: opt_pushselect stuck with multi-table UDF +- BZ#3835: windows does not release ram after operations +- BZ#3836: rand() only gets evaluated once when used as an expression +- BZ#3838: Update column with or without parenthesis produce different + results +- BZ#3840: savepoints may crash the database +- BZ#3841: mclient fails with response "Challenge string is not valid" +- BZ#3842: SQL execution fails to finish and reports bogus error messages +- BZ#3845: Too many VALUES in INSERT freeze mserver5 +- BZ#3847: Wrong SQL results for a certain combination of GROUP BY / + ORDER BY / LIMIT +- BZ#3848: mserver segfault during bulk loading/updating +- BZ#3849: HUGEINT incorrect value +- BZ#3850: DEL character not escaped +- BZ#3851: expression that should evaluate to FALSE evaluates to TRUE + in SELECT query +- BZ#3852: CASE statement produces GDK error on multithreaded database: + BATproject does not match always +- BZ#3854: Complex expression with comparison evaluates incorrectly in + WHERE clause +- BZ#3855: Foreign key referencing table in a different schema - + not allowed. +- BZ#3857: Large LIMIT in SELECT may abort the query +- BZ#3861: Using window functions cause a crash +- BZ#3864: Error in bulk import for chinese character +- BZ#3871: NOT x LIKE triggers "too many nested operators" +- BZ#3872: mserver crashes under specific combination of JOIN and WHERE + conditions +- BZ#3873: mserver5: gdk_bat.c:1015: setcolprops: Assertion `x != + ((void *)0) || col->type == 0' failed. +- BZ#3879: Database crashes when querying with several UNION ALLs. +- BZ#3887: Querying "sys"."tracelog" causes assertion violation and + crash of mserver5 process +- BZ#3889: read only does not protect empty tables +- BZ#3895: read only does not protect this table + * Fri Oct 30 2015 Sjoerd Mullender <[email protected]> - 11.21.11-20151030 - Rebuilt. - BZ#3828: Schema corruption after several ALTER TABLE statements and diff --git a/buildtools/ChangeLog b/buildtools/ChangeLog --- a/buildtools/ChangeLog +++ b/buildtools/ChangeLog @@ -1,3 +1,7 @@ # ChangeLog file for buildtools # This file is updated with Maddlog +* Sat Jan 23 2016 Sjoerd Mullender <[email protected]> +- Implemented a systemd configuration file for a monetdbd.service + on Fedora. + diff --git a/clients/R/Tests/survey.R b/clients/R/Tests/survey.R --- a/clients/R/Tests/survey.R +++ b/clients/R/Tests/survey.R @@ -69,3 +69,4 @@ cat("#~EndVariableOutput~#\n") print("SUCCESS") +dbDisconnect(db) diff --git a/clients/R/Tests/survey.stable.out b/clients/R/Tests/survey.stable.out --- a/clients/R/Tests/survey.stable.out +++ b/clients/R/Tests/survey.stable.out @@ -172,6 +172,7 @@ 2 223 757 33.847 2 [1] TRUE #~EndVariableOutput~# [1] "SUCCESS" +[1] TRUE # 14:26:26 > # 14:26:26 > "Done." diff --git a/clients/Tests/All b/clients/Tests/All --- a/clients/Tests/All +++ b/clients/Tests/All @@ -1,4 +1,4 @@ exports -HAVE_NETCDF&HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIBR&HAVE_SAMTOOLS&HAVE_SPHINXCLIENT?MAL-signatures -HAVE_NETCDF&HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_SAMTOOLS&!BITS32&!BITS64OID32?SQL-dump +HAVE_FITS&HAVE_GEOM&HAVE_GSL&HAVE_LIBR&!HAVE_LIDAR&HAVE_NETCDF&HAVE_SAMTOOLS&HAVE_SPHINXCLIENT?MAL-signatures +!BITS32&!BITS64OID32&HAVE_FITS&HAVE_GEOM&HAVE_GSL&!HAVE_LIDAR&HAVE_NETCDF&HAVE_SAMTOOLS?SQL-dump MERCURIAL?malcheck 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 @@ -25,1956 +25,1955 @@ Ready. # 21:33:48 > "mclient" "-lmal" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-19610" "--port=35607" # 21:33:48 > -#?*) -command aggr.avg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on dbl, also returns count -command aggr.avg(b:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:dbl],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on dbl -command aggr.avg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on flt, also returns count -command aggr.avg(b:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:flt],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on flt -command aggr.avg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on lng, also returns count -command aggr.avg(b:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:lng],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on lng -command aggr.avg(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:wrd],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on wrd, also returns count -command aggr.avg(b:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:wrd],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on wrd -command aggr.avg(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on int, also returns count -command aggr.avg(b:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:int],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on int -command aggr.avg(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on sht, also returns count -command aggr.avg(b:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:sht],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on sht -command aggr.avg(b:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_1]) (X_4:bat[:oid,:dbl],X_5:bat[:oid,:wrd]) +command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]) (X_4:bat[:dbl],X_5:bat[:wrd]) address AGGRavg23_dbl; comment Grouped tail average on bte, also returns count -command aggr.avg(b:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_1]):bat[:oid,:dbl] +command aggr.avg(b:bat[:bte],g:bat[:oid],e:bat[:any_1]):bat[:dbl] address AGGRavg13_dbl; comment Grouped tail average on bte -pattern aggr.avg(b:bat[:oid,:any_2]):dbl +pattern aggr.avg(b:bat[:any_2]):dbl address CMDcalcavg; comment Gives the avg of all tail values -function aggr.corr(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:dbl]; -function aggr.covar(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:dbl]; -function aggr.corr(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl]):dbl; -function aggr.covar(e1:bat[:oid,:dbl],e2:bat[:oid,:dbl]):dbl; -function aggr.corr(e1:bat[:oid,:flt],e2:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:flt]; -function aggr.covar(e1:bat[:oid,:flt],e2:bat[:oid,:flt],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:flt]; -function aggr.corr(e1:bat[:oid,:flt],e2:bat[:oid,:flt]):flt; -function aggr.covar(e1:bat[:oid,:flt],e2:bat[:oid,:flt]):flt; -function aggr.corr(e1:bat[:oid,:lng],e2:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:lng]; -function aggr.covar(e1:bat[:oid,:lng],e2:bat[:oid,:lng],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:lng]; -function aggr.corr(e1:bat[:oid,:lng],e2:bat[:oid,:lng]):lng; -function aggr.covar(e1:bat[:oid,:lng],e2:bat[:oid,:lng]):lng; -function aggr.corr(e1:bat[:oid,:wrd],e2:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:wrd]; -function aggr.covar(e1:bat[:oid,:wrd],e2:bat[:oid,:wrd],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:wrd]; -function aggr.corr(e1:bat[:oid,:wrd],e2:bat[:oid,:wrd]):wrd; -function aggr.covar(e1:bat[:oid,:wrd],e2:bat[:oid,:wrd]):wrd; -function aggr.corr(e1:bat[:oid,:int],e2:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:int]; -function aggr.covar(e1:bat[:oid,:int],e2:bat[:oid,:int],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:int]; -function aggr.corr(e1:bat[:oid,:int],e2:bat[:oid,:int]):int; -function aggr.covar(e1:bat[:oid,:int],e2:bat[:oid,:int]):int; -function aggr.corr(e1:bat[:oid,:sht],e2:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:sht]; -function aggr.covar(e1:bat[:oid,:sht],e2:bat[:oid,:sht],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:sht]; -function aggr.corr(e1:bat[:oid,:sht],e2:bat[:oid,:sht]):sht; -function aggr.covar(e1:bat[:oid,:sht],e2:bat[:oid,:sht]):sht; -function aggr.corr(e1:bat[:oid,:bte],e2:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:bte]; -function aggr.covar(e1:bat[:oid,:bte],e2:bat[:oid,:bte],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:bte]; -function aggr.corr(e1:bat[:oid,:bte],e2:bat[:oid,:bte]):bte; -function aggr.covar(e1:bat[:oid,:bte],e2:bat[:oid,:bte]):bte; -command aggr.count_no_nil(b:bat[:oid,:any_1],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:wrd] +function aggr.corr(e1:bat[:dbl],e2:bat[:dbl],g:bat[:oid],e:bat[:any_2]):bat[:dbl]; +function aggr.covar(e1:bat[:dbl],e2:bat[:dbl],g:bat[:oid],e:bat[:any_2]):bat[:dbl]; +function aggr.corr(e1:bat[:dbl],e2:bat[:dbl]):dbl; +function aggr.covar(e1:bat[:dbl],e2:bat[:dbl]):dbl; +function aggr.corr(e1:bat[:flt],e2:bat[:flt],g:bat[:oid],e:bat[:any_2]):bat[:flt]; +function aggr.covar(e1:bat[:flt],e2:bat[:flt],g:bat[:oid],e:bat[:any_2]):bat[:flt]; +function aggr.corr(e1:bat[:flt],e2:bat[:flt]):flt; +function aggr.covar(e1:bat[:flt],e2:bat[:flt]):flt; +function aggr.corr(e1:bat[:lng],e2:bat[:lng],g:bat[:oid],e:bat[:any_2]):bat[:lng]; +function aggr.covar(e1:bat[:lng],e2:bat[:lng],g:bat[:oid],e:bat[:any_2]):bat[:lng]; +function aggr.corr(e1:bat[:lng],e2:bat[:lng]):lng; +function aggr.covar(e1:bat[:lng],e2:bat[:lng]):lng; +function aggr.corr(e1:bat[:wrd],e2:bat[:wrd],g:bat[:oid],e:bat[:any_2]):bat[:wrd]; +function aggr.covar(e1:bat[:wrd],e2:bat[:wrd],g:bat[:oid],e:bat[:any_2]):bat[:wrd]; +function aggr.corr(e1:bat[:wrd],e2:bat[:wrd]):wrd; +function aggr.covar(e1:bat[:wrd],e2:bat[:wrd]):wrd; +function aggr.corr(e1:bat[:int],e2:bat[:int],g:bat[:oid],e:bat[:any_2]):bat[:int]; +function aggr.covar(e1:bat[:int],e2:bat[:int],g:bat[:oid],e:bat[:any_2]):bat[:int]; +function aggr.corr(e1:bat[:int],e2:bat[:int]):int; +function aggr.covar(e1:bat[:int],e2:bat[:int]):int; +function aggr.corr(e1:bat[:sht],e2:bat[:sht],g:bat[:oid],e:bat[:any_2]):bat[:sht]; +function aggr.covar(e1:bat[:sht],e2:bat[:sht],g:bat[:oid],e:bat[:any_2]):bat[:sht]; +function aggr.corr(e1:bat[:sht],e2:bat[:sht]):sht; +function aggr.covar(e1:bat[:sht],e2:bat[:sht]):sht; +function aggr.corr(e1:bat[:bte],e2:bat[:bte],g:bat[:oid],e:bat[:any_2]):bat[:bte]; +function aggr.covar(e1:bat[:bte],e2:bat[:bte],g:bat[:oid],e:bat[:any_2]):bat[:bte]; +function aggr.corr(e1:bat[:bte],e2:bat[:bte]):bte; +function aggr.covar(e1:bat[:bte],e2:bat[:bte]):bte; +command aggr.count_no_nil(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:wrd] address AGGRcount3nonils; -command aggr.count(b:bat[:oid,:any_1],g:bat[:oid,:oid],e:bat[:oid,:any_2]):bat[:oid,:wrd] +command aggr.count(b:bat[:any_1],g:bat[:oid],e:bat[:any_2]):bat[:wrd] address AGGRcount3nils; comment Grouped count -command aggr.count(b:bat[:oid,:any_1],g:bat[:oid,:oid],e:bat[:oid,:any_2],ignorenils:bit):bat[:oid,:wrd] +command aggr.count(b:bat[:any_1],g:bat[:oid],e:bat[:any_2],ignorenils:bit):bat[:wrd] address AGGRcount3; -command aggr.cardinality(b:bat[:oid,:any_2]):lng +command aggr.cardinality(b:bat[:any_2]):lng address ALGcard; comment Return the cardinality of the BAT tail values. -command aggr.count_no_nil(b:bat[:oid,:any_2]):wrd +command aggr.count_no_nil(b:bat[:any_2]):wrd address ALGcount_no_nil; comment Return the number of elements currently in a BAT ignoring BUNs with nil-tail -command aggr.count(b:bat[:oid,:any],ignore_nils:bit):wrd +command aggr.count(b:bat[:any],ignore_nils:bit):wrd address ALGcount_nil; comment Return the number of elements currently in a BAT ignores BUNs with nil-tail iff ignore_nils==TRUE. -command aggr.count(b:bat[:oid,:any]):wrd +command aggr.count(b:bat[:any]):wrd address ALGcount_bat; comment Return the current size (in number of elements) in a BAT. -command aggr.exist(b:bat[:oid,:any_2],h:any_1):bit +command aggr.exist(b:bat[:any_2],h:any_1):bit address ALGexist; -command aggr.jsonaggr(val:bat[:oid,:dbl]):str +command aggr.jsonaggr(val:bat[:dbl]):str _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
