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 <[email protected]> - 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 <[email protected]> - 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 <[email protected]> -
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 <[email protected]> Mon, 23 Oct 2017 15:39:35 +0200
+
+monetdb (11.27.9) unstable; urgency=low
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
