Release 3.1.4

SECURITY RELEASE: All users are advised to upgrade when using doctrine/dbal 3.0.0 - 3.1.3 due to a critical SQL injection that was fixed: https://github.com/doctrine/dbal/security/advisories/GHSA-r7cj-8hjg-x622

3.1.4

• Total issues resolved: 6
• Total pull requests resolved: 20
• Total contributors: 13

Bug,oci8

• 4995: Fix getServerVersion for OCI8 when assertions are disabled thanks to @derrabus and @SylvainSimonGPA

Connections,Test Suite

• 4991: Optimize sharing test connection thanks to @morozov

Bug,QueryBuilder

• 4984: Cast LIMIT and OFFSET to int when building limit query thanks to @morozov

Bug,Prepared Statements,Regression,SQL Parser

• 4980: DBAL 3.1: Array parameter conversion does not work with long SQL queries thanks to @AlexeyKosov

Documentation

• 4979: Remove unwanted colon in code samples thanks to @greg0ire
• 4947: [Docs] Removing paragraph about PDO similarity thanks to @ThomasLandauer
• 4931: Fixes spelling error discovered via textlint thanks to @raphaelstolt

Bug,MySQL,Schema Introspection

• 4978: Use correct column order for composite foreign keys thanks to @AndreasA

CI

• 4942: Do not mark issues as stale thanks to @morozov

Bug,Connections,Test Suite,pdo_oci

• 4940: Fix connection leaks in Oracle functional tests thanks to @morozov

Bug,Platforms,SQL Server

• 4939: Use CONCAT() with SQL Server to concatenate strings thanks to @morozov

• 3346: mssql 2016 SQLServer2012Platform::getConcatExpression() missing/wrong thanks to @Lacoi

• 4935: Workflow for closing stale pull requests thanks to @morozov

Prepared Statements,Regression,SQL Parser

• 4927: Rework negation of the special characters in SQL parser thanks to @morozov and @j-schumann
• 4916: Make the SQL parser regular expression less greedy thanks to @morozov and @j-schumann

Bug,PostgreSQL,Prepared Statements,Regression,SQL Parser

• 4904: Fix parsing escaped PostgreSQL JSONB question operator thanks to @morozov and @lugosium

Bug,PHP,mysqli

• 4880: Catch MySQLi exceptions on PHP 8.1 thanks to @derrabus

Test Suite

• 4868: Rework connect/disconnect routines in functional tests thanks to @morozov

CI,Code Style

• 4865: Remove obsolete PHPCS config thanks to @derrabus

SQL Server,Test Suite

• 4856: Merge AbstractSQLServerPlatformTestCase into SQLServerPlatformTestCase thanks to @morozov

Bug,Cache

• 4852: QueryCacheProfiler::generateCacheKey: Param password should be ignore in connection hash thanks to @janbarasek

Bug,SQLite

• 4838: fixed using lower case column names thanks to @eschricker