Changeset: acb6e2a6951d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/acb6e2a6951d
Modified Files:
sql/server/rel_dump.c
sql/storage/store.c
Branch: ordered-set-aggregates
Log Message:
merged with default
diffs (truncated from 873 to 300 lines):
diff --git a/.github/workflows/linux.yml b/.github/workflows/linux.yml
--- a/.github/workflows/linux.yml
+++ b/.github/workflows/linux.yml
@@ -48,7 +48,12 @@ jobs:
ref: ${{ github.ref }}
- name: install pymonetdb cryptography
+ run: pip3 install --user --upgrade pymonetdb cryptography
+ if: runner.os != 'macOS'
+
+ - name: install pymonetdb cryptography
run: pip3 install --user --break-system-packages --upgrade pymonetdb
cryptography
+ if: runner.os == 'macOS'
- name: make MonetDB on linux
run: |
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -833,3 +833,4 @@ cde7d8f7c99540a8c95856df052a9f123b0c1643
ae474f7fda0a3f2ebefc6c0b2cd969ef0854fad1 Aug2024_1
dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_3
dce400b68239412b1835fb28bd183bf50f5e8692 Aug2024_release
+ab5d60be21cd1c65e9de476d71a86c2995f70785 Aug2024_5
diff --git a/ChangeLog.Aug2024 b/ChangeLog.Aug2024
--- a/ChangeLog.Aug2024
+++ b/ChangeLog.Aug2024
@@ -1,10 +1,3 @@
# ChangeLog file for devel
# This file is updated with Maddlog
-* Thu Oct 17 2024 Niels Nes <[email protected]>
-- Changed generic Decimal handling (ie without digits/scale), old cased
- mapped always into dec(18,3) now this is only done in case of create of
- a column. In other cases the coercion to the correct decimal type is
- based on the input data type. For *api (LANG*PY/C(pp)/R) we no longer
- allow generic decimal type in the function definitions.
-
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -95,7 +95,7 @@ Group: Applications/Databases
License: MPL-2.0
URL: https://www.monetdb.org/
BugURL: https://github.com/MonetDB/MonetDB/issues
-Source:
https://www.monetdb.org/downloads/sources/Aug2024/MonetDB-%{version}.tar.bz2
+Source:
https://www.monetdb.org/downloads/sources/Aug2024-SP1/MonetDB-%{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
@@ -989,6 +989,57 @@ rm "${RPM_BUILD_ROOT}"%{_unitdir}/monetd
%endif
%changelog
+* Thu Oct 24 2024 Sjoerd Mullender <[email protected]> - 11.51.5-20241024
+- Rebuilt.
+- GH#7281: UDFs defined at compile time in a user schema should not become
+ system functions
+- GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW`
+- GH#7567: creating remote table from subquery crashes the server
+- GH#7569: Column of temporary table changes when another is updated
+- GH#7570: BUG in the "str_to_timestamp" function
+- GH#7571: Crash when integer overflow in `ORDER BY`
+- GH#7572: column max length is not stored as specified and accepted at
+ creation time
+- GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with
+ restart.
+- GH#7576: unescaping UTF-16 code units goes wrong in json.text
+- GH#7577: Crash when using `CHECK` constraint
+- GH#7580: statistics optimizer handles date difference incorrectly
+- GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN
+ EXISTS (..)
+- GH#7583: Query slowdown after deleting rows from large table
+- GH#7584: SO_KEEPALIVE should be configured sensibly
+- GH#7585: rel2bin_join: Assertion `sql->session->status == -10' failed.
+- GH#7587: Line/row numbers get out of sync with COPY INTO .. BEST EFFORT
+
+* Mon Oct 21 2024 Lucas Pereira <[email protected]> -
11.51.5-20241024
+- sql: Improve casting to generic decimal type by choosing a better fit for
+ precision and scale instead of defaulting to 18 and 3, respectively.
+
+* Thu Oct 17 2024 Sjoerd Mullender <[email protected]> - 11.51.5-20241024
+- sql: When for whatever reason the upgrade code produces an error, we now
+ exit the server. Before the server would limp on with what is basically
+ a broken database.
+
+* Mon Oct 14 2024 stefanos mavros <[email protected]> - 11.51.5-20241024
+- monetdb5: The server prints out an informative message for the case of a
graceful
+ termination.
+
+* Mon Oct 7 2024 Joeri van Ruth <[email protected]> -
11.51.5-20241024
+- merovingian: Tweak socket parameters to simulate network activity on client
connections.
+ This prevents firewalls from killing connections that seem idle but are
+ actually waiting for a long-running query. Can be controlled with a new
+ 'keepalive' option to monetdbd.
+
+* Thu Sep 26 2024 Martin van Dinther <[email protected]>
- 11.51.5-20241024
+- sql: Improved the violation message of CHECK constraints when violated. It
+ now includes the schema name of the constraint and the check clause.
+
+* Fri Aug 23 2024 Joeri van Ruth <[email protected]> -
11.51.5-20241024
+- sql: Increase the buffer size used by hot snapshot from 64kiB to 1MiB,
+ and make it configurable through setting 'hot_snapshot_buffer_size'.
+ It must be a multiple of 512.
+
* Mon Aug 19 2024 Sjoerd Mullender <[email protected]> - 11.51.3-20240819
- Rebuilt.
- GH#7562: Assertion failure when comparing `INTERVAL` value
diff --git a/cmake/monetdb-versions.cmake b/cmake/monetdb-versions.cmake
--- a/cmake/monetdb-versions.cmake
+++ b/cmake/monetdb-versions.cmake
@@ -44,20 +44,20 @@ set(MONETDB_VERSION "${MONETDB_VERSION_M
# common/options and common/utils)
set(GDK_VERSION_MAJOR "29")
set(GDK_VERSION_MINOR "0")
-set(GDK_VERSION_PATCH "0")
+set(GDK_VERSION_PATCH "1")
set(GDK_VERSION
"${GDK_VERSION_MAJOR}.${GDK_VERSION_MINOR}.${GDK_VERSION_PATCH}")
# version of the MAPI library (subdirectory clients/mapilib)
set(MAPI_VERSION_MAJOR "27")
set(MAPI_VERSION_MINOR "0")
-set(MAPI_VERSION_PATCH "0")
+set(MAPI_VERSION_PATCH "1")
set(MAPI_VERSION
"${MAPI_VERSION_MAJOR}.${MAPI_VERSION_MINOR}.${MAPI_VERSION_PATCH}")
# version of the MONETDB5 library (subdirectory monetdb5, not including
# extras, and tools/utils/msabaoth.[ch])
set(MONETDB5_VERSION_MAJOR "36")
set(MONETDB5_VERSION_MINOR "0")
-set(MONETDB5_VERSION_PATCH "1")
+set(MONETDB5_VERSION_PATCH "2")
set(MONETDB5_VERSION
"${MONETDB5_VERSION_MAJOR}.${MONETDB5_VERSION_MINOR}.${MONETDB5_VERSION_PATCH}")
# version of the MONETDBE library (subdirectory tools/monetdbe)
@@ -75,5 +75,5 @@ set(STREAM_VERSION "${STREAM_VERSION_MAJ
# version of the SQL library (subdirectory sql)
set(SQL_VERSION_MAJOR "15")
set(SQL_VERSION_MINOR "0")
-set(SQL_VERSION_PATCH "1")
+set(SQL_VERSION_PATCH "2")
set(SQL_VERSION
"${SQL_VERSION_MAJOR}.${SQL_VERSION_MINOR}.${SQL_VERSION_PATCH}")
diff --git a/debian/changelog b/debian/changelog
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,75 @@
+monetdb (11.51.5) unstable; urgency=low
+
+ * Rebuilt.
+ * GH#7281: UDFs defined at compile time in a user schema should not become
+ system functions
+ * GH#7563: Unexpected result when using `IS DISTINCT FROM` in `VIEW`
+ * GH#7567: creating remote table from subquery crashes the server
+ * GH#7569: Column of temporary table changes when another is updated
+ * GH#7570: BUG in the "str_to_timestamp" function
+ * GH#7571: Crash when integer overflow in `ORDER BY`
+ * GH#7572: column max length is not stored as specified and accepted at
+ creation time
+ * GH#7575: Incorrect BAT properties after mmapped BAT "leaks" to disk with
+ restart.
+ * GH#7576: unescaping UTF-16 code units goes wrong in json.text
+ * GH#7577: Crash when using `CHECK` constraint
+ * GH#7580: statistics optimizer handles date difference incorrectly
+ * GH#7582: SIGSEGV when creating a SQL function with RETURN CASE WHEN
+ EXISTS (..)
+ * GH#7583: Query slowdown after deleting rows from large table
+ * GH#7584: SO_KEEPALIVE should be configured sensibly
+ * GH#7585: rel2bin_join: Assertion `sql->session->status == -10' failed.
+ * GH#7587: Line/row numbers get out of sync with COPY INTO .. BEST EFFORT
+
+ -- Sjoerd Mullender <[email protected]> Thu, 24 Oct 2024 14:18:25 +0200
+
+monetdb (11.51.5) unstable; urgency=low
+
+ * sql: Improve casting to generic decimal type by choosing a better fit for
+ precision and scale instead of defaulting to 18 and 3, respectively.
+
+ -- Lucas Pereira <[email protected]> Mon, 21 Oct 2024
14:18:25 +0200
+
+monetdb (11.51.5) unstable; urgency=low
+
+ * sql: When for whatever reason the upgrade code produces an error, we now
+ exit the server. Before the server would limp on with what is basically
+ a broken database.
+
+ -- Sjoerd Mullender <[email protected]> Thu, 17 Oct 2024 14:18:25 +0200
+
+monetdb (11.51.5) unstable; urgency=low
+
+ * monetdb5: The server prints out an informative message for the case of a
graceful
+ termination.
+
+ -- stefanos mavros <[email protected]> Mon, 14 Oct 2024 14:18:25 +0200
+
+monetdb (11.51.5) unstable; urgency=low
+
+ * merovingian: Tweak socket parameters to simulate network activity on
client connections.
+ This prevents firewalls from killing connections that seem idle but are
+ actually waiting for a long-running query. Can be controlled with a new
+ 'keepalive' option to monetdbd.
+
+ -- Joeri van Ruth <[email protected]> Mon, 7 Oct 2024
14:18:25 +0200
+
+monetdb (11.51.5) unstable; urgency=low
+
+ * sql: Improved the violation message of CHECK constraints when violated. It
+ now includes the schema name of the constraint and the check clause.
+
+ -- Martin van Dinther <[email protected]> Thu, 26 Sep
2024 14:18:25 +0200
+
+monetdb (11.51.5) unstable; urgency=low
+
+ * sql: Increase the buffer size used by hot snapshot from 64kiB to 1MiB,
+ and make it configurable through setting 'hot_snapshot_buffer_size'.
+ It must be a multiple of 512.
+
+ -- Joeri van Ruth <[email protected]> Fri, 23 Aug 2024
14:18:25 +0200
+
monetdb (11.51.3) unstable; urgency=low
* Rebuilt.
diff --git a/documentation/source/manual_pages/mserver5.rst.in
b/documentation/source/manual_pages/mserver5.rst.in
--- a/documentation/source/manual_pages/mserver5.rst.in
+++ b/documentation/source/manual_pages/mserver5.rst.in
@@ -167,13 +167,16 @@ MSERVER5 OPTIONS
**268435456**
(HEAPMASK) trace/debug HEAPextend; used only for development &
- debugging **536870912** (FORCEMITOMASK) forcefully activate
- mitosis even on small tables, i.e., split small tables in as many
- (tiny) pieces as there are cores (threads) available; this allows
- us to test mitosis functionality without requiring large data sets
- (— at the expense of a potentially significant interpretation
- overhead for unnecessarily large plans); used only for development
- & testing; set automatically by Mtest.py
+ debugging
+
+ **536870912**
+ (FORCEMITOMASK) forcefully activate mitosis even on small tables,
+ i.e., split small tables in as many (tiny) pieces as there are
+ cores (threads) available; this allows us to test mitosis
+ functionality without requiring large data sets (— at the expense
+ of a potentially significant interpretation overhead for
+ unnecessarily large plans); used only for development & testing;
+ set automatically by Mtest.py
**--algorithms**
Equivalent to **--debug=**\ *(ALGOMASK)*.
diff --git a/gdk/gdk.h b/gdk/gdk.h
--- a/gdk/gdk.h
+++ b/gdk/gdk.h
@@ -390,6 +390,7 @@ gdk_export _Noreturn void GDKfatal(_In_z
#define IOMASK (1U<<4)
#define BATMASK (1U<<5)
#define PARMASK (1U<<7)
+#define TESTINGMASK (1U<<8)
#define TMMASK (1U<<9)
#define TEMMASK (1U<<10)
#define PERFMASK (1U<<12)
diff --git a/gdk/gdk_logger.c b/gdk/gdk_logger.c
--- a/gdk/gdk_logger.c
+++ b/gdk/gdk_logger.c
@@ -2350,7 +2350,7 @@ log_new(int debug, const char *fn, const
lng max_file_age = GDKgetenv_int("wal_max_file_age", 600);
lng max_file_size = 0;
- if (GDKdebug & FORCEMITOMASK) {
+ if (GDKdebug & TESTINGMASK) {
max_file_size = 2048; /* 2 KiB */
} else {
const char *max_file_size_str = GDKgetenv("wal_max_file_size");
@@ -2548,7 +2548,7 @@ log_create(int debug, const char *fn, co
static logged_range *
log_next_logfile(logger *lg, ulng ts)
{
- int m = (ATOMIC_GET(&GDKdebug) & FORCEMITOMASK) ? 1000 : 100;
+ int m = (ATOMIC_GET(&GDKdebug) & TESTINGMASK) ? 1000 : 100;
if (!lg->pending || !lg->pending->next)
return NULL;
rotation_lock(lg);
diff --git a/gdk/gdk_strimps.c b/gdk/gdk_strimps.c
--- a/gdk/gdk_strimps.c
+++ b/gdk/gdk_strimps.c
@@ -94,7 +94,7 @@
#define STRIMP_HEADER_SIZE 64
#define STRIMP_PAIRS (STRIMP_HEADER_SIZE - 1)
#define STRIMP_CREATION_THRESHOLD \
- ((BUN) ((ATOMIC_GET(&GDKdebug) & FORCEMITOMASK)? 100 : 5000))
+ ((BUN) ((ATOMIC_GET(&GDKdebug) & TESTINGMASK)? 100 : 5000))
typedef struct {
#ifdef UTF8STRIMPS
diff --git a/gdk/gdk_tracer.c b/gdk/gdk_tracer.c
--- a/gdk/gdk_tracer.c
+++ b/gdk/gdk_tracer.c
@@ -605,7 +605,7 @@ GDKtracer_log(const char *file, const ch
if (interrupted)
reinit();
- if (level <= M_WARNING || (ATOMIC_GET(&GDKdebug) & FORCEMITOMASK)) {
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
