Changeset: a2c17e7d936e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a2c17e7d936e Modified Files: sql/backends/monet5/rel_bin.c sql/backends/monet5/sql.c sql/backends/monet5/sql_upgrades.c sql/server/rel_optimizer.c tools/monetdbe/monetdbe.c Branch: nospare Log Message:
merged diffs (truncated from 35484 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -791,3 +791,5 @@ cb4b3f021774b60ffd84c3004d341ec04de736f3 bd91504a03736565fb2dff13cd4c94c738e81aa0 Oct2020_release ac8254a47e87d0be9df2a623e2c2fcf67c0f982d Oct2020_7 ac8254a47e87d0be9df2a623e2c2fcf67c0f982d Oct2020_SP1_release +929f5e280bc1532a2bfaab127ca7915dc3b69a33 Oct2020_9 +929f5e280bc1532a2bfaab127ca7915dc3b69a33 Oct2020_SP2_release diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -84,7 +84,7 @@ Group: Applications/Databases License: MPLv2.0 URL: https://www.monetdb.org/ BugURL: https://bugs.monetdb.org/ -Source: https://www.monetdb.org/downloads/sources/Oct2020-SP1/%{name}-%{version}.tar.bz2 +Source: https://www.monetdb.org/downloads/sources/Oct2020-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 @@ -823,6 +823,35 @@ else fi %changelog +* Mon Jan 11 2021 Sjoerd Mullender <sjo...@acm.org> - 11.39.9-20210111 +- Rebuilt. +- GH#6862: mserver5: crashes under update_table() when calling lib_sql.so + ( max_clients = 2048) +- GH#7002: monetdb stop fails +- GH#7012: mclient enters an infinite loop when a file on the command line + does not exist +- GH#7013: Select * on grouped view: wrong error "cannot use non GROUP BY + column 'a1' in query results without an aggregate function" +- GH#7017: mal seems to leak in functions +- GH#7020: release an older savepoint causes "BATproject2: does not match + always" +- GH#7021: savepoints crash mserver5 +- GH#7022: transaction with an unreleased savepoint not properly persisted +- GH#7023: CREATE VIEW: SELECT: cannot use non GROUP BY column '%1' in + query results without an aggregate function +- GH#7024: DELETE FROM or TRUNCATE on freshly created table leads to + loosing all further inserts in same transaction +- GH#7030: DROP TABLE with AUTO_INCREMENT doesn't drop sequence causing + left-over dependency +- GH#7034: User with sysadmin role cannot create another user +- GH#7035: UPDATE and SELECT column privileges + +* Thu Dec 10 2020 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.39.9-20210111 +- sql: CREATE [OR REPLACE] TRIGGER schema_name.trigger_name is now disallowed, + because the trigger will be stored on the same schema as the table it + refers to. Use a schema-qualified on the table reference (ie ON clause) + when necessary. + * Wed Nov 18 2020 Sjoerd Mullender <sjo...@acm.org> - 11.39.7-20201118 - Rebuilt. - BZ#6890: Add support of xz/lzma (de)compression on MS Windows @@ -1359,4278 +1388,3 @@ fi thereby avoiding the interaction with other queries, but loosing insight of competing queries. The stethoscope should be used for that. -* Sat Feb 22 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.19-20200222 -- Rebuilt. -- BZ#6829: NTILE window function returns incorrect results - -* Fri Feb 21 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.17-20200221 -- Rebuilt. -- BZ#6827: CUME_DIST window function returns incorrect results - -* Mon Feb 17 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.15-20200217 -- Rebuilt. -- BZ#6817: running analyze on a schema which contains a stream table - stops with an error -- BZ#6819: functions do not persist - -* Wed Feb 12 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.13-20200212 -- Rebuilt. - -* Tue Feb 11 2020 Sjoerd Mullender <sjo...@acm.org> - 11.35.11-20200211 -- Rebuilt. -- BZ#6805: Using the cascade operator in a drop table statement ends in - an exit from the Monetdb shell. -- BZ#6807: Median_avg and quantile_avg ignore NULL values -- BZ#6815: query with ifthenelse() crashes mserver5 -- BZ#6816: Monetdb Crashes on INSERT statement after ALTER statement in - another connection - -* Wed Dec 18 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.9-20191218 -- Rebuilt. -- BZ#6804: DNS resolution of 0.0.0.0 fails on recent Ubuntus - -* Tue Dec 17 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.7-20191217 -- Rebuilt. - -* Thu Dec 12 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.5-20191212 -- Rebuilt. -- BZ#6723: columns aliases duplicates should not be allowed. automatic - aliasing required. -- BZ#6724: Prepare confuses types when more than one argument is used -- BZ#6726: Python aggregation does not create aggr_group when aggregating - over all rows -- BZ#6765: GRANT SELECT privilege on a subset of table columns results - in access denied error when selecting the same columns from the table -- BZ#6790: Count distinct giving wrong results -- BZ#6791: str_to_time('11:40', '%H:%M') creates wrong time value -- BZ#6792: JSON path compiler accepts invalid input -- BZ#6793: cast(interval second value to int or decimal) is wrong (by - a factor of 1000), cast(interval month value to decimal or floating - point) fails -- BZ#6794: external name fits.listdir not bound (sys.listdir) Fatal - error during initialization: -- BZ#6796: Incorrect crash time reported by monetdb tool after crash - of mserver5 -- BZ#6798: json.text off by one error - -* Mon Nov 25 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.3-20191125 -- Rebuilt. -- BZ#3533: SQL aggregate functions avg(), sum() and median() return an - error when used on a column with datatype interval second - -* Mon Nov 18 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- Rebuilt. -- BZ#6134: Query produces error: HEAPalloc: Insufficient space for HEAP - of 1168033427456 bytes. -- BZ#6613: LATERAL crash /.../rel_bin.c:1473: rel2bin_table: Assertion - `0' failed. -- BZ#6683: Bug in subselect -- BZ#6686: Bug in subselect (count function) -- BZ#6688: Bug in subselect (or condition) -- BZ#6689: Trying to improve the performance of SQL queries with a large - list of members in IN clause. -- BZ#6695: timestamp transformation -- BZ#6700: Monetdb Bugs in Subselect statements: -- BZ#6722: window functions issues -- BZ#6740: while upgrading the database from verison (MonetDB-11.27.13) - to (MonetDB-11.33.3) we are unable to bring up the database -- BZ#6754: in mclient a strang msg is reported after issueing command: - set schema sys; -- BZ#6755: Assertion failure in rel_bin.c -- BZ#6756: Error in optimizer garbageCollector on merge tables select -- BZ#6757: Double free or corruption (out) -- BZ#6758: SIGSEGV in __strcmp_sse2_unaligned() -- BZ#6759: Python JSON loader creates invalid data type for strings -- BZ#6761: Error: Program contains errors.:(NONE).multiplex -- BZ#6762: mserver5 crashes on (re-)start -- BZ#6764: mserver5 crashes with corruption, double free, invalid size - or invalid pointer -- BZ#6766: Missing bulk implementation for get_value and next_value calls -- BZ#6769: ProfilerStart is not threadsafe -- BZ#6771: R-devel -- BZ#6773: json.filter returns corrupted string when selecting JSON - null value -- BZ#6774: PROD aggregation gives wrong result -- BZ#6775: NOT IN with an AND containing an OR gives wrong result -- BZ#6776: Creating a table with a full outer join query gives type with - wrong digits on the joined key. -- BZ#6779: Using Windows Messages translation for errno error codes. -- BZ#6780: Wrong value of the rank function -- BZ#6781: Insert after index creation crash -- BZ#6783: AVG changes scale of its results -- BZ#6784: function sys.isauuid(string) should return false if string - value cannot be converted to a UUID - -* Mon Nov 4 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: Removed functions json.text(string) returns string and json.text(int) - returns string. Their MAL implementation didn't exist, so they were - meaningless. - -* Thu Oct 17 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- merovingian: Added "vmmaxsize" and "memmaxsize" mserver5 options to the daemon in - order to set mserver5's maximum virtual and committed memory - respectively. - -* Wed Sep 25 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- sql: Strings are now limited to 1GB, double-quoted tokens are limited to 2kB. - These sizes are bytes of (UTF-8 encoded) input data. - -* Mon Sep 23 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- sql: There are new aggregate functions sys.median_avg and sys.quantile_avg - that return the interpolated value if the median/quantile doesn't fall - exactly on a particular row. These functions always return a value - of type DOUBLE and only work for numeric types (various width integers - and floating point). - -* Sun Sep 8 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- gdk: BATcalcbetween and all its variants now have an extra bool parameter - "anti" to invert the test. - -* Thu Sep 5 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: The server "console" has been removed, as has the --daemon option. - The server now doesn't read from standard input anymore. The way to - stop a server is by sending it a TERM signal (on Linux/Unix) or by - sending it an interrupt signal (usually control-C -- on all - systems). - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: Added sys.deltas ("schema" string, "table" string, "column" string) - returns table ("values" bigint) system function which returns a single - column with 6 values: a flag indicating if the column's upper table is - cleared or not, the count of the RDONLY, RD_INS and RD_UPD_ID deltas - of the column itself, the number of deleted values of the column's - table, as well as the level of the current transaction in the - transaction level tree. It should be used for debugging purposes only. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: Implemented a function bat.diffcand to calculate difference of two - candidate lists. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: The mtime module was completely rewritten, the atom types date, - daytime, and timestamp were changed. Upgrade code for BATs - containing these types has been implemented. The old daytime type - used a 32 bit integer to record milliseconds since the start of the - day. The new daytime type uses a 64 bit integer to record - microseconds since the start of the day. The old date type recorded - days since or before the year 1. The new daytime type records the - day of the month and the number of months since the year -4712 - separately in a single 32 bit integer of which only 26 bits are - used. Dates now use the proleptic Gregorian calendar, meaning the - normal Gregorian callendar has been extended backward, and before - the year 1, we have the year 0. Both the old and new timestamp - types are a combination of a daytime and a date value, but since - those types have changed, the timestamp type has also changed. The - new date type has a smaller range than the old. The new date range - is from the year -4712 to the year 170049. During conversion of - date and timestamp columns, the dates are clamped to this range. -- monetdb5: The tzone and rule atom types have been removed. They were not used - by any code, and they were defined in a non-portable way. - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: Added "VALUES row_list" statement as a top SQL projection statement. - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- merovingian: Added ipv6 property to monetdbd properties to force IPv6 addresses - binding only. By default this property is false to allow IPv4 - addresses as well. - -* Fri Aug 30 2019 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com> - 11.35.1-20191118 -- monetdb5: Added "mapi_ipv6" property to monet_options to force ipv6 address - binding only. This property is inherited while forking from - monetdbd if it is also set there. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- gdk: All forms of BATcalcbetween and VARcalcbetween have extra bool arguments - for low inclusive, high inclusive and nils false. The latter causes - the result to be false instead of nil if the value being checked is nil. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.35.1-20191118 -- monetdb5: Removed (bat)calc.between_symmetric and changed (bat)calc.between - by adding a number of extra arguments, all of type :bit: symmetric, - low inclusive, high inclusive, nils false. - -* Fri Aug 30 2019 Aris Koning <aris.kon...@monetdbsolutions.com> - 11.35.1-20191118 -- sql: The implementation of in-expression now follows a join-based approach - instead of using iterative union/selects. This greatly improves - performance for large in-value-lists. Furthermore the old approach has - large in-value-lists generate large MAL plans. This is now no longer - the case. - -* Fri Aug 30 2019 Sjoerd Mullender <sjo...@acm.org> - 11.33.11-20190830 -- Rebuilt. -- BZ#6749: mserver5 restart aborts/segfaults after dropping column - with constraint - -* Tue Aug 20 2019 Sjoerd Mullender <sjo...@acm.org> - 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 <sjo...@acm.org> - 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 <kutsu...@monetdbsolutions.com> - 11.33.7-20190807 -- Rebuilt. - -* Thu Aug 01 2019 Panagiotis Koutsourakis <kutsu...@monetdbsolutions.com> - 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 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
