Changeset: 57caa0f16600 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/57caa0f16600
Removed Files:
sql/backends/monet5/UDF/rapi/rapi.c
Modified Files:
clients/Tests/MAL-signatures-hge.test
clients/Tests/MAL-signatures.test
clients/Tests/exports.stable.out
clients/mapiclient/dump.c
gdk/gdk_calc.c
monetdb5/mal/mal_namespace.h
sql/backends/monet5/rel_bin.c
sql/backends/monet5/sql.c
sql/backends/monet5/sql_scenario.c
sql/backends/monet5/sql_statement.c
sql/backends/monet5/sql_upgrades.c
sql/include/sql_catalog.h
sql/include/sql_relation.h
sql/server/rel_psm.c
sql/server/rel_semantic.c
sql/server/sql_mvc.h
sql/server/sql_parser.y
sql/server/sql_scan.c
sql/server/sql_tokens.h
sql/storage/store.c
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
sql/test/testdb/Tests/load.test
testing/Mtest.py.in
Branch: ustr
Log Message:
Merge with default branch.
diffs (truncated from 30329 to 300 lines):
diff --git a/.clang-format b/.clang-format
--- a/.clang-format
+++ b/.clang-format
@@ -91,7 +91,6 @@ StatementAttributeLikeMacros:
- mvc_export
- netcdf_export
- orderidx_export
- - pyapi_export
- shp_export
- sql5_export
- sql_export
diff --git a/.github/workflows/linux.yml b/.github/workflows/linux.yml
--- a/.github/workflows/linux.yml
+++ b/.github/workflows/linux.yml
@@ -46,7 +46,7 @@ jobs:
runs-on: ${{ matrix.os }}
steps:
- name: Checkout
- uses: actions/checkout@v4
+ uses: actions/checkout@v6
with:
ref: ${{ github.ref }}
@@ -74,8 +74,6 @@ jobs:
cd build
cmake .. \
-DCMAKE_INSTALL_PREFIX=$HOME/MDB \
- -DPY3INTEGRATION=OFF \
- -DRINTEGRATION=OFF \
-DCMAKE_BUILD_TYPE=Release \
-DASSERT=OFF \
-DCMAKE_C_COMPILER=${{ matrix.c_compiler }} \
@@ -93,8 +91,6 @@ jobs:
cd build
cmake .. \
-DCMAKE_INSTALL_PREFIX=$HOME/MDB \
- -DPY3INTEGRATION=OFF \
- -DRINTEGRATION=OFF \
-DCMAKE_BUILD_TYPE=Release \
-DASSERT=OFF \
-DCMAKE_C_COMPILER=${{ matrix.c_compiler }} \
@@ -109,8 +105,6 @@ jobs:
cd build
cmake .. \
-DCMAKE_INSTALL_PREFIX=$HOME/MDB \
- -DPY3INTEGRATION=OFF \
- -DRINTEGRATION=OFF \
-DCMAKE_BUILD_TYPE=Release \
-DASSERT=OFF \
-DCMAKE_C_COMPILER=${{ matrix.c_compiler }} \
@@ -130,7 +124,7 @@ jobs:
run: |
mkdir build
cd build
- cmake .. -DCMAKE_INSTALL_PREFIX=C:\MDB
-DCMAKE_TOOLCHAIN_FILE=C:\vcpkg\scripts\buildsystems\vcpkg.cmake
-DPY3INTEGRATION=OFF -DRINTEGRATION=OFF -DCMAKE_BUILD_TYPE=Release
-DASSERT=OFF -DCMAKE_C_COMPILER=${{ matrix.c_compiler }} -DCMAKE_SUMMARY=ON
+ cmake .. -DCMAKE_INSTALL_PREFIX=C:\MDB
-DCMAKE_TOOLCHAIN_FILE=C:\vcpkg\scripts\buildsystems\vcpkg.cmake
-DCMAKE_BUILD_TYPE=Release -DASSERT=OFF -DCMAKE_C_COMPILER=${{
matrix.c_compiler }} -DCMAKE_SUMMARY=ON
cmake --build . --target install
if: runner.os == 'Windows'
@@ -163,7 +157,7 @@ jobs:
- name: Tar files
run: tar -cvf mtests.tar mTests
- name: Publish mtest results
- uses: actions/upload-artifact@v4
+ uses: actions/upload-artifact@v7
with:
name: mtest-${{ github.sha }}-${{ matrix.os }}-${{ matrix.c_compiler
}}
path: mtests.tar
diff --git a/.hgtags b/.hgtags
--- a/.hgtags
+++ b/.hgtags
@@ -857,3 +857,4 @@ b4c2936c46f28ad6b3e59ed5a1a844726d521994
69f4fe2ad29b5d50d9ef06ad76639faaa60fcfa8 Dec2025_SP1_release
691e862e16ceb7f720536063ed6d3c2e3d11e33a Dec2025_5
691e862e16ceb7f720536063ed6d3c2e3d11e33a Dec2025_SP2_release
+1d742c123cb0e622d9a137b10bfbd7e4c446fde2 Dec2025_7
diff --git a/ChangeLog b/ChangeLog
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,6 +1,40 @@
# ChangeLog file for devel
# This file is updated with Maddlog
+* Mon Jun 22 2026 Sjoerd Mullender <[email protected]>
+- Removed support for LOADER FUNCTION. Since Python UDFs are not
+ supported anymore, the loader functions can also not be supported
+ anymore. It is no longer possible to create LOADER functions, nor is
+ it possible to use them. Upgrading to this version will succeed if
+ such functions exist. Use this query to find all affected functions:
+ `SELECT s.name, f.name FROM sys.functions f JOIN sys.schemas s ON s.id
+ = f.schema_id WHERE f.type = 7;`. These functions can then be dropped
+ manually using `DROP LOADER FUNCTION ...;`.
+
+* Fri Jun 19 2026 Sjoerd Mullender <[email protected]>
+- Removed embedded Python support. It is no longer possible to use
+ user-defined functions which are written in Python (i.e. using `CREATE
+ FUNCTION ... LANGUAGE PYTHON ...`). Upgrading to this version will
+ succeed if such functions are defined, but the cannot be used anymore.
+ Use this query to find all affected functions: `SELECT s.name, f.name
+ FROM sys.functions f JOIN sys.schemas s ON s.id = f.schema_id WHERE
+ f.language IN (6, 10);`. These functions can then be dropped manually.
+- Removed embedded R support. It is no longer possible to use
+ user-defined functions which are written in R (i.e. using `CREATE
+ FUNCTION ... LANGUAGE R ...`). Upgrading to this version will succeed
+ if such functions are defined, but they cannot be used anymore.
+ Use this query to find all affected functions: `SELECT s.name, f.name
+ FROM sys.functions f JOIN sys.schemas s ON s.id = f.schema_id WHERE
+ f.language = 3;`. These functions can then be dropped manually.
+- Removed embedded C support. It is no longer possible to use
+ user-defined functions which are written in C or C++ (i.e. using
+ `CREATE FUNCTION ... LANGUAGE C ...`). Upgrading to this version will
+ succeed if such functions are defined, but they cannot be used
+ anymore. Use this query to find all affected functions: `SELECT
+ s.name, f.name FROM sys.functions f JOIN sys.schemas s ON s.id =
+ f.schema_id WHERE f.language IN (4, 12);`. These functions can then
+ be dropped manually.
+
* Thu May 7 2026 Niels Nes <[email protected]>
- disallow casting /coercing from decimal to integers when the functions
work on bits (like xor, and, or, <<, >> etc)
diff --git a/ChangeLog-Archive b/ChangeLog-Archive
--- a/ChangeLog-Archive
+++ b/ChangeLog-Archive
@@ -1,6 +1,31 @@
# DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY
# This file contains past ChangeLog entries
+* Fri Jun 12 2026 Sjoerd Mullender <[email protected]> - 11.55.7-20260615
+- Fixed a number of race conditions.
+- Improved summing of floating point values in window functions.
+ The result is now as exact as floating point allows. This uses the
+ same algorithm that was already used in the floating sum aggregate.
+- Added a new tracer component MAL_INSTRUCTION to log MAL instructions
+ during execution.
+- Fixed calculation of integer averages when the simple summing of
+ values (before the sum is divided by the count) overflows. When it
+ does overflow we continue with a different algorithm, but the switch
+ was done incorrectly. Summation was done in 128 bit integers, so
+ overflow was exceedingly rare.
+- Fixed a race condition during server exit.
+- Improvements to the way execution of prepared statements are being
+ reported.
+
+* Tue May 12 2026 Lucas Pereira <[email protected]> -
11.55.7-20260615
+- Fix using --logging option of mserver5 to change component levels
+ that are also used by --debug option. For overlapping components,
+ component level change via --logging was being discarded.
+
+* Thu Apr 23 2026 Sjoerd Mullender <[email protected]> - 11.55.7-20260615
+- It is no longer allowed to run mserver5 or monetdbd as root. There are
+ important security concerns when these servers are run as root.
+
* Wed Mar 4 2026 Joeri van Ruth <[email protected]> -
11.55.5-20260403
- Suppress error messages in merovingian.log when incoming connections
are closed by the client before any I/O takes place.
diff --git a/ChangeLog.Dec2025 b/ChangeLog.Dec2025
--- a/ChangeLog.Dec2025
+++ b/ChangeLog.Dec2025
@@ -1,12 +1,3 @@
# ChangeLog file for devel
# This file is updated with Maddlog
-* Tue May 12 2026 Lucas Pereira <[email protected]>
-- Fix using --logging option of mserver5 to change component levels
- that are also used by --debug option. For overlapping components,
- component level change via --logging was being discarded.
-
-* Thu Apr 23 2026 Sjoerd Mullender <[email protected]>
-- It is no longer allowed to run mserver5 or monetdbd as root. There are
- important security concerns when these servers are run as root.
-
diff --git a/MonetDB.spec b/MonetDB.spec
--- a/MonetDB.spec
+++ b/MonetDB.spec
@@ -67,17 +67,6 @@
# operators. Otherwise the POSIX regex functions are used.
%bcond_without pcre
-# By default, include C integration
-%bcond_without cintegration
-
-%if %{fedpkgs}
-# By default, create the MonetDB-R package.
-%bcond_without rintegration
-%endif
-
-# By default, include Python 3 integration.
-%bcond_without py3integration
-
%if %{fedpkgs}
# By default, create the MonetDB-cfitsio package.
%bcond_without fits
@@ -93,7 +82,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/Dec2025-SP2/MonetDB-%{version}.tar.bz2
+Source:
https://www.monetdb.org/downloads/sources/Dec2025-SP3/MonetDB-%{version}.tar.bz2
# We need checkpolicy and selinux-policy-devel for the SELinux policy.
BuildRequires: systemd-rpm-macros
@@ -130,13 +119,6 @@ BuildRequires: pkgconfig(libpcre2-8)
%endif
BuildRequires: pkgconfig(zlib)
BuildRequires: pkgconfig(liblz4) >= 1.8
-%if %{with py3integration}
-BuildRequires: pkgconfig(python3) >= 3.5
-BuildRequires: python3dist(numpy)
-%endif
-%if %{with rintegration}
-BuildRequires: pkgconfig(libR)
-%endif
# optional packages:
# BuildRequires: pkgconfig(cmocka) # -DWITH_CMOCKA=ON
# BuildRequires: pkgconfig(gdal) # -DSHP=ON
@@ -456,6 +438,7 @@ developer.
%{_bindir}/smack01
%{_bindir}/sqlsample.php
%{_bindir}/sqlsample.pl
+%{_bindir}/sqlsample.py
%{_bindir}/streamcat
%{_bindir}/testcondvar
%endif
@@ -483,56 +466,6 @@ extensions for %{name}-server.
%{_libdir}/monetdb5*/lib_geom.so
%endif
-%if %{with rintegration}
-%package R
-Summary: Integration of MonetDB and R, allowing use of R from within SQL
-Group: Applications/Databases
-Requires: %{name}-server%{?_isa} = %{version}-%{release}
-
-%description R
-MonetDB is a database management system that is developed from a
-main-memory perspective with use of a fully decomposed storage model,
-automatic index management, extensibility of data types and search
-accelerators. It also has an SQL front end.
-
-This package contains the interface to use the R language from within
-SQL queries.
-
-NOTE: INSTALLING THIS PACKAGE OPENS UP SECURITY ISSUES. If you don't
-know how this package affects the security of your system, do not
-install it.
-
-%files R
-%defattr(-,root,root)
-%{_libdir}/monetdb5*/rapi.R
-%{_libdir}/monetdb5*/lib_rapi.so
-%endif
-
-%if %{with py3integration}
-%package python3
-Summary: Integration of MonetDB and Python, allowing use of Python from within
SQL
-Group: Applications/Databases
-Requires: %{name}-server%{?_isa} = %{version}-%{release}
-Requires: python3-numpy
-
-%description python3
-MonetDB is a database management system that is developed from a
-main-memory perspective with use of a fully decomposed storage model,
-automatic index management, extensibility of data types and search
-accelerators. It also has an SQL front end.
-
-This package contains the interface to use the Python language from
-within SQL queries. This package is for Python 3.
-
-NOTE: INSTALLING THIS PACKAGE OPENS UP SECURITY ISSUES. If you don't
-know how this package affects the security of your system, do not
-install it.
-
-%files python3
-%defattr(-,root,root)
-%{_libdir}/monetdb5*/lib_pyapi3.so
-%endif
-
%if %{with fits}
%package cfitsio
Summary: MonetDB: Add on module that provides support for FITS files
@@ -578,9 +511,6 @@ embedded library (%{name}-embedded).
%{_libdir}/libmonetdb5*.so.*
%{_libdir}/libmonetdbsql*.so*
%dir %{_libdir}/monetdb5-%{version}
-%if %{with cintegration}
-%{_libdir}/monetdb5*/lib_capi.so
-%endif
%{_libdir}/monetdb5*/lib_csv.so
%{_libdir}/monetdb5*/lib_generator.so
%{_libdir}/monetdb5*/lib_monetdb_loader.so
@@ -951,14 +881,11 @@ fi
-DCMAKE_INSTALL_RUNSTATEDIR=/run \
-DRELEASE_VERSION=ON \
-DASSERT=OFF \
- -DCINTEGRATION=%{?with_cintegration:ON}%{!?with_cintegration:OFF} \
-DFITS=%{?with_fits:ON}%{!?with_fits:OFF} \
-DGEOM=%{?with_geos:ON}%{!?with_geos:OFF} \
-DINT128=%{?with_hugeint:ON}%{!?with_hugeint:OFF} \
-DNETCDF=OFF \
-DODBC=ON \
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
