3.2.0

Release 3.2.0

3.2.0

• Total issues resolved: 12
• Total pull requests resolved: 58
• Total contributors: 19

Improvements

• 3425: Improve ConnectionTest by triggering real exceptions thanks to @grongor
• 4622: Add events for Transaction begin/commit/rollBack. thanks to @Warxcell and @mariusbalcytis
• 4685: Support for more drivers on PHP 8.1 thanks to @morozov
• 4746: Platform-aware schema comparison thanks to @morozov
• 4844: Get view definition for SQL Server thanks to @kitloong
• 4855: Test AbstractPlatform::getLengthExpression() thanks to @morozov
• 4894: Refactor MySQLi statement to make it unaware of the connection thanks to @derrabus
• 4910: Remove redundant reference assignment thanks to @kamil-tekiela
• 4918: Remove redundant assert thanks to @kamil-tekiela
• 4925: Remove obsolete define() check thanks to @derrabus
• 4928: Basic exception handling for SQL Server thanks to @morozov
• 4929: Basic exception handling for IBM DB2 thanks to @morozov
• 4948: Accept PDO as a Connection constructor argument thanks to @morozov
• 4949: Accept connection object/resource as a driver connection constructor argument thanks to @morozov
• 4950: Accept driver-level statement as a wrapper-level statement constructor argument thanks to @morozov
• 4957: Accept the underlying statement as an oci8 statement constructor argument thanks to @morozov
• 4967: Introduce logging middleware thanks to @morozov
• 4986: Add return types to private and final methods thanks to @derrabus

Deprecations

• 4624: Deprecate doctrine/cache in favor of psr/cache thanks to @derrabus
• 4681: Deprecate TableGenerator thanks to @morozov
• 4688: [GH-4687] Deprecate Connection::lastInsertId($name) thanks to @morozov
• 4707: Introduce consistent Comparator API thanks to @trompette
• 4724: Deprecate redundant AbstractPlatform methods thanks to @morozov
• 4743: Deprecate reference from foreign key to its referencing table thanks to @morozov
• 4751: Deprecate VersionAwarePlatformDriver and ServerInfoAwareConnection thanks to @morozov
• 4753: Deprecate AbstractPlatform::getNowExpression() thanks to @morozov
• 4755: Deprecate AbstractPlatform::getName() thanks to @morozov
• 4785: Deprecate not passing $fromColumn to ColumnDiff thanks to @morozov
• 4789: Deprecate features of Table::getColumns() thanks to @morozov
• 4802: Platform API cleanup thanks to @morozov
• 4805: Deprecate AbstractPlatform::canEmulateSchemas() thanks to @morozov
• 4812: Deprecate Schema::getTableNames() thanks to @morozov
• 4814: Deprecate AbstractAsset::getFullQualifiedName() thanks to @morozov
• 4821: Deprecate AbstractSchemaManager::getSchemaSearchPaths() thanks to @morozov
• 4822: Deprecate schema methods related to explicit foreign key indexes thanks to @morozov
• 4839: Deprecate the Constraint interface thanks to @morozov
• 4897: Deprecate AbstractSchemaManager::dropAndCreate() and ::tryMethod() methods thanks to @morozov
• 4969: Declare SQLite as not supporting CREATE|DROP DATABASE thanks to @morozov
• 4999: Use sprintf('%d') like in DB2, SQLServer and Oracle to harden against wrong limit and offset thanks to @nickvergessen
• 4920: Remove redundant code in mysqli Result thanks to @kamil-tekiela
• 4898: Use the driver API to begin a transaction on mysqli thanks to @morozov
• 4887: Remove mysqli_report() call thanks to @derrabus
• 4869: mysqli::real_connect may be called with null $flags thanks to @mondrake
• 4871: OracleSchemaManager::_getPortableTableColumnDefinition throws deprecations on PHP 8.1 thanks to @mondrake

Bugfixes

• 1125: DBAL-1182: No schema difference detected when changing length of a text field thanks to @doctrinebot
• 2566: Column altering in migration from TEXT to LONGTEXT may not apply. thanks to @janokary
• 2663: Comparator fails for BLOBS thanks to @thomashohn
• 2930: Comparator doesn't see changes in the length of TextType field thanks to @WhiteEagle88
• 4178: DDC-2043: Extra cache operation in DBAL\Cache\ResultCacheStatement.php thanks to @doctrinebot
• 5003: Always cache the full result thanks to @morozov
• 5020: Fix hardcoded varchar default length thanks to @mvorisek

Internal

• 4857: Merge AbstractPostgreSQLPlatformTestCase into PostgreSQLPlatformTest thanks to @morozov
• 4891: Bump PHPStan level to 8 thanks to @greg0ire
• 4951: Detect driver in tests based on configured driver name thanks to @morozov
• 5008: Refactor query caching tests thanks to @morozov

3.1.5

Release 3.1.5

3.1.5

• Total issues resolved: 0
• Total pull requests resolved: 1
• Total contributors: 1

Documentation

• 5021: Remove references to Doctrine 2 thanks to @greg0ire

2.13.6

Release 2.13.6

2.13.6

• Total issues resolved: 0
• Total pull requests resolved: 3
• Total contributors: 3

Bugfixes

• 5017: Cast decimals integers to string on SQLite [PHP 8.1] thanks to @janlanger

Static Analysis

• 5009: PHPStan 1.2.0, Psalm 4.13.0 thanks to @derrabus

Documentation

• 5022: docs: fix docs for the json type thanks to @dunglas

3.1.4

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: 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

2.13.5

Release 2.13.5

2.13.5

• Total issues resolved: 2
• Total pull requests resolved: 20
• Total contributors: 7

Tools

• 4970: Fix a deprecation in console command return types thanks to @javiereguiluz

Static Analysis

• 4959: Psalm 4.12.0, PHPStan 1.1.1 thanks to @derrabus
• 4943: PHPStan 1.0.2 thanks to @derrabus
• 4895: Cleanup ignored PHPStan errors thanks to @derrabus
• 4873: Bump PHPStan level to 8 thanks to @morozov

Test Suite

• 4954: Use willReturn() in mocks instead of will(returnValue()) thanks to @morozov
• 4876: Fix XSD paths in PHPUnit XML config files thanks to @derrabus

Static Analysis,mysqli

• 4934: Update Psalm to 4.11.2 thanks to @morozov

PHP,pdo_sqlsrv

• 4915: Fix PHP 8.1 deprecations on PDO_sqlsrv thanks to @derrabus

Oracle,PHP

• 4914: Fix PHP 8.1 deprecations in OracleSchemaManager thanks to @derrabus

PDO,PHP

• 4913: Fix deprecation on ExpressionBuilder::literal() with default type thanks to @derrabus and @come-nc

PHP,PostgreSQL

• 4912: Fix PHP 8.1 deprecations in PostgreSqlSchemaManager thanks to @derrabus

MariaDB

• 4909: MariaDb1027Platform class should be non-final thanks to @mvorisek

Bug,Deprecation,Platforms

• 4890: Fix calling AbstractPlatform::getAdvancedForeignKeyOptionsSQL triggers a deprecation thanks to @simonberger

CI,Improvement

• 4883: Reuse centralized coding standard workflow thanks to @greg0ire

Bug,PHP,mysqli

• 4881: Add missing upcast thanks to @derrabus

PHP,mysqli,pdo_sqlsrv,sqlsrv

• 4875: Run tests on PHP 8.1 with different database drivers thanks to @derrabus

Improvement,Static Analysis

• 4874: Get rid of current working directory variable thanks to @greg0ire

CI,Dependencies

• 4861: PHP CodeSniffer 3.6.1 thanks to @derrabus

CI,PostgreSQL

• 4848: Add Postgres 14 to the test matrix thanks to @derrabus

3.1.3

Release 3.1.3

3.1.3

• Total issues resolved: 1
• Total pull requests resolved: 5
• Total contributors: 3

Static Analysis

• 4826: Remove obsolete error suppression thanks to @derrabus

Bug,Console

• 4825: Fix version displayed in ConsoleRunner thanks to @derrabus

• 4824: Remove pinned platform thanks to @derrabus

Bug,Platforms,Regression,SQLite

• 4815: Fix renaming upper-cased SQLite columns thanks to @morozov and @Spice-King

Bug,Schema

• 4811: Fix Schema::getTableNames() thanks to @morozov

2.13.4

Release 2.13.4

2.13.4

• Total issues resolved: 1
• Total pull requests resolved: 7
• Total contributors: 3

PHP

• 4818: Cast decimals to string on SQLite thanks to @derrabus

Bug

• 4792: Do not normalize current version during comparison thanks to @morozov

Documentation

• 4833: Add explanation why we need to cast float to string in decimal type thanks to @andrew-demb
• 4827: Backport doc block fix thanks to @derrabus

CI

• 4834: Build ibm_db2 with a public driver thanks to @morozov
• 4819: PHPUnit 9.5.10 thanks to @derrabus
• 4796: Bump PHPStan and PHPUnit thanks to @derrabus

3.1.2

Release 3.1.2

3.1.2

• Total issues resolved: 6
• Total pull requests resolved: 11
• Total contributors: 4

PHP 8.1

• 4793: Do not pass NULL to internal functions that do not expect NULL thanks to @derrabus

Bug Fixes

• 4776: Retain SQLite column position when renaming or altering thanks to @morozov
• 4766: Fix introspection of BINARY columns thanks to @morozov
• 4765: Fix introspection of BLOB columns on SQL Server thanks to @morozov
• 4733: Fix auto_increment implementation for Oracle thanks to @mondrake
• 4719: Reset transaction nesting level when closing connection thanks to @morozov
• 4677: Create tables with unique constraints on PostgreSQL thanks to @hschletz

Static Analysis

• 4739: Code cleanup thanks to @morozov
• 4717: PHPStan check fails on PHP 8 thanks to @morozov

Documentation

• 4768: Remove obsolete TODO annotation thanks to @derrabus
• 4716: Clarify ExpressionBuilder arguments thanks to @morozov

Release 2.13.3

Release 2.13.3

2.13.3

• Total issues resolved: 2
• Total pull requests resolved: 16
• Total contributors: 6

Bug Fixes

• 4621: Move fix for user provided pdo connection thanks to @bizurkur
• 4662: Add ReturnTypeWillChange to PDO implementations thanks to @derrabus

Deprecations

• 4767: Deprecate SQLAnywhere driver thanks to @derrabus

PHP 8.1

• 4736: Don't use null as exception message thanks to @derrabus
• 4735: PHP 8.1 compatibility for 2.13 thanks to @derrabus
• 4734: Add ReturnTypeWillChange to core interface implementations thanks to @derrabus

Documentation

• 4740: Fix links to the recommended exception interface thanks to @morozov and @nreynis

Static Analysis

• 4695: Ignore errors about missing ReturnTypeWillChange class thanks to @derrabus
• 4784: Update Psalm to 4.10.0 thanks to @morozov
• 4780: Update PHPStan to 0.12.96 thanks to @morozov
• 4694: Update JetBrains PhpStorm stubs to 2021.1 thanks to @morozov

Packaging

• 4710: Update .gitattributes thanks to @bytestream

Code Style

• 4697: Configure PHP version for PHP_CodeSniffer thanks to @morozov

Continuous Integration

• 4788: Don't fake the PHP version anymore thanks to @derrabus
• 4686: Drop merge up and release branch creation steps thanks to @greg0ire

3.1.1

Release 3.1.1

3.1.1

• Total issues resolved: 1
• Total pull requests resolved: 8
• Total contributors: 5

Bug,Indexes,Platforms

• 4672: Fixed generated SQL for UniqueConstraint objects thanks to @hschletz

Bug

• 4667: Make Table::removeUniqueConstraint() actually work thanks to @hschletz

Improvement,Test Suite,Tools

• 4656: Allow Symfony 6 thanks to @jderusse

Documentation

• 4642: Update versions for default branch thanks to @SenseException
• 4635: Address class rename in the docs thanks to @greg0ire
• 4615: Remove docs about user-provided PDO instance thanks to @greg0ire

CI,Cache,Deprecation,Static Analysis

• 4630: Suppress deprecation notices for ArrayCache thanks to @morozov

Character Encoding,Connections,MySQL,Test Suite

• 4614: [GH-4613] Use utf8mb4 instead of utf8 for testing connection charset thanks to @morozov