Changeset: 58723cf394e2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=58723cf394e2 Added Files: sql/test/BugTracker-2017/Tests/sqlitelogictest-cast-decimal.Bug-6445.sql Modified Files: .hgtags MonetDB.spec NT/monetdb_config.h.in NT/rules.msc clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc configure.ag debian/changelog gdk/ChangeLog-Archive gdk/ChangeLog.Jul2017 gdk/gdk_batop.c gdk/gdk_logger.c gdk/libbat.rc libversions monetdb5/mal/mal_parser.c monetdb5/modules/atoms/str.c monetdb5/tools/libmonetdb5.rc sql/backends/monet5/sql_aggr_bte.mal sql/backends/monet5/sql_aggr_dbl.mal sql/backends/monet5/sql_aggr_flt.mal sql/backends/monet5/sql_aggr_hge.mal sql/backends/monet5/sql_aggr_int.mal sql/backends/monet5/sql_aggr_lng.mal sql/backends/monet5/sql_aggr_sht.mal sql/backends/monet5/sql_cat.c sql/backends/monet5/sql_execute.c sql/backends/monet5/sql_upgrades.c sql/benchmarks/tpch/fileleak/Tests/delete_all.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out.Windows sql/scripts/39_analytics.sql sql/scripts/39_analytics_hge.sql sql/server/rel_select.c sql/server/sql_parser.y sql/test/BugTracker-2011/Tests/UDF_in_schema.Bug-2817.sql sql/test/BugTracker-2012/Tests/insert_serial_with_unique_key.Bug-3091.sql sql/test/BugTracker-2015/Tests/schema_view.Bug-3708.sql sql/test/BugTracker-2016/Tests/subcorr-missing.Bug-3978.sql sql/test/BugTracker-2016/Tests/subcorr-missing.Bug-3978.stable.out sql/test/BugTracker-2017/Tests/All sql/test/BugTracker-2017/Tests/function_and_mergetable.Bug-6288.sql sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/Skyserver/drop_user.sql sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/emptydb/Tests/check.stable.out sql/test/emptydb/Tests/check.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.int128 sql/test/leaks/Tests/check1.stable.out.int128 vertoo.data Branch: trails Log Message:
Merge with default diffs (truncated from 5346 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -682,3 +682,6 @@ 1534ee14ff84fe5629becc6a5b5e2990b694d5a3 269ab71a82190d6024b3a920837089d657893493 Jul2017_SP1_release fce449d5af88de715fde36624815a56ef34c56bb Jul2017_7 fce449d5af88de715fde36624815a56ef34c56bb Jul2017_SP2_release +3d26c58579a18157659b590899a8f73f45954ec6 Jul2017_9 +fce449d5af88de715fde36624815a56ef34c56bb Jul2017_SP2_release +3d26c58579a18157659b590899a8f73f45954ec6 Jul2017_SP2_release diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -970,7 +970,7 @@ fi --enable-monetdb5=yes \ --enable-netcdf=no \ --enable-odbc=yes \ - --enable-optimize=yes \ + --enable-optimize=no \ --enable-profile=no \ --enable-pyintegration=%{?with_pyintegration:yes}%{!?with_pyintegration:no} \ --enable-rintegration=%{?with_rintegration:yes}%{!?with_rintegration:no} \ @@ -1041,6 +1041,44 @@ done %postun -p /sbin/ldconfig %changelog +* Mon Oct 23 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.9-20171023 +- Rebuilt. +- BZ#6207: identifier ambiguous when grouping and selecting the same + column twice +- BZ#6335: Sqlitelogictest crash in complex SQL query +- BZ#6405: Compilation error if DISABLE_PARENT_HASH not defined +- BZ#6412: Overflow in sys.epoch +- BZ#6413: Wrong answer for TPC-H Q17 +- BZ#6414: Using RPAD returns: could not allocate space +- BZ#6416: Sqlitelogictest crash in aggregation query with a NOT IN clause +- BZ#6417: Segfault encountered (sqlsmith) +- BZ#6418: Segfault in renaming (sqlsmith) +- BZ#6419: segfault in rel_optimizer (sqlsmith) +- BZ#6420: Assertion error in mergetable task (sqlsmith) +- BZ#6422: Another assertion error in rel_or (sqlsmith) +- BZ#6423: Dereference null pointer (sqlsmith) +- BZ#6424: Assertion error in rel_rename_expr (sqlsmith) +- BZ#6425: Assertion error in exp_bin (sqlsmith) +- BZ#6426: Assertion error in rel_find_exp_ (sqlsmith) +- BZ#6427: Assertion error in eq_typeswitchloop (sqlsmith) +- BZ#6428: Sqlitelogictest crash in aggregation query +- BZ#6430: Assertion raised in another eq_typeswitch error (sqlsmith) +- BZ#6431: Sqlitelogictest crash in aggregation query with a long + having clause +- BZ#6432: Assertion error in exp_bin (sqlsmith) +- BZ#6433: Sqlitelogictest crash in complex SELECT query with IN operator +- BZ#6435: Sqlitelogictest crash in simple select query +- BZ#6437: System schemas "profiler" and "json" shouldn't be allowed to + be dropped. +- BZ#6438: Implement functionality to enforce the restrict option in: + DROP SCHEMA xyz RESTRICT; +- BZ#6440: Faulty plan generated. Query returns more rows than expected + or existing in the view sys.tables. + +* Mon Oct 23 2017 Sjoerd Mullender <sjo...@acm.org> - 11.27.9-20171023 +- gdk: A serious bug, possibly resulting in database corruption, having to + do with appending data to a string BAT was fixed. + * Wed Oct 11 2017 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 11.27.7-20171011 - Rebuilt. - BZ#4017: server crashes when executing particular loopback query in 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 @@ -75,24 +75,24 @@ Ready. [ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on sht, also returns count" ] [ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;", "Gives the avg of all tail values" ] [ "aggr", "cardinality", "command aggr.cardinality(b:bat[:any_2]):lng ", "ALGcard;", "Return the cardinality of the BAT tail values." ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):bte;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):dbl;", "", "" ] [ "aggr", "corr", "function aggr.corr(e1:bat[:dbl], e2:bat[:dbl]):dbl;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):flt;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):int;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):lng;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):sht;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):dbl;", "", "" ] [ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], ignorenils:bit):bat[:lng] ", "AGGRcount3;", "" ] [ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ] [ "aggr", "count", "command aggr.count(b:bat[:any]):lng ", "ALGcount_bat;", "Return the current size (in number of elements) in a BAT." ] [ "aggr", "count", "command aggr.count(b:bat[:any], ignore_nils:bit):lng ", "ALGcount_nil;", "Return the number of elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff ignore_nils==TRUE." ] [ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ] [ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng ", "ALGcount_no_nil;", "Return the number of elements currently\n\tin a BAT ignoring BUNs with nil-tail" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:bte], e2:bat[:bte]):bte;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:bte], e2:bat[:bte]):dbl;", "", "" ] [ "aggr", "covar", "function aggr.covar(e1:bat[:dbl], e2:bat[:dbl]):dbl;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:flt], e2:bat[:flt]):flt;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:int], e2:bat[:int]):int;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:lng], e2:bat[:lng]):lng;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:sht], e2:bat[:sht]):sht;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:flt], e2:bat[:flt]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:int], e2:bat[:int]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:lng], e2:bat[:lng]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:sht], e2:bat[:sht]):dbl;", "", "" ] [ "aggr", "exist", "command aggr.exist(b:bat[:any_2], h:any_1):bit ", "ALGexist;", "" ] [ "aggr", "exist", "command aggr.exist(b:bat[:any_2]):bit ", "SQLexist;", "" ] [ "aggr", "exist", "pattern aggr.exist(v:any_2):bit ", "SQLexist_val;", "" ] @@ -225,20 +225,20 @@ Ready. [ "aggr", "subavg", "command aggr.subavg(b:bat[:int], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:lng], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:sht], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:dbl], e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subcount", "command aggr.subcount(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], skip_nils:bit):bat[:lng] ", "AGGRsubcount;", "Grouped count aggregate" ] [ "aggr", "subcount", "command aggr.subcount(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], s:bat[:oid], skip_nils:bit):bat[:lng] ", "AGGRsubcountcand;", "Grouped count aggregate with candidates list" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:dbl], e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:dbl], g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ", "JSONsubjson;", "Grouped aggregation of values." ] [ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:str], g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ", "JSONsubjson;", "Grouped aggregation of values." ] [ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:dbl], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit):bat[:str] ", "JSONsubjsoncand;", "Grouped aggregation of values with candidates list." ] 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 @@ -81,26 +81,26 @@ Ready. [ "aggr", "avg", "command aggr.avg(b:bat[:sht], g:bat[:oid], e:bat[:any_1]) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRavg23_dbl;", "Grouped tail average on sht, also returns count" ] [ "aggr", "avg", "pattern aggr.avg(b:bat[:any_2]):dbl ", "CMDcalcavg;", "Gives the avg of all tail values" ] [ "aggr", "cardinality", "command aggr.cardinality(b:bat[:any_2]):lng ", "ALGcard;", "Return the cardinality of the BAT tail values." ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):bte;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:bte], e2:bat[:bte]):dbl;", "", "" ] [ "aggr", "corr", "function aggr.corr(e1:bat[:dbl], e2:bat[:dbl]):dbl;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):flt;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:hge], e2:bat[:hge]):hge;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):int;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):lng;", "", "" ] -[ "aggr", "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):sht;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:flt], e2:bat[:flt]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:hge], e2:bat[:hge]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:int], e2:bat[:int]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:lng], e2:bat[:lng]):dbl;", "", "" ] +[ "aggr", "corr", "function aggr.corr(e1:bat[:sht], e2:bat[:sht]):dbl;", "", "" ] [ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], ignorenils:bit):bat[:lng] ", "AGGRcount3;", "" ] [ "aggr", "count", "command aggr.count(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nils;", "Grouped count" ] [ "aggr", "count", "command aggr.count(b:bat[:any]):lng ", "ALGcount_bat;", "Return the current size (in number of elements) in a BAT." ] [ "aggr", "count", "command aggr.count(b:bat[:any], ignore_nils:bit):lng ", "ALGcount_nil;", "Return the number of elements currently in a BAT ignores\n\t\tBUNs with nil-tail iff ignore_nils==TRUE." ] [ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_1], g:bat[:oid], e:bat[:any_2]):bat[:lng] ", "AGGRcount3nonils;", "" ] [ "aggr", "count_no_nil", "command aggr.count_no_nil(b:bat[:any_2]):lng ", "ALGcount_no_nil;", "Return the number of elements currently\n\tin a BAT ignoring BUNs with nil-tail" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:bte], e2:bat[:bte]):bte;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:bte], e2:bat[:bte]):dbl;", "", "" ] [ "aggr", "covar", "function aggr.covar(e1:bat[:dbl], e2:bat[:dbl]):dbl;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:flt], e2:bat[:flt]):flt;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:hge], e2:bat[:hge]):hge;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:int], e2:bat[:int]):int;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:lng], e2:bat[:lng]):lng;", "", "" ] -[ "aggr", "covar", "function aggr.covar(e1:bat[:sht], e2:bat[:sht]):sht;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:flt], e2:bat[:flt]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:hge], e2:bat[:hge]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:int], e2:bat[:int]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:lng], e2:bat[:lng]):dbl;", "", "" ] +[ "aggr", "covar", "function aggr.covar(e1:bat[:sht], e2:bat[:sht]):dbl;", "", "" ] [ "aggr", "exist", "command aggr.exist(b:bat[:any_2], h:any_1):bit ", "ALGexist;", "" ] [ "aggr", "exist", "command aggr.exist(b:bat[:any_2]):bit ", "SQLexist;", "" ] [ "aggr", "exist", "pattern aggr.exist(v:any_2):bit ", "SQLexist_val;", "" ] @@ -268,22 +268,22 @@ Ready. [ "aggr", "subavg", "command aggr.subavg(b:bat[:int], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:lng], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] [ "aggr", "subavg", "command aggr.subavg(b:bat[:sht], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit, abort_on_error:bit) (X_0:bat[:dbl], X_1:bat[:lng]) ", "AGGRsubavg2cand_dbl;", "Grouped average aggregate with candidates list, also returns count" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:dbl], e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:hge], e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:hge];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];", "", "" ] -[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:hge], e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcorr", "function aggr.subcorr(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subcount", "command aggr.subcount(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], skip_nils:bit):bat[:lng] ", "AGGRsubcount;", "Grouped count aggregate" ] [ "aggr", "subcount", "command aggr.subcount(b:bat[:any_1], g:bat[:oid], e:bat[:any_2], s:bat[:oid], skip_nils:bit):bat[:lng] ", "AGGRsubcountcand;", "Grouped count aggregate with candidates list" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:bte];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:bte], e2:bat[:bte], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:dbl], e2:bat[:dbl], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:flt];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:hge], e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:hge];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:int];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:lng];", "", "" ] -[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:sht];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:flt], e2:bat[:flt], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:hge], e2:bat[:hge], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:int], e2:bat[:int], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:lng], e2:bat[:lng], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] +[ "aggr", "subcovar", "function aggr.subcovar(e1:bat[:sht], e2:bat[:sht], g:bat[:oid], e:bat[:any_2], f:bit):bat[:dbl];", "", "" ] [ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:dbl], g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ", "JSONsubjson;", "Grouped aggregation of values." ] [ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:str], g:bat[:oid], e:bat[:any_1], skip_nils:bit):bat[:str] ", "JSONsubjson;", "Grouped aggregation of values." ] [ "aggr", "subjsonaggr", "command aggr.subjsonaggr(val:bat[:dbl], g:bat[:oid], e:bat[:any_1], s:bat[:oid], skip_nils:bit):bat[:str] ", "JSONsubjsoncand;", "Grouped aggregation of values with candidates list." ] diff --git a/configure.ag b/configure.ag --- a/configure.ag +++ b/configure.ag @@ -326,19 +326,19 @@ AC_ARG_ENABLE([debug], [AS_HELP_STRING([--enable-debug], [enable full debugging (default=yes for development sources)])], [enable_debug=$enableval], - [enable_debug=def_$dft_debug]) + [enable_debug=$dft_debug]) AC_ARG_ENABLE([assert], [AS_HELP_STRING([--enable-assert], [enable assertions in the code (default=yes for development sources)])], [enable_assert=$enableval], - [enable_assert=def_$dft_assert]) + [enable_assert=$dft_assert]) AC_ARG_ENABLE([optimize], [AS_HELP_STRING([--enable-optimize], [enable extra optimization (default=no)])], [enable_optimize=$enableval], - [enable_optimize=def_$dft_optimize]) + [enable_optimize=$dft_optimize]) AC_ARG_ENABLE([strict], [AS_HELP_STRING([--enable-strict], @@ -362,7 +362,7 @@ dft_profile=$need_profile AC_ARG_ENABLE([profile], [AS_HELP_STRING([--enable-profile], [enable profiling (default=no)])], [enable_profile=$enableval], - [enable_profile=def_$dft_profile]) + [enable_profile=$dft_profile]) need_instrument=no dft_instrument=$need_instrument @@ -370,7 +370,7 @@ AC_ARG_ENABLE([instrument], [AS_HELP_STRING([--enable-instrument], [enable instrument (default=no)])], [enable_instrument=$enableval], - [enable_instrument=def_$dft_instrument]) + [enable_instrument=$dft_instrument]) # RIPEMD160 is patent free, academic and European, but unfortunately # can't use it by default, as that would exclude JDBC usage (Java diff --git a/debian/changelog b/debian/changelog --- a/debian/changelog +++ b/debian/changelog @@ -1,3 +1,47 @@ +monetdb (11.27.9) unstable; urgency=low + + * Rebuilt. + * BZ#6207: identifier ambiguous when grouping and selecting the same + column twice + * BZ#6335: Sqlitelogictest crash in complex SQL query + * BZ#6405: Compilation error if DISABLE_PARENT_HASH not defined + * BZ#6412: Overflow in sys.epoch + * BZ#6413: Wrong answer for TPC-H Q17 + * BZ#6414: Using RPAD returns: could not allocate space + * BZ#6416: Sqlitelogictest crash in aggregation query with a NOT IN clause + * BZ#6417: Segfault encountered (sqlsmith) + * BZ#6418: Segfault in renaming (sqlsmith) + * BZ#6419: segfault in rel_optimizer (sqlsmith) + * BZ#6420: Assertion error in mergetable task (sqlsmith) + * BZ#6422: Another assertion error in rel_or (sqlsmith) + * BZ#6423: Dereference null pointer (sqlsmith) + * BZ#6424: Assertion error in rel_rename_expr (sqlsmith) + * BZ#6425: Assertion error in exp_bin (sqlsmith) + * BZ#6426: Assertion error in rel_find_exp_ (sqlsmith) + * BZ#6427: Assertion error in eq_typeswitchloop (sqlsmith) + * BZ#6428: Sqlitelogictest crash in aggregation query + * BZ#6430: Assertion raised in another eq_typeswitch error (sqlsmith) + * BZ#6431: Sqlitelogictest crash in aggregation query with a long + having clause + * BZ#6432: Assertion error in exp_bin (sqlsmith) + * BZ#6433: Sqlitelogictest crash in complex SELECT query with IN operator + * BZ#6435: Sqlitelogictest crash in simple select query + * BZ#6437: System schemas "profiler" and "json" shouldn't be allowed to + be dropped. + * BZ#6438: Implement functionality to enforce the restrict option in: + DROP SCHEMA xyz RESTRICT; + * BZ#6440: Faulty plan generated. Query returns more rows than expected + or existing in the view sys.tables. + + -- Sjoerd Mullender <sjo...@acm.org> Mon, 23 Oct 2017 15:39:35 +0200 + +monetdb (11.27.9) unstable; urgency=low + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list