Script Language Container is updated to 11.3.0 and the 'PYTHON3' alias for UDFs was updated to Python 3.12

Details

Detail name Value
Changelog Number 32006
Type Improvement
Status Resolved
Fix Versions Exasol 2025.1.16
Resolution Date 2026-08-28

Background

The Exasol database allows users to create and run scripts (User Defined Functions) in several languages.

The database component implementing support for those languages is called Script Language Container (SLC).

There are containers built into database installations and also custom ones that could be prepared by users on-demand and uploaded to BucketFS for further use. See Adding New Packages to Existing Script Languages for more details.

Improvement

Release 11.3.0 of the Script-Languages-Container was integrated, which provides security-related updates of several Ubuntu and PyPi packages. Lists of changed packages in SLC since SLC version 11.2.0 can be found at:

Package Version Comparison between Standard-exasol-all flavor in 11.2.0 and Standard-exasol-all flavor in 11.3.0

Changed behavior

The Python language for the default `PYTHON3` alias in UDFs was updated from Python3.10 to Python3.12. With the change to Python3.12, the base image of the Script-Languages-Container (SLC) was updated to Ubuntu 24.04 from Ubuntu 22.04. For that reason, the package version can have changed dramatically from Python3.10 SLC. The Python3.10 SLC will be removed at the end of October 2026 because this is the official end-of-life for Python3.10 (https://devguide.python.org/versions/). In this version of the database, the Python3.10 SLC is still available and can be explicitly configured again. Use the following command either for the SESSION or SYSTEM to change back to Python3.10: ALTER SESSION|SYSTEM SET SCRIPT_LANGUAGES='PYTHON3=builtin_python310 R=builtin_r JAVA=builtin_java'; To activate Python 3.12 again, use: ALTER SESSION|SYSTEM SET SCRIPT_LANGUAGES='PYTHON3=builtin_python3 R=builtin_r JAVA=builtin_java'; You can also create new language aliases when you want to try both in parallel: ALTER SESSION|SYSTEM SET SCRIPT_LANGUAGES='PYTHON3=builtin_python3 PYTHON310=builtin_python310 PYTHON312=builtin_python312 R=builtin_r JAVA=builtin_java'; Furthermore, release 11.3.0 of the Script-Languages-Container was integrated, which provides security-related updates of several Ubuntu and PyPi packages.