Motivation

Our CI testing matrix currently tests database versions that have reached end-of-life.

We should update it to test against currently supported versions to better align with production deployments and vendor
support lifecycles.

Problematic Versions (End-of-Life)

• MySQL 8.0: Extended support ends April 2026
• PostgreSQL 9, 10, 11: End-of-life since 2021-2023
• MariaDB 10.4: End-of-life since June 2024
• MySQL 5.6, 5.7: End-of-life since 2021 and 2023

Current vs. Proposed Versions

Proposed Solution - Updated Testing Matrix

JDK 11 - Baseline (7 jobs)

Single version per database for baseline compatibility:

• PostgreSQL: 14
• MySQL: 8.4 LTS
• MariaDB: 11.8 LTS
• MSSQL: 2019
• DB2: 12.1
• Oracle: 23ai (latest 23.x)
• Templates: (1 job)

JDK 25 - Comprehensive (10 jobs)

Multiple versions per database on latest JDK:

• PostgreSQL: 14, 16, 18
• MySQL: 8.4 LTS, 9.6
• MariaDB: 11.8 LTS
• MSSQL: 2019, 2022, 2025
• Oracle: 23ai (latest 23.x)

Total: 17 jobs (7 JDK 11 + 10 JDK 25)

Benefits

• Tests currently supported database versions
• Better alignment with production deployments
• Simplifies test infrastructure (removes version-specific workarounds)
• Comprehensive testing on JDK 25 (latest)
• Baseline testing on JDK 11 (minimum supported)

Scope

This change will not be backported to 4.x.
The 4.x branch will continue testing with its current database version matrix.