2.13.2

Release 2.13.2

2.13.2

• Total issues resolved: 3
• Total pull requests resolved: 8
• Total contributors: 6

Test Suite

• 4679: Update PHPUnit to 9.5.5 thanks to @morozov

Documentation

• 4673: Document a non-deprecated way to interact with prepared statements thanks to @derrabus

Code Style

• 4663: Bump doctrine/coding-standard thanks to @derrabus

Bug,Quoting,SQL Server

• 4648: [GH-4643] Fix SQLServerPlatform::quoteIdentifier() thanks to @morozov and @zajca

Bug,Connections,Error Handling,mysqli

• 4647: [GH-4645] Use error suppression instead of an error handler in MySQLi Connection thanks to @morozov and @mbrodala

Bug,Static Analysis,Strict Typing

• 4638: Fix #4637 by duplicating the type definition for DriverManager::getConnection($args) params thanks to @Ocramius and @DavideBicego

Character Encoding,Connections,MySQL,Test Suite

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

Cache,Improvement

• 4623: Support Doctrine Cache 2 thanks to @derrabus

3.1.0

Release 3.1.0

3.1.0

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

Deprecation,New Feature

• 4607: Introduce Statement::executeQuery and Statement::executeStatement. thanks to @beberlei

Deprecation,Documentation

• 4589: Reference methods using parentheses thanks to @PowerKiKi

Deprecation,Documentation,Reserved Keywords

• 4587: [GH-4510] Deprecate ReservedWordsCommand::setKeywordListClass() thanks to @morozov

Deprecation,Oracle,Schema Managers

• 4584: [GH-4503] Mark OracleSchemaManager methods internal thanks to @morozov

Error Handling,Improvement,Prepared Statements,oci8

• 4581: Fix truncated oracle fetch result thanks to @amenning

Deprecation,Improvement,QueryBuilder

• 4578: Predictable QueryBuilder::executeQuery() and QueryBuilder::executeStatement() thanks to @PowerKiKi

Deprecation

• 4568: Trigger runtime deprecations for previously deprecated APIs thanks to @morozov

Connections,Sequences,pdo_sqlsrv

• 4560: Remove redundant implementation of PDO\SQLSrv\Connection::lastInsertId($name) thanks to @morozov

Deprecation,Improvement,Schema,Schema Managers

• 4548: Deprecations in schema- and namespace-related APIs thanks to @morozov

Deprecation,Platforms,Reserved Keywords

• 4547: Deprecate AbstractPlatform::getReservedKeywordsClass() thanks to @morozov

Deprecation,PDO,pdo_sqlsrv

• 4534: Deprecate Statement::bindParam($driverOptions) thanks to @morozov

Connections,Deprecation

• 4527: Deprecate Connection::getExpressionBuilder() thanks to @morozov
• 4517: Deprecate Connection::$_expr thanks to @morozov

Connections,Deprecation,Schema Managers

• 4519: Deprecate Connection::$_schemaManager and Connection::getSchemaManager() thanks to @morozov

Prepared Statements,Static Analysis,sqlsrv

• 4514: Remove SQLSrv\LastInsertId thanks to @morozov

Improvement,QueryBuilder,Static Analysis

• 4489: Introduce fetch* methods in query builder thanks to @andrew-demb

Connections,Documentation,Error Handling

• 4457: Add note about lost connections to UPGRADE guide. thanks to @beberlei

2.13.1

Release 2.13.1

2.13.1

• Total issues resolved: 4
• Total pull requests resolved: 8
• Total contributors: 8

Documentation,Static Analysis

• 4608: Attribute type coverage metric to 3.1.x instead of 2.13.x thanks to @morozov

• 4604: Collect type coverage metrics, add badge to README thanks to @morozov

• 4603: ensureForwardCompatibilityStatement expects ResultStatement, given PDOStatement thanks to @mwoods-familiaris

BC Fix,Prepared Statements,QueryBuilder

• 4596: Fix BC break on QueryBuilder::execute() thanks to @mdumoulin and @m50

Code Style

• 4593: Add direct dependency on PHP_CodeSniffer thanks to @morozov

BC Fix,Connections,PDO

• 4590: Fix user provided pdo connection thanks to @mdumoulin and @htto

Compatibility,Deprecation,Prepared Statements

• 4580: Deprecate Statement::execute in favor of Statement::executeStatement/executeQuery thanks to @beberlei

Deprecation,Prepared Statements

• 4579: Add missing runtime deprecations related to FC Result API (#4529, #4571) thanks to @beberlei

Deprecation,Documentation,Prepared Statements

• 4571: Add explicit @deprecated in ForwardCompatibility\Result thanks to @bcremer

Bug,Prepared Statements

• 4569: Doctrine DBAL 2.13 $statement->execute() returns bool (instead of Result) thanks to @knallcharge

2.13.0

Release 2.13.0

2.13.0

• Total issues resolved: 1

• Total pull requests resolved: 4

• Total contributors: 2

• 4555: [GH-4554] Deprecate all Statement::fetch* in favor of Result::fetch* thanks to @beberlei

• 4535: Deprecations thanks to @beberlei

• 4386: Reintroduce support for PHP 7.1 and 7.2 thanks to @beberlei

• 4529: Improve forward compatibility between 2.x and 3.0 thanks to @mdumoulin

Release 3.0.0

Release 3.0.0

This is a major release of Doctrine DBAL that focuses on API improvements and removal of deprecated APIs.

Major release highlights

1. Integration with PDO has been reworked. The php_pdo extension is no longer a hard dependency of the doctrine/dbal package. The PDO API is not longer the standard for DBAL APIs.
2. The wrapper-level connection and statement classes no longer implement the corresponding driver-level interfaces.
3. Instead of being available in certain states of the Statement class, the statement result is explicitly returned as a separate value.
4. A new dedicated API has been introduced for unique constraints.
5. The prepared statement portability layer has been reworked on top of the newly introduced Driver Middleware API.
6. The logic of conversion of driver-specific error codes and exceptions has been extracted into the Exception Converter API.
7. The SQL parser has been completely reworked to allow for better compatibility with the SQL syntax.
8. The following database platforms are no longer supported:
   • Drizzle,
   • MariaDB 10.0 and older,
   • Microsoft Azure,
   • PostgreSQL 9.3 and older,
   • SQL Anywhere,
   • SQL Server 2008 and older.
9. The following drivers are no longer supported:
   • pdo_ibm,
   • sasql.
10. Passing a PDO instance initialized outside of the DBAL is no longer supported.
11. The support for UUID generation on the database side has been dropped.
12. The MasterSlaveConnection class has been renamed to PrimaryReplicaConnection.
13. The executeUpdate() method has been renamed to executeStatement().
14. All driver classes and driver-level connection and statement classes are now consistently named and declared as final.
15. All PDO-based drivers have been moved under the PDO namespace.
16. The Doctrine\DBAL\DBALException and Doctrine\DBAL\Driver\DriverException have been renamed to Doctrine\DBAL\Exception and Doctrine\DBAL\Driver\Exception respectively.

• Total issues resolved: 26
• Total pull requests resolved: 99
• Total contributors: 13

PHP 8 support

• 4207: Update locked composer/package-versions-deprecated for compatibility with PHP 8.0 thanks to @morozov
• 4203: Remove --ignore-platform-reqs from PHP 8.0 builds thanks to @morozov
• 4197: The test suite fails on PHP 8 due to introduction of the match keyword thanks to @morozov
• 4171: Inconsistent naming of method arguments thanks to @morozov
• 4028: Allow php 8 thanks to @greg0ire
• 3814: Added builds against PHP nightly on Travis thanks to @morozov
• 3802: OCI8StatementTest fails on PHP 8 thanks to @morozov

API improvements

• 4429: Throw exception on invalid LockMode thanks to @morozov and @BenMorel
• 4397: Port the SQL parser from PDO thanks to @morozov and @shurik005
• 4317: Reintroduce parts of Legacy API for some more time thanks to @beberlei
• 4293: Add Result::fetchAllKeyValue() and ::iterateKeyValue() thanks to @morozov
• 4159: Do not implement driver-level interfaces by wrapper-level classes thanks to @morozov
• 4157: Rework the portability layer to act as a middleware thanks to @morozov
• 4149: Replace DefaultExceptionConverter with driver-specific implementations thanks to @morozov
• 4136: Move the logic of driver exception conversion into a separate interface thanks to @morozov
• 4129: Remove ExceptionConverterDriver thanks to @morozov
• 4081: Simplify Driver::connect() signature thanks to @morozov
• 4045: Extract Result from the Statement interface thanks to @morozov
• 4035: Moved rowCount() from Statement to ResultStatement thanks to @morozov
• 4007: Replace the concept of statement fetch modes with the explicit API thanks to @morozov
• 4039: Refactor portability statement into a functional composition thanks to @morozov
• 3980: Segregated support of unique index and unique constraint thanks to @guilhermeblanco
• 3943: Do not require hostname for non-persistent MySQL connection and require for persistent thanks to @morozov
• 3548: Remove user provided PDO functionality thanks to @morozov
• 3080: [DBAL-3079] Reworked the usage of PDO in PDOConnection from inheritance to composition thanks to @morozov
• 2958: Remove hard dependency on PDO thanks to @morozov

Legacy platform and driver removal

• 4077: Remove SQL Anywhere platform and driver thanks to @morozov
• 3756: Dropped SQL Server 2008 support thanks to @morozov
• 3602: Remove support for sharding and the Azure platform thanks to @morozov
• 3584: Remove LoggerChain::addLogger thanks to @ostrolucky
• 3477: Drop db support for PostgreSQL 9.3 and MariaDB 10.0 thanks to @SenseException
• 3055: Drop support for legacy platforms thanks to @Majkl578 and @morozov
• 3040: Drop Drizzle support thanks to @BenMorel

Deprecated API removal

• 4294: Remove Abstraction\Result thanks to @morozov
• 4278: Remove deprecated APIs thanks to @morozov
• 4234: Remove deprecated APIs thanks to @morozov
• 4217: Remove the Synchronizer package thanks to @morozov
• 4167: Remove deprecated methods from the wrapper Connection thanks to @morozov
• 4153: Remove deprecated components thanks to @morozov
• 4128: Remove PingableConnection thanks to @morozov
• 4125: Remove deprecated driver classes thanks to @morozov
• 4115: Remove ServerInfoAwareConnection#requiresQueryForServerVersion() as an implementation detail thanks to @morozov
• 4113: Remove DriverException::getErrorCode() thanks to @morozov
• 4083: Remove MasterSlaveConnection thanks to @greg0ire
• 4082: Backport removal of deprecated APIs from develop thanks to @morozov
• 4064: Remove platform-specific portability mode constants thanks to @morozov
• 4059: Remove deprecations for ConnectionHelper thanks to @dmaicher
• 4030: Backport removal of some deprecated APIs thanks to @morozov
• 3934: Removed EchoSQLLogger thanks to @morozov
• 3808: Removed the OCI8Connection::getExecuteMode() method thanks to @morozov
• 3606: Removed Driver::getDatabase() in favor of Connection::getDatabase() thanks to @morozov
• 3579: Remove deprecated stuff for 3.0 thanks to @jwage
• 3553: Removed Driver::getName() thanks to @morozov
• 3518: Remove @​deprecated stuff thanks to @Majkl578
• 3257: Remove Doctrine\DBAL\Types\Type::__toString() thanks to @Majkl578
• 3211: Removed support for DB-generated UUIDs thanks to @morozov
• 3070: Dropped support of fetching objects and non-zero column thanks to @morozov
• 2967: Drop Doctrine\DBAL\Version in favor of Ocramius\PackageVersions thanks to @Majkl578

Other breaking changes

• 4147: Mark driver classes final thanks to @morozov
• 4146: Require $platform in AbstractSchemaManager::__construct() thanks to @morozov
• 4138: PDO connection and statement classes made final thanks to @morozov
• 4109: Preparation to marking OCI8 driver classes final thanks ...

Release 2.12.1

Release 2.12.1

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

Bug fixes

• 4414: ResultCacheStatement::fetchAllAssociative does not store results in cache thanks to @morozov and @dFayet
• 4400: LockMode::NONE should not set WITH (NOLOCK) thanks to @BenMorel

Deprecations

• 4411: Deprecate inappropriate usage of prepared statement parameters thanks to @morozov
• 4407: Deprecate colon prefix for prepared statement parameters thanks to @morozov

PHP 8

• 4396: Fix php8 mysql mariadb thanks to @greg0ire
• 4398: Update PHP_CodeSniffer to 3.5.8 thanks to @morozov

Packaging

• 4416: Update .gitattributes thanks to @bytestream

Static Analysis

• 4403: Remove redundant phpstan param from DriverManager::getConnection() thanks to @simPod

Documentation

• 4424: Mark SQLParserUtils internal thanks to @morozov
• 4390: Fix headline in the upgrade docs thanks to @jdreesen
• 4356: Testing Guidelines thanks to @morozov

2.12.0

Release 2.12.0

2.12.0

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

Documentation,Static Analysis

• 4376: Configuration should not be internal thanks to @BenMorel

CI

• 4374: Reduce number of build jobs thanks to @greg0ire
• 4365: Fail on extension / tool installation failure thanks to @greg0ire

Bug,Static Analysis

• 4373: Psalm fails on release commits thanks to @morozov

Documentation,Error Handling

• 4362: Adds exception thrown by execute() method thanks to @toby-griffiths

CI,PHP

• 4361: Test all extensions with PHP8 thanks to @greg0ire

PHP

• 4347: [2.12] PHP 8 compatibility thanks to @derrabus

Release 2.11.3

Release 2.11.3

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

Regression in PostgreSQL Schema Manager

• 4364: Move the logic out of the assertion thanks to @morozov and @andreybolonin

Release 2.11.2

Release 2.11.2

• Total issues resolved: 5
• Total pull requests resolved: 16
• Total contributors: 10

Backward compatibility fixes

• 4330: Fix regression in QueryBuilder::and|orWhere() thanks to @BenMorel
• 4308: #4295 Keep master, slaves, keepReplica params in MasterSlaveConnection thanks to @kralos

Upgrade path improvements

• 4341: Add Statement::fetchAllIndexedAssociative() and ::iterateIndexedAssociative() thanks to @morozov and @ZaneCEO
• 4338: Add Statement::fetchAllKeyValue() and ::iterateKeyValue() thanks to @morozov
• 4289: Add a fetch mode methods for "PDO::FETCH_KEY_PAIR" thanks to @tswcode

Bug fixes

• 4315: Fix handling existing SQL Server column comment when other properties change thanks to @trusek
• 3400: Wrong column comment setting command in migrations of SQL Server thanks to @msyfurukawa

Documentation improvements

• 4305: Move website config to default branch thanks to @SenseException

Test suite improvements

• 4321: Update PHPUnit to 9.4 thanks to @morozov

Static analysis improvements

• 4353: Update Psalm to 3.17.2 and lock the version used with GitHub Actions thanks to @morozov
• 4348: Bump Psalm level to 3 thanks to @morozov
• 4346: Minor CS improvement - use ::class for TestCase::expectException input thanks to @mvorisek
• 4332: Static analysis improvements thanks to @morozov
• 4319: Bump Psalm level to 4 thanks to @morozov

Continuous integration improvements

• 4310: Migrate jobs away from Travis to Github Actions thanks to @greg0ire
• 4344: Static analysis workflow thanks to @greg0ire
• 4340: Modernize existing ga thanks to @greg0ire
• 4309: Use cache action v2 thanks to @greg0ire

Release 2.11.1

Release 2.11.1

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

Backward compatibility fixes

• 4287: Restore PDOStatement::quote() for backward compatibility thanks to @morozov and @Shahelm
• 4286: Fix BC break: QueryBuilder::andWhere() etc. should ignore empty strings thanks to @BenMorel and @infabo

Bug fixes

• 4173: Fix Third parameter not allowed for PDO::FETCH_COLUMN thanks to @BenMorel

Deprecations

• 4291: Deprecate Abstraction\Result thanks to @morozov

Documentation fixes and improvements

• 4296: Increase indent in definition lists thanks to @greg0ire
• 4299: Link to contributing guide thanks to @greg0ire
• 4285: Fix phpdoc on deprecated functions thanks to @qdequippe

Test suite improvements

• 4297: Fix ExceptionTest::testConnectionExceptionSqLite() on macOS thanks to @morozov