Changeset: 567c57e9313c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/567c57e9313c
Modified Files:
.bumpversion.cfg
MonetDB.spec
NT/monetdb_config.h.in
NT/rules.msc
configure.ag
sql/backends/monet5/sql.c
sql/storage/bat/bat_logger.c
sql/storage/store.c
Branch: Jun2020-mmt
Log Message:
Merge with Jun2020 branch.
diffs (truncated from 5277 to 300 lines):
diff --git a/.bumpversion.cfg b/.bumpversion.cfg
--- a/.bumpversion.cfg
+++ b/.bumpversion.cfg
@@ -1,5 +1,5 @@
[bumpversion]
-current_version = 11.37a.12
+current_version = 11.37a.14
commit = False
tag = False
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -780,3 +780,5 @@ 1e3bd8cd485a0880a7557aa5307e986a210a1e00
bb157905ecb86908dcfb112d102a8c6152557b5d Jun2020_11
1e3bd8cd485a0880a7557aa5307e986a210a1e00 Jun2020_SP1_release
bb157905ecb86908dcfb112d102a8c6152557b5d Jun2020_SP1_release
+1252291e5c0ddc91ccb16d612d04e34e6a7d3bc3 Jun2020_13
+1252291e5c0ddc91ccb16d612d04e34e6a7d3bc3 Jun2020_SP2_release
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -1,5 +1,5 @@
%global name MonetDB
-%global version 11.37a.12
+%global version 11.37a.14
%{!?buildno: %global buildno %(date +%Y%m%d)}
# Use bcond_with to add a --with option; i.e., "without" is default.
@@ -105,7 +105,7 @@ Group: Applications/Databases
License: MPLv2.0
URL: https://www.monetdb.org/
BugURL: https://bugs.monetdb.org/
-Source:
https://www.monetdb.org/downloads/sources/Jun2020-SP1/%{name}-%{version}.tar.bz2
+Source:
https://www.monetdb.org/downloads/sources/Jun2020-SP2/%{name}-%{version}.tar.bz2
# The Fedora packaging document says we need systemd-rpm-macros for
# the _unitdir and _tmpfilesdir macros to exist; however on RHEL 7
@@ -985,6 +985,55 @@ fi
%postun -p /sbin/ldconfig
%changelog
+* Mon May 09 2022 Sjoerd Mullender <[email protected]> - 11.37.13-20220509
+- Rebuilt.
+- GH#6938: Segmentation fault in MalOptimizer
+- GH#6939: Error in optimizer multiplex when selecting
+ profiler.getlimit() or wlc.clock() or wlc.tick() or wlr.clock() or
+ wlr.tick()
+- GH#6950: redundant/replicated code line in gdk/gdk_hash.c
+- GH#6954: FILTER functions no longer find their implementation
+- GH#6955: ROUND(DECIMAL, PRECISION) gives incorrect result with
+ non-scalar precision parameter
+- GH#6964: Table returning function: Cannot access column descriptor
+- GH#6965: Crash when using distinct on the result of a table returning
+ function
+- GH#7108: Monetdb crashes on query execution
+
+* Mon May 9 2022 Sjoerd Mullender <[email protected]> - 11.37.13-20220509
+- gdk: Improve the heuristic for growing the result bat in a rangejoin.
+- gdk: Improved management of bats around commit time, both at the SQL level
+ (write-ahead log) and low level (so-called subcommit).
+- gdk: Improved BATproject for string bats.
+- gdk: Improved low-level algorithm selection in join.
+
+* Mon May 9 2022 Sjoerd Mullender <[email protected]> - 11.37.13-20220509
+- sql: Print current query when using CALL
+ logging.setcomplevel('SQL_EXECUTION', 'INFO');
+- sql: Comments inside queries are now available in the sys.queue
+ function/view.
+
+* Mon May 3 2021 Sjoerd Mullender <[email protected]> - 11.37.13-20220509
+- gdk: A bug that would very occasionally produce an error "strPut: incorrectly
+ encoded UTF-8", even when no incorrectly coded characters are used
+ at all, has been fixed. It was the result of a rare combination of
+ strings having been added to the column that caused essentially an
+ off-by-one type of error to occur.
+
+* Mon May 3 2021 Sjoerd Mullender <[email protected]> - 11.37.13-20220509
+- merovingian: When stopping monetdbd using the `monetdbd stop' command, this
command
+ now waits for 5 seconds longer than the exittimeout value before it
+ kills the monetdbd daemon instead of only 30 seconds total (or until
+ that daemon stops earlier). This gives the daemon enough time to
+ terminate the mserver5 processes that it is managing. If exittimeout
+ is negative, the daemon and the monetdbd process initiating the stop
+ wait indefinitely until the mserver5 processes have stopped.
+
+* Mon May 3 2021 Sjoerd Mullender <[email protected]> - 11.37.13-20220509
+- sql: A bug where a sequence of TRUNCATE TABLE and COPY INTO the just
+ truncated table would result in success being reported to both queries,
+ but the table still being empty afterwards, has been fixed.
+
* Thu Jul 23 2020 Sjoerd Mullender <[email protected]> - 11.37.11-20200723
- Rebuilt.
- BZ#6917: Decimal parsing fails
@@ -1540,4080 +1589,3 @@ fi
large in-value-lists generate large MAL plans. This is now no longer
the case.
-* Fri Aug 30 2019 Sjoerd Mullender <[email protected]> - 11.33.11-20190830
-- Rebuilt.
-- BZ#6749: mserver5 restart aborts/segfaults after dropping column
- with constraint
-
-* Tue Aug 20 2019 Sjoerd Mullender <[email protected]> - 11.33.9-20190820
-- Rebuilt.
-- BZ#6571: Jdbc connection hangs
-- BZ#6693: mix of long and short queries make JDBC-driver hang
-- BZ#6741: report no such table when execute “alter table tb1 rename
- to tb2” according to using mapi
-- BZ#6744: CREATE SEQUENCE seq; fails
-- BZ#6748: MonetDB "forgets" columns after ALTER TABLE statements
-- BZ#6751: ODBC driver(11.33.3) Seg Faults when "fn ucase" is used in SQL
-
-* Tue Aug 20 2019 Sjoerd Mullender <[email protected]> - 11.33.9-20190820
-- sql: Many fixes for using the server in a highly concurrent setting with
- many clients doing read-only queries mixed with clients doing updating
- queries.
-
-* Wed Aug 07 2019 Panagiotis Koutsourakis <[email protected]> -
11.33.7-20190807
-- Rebuilt.
-
-* Thu Aug 01 2019 Panagiotis Koutsourakis <[email protected]> -
11.33.5-20190801
-- Rebuilt.
-- BZ#6697: Duplicate expressions not eliminated with long CASE statement
-- BZ#6701: When changing the schema name of a table, referencing rows
- from sys.columns, sys.keys and more tables are not removed
-- BZ#6703: SQL optimizer enters loop and goes into stack overflow
-- BZ#6706: prepare doesn't recognize merge statement
-- BZ#6712: Where clause with cast ignores sub-select
-- BZ#6713: COPY INTO FROM 'file.xz' does not work
-- BZ#6714: Assertion failure in rel_select.c for correlated subquery in
- aggregation query (with group by and having and order by and limit)
-- BZ#6715: Assertion failure in rel_bin.c for MERGE INTO command
-- BZ#6716: COPY INTO does not load UTF8 encoded text
-- BZ#6718: Can't copy table into another table with constraints
- (mkey.bulk_rotate_xor_hash)
-- BZ#6720: Compilation issues on gcc 9.1.1 [-Werror=stringop-truncation]
-- BZ#6721: Possibly incorrect call to pcre_exec
-- BZ#6725: Prepare statement on non-existing function crashes
-- BZ#6728: SELECT DISTINCT not removing duplicates
-- BZ#6729: Creating a table with duplicate column name should not
- be possible
-- BZ#6730: sys.stop or sys.pause a INSERT query triggers "BATproject:
- does not match always"
-- BZ#6736: Unexpected query result with merge tables and view after
- upgrade
-- BZ#6738: issue with window functions and hugeint type coercion
-
-* Mon Jul 15 2019 Sjoerd Mullender <[email protected]> - 11.33.5-20190801
-- gdk: We now look at the limits imposed by cgroups and the setrlimit system
- call to initialize some internal values related to how much (virtual)
- memory we think is available.
-
-* Fri Jul 12 2019 Sjoerd Mullender <[email protected]> - 11.33.5-20190801
-- buildtools: Removed restriction on using combinations of --enable-assert,
- --enable-debug, and --enable-optimize. --enable-debug adds a -g (or
- -even -g3) option, --enable-debug=gdb adds a -ggdb3 flag (for GCC);
- --enable-optimize adds a bunch of optimization flags; --disable-debug
- (or --enable-debug=no) removes any -g flags; --disable-optimize
- removes any -O flags; --enable-optimize=auto leaves the optimization
- flags untouched.
-
-* Fri Jun 7 2019 Sjoerd Mullender <[email protected]> - 11.33.5-20190801
-- sql: Changed the internal representation of RANGE MINVALUE and RANGE MAXVALUE
- in MERGE TABLE partitions. Before, the limits were represented by
- the smallest and largest value of the domain of the column, now these
- are represented by a NULL value. This has the added benefit that if
- you use TO RANGE MAXVALUE, the largest value of the domain is included
- in the partition (before it wasn't). Also, these new limits now work
- for any ordered type, so including VARCHAR.
-
-* Fri Apr 26 2019 Sjoerd Mullender <[email protected]> - 11.33.3-20190426
-- Rebuilt.
-- BZ#6647: Add suport to Python 3 on Windows
-- BZ#6696: Re-use of MAL explain plans with complex type coercions
-
-* Fri Apr 05 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- Rebuilt.
-- BZ#2403: stream: http read support in streams
-- BZ#2416: GDK: file/dir creation mask
-- BZ#2478: SQL: rename columns
-- BZ#2496: SQL: implement greatest / least
-- BZ#3384: Auxiliary window functions
-- BZ#3416: log() SQL function only supports natural logarithm
-- BZ#3448: Make lbatomic_ops optional if installed
-- BZ#3520: Add support for scalar function LN(num)
-- BZ#3530: sigabort on window aggr function
-- BZ#3567: Add support for: ALTER TABLE [schema1.]oldtablename RENAME [TO]
- [schema2.]newtablename
-- BZ#3743: DELETE FROM merge table not supported.
-- BZ#3832: Cannot use expressions in GROUP BY clause
-- BZ#3946: Expose C log2 function to SQL
-- BZ#4056: mapi_timeout is not implemented
-- BZ#6181: comments cause error with return in function
-- BZ#6326: Eliminate unused UNION tables
-- BZ#6347: Mserver returns with "memory exhausted in" error if query
- size exceeds 2.5MB
-- BZ#6402: JDBC: Support for Connection.prepareCall
-- BZ#6475: Remove unused SQL global variable "history"
-- BZ#6588: Table aliasing are not supported in SQL update queries
-- BZ#6591: Name mangling in the SQL catalog results in ambiguity
-- BZ#6608: Sqlitelogictest error message in group by with coalesce
-- BZ#6609: Rename Schema in MonetDB
-- BZ#6636: sys.queue() extension: allow DBA to see all running queries
-- BZ#6671: Error when running user function on merge table with remote
- part
-- BZ#6674: R UDF with Date type fails to convert RAPI
-- BZ#6676: Max data length of 2048 for column sys._tables.query is too
- small for the actual data (2811 for view sys.ids)
-- BZ#6678: Binding NULL parameter to parametrized query results in syntax
- error on execution
-- BZ#6680: Copy cannot open CSV file if systemctl enabled
-- BZ#6684: Inserting into a replica table crashes the server
-- BZ#6685: adding a view to a merge table gives unexpected behaviour
-- BZ#6690: Unable to fetch empty string with ODBC driver
-
-* Tue Mar 19 2019 Panagiotis Koutsourakis <[email protected]> -
11.33.1-20190405
-- merovingian: Added a new database property named `profilerbeatfreq`. Its
value,
- <freq>, should be an integer and, if it is set the command
- `profilerstart` will call stethoscope with this value as the
- argument to -b. This will instruct stethoscope to collect heartbeat
- events from the MonetDB server every <freq> milliseconds. Please note
- that no type checking is done, and if
- <freq> is not an integer, stethoscope will silently ignore it.
-
-* Tue Mar 19 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- buildtools: We now use the C11 atomic operations if available, although
- libatomic_ops is still used if present and not disabled on the configure
- command line.
-
-* Tue Mar 19 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- gdk: During processing, we now try to maintain the smallest and largest
- values that occur in a BAT. This information is not saved across
- server restarts.
-
-* Tue Mar 19 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- selinux: There is one tunable parameter, mserver5_can_read_home, which can
- be set using "setsebool -P mserver5_can_read_home=true" to allow an
- mserver5 process started by monetdbd under the control of systemd to
- read files in users' home directories.
-
-* Fri Feb 8 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- monetdb5: Changed the way blobs are ordered. Before, shorter blobs came
before
- longer, now the contents is compared first.
-
-* Mon Jan 28 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- sql: Implemented two-argument least/greatest functions. If one argument
- is NULL, the functions return the other value, otherwise they return
- the least/greatest of the two arguments.
-
-* Thu Jan 24 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- sql: Implemented SQL2003 natural logarithm function: ln(num_expr).
-
-* Wed Jan 23 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- monetdb5: Removed function blob.tostring() since it cannot guarantee that the
- resulting string is properly encoded in UTF-8.
-
-* Wed Jan 23 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- sql: Function octet_length now also accepts a BLOB argument and returns
- the length of the BLOB (i.e. the same as length when called with a
- BLOB argument).
-
-* Tue Jan 22 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- monetdb5: Removed the type "sqlblob", changed the external format of the type
- "blob" to be like what "sqlblob" used to be. In other words, the
- "blob" type is now SQL-compatible.
-
-* Tue Jan 22 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- sql: Implemented length(blob) and comparison between blobs.
-- sql: Implemented a two argument function log which calculates the logarithm
- of the first argument using the second argument as base.
-- sql: Next to the functions log (natural logarithm) and log10 (base 10
- logarithm), there is now also log2 (base 2 logarithm).
-
-* Fri Jan 18 2019 Sjoerd Mullender <[email protected]> - 11.33.1-20190405
-- sql: Removed unused global SQL variable "history".
-
-* Fri Jan 4 2019 Pedro Ferreira <[email protected]> -
11.33.1-20190405
-- sql: Allow usage of custom expressions in GROUP BY and PARTITION BY
- clauses. The same expressions can be used in the projection phase as
- long as it is exactly the same used in the grouping clause (textual
- lookup is performed). As an example the query:
- SELECT col1*2 FROM t1 GROUP BY col1*2; is correct, while
- SELECT sin(col1+5) FROM t1 GROUP BY col1*2; is wrong.
-- sql: Allow usage of WITH clauses in insert, update, delete and merge
- statements.
-
-* Fri Jan 4 2019 Pedro Ferreira <[email protected]> -
11.33.1-20190405
-- sql: Implemented merge statements from SQL:2003 standard. Using a source
- relation R, a target table T is updating depending on the result of
- the merge. In case of a match, the table T's row is either updated
- or deleted with R's row. In a non-match case, R's row is inserted
- into T. The grammar is the follows:
- > MERGE INTO target [ [AS] ident ] USING source ON search_condition
- { WHEN MATCHED [ AND search_condition ] THEN
- { UPDATE SET assignment_list | DELETE } } |
- { WHEN NOT MATCHED [ AND search_condition ] THEN
- INSERT [ column_list ] [ { DEFAULT VALUES | VALUES row_values } ] }
-- sql: Added possibility to change the schema of a table with the syntax:
- > ALTER TABLE [ IF EXISTS ] qname SET SCHEMA ident
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
