Skip to content

GitLab

Tags give the ability to mark specific points in history as being important
  • 3.1.0
    5ba62e7e · Merge branch '3.0.x' into 3.1.x · 
    Release [3.1.0](https://github.com/doctrine/dbal/milestone/87)

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.](https://github.com/doctrine/dbal/issues/4607) thanks to @beberlei

Deprecation,Documentation
-------------------------

 - [4589: Reference methods using parentheses](https://github.com/doctrine/dbal/pull/4589) thanks to @PowerKiKi

Deprecation,Documentation,Reserved Keywords
-------------------------------------------

 - [4587: [GH-4510] Deprecate ReservedWordsCommand::setKeywordListClass()](https://github.com/doctrine/dbal/pull/4587) thanks to @morozov

Deprecation,Oracle,Schema Managers
----------------------------------

 - [4584: [GH-4503] Mark OracleSchemaManager methods internal](https://github.com/doctrine/dbal/pull/4584) thanks to @morozov

Error Handling,Improvement,Prepared Statements,oci8
---------------------------------------------------

 - [4581: Fix truncated oracle fetch result](https://github.com/doctrine/dbal/pull/4581) thanks to @amenning

Deprecation,Improvement,QueryBuilder
------------------------------------

 - [4578: Predictable `QueryBuilder::executeQuery()` and `QueryBuilder::executeStatement()`](https://github.com/doctrine/dbal/pull/4578) thanks to @PowerKiKi

Deprecation
-----------

 - [4568: Trigger runtime deprecations for previously deprecated APIs](https://github.com/doctrine/dbal/pull/4568) thanks to @morozov

Connections,Sequences,pdo_sqlsrv
--------------------------------

 - [4560: Remove redundant implementation of PDO\SQLSrv\Connection::lastInsertId($name)](https://github.com/doctrine/dbal/pull/4560) thanks to @morozov

Deprecation,Improvement,Schema,Schema Managers
----------------------------------------------

 - [4548: Deprecations in schema- and namespace-related APIs](https://github.com/doctrine/dbal/pull/4548) thanks to @morozov

Deprecation,Platforms,Reserved Keywords
---------------------------------------

 - [4547: Deprecate AbstractPlatform::getReservedKeywordsClass()](https://github.com/doctrine/dbal/pull/4547) thanks to @morozov

Deprecation,PDO,pdo_sqlsrv
--------------------------

 - [4534: Deprecate Statement::bindParam($driverOptions)](https://github.com/doctrine/dbal/pull/4534) thanks to @morozov

Connections,Deprecation
-----------------------

 - [4527: Deprecate Connection::getExpressionBuilder()](https://github.com/doctrine/dbal/pull/4527) thanks to @morozov
 - [4517: Deprecate Connection::$_expr](https://github.com/doctrine/dbal/pull/4517) thanks to @morozov

Connections,Deprecation,Schema Managers
---------------------------------------

 - [4519: Deprecate Connection::$_schemaManager and Connection::getSchemaManager()](https://github.com/doctrine/dbal/pull/4519) thanks to @morozov

Prepared Statements,Static Analysis,sqlsrv
------------------------------------------

 - [4514: Remove SQLSrv\LastInsertId](https://github.com/doctrine/dbal/pull/4514) thanks to @morozov

Improvement,QueryBuilder,Static Analysis
----------------------------------------

 - [4489: Introduce fetch* methods in query builder](https://github.com/doctrine/dbal/pull/4489) thanks to @andrew-demb

Connections,Documentation,Error Handling
----------------------------------------

 - [4457: Add note about lost connections to UPGRADE guide.](https://github.com/doctrine/dbal/pull/4457) thanks to @beberlei
  • 2.13.1
    c8003804 · Merge pull request #4608 from morozov/shepherd · 
    Release [2.13.1](https://github.com/doctrine/dbal/milestone/89)

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](https://github.com/doctrine/dbal/pull/4608) thanks to @morozov
 - [4604: Collect type coverage metrics, add badge to README](https://github.com/doctrine/dbal/pull/4604) thanks to @morozov

 - [4603: ensureForwardCompatibilityStatement expects ResultStatement, given PDOStatement](https://github.com/doctrine/dbal/issues/4603) thanks to @mwoods-familiaris

BC Fix,Prepared Statements,QueryBuilder
---------------------------------------

 - [4596: Fix BC break on QueryBuilder::execute()](https://github.com/doctrine/dbal/pull/4596) thanks to @mdumoulin and @m50

Code Style
----------

 - [4593: Add direct dependency on PHP_CodeSniffer](https://github.com/doctrine/dbal/pull/4593) thanks to @morozov

BC Fix,Connections,PDO
----------------------

 - [4590: Fix user provided pdo connection](https://github.com/doctrine/dbal/pull/4590) thanks to @mdumoulin and @htto

Compatibility,Deprecation,Prepared Statements
---------------------------------------------

 - [4580: Deprecate Statement::execute in favor of Statement::executeStatement/executeQuery](https://github.com/doctrine/dbal/pull/4580) thanks to @beberlei

Deprecation,Prepared Statements
-------------------------------

 - [4579: Add missing runtime deprecations related to FC Result API (#4529, #4571)](https://github.com/doctrine/dbal/pull/4579) thanks to @beberlei

Deprecation,Documentation,Prepared Statements
---------------------------------------------

 - [4571: Add explicit @deprecated in ForwardCompatibility\Result](https://github.com/doctrine/dbal/pull/4571) thanks to @bcremer

Bug,Prepared Statements
-----------------------

 - [4569: Doctrine DBAL 2.13 $statement->execute() returns bool (instead of Result)](https://github.com/doctrine/dbal/issues/4569) thanks to @Knallcharge
  • 2.13.0
    67d56d32 · Merge 2.12.x up into 2.13.x · 
    Release [2.13.0](https://github.com/doctrine/dbal/milestone/88)

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*](https://github.com/doctrine/dbal/pull/4555) thanks to @beberlei
 - [4535: Deprecations](https://github.com/doctrine/dbal/pull/4535) thanks to @beberlei
 - [4386: Reintroduce support for PHP 7.1 and 7.2](https://github.com/doctrine/dbal/pull/4386) thanks to @beberlei

Connections,Improvement,Prepared Statements
-------------------------------------------

 - [4529: Improve forward compatibility between 2.x and 3.0](https://github.com/doctrine/dbal/pull/4529) thanks to @mdumoulin
  • 3.0.0
    ee6d1260 · Merge pull request #4433 from morozov/more-specific-statement-params-type · 
    Release [3.0.0](https://github.com/doctrine/dbal/milestone/76)

3.0.0
=====

- Total issues resolved: **26**
- Total pull requests resolved: **99**
- Total contributors: **13**

Documentation,Prepared Statements,Static Analysis
-------------------------------------------------

 - [4433: Require positional statement parameters to be a list](https://github.com/doctrine/dbal/pull/4433) thanks to @morozov

Configuration
-------------

 - [4431: Use individual properties in Configuration](https://github.com/doctrine/dbal/pull/4431) thanks to @BenMorel

BC Break,Improvement,Locking
----------------------------

 - [4429: Throw exception on invalid LockMode](https://github.com/doctrine/dbal/pull/4429) thanks to @morozov and @BenMorel

 - [4423: Add missing word](https://github.com/doctrine/dbal/pull/4423) thanks to @greg0ire
 - [4028: Allow php 8](https://github.com/doctrine/dbal/pull/4028) thanks to @greg0ire

Bug,Prepared Statements,Query
-----------------------------

 - [4422: QueryBuilder must use 0-based positional parameter keys](https://github.com/doctrine/dbal/pull/4422) thanks to @morozov

BC Break,Prepared Statements
----------------------------

 - [4410: Remove support for colon prefix in statement parameters](https://github.com/doctrine/dbal/pull/4410) thanks to @morozov
 - [4294: Remove Abstraction\Result](https://github.com/doctrine/dbal/pull/4294) thanks to @morozov
 - [4007: Replace the concept of statement fetch modes with the explicit API](https://github.com/doctrine/dbal/pull/4007) thanks to @morozov

Error Handling,Static Analysis,Test Suite
-----------------------------------------

 - [4401: Add missing instanceof check](https://github.com/doctrine/dbal/pull/4401) thanks to @BenMorel

SQL Parser
----------

 - [4397: Port the SQL parser from PDO](https://github.com/doctrine/dbal/pull/4397) thanks to @morozov and @shurik005

Error Handling
--------------

 - [4387: Store query params in driver exceptions](https://github.com/doctrine/dbal/pull/4387) thanks to @BenMorel

Documentation
-------------

 - [4384: Proofread upgrade guide](https://github.com/doctrine/dbal/pull/4384) thanks to @greg0ire

BC Break,Code Style,MySQL,PostgreSQL
------------------------------------

 - [4343: Rename MySql... to MySQL... and PostgreSqlSchemaManager to PostgreSQLSchemaManager](https://github.com/doctrine/dbal/pull/4343) thanks to @mvorisek

Connections
-----------

 - [4323: Clean up redundant implements](https://github.com/doctrine/dbal/pull/4323) thanks to @BenMorel

Bug,Error Handling,Type Conversion
----------------------------------

 - [4320: Properly format scalar values in ConversionException](https://github.com/doctrine/dbal/pull/4320) thanks to @morozov

Improvement,Prepared Statements
-------------------------------

 - [4317: Reintroduce parts of Legacy API for some more time](https://github.com/doctrine/dbal/pull/4317) thanks to @beberlei
 - [4293: Add Result::fetchAllKeyValue() and ::iterateKeyValue()](https://github.com/doctrine/dbal/pull/4293) thanks to @morozov

Console,Documentation
---------------------

 - [4301: Remove irrelevant deprecation message from console runner](https://github.com/doctrine/dbal/pull/4301) thanks to @morozov

Blocker
-------

 - [4290: Don't ignore empty strings in QueryBuilder](https://github.com/doctrine/dbal/issues/4290) thanks to @BenMorel

BC Break,Error Handling,Platforms,Types
---------------------------------------

 - [4278: Remove deprecated APIs](https://github.com/doctrine/dbal/pull/4278) thanks to @morozov

BC Break,Improvement,Platforms,Schema Managers
----------------------------------------------

 - [4234: Remove deprecated APIs](https://github.com/doctrine/dbal/pull/4234) thanks to @morozov

BC Break,Schema
---------------

 - [4217: Remove the Synchronizer package](https://github.com/doctrine/dbal/pull/4217) thanks to @morozov

Blocker,PHP
-----------

 - [4207: Update locked composer/package-versions-deprecated for compatibility with PHP 8.0](https://github.com/doctrine/dbal/pull/4207) thanks to @morozov

Blocker,CI,Improvement,PHP
--------------------------

 - [4203: Remove --ignore-platform-reqs from PHP 8.0 builds](https://github.com/doctrine/dbal/pull/4203) thanks to @morozov

Blocker,PHP,Test Suite
----------------------

 - [4197: The test suite fails on PHP 8 due to introduction of the match keyword](https://github.com/doctrine/dbal/issues/4197) thanks to @morozov

Blocker,Bug,PHP,Platforms
-------------------------

 - [4171: Inconsistent naming of method arguments](https://github.com/doctrine/dbal/issues/4171) thanks to @morozov

BC Break,Connections,Prepared Statements
----------------------------------------

 - [4167: Remove deprecated methods from the wrapper Connection](https://github.com/doctrine/dbal/pull/4167) thanks to @morozov

Documentation,Improvement
-------------------------

 - [4164: Update architecture documentation](https://github.com/doctrine/dbal/pull/4164) thanks to @morozov
 - [4135: Remove irrelevant references to PDO from the documentation](https://github.com/doctrine/dbal/pull/4135) thanks to @morozov

BC Break,Connections,Error Handling,Events,Improvement,Prepared Statements,Query,Schema,Schema Managers,Tools,Types
-------------------------------------------------------------------------------------------------------------------

 - [4160: Add some missing @throws annotations and fix thrown exceptions](https://github.com/doctrine/dbal/pull/4160) thanks to @morozov

BC Break,Connections,Improvement,Prepared Statements
----------------------------------------------------

 - [4159: Do not implement driver-level interfaces by wrapper-level classes](https://github.com/doctrine/dbal/pull/4159) thanks to @morozov

BC Break,Drivers,Improvement,New Feature,Portability
----------------------------------------------------

 - [4157: Rework the portability layer to act as a middleware](https://github.com/doctrine/dbal/pull/4157) thanks to @morozov

BC Break,Connections,Error Handling,Platforms
---------------------------------------------

 - [4153: Remove deprecated components](https://github.com/doctrine/dbal/pull/4153) thanks to @morozov

Drivers,Error Handling,Improvement
----------------------------------

 - [4149: Replace DefaultExceptionConverter with driver-specific implementations](https://github.com/doctrine/dbal/pull/4149) thanks to @morozov

BC Break,Drivers,Improvement
----------------------------

 - [4147: Mark driver classes final](https://github.com/doctrine/dbal/pull/4147) thanks to @morozov

BC Break,Bug,Error Handling,Schema Managers
-------------------------------------------

 - [4146: Require $platform in AbstractSchemaManager::__construct()](https://github.com/doctrine/dbal/pull/4146) thanks to @morozov

Documentation,Improvement,Prepared Statements
---------------------------------------------

 - [4140: Mark result constructors internal](https://github.com/doctrine/dbal/pull/4140) thanks to @morozov

BC Break,Drivers,Improvement,PDO,pdo_sqlsrv
-------------------------------------------

 - [4138: PDO connection and statement classes made final](https://github.com/doctrine/dbal/pull/4138) thanks to @morozov

BC Break,Drivers,Error Handling,Improvement
-------------------------------------------

 - [4136: Move the logic of driver exception conversion into a separate interface](https://github.com/doctrine/dbal/pull/4136) thanks to @morozov

BC Break,Connections,Drivers,Error Handling,Improvement,Prepared Statements
---------------------------------------------------------------------------

 - [4130: Missing driver exception annotations](https://github.com/doctrine/dbal/pull/4130) thanks to @morozov

BC Break,Drivers,Error Handling
-------------------------------

 - [4129: Remove ExceptionConverterDriver](https://github.com/doctrine/dbal/pull/4129) thanks to @morozov
 - [4113: Remove DriverException::getErrorCode()](https://github.com/doctrine/dbal/pull/4113) thanks to @morozov

BC Break,Connections
--------------------

 - [4128: Remove PingableConnection](https://github.com/doctrine/dbal/pull/4128) thanks to @morozov

BC Break,Connections,Drivers
----------------------------

 - [4125: Remove deprecated driver classes](https://github.com/doctrine/dbal/pull/4125) thanks to @morozov

BC Break,Connections,Platform Detection
---------------------------------------

 - [4115: Remove ServerInfoAwareConnection#requiresQueryForServerVersion() as an implementation detail](https://github.com/doctrine/dbal/pull/4115) thanks to @morozov

Improvement,Prepared Statements,SQL Parser,oci8
-----------------------------------------------

 - [4109: Preparation to marking OCI8 driver classes final](https://github.com/doctrine/dbal/pull/4109) thanks to @morozov

Improvement,Static Analysis
---------------------------

 - [4107: Remove the suppressed errors that PHPStan no longer reports](https://github.com/doctrine/dbal/pull/4107) thanks to @morozov

Improvement,Test Suite
----------------------

 - [4093: Expect only DriverException from Result::fetch*() methods](https://github.com/doctrine/dbal/pull/4093) thanks to @morozov

Configuration,Connections,Improvement
-------------------------------------

 - [4091: Get rid of the call to Connection::getParams() in Portability\Statement](https://github.com/doctrine/dbal/pull/4091) thanks to @morozov

Oracle,Schema Managers
----------------------

 - [4090: Make the $database argument of OracleSchemaManager::createDatabase() mandatory](https://github.com/doctrine/dbal/pull/4090) thanks to @morozov

Test Suite
----------

 - [4089: Remove the CommentedType class from tests](https://github.com/doctrine/dbal/pull/4089) thanks to @morozov

Improvement,Tools
-----------------

 - [4084: Allow using on PHP 7.3 with Composer 2](https://github.com/doctrine/dbal/pull/4084) thanks to @nicolas-grekas
 - [3862: Specify the platform configuration in composer.json](https://github.com/doctrine/dbal/pull/3862) thanks to @morozov

BC Break,Connections,Improvement
--------------------------------

 - [4083: Remove MasterSlaveConnection](https://github.com/doctrine/dbal/pull/4083) thanks to @greg0ire

BC Break,Connections,Drivers,Events,Improvement,Logging,Platforms
-----------------------------------------------------------------

 - [4082: Backport removal of deprecated APIs from develop](https://github.com/doctrine/dbal/pull/4082) thanks to @morozov

BC Break,Connecting,Connections,Drivers,Improvement
---------------------------------------------------

 - [4081: Simplify Driver::connect() signature](https://github.com/doctrine/dbal/pull/4081) thanks to @morozov

BC Break,SQL Anywhere,sqlanywhere
---------------------------------

 - [4077: Remove SQL Anywhere platform and driver](https://github.com/doctrine/dbal/pull/4077) thanks to @morozov

BC Break,Improvement,Portability
--------------------------------

 - [4064: Remove platform-specific portability mode constants](https://github.com/doctrine/dbal/pull/4064) thanks to @morozov

BC Break,Connections,Console,Improvement
----------------------------------------

 - [4059: Remove deprecations for ConnectionHelper](https://github.com/doctrine/dbal/pull/4059) thanks to @dmaicher

Portability,Test Suite
----------------------

 - [4058: Add tests for fetch*() methods of Portability\Result](https://github.com/doctrine/dbal/pull/4058) thanks to @morozov

BC Break,Improvement,Prepared Statements
----------------------------------------

 - [4045: Extract Result from the Statement interface](https://github.com/doctrine/dbal/pull/4045) thanks to @morozov
 - [4035: Moved rowCount() from Statement to ResultStatement](https://github.com/doctrine/dbal/pull/4035) thanks to @morozov

Code Style,PostgreSQL,Test Suite
--------------------------------

 - [4040: Merge up mistakes](https://github.com/doctrine/dbal/pull/4040) thanks to @greg0ire

Improvement,Portability,Prepared Statements
-------------------------------------------

 - [4039: Refactor portability statement into a functional composition](https://github.com/doctrine/dbal/pull/4039) thanks to @morozov

BC Break,Connections,Error Handling
-----------------------------------

 - [4030: Backport removal of some deprecated APIs](https://github.com/doctrine/dbal/pull/4030) thanks to @morozov

Regression,Test Suite
---------------------

 - [4006: Fix logging in functional tests in case of connection failure](https://github.com/doctrine/dbal/pull/4006) thanks to @morozov

Blocker,Compatibility,Improvement,New Feature
---------------------------------------------

 - [3980: Segregated support of unique index and unique constraint](https://github.com/doctrine/dbal/pull/3980) thanks to @guilhermeblanco

CI,Oracle,SQL Server,Testing
----------------------------

 - [3965: Sync expected coverage report count](https://github.com/doctrine/dbal/pull/3965) thanks to @greg0ire

Bug,Connecting,Connections,mysqli
---------------------------------

 - [3943: Do not require hostname for non-persistent MySQL connection and require for persistent](https://github.com/doctrine/dbal/pull/3943) thanks to @morozov

BC Break,Logging
----------------

 - [3934: Removed EchoSQLLogger](https://github.com/doctrine/dbal/pull/3934) thanks to @morozov

Drivers,Improvement,mysqli
--------------------------

 - [3933: Removed the hard-coded MySQL default port and the usage of ini-settings](https://github.com/doctrine/dbal/pull/3933) thanks to @morozov

BC Break,Improvement,Strict Typing
----------------------------------

 - [3932: Enable PHPStan strict rules](https://github.com/doctrine/dbal/pull/3932) thanks to @morozov

CI,Improvement,Test Suite
-------------------------

 - [3915: Flatten source and test directory structure](https://github.com/doctrine/dbal/pull/3915) thanks to @morozov

Improvement,Platforms,PostgreSQL,SQL Anywhere,SQL Server
--------------------------------------------------------

 - [3912: Made some platform class names reflect the lowest server version they support](https://github.com/doctrine/dbal/pull/3912) thanks to @morozov

Azure,BC Break,Drivers,Drizzle,MariaDB,Platforms,PostgreSQL,SQL Anywhere,SQL Server,Sharding,pdo_ibm
----------------------------------------------------------------------------------------------------

 - [3906: Backport removal of legacy platforms and drivers from master](https://github.com/doctrine/dbal/pull/3906) thanks to @morozov

Improvement,PHP
---------------

 - [3899: Drop support for PHP 7.2 in DBAL 3.0](https://github.com/doctrine/dbal/issues/3899) thanks to @morozov

BC Break,Improvement,Tools
--------------------------

 - [3860: Drop Doctrine\DBAL\Version in favor of Ocramius\PackageVersions](https://github.com/doctrine/dbal/pull/3860) thanks to @morozov
 - [2967: Drop Doctrine\DBAL\Version in favor of Ocramius\PackageVersions](https://github.com/doctrine/dbal/pull/2967) thanks to @Majkl578

Code Style,Improvement
----------------------

 - [3847: Update Doctrine Coding Standard to 7.0](https://github.com/doctrine/dbal/pull/3847) thanks to @morozov

BC Break,Improvement,Prepared Statements,SQL Parser,oci8
--------------------------------------------------------

 - [3820: Made the OCI8Statement class final](https://github.com/doctrine/dbal/pull/3820) thanks to @morozov

Prepared Statements,Refactoring,mysqli
--------------------------------------

 - [3817: Refactored MySQLiStatement::$columnNames](https://github.com/doctrine/dbal/pull/3817) thanks to @morozov

CI,Improvement
--------------

 - [3814: Added builds against PHP nightly on Travis](https://github.com/doctrine/dbal/pull/3814) thanks to @morozov

BC Break,Improvement,Prepared Statements,oci8
---------------------------------------------

 - [3808: Removed the OCI8Connection::getExecuteMode() method](https://github.com/doctrine/dbal/pull/3808) thanks to @morozov

BC Break,PDO,PHP,RFC
--------------------

 - [3803: Backport PDO-related changes from master to 3.0.x](https://github.com/doctrine/dbal/pull/3803) thanks to @morozov

Failing Test,Test Suite,oci8
----------------------------

 - [3802: OCI8StatementTest fails on PHP 8](https://github.com/doctrine/dbal/issues/3802) thanks to @morozov

BC Break,Improvement,SQL Server
-------------------------------

 - [3756: Dropped SQL Server 2008 support](https://github.com/doctrine/dbal/pull/3756) thanks to @morozov

BC Break,Drivers,Improvement,Platform Detection
-----------------------------------------------

 - [3750: VersionAwarePlatformDriver now extends Driver](https://github.com/doctrine/dbal/pull/3750) thanks to @morozov

BC Break,Connections,Databases,Drivers,Improvement,Schema Introspection
-----------------------------------------------------------------------

 - [3606: Removed Driver::getDatabase() in favor of Connection::getDatabase()](https://github.com/doctrine/dbal/pull/3606) thanks to @morozov

Azure,BC Break,Improvement,Sharding
-----------------------------------

 - [3602: Remove support for sharding and the Azure platform](https://github.com/doctrine/dbal/pull/3602) thanks to @morozov

BC Break,Improvement,Platforms,Prepared Statements
--------------------------------------------------

 - [3594: Removed some unused code bits](https://github.com/doctrine/dbal/pull/3594) thanks to @morozov

BC Break,Improvement,Logging
----------------------------

 - [3584: Remove LoggerChain::addLogger](https://github.com/doctrine/dbal/pull/3584) thanks to @ostrolucky

BC Break,Improvement
--------------------

 - [3579: Remove deprecated stuff for 3.0](https://github.com/doctrine/dbal/pull/3579) thanks to @jwage
 - [3518: Remove @​deprecated stuff](https://github.com/doctrine/dbal/pull/3518) thanks to @Majkl578

BC Break,Drivers
----------------

 - [3553: Removed Driver::getName()](https://github.com/doctrine/dbal/pull/3553) thanks to @morozov

BC Break,Configuration,Connections,PDO
--------------------------------------

 - [3548: Remove user provided PDO functionality](https://github.com/doctrine/dbal/pull/3548) thanks to @morozov

BC Break,MariaDB,Platform Detection,Platforms,PostgreSQL
--------------------------------------------------------

 - [3477: Drop db support for PostgreSQL 9.3 and MariaDB 10.0](https://github.com/doctrine/dbal/pull/3477) thanks to @SenseException

BC Break,Improvement,Types
--------------------------

 - [3257: Remove Doctrine\DBAL\Types\Type::__toString()](https://github.com/doctrine/dbal/pull/3257) thanks to @Majkl578

BC Break,Platforms
------------------

 - [3211: Removed support for DB-generated UUIDs](https://github.com/doctrine/dbal/pull/3211) thanks to @morozov

BC Break,Connections,Drivers,Improvement,PDO,Prepared Statements
----------------------------------------------------------------

 - [3080: [DBAL-3079] Reworked the usage of PDO in PDOConnection from inheritance to composition](https://github.com/doctrine/dbal/pull/3080) thanks to @morozov

BC Break,Prepared Statements,RFC
--------------------------------

 - [3070: Dropped support of fetching objects and non-zero column](https://github.com/doctrine/dbal/pull/3070) thanks to @morozov

BC Break,Platform Detection,Platforms,PostgreSQL,SQL Anywhere,SQL Server
------------------------------------------------------------------------

 - [3055: Drop support for legacy platforms](https://github.com/doctrine/dbal/pull/3055) thanks to @Majkl578 and @morozov

BC Break,Drivers,Drizzle,Platforms
----------------------------------

 - [3040: Drop Drizzle support](https://github.com/doctrine/dbal/pull/3040) thanks to @BenMorel

BC Break,Compatibility,Improvement,PDO,Prepared Statements
----------------------------------------------------------

 - [2958: Remove hard dependency on PDO](https://github.com/doctrine/dbal/pull/2958) thanks to @morozov
  • 2.12.1
    adce7a95 · Release 2.12.1 · 
    Release [2.12.1](https://github.com/doctrine/dbal/milestone/84)

2.12.1
======

- Total issues resolved: **2**
- Total pull requests resolved: **11**
- Total contributors: **7**

Documentation,Prepared Statements
---------------------------------

 - [4424: Mark SQLParserUtils internal](https://github.com/doctrine/dbal/pull/4424) thanks to @morozov

Packaging
---------

 - [4416: Update .gitattributes](https://github.com/doctrine/dbal/pull/4416) thanks to @bytestream

Bug,Cache
---------

 - [4414: ResultCacheStatement::fetchAllAssociative does not store results in cache](https://github.com/doctrine/dbal/pull/4414) thanks to @morozov and @dFayet

Deprecation,Prepared Statements
-------------------------------

 - [4411: Deprecate inappropriate usage of prepared statement parameters](https://github.com/doctrine/dbal/pull/4411) thanks to @morozov
 - [4407: Deprecate colon prefix for prepared statement parameters](https://github.com/doctrine/dbal/pull/4407) thanks to @morozov

Static Analysis
---------------

 - [4403: Remove redundant phpstan param from DriverManager::getConnection()](https://github.com/doctrine/dbal/pull/4403) thanks to @simPod

Bug,Locking,Transactions
------------------------

 - [4400: LockMode::NONE should not set WITH (NOLOCK)](https://github.com/doctrine/dbal/pull/4400) thanks to @BenMorel

Code Style,PHP
--------------

 - [4398: Update PHP_CodeSniffer to 3.5.8](https://github.com/doctrine/dbal/pull/4398) thanks to @morozov

PDO,PHP,Test Suite
------------------

 - [4396: Fix php8 mysql mariadb](https://github.com/doctrine/dbal/pull/4396) thanks to @greg0ire

Documentation
-------------

 - [4390: Fix headline in the upgrade docs](https://github.com/doctrine/dbal/pull/4390) thanks to @jdreesen

Documentation,Testing
---------------------

 - [4356: Testing Guidelines](https://github.com/doctrine/dbal/pull/4356) thanks to @morozov
  • 2.12.0
    c6d37b4c · Release 2.12.0 · 
    Release [2.12.0](https://github.com/doctrine/dbal/milestone/82)

2.12.0
======

- Total issues resolved: **1**
- Total pull requests resolved: **7**
- Total contributors: **5**

Documentation,Static Analysis
-----------------------------

 - [4376: Configuration should not be internal](https://github.com/doctrine/dbal/pull/4376) thanks to @BenMorel

CI
--

 - [4374: Reduce number of build jobs](https://github.com/doctrine/dbal/pull/4374) thanks to @greg0ire
 - [4365: Fail on extension / tool installation failure](https://github.com/doctrine/dbal/pull/4365) thanks to @greg0ire

Bug,Static Analysis
-------------------

 - [4373: Psalm fails on release commits](https://github.com/doctrine/dbal/pull/4373) thanks to @morozov

Documentation,Error Handling
----------------------------

 - [4362: Adds exception thrown by execute() method](https://github.com/doctrine/dbal/pull/4362) thanks to @toby-griffiths

CI,PHP
------

 - [4361: Test all extensions with PHP8](https://github.com/doctrine/dbal/pull/4361) thanks to @greg0ire

PHP
---

 - [4347: [2.12] PHP 8 compatibility](https://github.com/doctrine/dbal/pull/4347) thanks to @derrabus
  • 2.11.3
    fb5d5f2f · Release 2.11.3 · 
    Release [2.11.3](https://github.com/doctrine/dbal/milestone/83)

2.11.3
======

- Total issues resolved: **1**
- Total pull requests resolved: **1**
- Total contributors: **2**

Bug,PostgreSQL,Regression,Schema Managers
-----------------------------------------

 - [4364: Move the logic out of the assertion](https://github.com/doctrine/dbal/pull/4364) thanks to @morozov and @andreybolonin
  • 2.11.2
    b88a45cb · Release 2.11.2 · 
    Release [2.11.2](https://github.com/doctrine/dbal/milestone/81)

2.11.2
======

- Total issues resolved: **5**
- Total pull requests resolved: **16**
- Total contributors: **10**

Static Analysis
---------------

 - [4353: Update Psalm to 3.17.2 and lock the version used with GitHub Actions](https://github.com/doctrine/dbal/pull/4353) thanks to @morozov
 - [4348: Bump Psalm level to 3](https://github.com/doctrine/dbal/pull/4348) thanks to @morozov
 - [4332: Static analysis improvements](https://github.com/doctrine/dbal/pull/4332) thanks to @morozov
 - [4319: Bump Psalm level to 4](https://github.com/doctrine/dbal/pull/4319) thanks to @morozov

Code Style
----------

 - [4346: Minor CS improvement - use ::class for TestCase::expectException input](https://github.com/doctrine/dbal/pull/4346) thanks to @mvorisek

 - [4344: Static analysis workflow](https://github.com/doctrine/dbal/pull/4344) thanks to @greg0ire
 - [4340: Modernize existing ga](https://github.com/doctrine/dbal/pull/4340) thanks to @greg0ire
 - [4309: Use cache action v2](https://github.com/doctrine/dbal/pull/4309) thanks to @greg0ire
 - [4305: Move website config to default branch](https://github.com/doctrine/dbal/pull/4305) thanks to @SenseException

Improvement,Prepared Statements
-------------------------------

 - [4341: Add Statement::fetchAllIndexedAssociative() and ::iterateIndexedAssociative()](https://github.com/doctrine/dbal/pull/4341) thanks to @morozov and @ZaneCEO
 - [4338: Add Statement::fetchAllKeyValue() and ::iterateKeyValue()](https://github.com/doctrine/dbal/pull/4338) thanks to @morozov

BC Fix,Query
------------

 - [4330: Fix regression in QueryBuilder::and|orWhere()](https://github.com/doctrine/dbal/pull/4330) thanks to @BenMorel

Test Suite
----------

 - [4321: Update PHPUnit to 9.4](https://github.com/doctrine/dbal/pull/4321) thanks to @morozov

Columns,SQL Server,Schema Managers
----------------------------------

 - [4315: Fix handling existing SQL Server column comment when other properties change](https://github.com/doctrine/dbal/pull/4315) thanks to @trusek

CI
--

 - [4310: Migrate jobs away from Travis to Github Actions ](https://github.com/doctrine/dbal/pull/4310) thanks to @greg0ire

BC Fix,Connections
------------------

 - [4308: #4295 Keep master, slaves, keepReplica params in MasterSlaveConnection](https://github.com/doctrine/dbal/pull/4308) thanks to @kralos

New Feature,Prepared Statements
-------------------------------

 - [4289: Add a fetch mode methods for "PDO::FETCH_KEY_PAIR"](https://github.com/doctrine/dbal/issues/4289) thanks to @tswcode

Bug,SQL Server,Schema
---------------------

 - [3400: Wrong column comment setting command in migrations of SQL Server](https://github.com/doctrine/dbal/issues/3400) thanks to @msyfurukawa
  • 2.11.1
    6e6903cd · Release 2.11.1 · 
    Release [2.11.1](https://github.com/doctrine/dbal/milestone/80)

2.11.1
======

- Total issues resolved: **2**
- Total pull requests resolved: **8**
- Total contributors: **6**

Documentation
-------------

 - [4299: Link to contributing guide](https://github.com/doctrine/dbal/pull/4299) thanks to @greg0ire

SQLite,Test Suite,pdo_sqlite
----------------------------

 - [4297: Fix ExceptionTest::testConnectionExceptionSqLite() on macOS](https://github.com/doctrine/dbal/pull/4297) thanks to @morozov

 - [4296: Increase indent in definition lists](https://github.com/doctrine/dbal/pull/4296) thanks to @greg0ire

Deprecation,Prepared Statements
-------------------------------

 - [4291: Deprecate Abstraction\Result](https://github.com/doctrine/dbal/pull/4291) thanks to @morozov

BC Fix,Quoting
--------------

 - [4287: Restore PDOStatement::quote() for backward compatibility](https://github.com/doctrine/dbal/pull/4287) thanks to @morozov and @Shahelm

BC Fix,Query
------------

 - [4286: Fix BC break: QueryBuilder::andWhere() etc. should ignore empty strings](https://github.com/doctrine/dbal/pull/4286) thanks to @BenMorel and @infabo

Bug,Documentation,Prepared Statements
-------------------------------------

 - [4285: Fix phpdoc on deprecated functions](https://github.com/doctrine/dbal/pull/4285) thanks to @qdequippe

Bug,PDO,Prepared Statements
---------------------------

 - [4173: Fix Third parameter not allowed for PDO::FETCH_COLUMN](https://github.com/doctrine/dbal/pull/4173) thanks to @BenMorel
  • 2.11.0
    0d4e1a8b · Release 2.11.0 · 
    Release [2.11.0](https://github.com/doctrine/dbal/milestone/77)

2.11.0
======

- Total issues resolved: **7**
- Total pull requests resolved: **55**
- Total contributors: **8**

Improvement,Prepared Statements,SQL Server,Types,pdo_sqlsrv,sqlsrv
------------------------------------------------------------------

 - [4274: Support ASCII parameter binding](https://github.com/doctrine/dbal/pull/4274) thanks to @gjdanis

Documentation
-------------

 - [4271: Add explanation about implicit indexes](https://github.com/doctrine/dbal/pull/4271) thanks to @greg0ire

Deprecation,Error Handling
--------------------------

 - [4253: Deprecate DBAL\DBALException in favor of DBAL\Exception](https://github.com/doctrine/dbal/pull/4253) thanks to @morozov

CI
--

 - [4251: Setup automatic release workflow](https://github.com/doctrine/dbal/pull/4251) thanks to @greg0ire

Deprecation,Schema Managers
---------------------------

 - [4230: Deprecate the functionality of dropping client connections when dropping a database](https://github.com/doctrine/dbal/pull/4230) thanks to @morozov

Deprecation,Platforms
---------------------

 - [4229: Deprecate more AbstractPlatform methods](https://github.com/doctrine/dbal/pull/4229) thanks to @morozov
 - [4132: Deprecate AbstractPlatform::fixSchemaElementName()](https://github.com/doctrine/dbal/pull/4132) thanks to @morozov

Improvement,Test Suite
----------------------

 - [4215: Remove test group configuration leftovers](https://github.com/doctrine/dbal/pull/4215) thanks to @morozov
 - [4080: Update PHPUnit to 9.2](https://github.com/doctrine/dbal/pull/4080) thanks to @morozov
 - [4079: Forward compatibility with PHPUnit 9.3](https://github.com/doctrine/dbal/pull/4079) thanks to @morozov
 - [3923: Removed performance tests](https://github.com/doctrine/dbal/pull/3923) thanks to @morozov

Deprecation,Schema
------------------

 - [4213: Deprecate the Synchronizer package](https://github.com/doctrine/dbal/pull/4213) thanks to @morozov

Blocker,Improvement,PHP,Test Suite
----------------------------------

 - [4201: Update PHPUnit to 9.3](https://github.com/doctrine/dbal/pull/4201) thanks to @morozov

Blocker,PHP,Test Suite
----------------------

 - [4196: The test suite uses the deprecated at() matcher](https://github.com/doctrine/dbal/issues/4196) thanks to @morozov

Connections,Deprecation,Documentation
-------------------------------------

 - [4175: Additional deprecation note for PrimaryReplicaConnection::query()](https://github.com/doctrine/dbal/pull/4175) thanks to @morozov

Connections,Deprecation,Prepared Statements
-------------------------------------------

 - [4165: Deprecated usage of wrapper components as implementations of driver-level interfaces](https://github.com/doctrine/dbal/pull/4165) thanks to @morozov
 - [4020: Deprecated Connection::project(), Statement::errorCode() and errorInfo()](https://github.com/doctrine/dbal/pull/4020) thanks to @morozov

Connections,Deprecation
-----------------------

 - [4163: Deprecate duplicate and ambiguous wrapper connection methods](https://github.com/doctrine/dbal/pull/4163) thanks to @morozov

Error Handling,Improvement,Types
--------------------------------

 - [4145: Add TypeRegistry constructor](https://github.com/doctrine/dbal/pull/4145) thanks to @morozov

Deprecation,Drivers,Improvement,pdo_mysql,pdo_oci,pdo_pgsql,pdo_sqlite,pdo_sqlsrv
---------------------------------------------------------------------------------

 - [4144: Deprecate classes in Driver\PDO* namespaces](https://github.com/doctrine/dbal/pull/4144) thanks to @morozov

Connections,Documentation,Improvement
-------------------------------------

 - [4139: Mark connection constructors internal](https://github.com/doctrine/dbal/pull/4139) thanks to @morozov

Deprecation,Drivers,Error Handling
----------------------------------

 - [4137: Deprecate driver exception conversion APIs](https://github.com/doctrine/dbal/pull/4137) thanks to @morozov
 - [4112: Deprecate DriverException::getErrorCode()](https://github.com/doctrine/dbal/pull/4112) thanks to @morozov

Configuration,Connections,Deprecation,Error Handling
----------------------------------------------------

 - [4134: Deprecate some DBALException factory methods](https://github.com/doctrine/dbal/pull/4134) thanks to @morozov

Code Style,Documentation
------------------------

 - [4133: Fix more issues introduced by the deprecation of driver classes](https://github.com/doctrine/dbal/pull/4133) thanks to @morozov

BC Break,Drivers,Error Handling,pdo_sqlsrv,sqlsrv
-------------------------------------------------

 - [4131: Restore the PortWithoutHost exception parent class](https://github.com/doctrine/dbal/pull/4131) thanks to @morozov

Code Style,Improvement,Static Analysis
--------------------------------------

 - [4123: Remove the no longer needed error suppressions](https://github.com/doctrine/dbal/pull/4123) thanks to @morozov

Deprecation,Drivers,Error Handling,Improvement
----------------------------------------------

 - [4118: Deprecate ExceptionConverterDriver](https://github.com/doctrine/dbal/pull/4118) thanks to @morozov

Bug,Connections,Improvement,Prepared Statements
-----------------------------------------------

 - [4117: Fixes for the recently introduced driver-level deprecations](https://github.com/doctrine/dbal/pull/4117) thanks to @morozov

Connections,Deprecation,Platform Detection
------------------------------------------

 - [4114: Deprecate ServerInfoAwareConnection#requiresQueryForServerVersion() as an implementation detail](https://github.com/doctrine/dbal/pull/4114) thanks to @morozov

Deprecation,Prepared Statements,SQL Parser,oci8
-----------------------------------------------

 - [4110: Mark non-interface OCI8 driver methods internal](https://github.com/doctrine/dbal/pull/4110) thanks to @morozov

Connections,Deprecation,Drivers,Improvement,Prepared Statements
---------------------------------------------------------------

 - [4100: Deprecate inconsistently and ambiguously named driver-level classes](https://github.com/doctrine/dbal/pull/4100) thanks to @morozov

Connections,Improvement
-----------------------

 - [4092: Remove Connection::$isConnected](https://github.com/doctrine/dbal/pull/4092) thanks to @morozov

Configuration,Connections
-------------------------

 - [4086: Mark Connection::getParams() internal](https://github.com/doctrine/dbal/pull/4086) thanks to @morozov

Bug,Drivers,ibm_db2
-------------------

 - [4085: The IBM DB2 driver Exception class must implement the DriverException interface](https://github.com/doctrine/dbal/pull/4085) thanks to @morozov

PHP
---

 - [4078: Bump PHP requirement to 7.3 as of DBAL 2.11.0](https://github.com/doctrine/dbal/pull/4078) thanks to @morozov

Connections,Databases,Deprecation,Drivers
-----------------------------------------

 - [4068: Deprecate Driver::getDatabase()](https://github.com/doctrine/dbal/pull/4068) thanks to @morozov

Deprecation,Improvement,Portability
-----------------------------------

 - [4061: Deprecated platform-specific portability mode constants](https://github.com/doctrine/dbal/pull/4061) thanks to @morozov

 - [4054: [GH-4052] Deprecate MasterSlaveConnection and rename to PrimaryReplicaConnection](https://github.com/doctrine/dbal/pull/4054) thanks to @beberlei and @albe
 - [4017: Improve help of dbal:run-sql command](https://github.com/doctrine/dbal/pull/4017) thanks to @ostrolucky

Code Style,Improvement
----------------------

 - [4050: Update doctrine/coding-standard to 8.0](https://github.com/doctrine/dbal/pull/4050) thanks to @morozov

Cache,Deprecation,Improvement,Prepared Statements
-------------------------------------------------

 - [4049: Replace forward-compatible ResultStatement interfaces with Result](https://github.com/doctrine/dbal/pull/4049) thanks to @morozov

Cache,Improvement,Prepared Statements
-------------------------------------

 - [4048: Make caching layer not rely on closeCursor()](https://github.com/doctrine/dbal/pull/4048) thanks to @morozov

Deprecation,Improvement,Prepared Statements
-------------------------------------------

 - [4037: Introduce Statement::fetchFirstColumn()](https://github.com/doctrine/dbal/pull/4037) thanks to @morozov
 - [4019: Deprecated the concept of the fetch mode](https://github.com/doctrine/dbal/pull/4019) thanks to @morozov

Bug,Documentation,Improvement,Prepared Statements
-------------------------------------------------

 - [4034: Additional changes based on the discussion in #4007](https://github.com/doctrine/dbal/pull/4034) thanks to @morozov

Connections,Console,Improvement
-------------------------------

 - [3956: allow using multiple connections for CLI commands](https://github.com/doctrine/dbal/pull/3956) thanks to @dmaicher

Deprecation,Logging
-------------------

 - [3935: Deprecate EchoSQLLogger](https://github.com/doctrine/dbal/pull/3935) thanks to @morozov

Improvement,Packaging
---------------------

 - [3924: Actualize the content of the .gitattributes file](https://github.com/doctrine/dbal/pull/3924) thanks to @morozov

Azure,Deprecation,Drivers,Drizzle,MariaDB,Platforms,PostgreSQL,SQL Anywhere,SQL Server,Sharding,pdo_ibm
-------------------------------------------------------------------------------------------------------

 - [3905: Deprecate the usage of the legacy platforms and drivers](https://github.com/doctrine/dbal/pull/3905) thanks to @morozov

Deprecation,Query
-----------------

 - [3864: CompositeExpression and()/or() factory methods](https://github.com/doctrine/dbal/pull/3864) thanks to @BenMorel
 - [3853: Deprecate calling QueryBuilder methods with an array argument](https://github.com/doctrine/dbal/pull/3853) thanks to @BenMorel and @morozov

Deprecation,Tools
-----------------

 - [3861: Deprecated the usage of the Version class](https://github.com/doctrine/dbal/pull/3861) thanks to @morozov

Improvement,Query
-----------------

 - [3852: First parameter of ExpressionBuilder::and/or() mandatory](https://github.com/doctrine/dbal/pull/3852) thanks to @BenMorel

Deprecation,Improvement,Query
-----------------------------

 - [3851: Rename andX() / orX() methods](https://github.com/doctrine/dbal/pull/3851) thanks to @BenMorel
 - [3850: Prepare CompositeExpression for immutability](https://github.com/doctrine/dbal/pull/3850) thanks to @BenMorel
  • 2.10.4
    47433196 · Release 2.10.4 · 
    Release 2.10.4
======

- Total issues resolved: **2**
- Total pull requests resolved: **3**
- Total contributors: **3**

Regressions
------------------------------

 - [4255: Revert full support for foreign key constraints for SQLite](https://github.com/doctrine/dbal/pull/4255) thanks to @morozov and @taylorotwell

Bug fixes
--------------

 - [4268: Handle both ways of PDO reporting failed connection](https://github.com/doctrine/dbal/pull/4268) thanks to @morozov

CI improvements
--------------

 - [4252: Reuse global coding standard workflow](https://github.com/doctrine/dbal/pull/4252) thanks to @greg0ire
  • 2.10.3
    03ca23af · Release 2.10.3 · 
    Release [2.10.3](https://github.com/doctrine/dbal/milestone/78)
======

[![Build Status](https://travis-ci.org/doctrine/dbal.svg?branch=2.10.3)](https://travis-ci.org/doctrine/dbal)

- Total issues resolved: **3**
- Total pull requests resolved: **42**
- Total contributors: **9**

Bug Fixes
------------------------------

- [4238: Fix errors with case sensitive collation on mssql: not existing procedures and tables (sp_RENAME, SysObjects, SysColumns)](https://github.com/doctrine/dbal/pull/4238) thanks to @redgnar
- [4231: Mark testDropsDatabaseWithActiveConnections() as incomplete on OraclePlatform](https://github.com/doctrine/dbal/pull/4231) thanks to @morozov
- [4162: Remove parameters and types unset after statement execution](https://github.com/doctrine/dbal/pull/4162) thanks to @morozov
- [4148: Remove workaround in PDOSqlsrv\Connection::quote()](https://github.com/doctrine/dbal/pull/4148) thanks to @morozov
- [4074: Fix handling host and port configuration in sqlsrv and pdo_sqlsrv drivers](https://github.com/doctrine/dbal/pull/4074) thanks to @morozov
- [4066: Fix DSN detection in the IBM DB2 driver](https://github.com/doctrine/dbal/pull/4066) thanks to @morozov
- [3994: Use proper check in acceptForeignKey()](https://github.com/doctrine/dbal/pull/3994) thanks to @greg0ire
- [3991: Extend RetryableException from Throwable interface](https://github.com/doctrine/dbal/pull/3991) thanks to @mitelg
- [3762: Add full support for foreign key constraints for SQLite](https://github.com/doctrine/dbal/pull/3762) thanks to @beberlei

Other Code Improvements
----------------------------------------------------------------------------------------------------

- [4172: Clean up inconsistent or redundant argument names](https://github.com/doctrine/dbal/pull/4172) thanks to @morozov

Static Analysis Improvements
---------------------------

- [4235: Update PHPStan to 0.12.40](https://github.com/doctrine/dbal/pull/4235) thanks to @morozov
- [4222: Upgrade Psalm to its latest version](https://github.com/doctrine/dbal/pull/4222) thanks to @greg0ire
- [4116: Update PHPStan to 0.12.31](https://github.com/doctrine/dbal/pull/4116) thanks to @morozov
- [4099: Update PHPStan to 0.12.30](https://github.com/doctrine/dbal/pull/4099) thanks to @morozov
- [4094: Bump Psalm level to 5](https://github.com/doctrine/dbal/pull/4094) thanks to @morozov
- [3977: Psalm 6](https://github.com/doctrine/dbal/pull/3977) thanks to @greg0ire
- [3974: Remove unneeded and risky stubs parsing](https://github.com/doctrine/dbal/pull/3974) thanks to @greg0ire
- [3969: Psalm 7](https://github.com/doctrine/dbal/pull/3969) thanks to @greg0ire

CI Improvements
--

- [4239: Cleanup Travis scripts and configuration](https://github.com/doctrine/dbal/pull/4239) thanks to @morozov
- [4184: Trigger Github workflow for merges](https://github.com/doctrine/dbal/pull/4184) thanks to @greg0ire
- [4181: Fetch parent commits](https://github.com/doctrine/dbal/pull/4181) thanks to @greg0ire
- [4176: Add GitHub Actions builds for oci8 and pdo_oci drivers](https://github.com/doctrine/dbal/pull/4176) thanks to @morozov
- [4009: Coveralls integration](https://github.com/doctrine/dbal/pull/4009) thanks to @greg0ire
- [3998: move PHPStan to GitHub Actions](https://github.com/doctrine/dbal/pull/3998) thanks to @bendavies
- [3979: Move phpcs from Travis to GitHub Actions](https://github.com/doctrine/dbal/pull/3979) thanks to @bendavies
- [3978: Use composer install in the Psalm job](https://github.com/doctrine/dbal/pull/3978) thanks to @greg0ire

Documentation Improvements
----------------------------

- [4185: Fix badges](https://github.com/doctrine/dbal/pull/4185) thanks to @morozov
- [4126: Use relative names in inline {@link} annotations where possible](https://github.com/doctrine/dbal/pull/4126) thanks to @morozov
- [4027: @link in convertException gives 404](https://github.com/doctrine/dbal/pull/4027) thanks to @tomasnorre
- [4008: Fix character for mysql driver example](https://github.com/doctrine/dbal/pull/4008) thanks to @alexpts

Test Suite Improvements
-----------------------------------------

- [4209: Test MySQLi connection via TLS on Travis](https://github.com/doctrine/dbal/pull/4209) thanks to @morozov
- [4127: Rework extension detection in tests](https://github.com/doctrine/dbal/pull/4127) thanks to @morozov
- [4067: Simplify test suite configuration](https://github.com/doctrine/dbal/pull/4067) thanks to @morozov
- [4053: Report coverage unconditionally on Travis](https://github.com/doctrine/dbal/pull/4053) thanks to @greg0ire
- [4047: Integrate with Codecov](https://github.com/doctrine/dbal/pull/4047) thanks to @greg0ire
- [3148: Ignore code coverage of private constructors of static classes](https://github.com/doctrine/dbal/pull/3148) thanks to @morozov

Code Style Improvements
----------------------

- [4150: Update doctrine/coding-standard to 8.1](https://github.com/doctrine/dbal/pull/4150) thanks to @morozov
- [4120: Update Slevomat Coding Standard to 6.3.10](https://github.com/doctrine/dbal/pull/4120) thanks to @morozov
- [4031: Ignore all violations of the LowercasePHPFunctions sniff in SQLSrvStatement](https://github.com/doctrine/dbal/pull/4031) thanks to @morozov
- [3989: Remove useless rules](https://github.com/doctrine/dbal/pull/3989) thanks to @greg0ire
- [3983: Bump cs libs](https://github.com/doctrine/dbal/pull/3983) thanks to @greg0ire
- [3287: Do not suppress warnings in PHP_CodeSniffer reports](https://github.com/doctrine/dbal/pull/3287) thanks to @morozov
  • 2.10.2
    aab745e7 · Release v2.10.2 · 
    Release [2.10.2](https://github.com/doctrine/dbal/milestone/75)



2.10.2
======

- Total issues resolved: **4**
- Total pull requests resolved: **19**
- Total contributors: **10**

Improvement,Static Analysis
---------------------------

 - [3964: Mark every exception as immutable](https://github.com/doctrine/dbal/pull/3964) thanks to @greg0ire

CI,Improvement,Static Analysis
------------------------------

 - [3961: Stop relying on the master version of Psalm](https://github.com/doctrine/dbal/pull/3961) thanks to @greg0ire
 - [3951: Setup static analysis with Psalm](https://github.com/doctrine/dbal/pull/3951) thanks to @greg0ire
 - [3799: Upgrade to PHPStan v0.12](https://github.com/doctrine/dbal/pull/3799) thanks to @lcobucci

Improvement,Logging,Test Suite
------------------------------

 - [3957: Reworked LoggingTest to be able to test Statement::executeUpdate()](https://github.com/doctrine/dbal/pull/3957) thanks to @morozov

CI,Code Style,Improvement,Strict Typing
---------------------------------------

 - [3955: Remove baseline](https://github.com/doctrine/dbal/pull/3955) thanks to @greg0ire

Bug,SQLite,Schema Introspection,Schema Managers
-----------------------------------------------

 - [3937: Column comment incorrectly introspected on SQLite](https://github.com/doctrine/dbal/issues/3937) thanks to @morozov

Bug,Documentation,Prepared Statements,Query
-------------------------------------------

 - [3896: Updated documentation for QueryBuilder::execute() return value type](https://github.com/doctrine/dbal/pull/3896) thanks to @morozov

Bug,Prepared Statements
-----------------------

 - [3894: Make sure that the $types array has the same keys $params](https://github.com/doctrine/dbal/pull/3894) thanks to @morozov
 - [3893: Ensure the constructor arguments are passed to custom classes](https://github.com/doctrine/dbal/pull/3893) thanks to @duncan3dc
 - [3843: Fix unquoted stmt fragments backslash escaping](https://github.com/doctrine/dbal/pull/3843) thanks to @morozov

Documentation,Improvement
-------------------------

 - [3886: Update readme](https://github.com/doctrine/dbal/pull/3886) thanks to @greg0ire
 - [3834: Fix docblock typos in DriverManager docs](https://github.com/doctrine/dbal/pull/3834) thanks to @CHItA

CI,Improvement,MariaDB,MySQL
----------------------------

 - [3884: Use Docker consistently](https://github.com/doctrine/dbal/pull/3884) thanks to @greg0ire
 - [3478: Improve readiness probe stability for containerized databases on CI](https://github.com/doctrine/dbal/issues/3478) thanks to @morozov




 - [3883: Fix broken build](https://github.com/doctrine/dbal/pull/3883) thanks to @greg0ire

Bug,Documentation,Query,Query Limit/Offset Modification
-------------------------------------------------------

 - [3842: Fixed the QueryBuilder::setMaxResults() signature to accept NULL](https://github.com/doctrine/dbal/pull/3842) thanks to @morozov

Bug,Query
---------

 - [3832: Fix JOIN with no condition bug](https://github.com/doctrine/dbal/pull/3832) thanks to @BenMorel

Bug,PostgreSQL,Schema Introspection
-----------------------------------

 - [3821: [pg] fix getting table information if search_path contains escaped schema name](https://github.com/doctrine/dbal/pull/3821) thanks to @linniksa

Documentation,Improvement,Logging
---------------------------------

 - [3812: Fix DebugStack#queries docblock type](https://github.com/doctrine/dbal/pull/3812) thanks to @ostrolucky

Bug,Regression,Schema
---------------------

 - [3790: fixed unqualified table name of fk constraints when using schemas](https://github.com/doctrine/dbal/pull/3790) thanks to @stlrnz and @Alarich
  • v2.10.1
    c2b8e6e8 · Release v2.10.1 · 
    # Release v2.10.1

[![Build Status](https://travis-ci.org/doctrine/dbal.svg?branch=v2.10.1)](https://travis-ci.org/doctrine/dbal)

This release fixes regressions introduced in [release v2.10.0](https://github.com/doctrine/dbal/releases/tag/v2.10.0), implements some CI/testing improvements and introduces updates in the documentation.

- Total issues resolved: **3**
- Total pull requests resolved: **10**
- Total contributors: **11**

**Regressions:**

 - [3790: Fix unqualified table name of fk constraints when using schemas](https://github.com/doctrine/dbal/pull/3790) thanks to @stlrnz and @Alarich
 - [3738: Fix breaks named parameters in Oracle](https://github.com/doctrine/dbal/pull/3738) thanks to @eisberg and @matesko

**CI improvements and maintenance:**

 - [3784: Use PHP 7.4 instead of a snapshot on Travis](https://github.com/doctrine/dbal/pull/3784) thanks to @andreybolonin
 - [3778: [GH-3777] Don't remove composer lock travis on stable 2.10 branch](https://github.com/doctrine/dbal/pull/3778) thanks to @beberlei
 - [3753: Allow build failures for unstable dependencies](https://github.com/doctrine/dbal/pull/3753) thanks to @morozov
 - [3720: Switched from PHPBrew-based configuration to the Docker-based](https://github.com/doctrine/dbal/pull/3720) thanks to @morozov

**Test suite improvements:**

 - [3745: Remove temporary SQLite file on teardown](https://github.com/doctrine/dbal/pull/3745) thanks to @morozov

**Documentation updates:**

 - [3793: Remove superfluous Configuration instance](https://github.com/doctrine/dbal/pull/3793) thanks to @mhitza

 - [3739: Update deprecation messages to refer to DBAL](https://github.com/doctrine/dbal/pull/3739) thanks to @alcaeus

 - [3723: Fix annotations](https://github.com/doctrine/dbal/pull/3723) thanks to @enumag and @Pnoexz
  • v2.10.0
    0c9a6467 · Release v2.10.0 · 
    # Release v2.10.0

This is a minor release of Doctrine DBAL that aggregates over 70 fixes and improvements developed by 25 contributors over the last year.

This release focuses on internal code quality improvement and deprecating the functionality identified for removal in the next major release.

## Backwards Compatibility Breaks

This release introduces a minor BC break. Default column values are no longer handled as SQL expressions. They are converted to SQL literals (e.g. escaped). The previous behavior was not portable and was never by design.

Clients must now specify default values in their initial form, not in the form of an SQL literal (e.g. escaped).

**Before:**

```php
$column->setDefault('Foo\\\\Bar\\\\Baz');
```

**After:**

```php
$column->setDefault('Foo\\Bar\\Baz');
```

## Deprecations

- The usage of the `getDriver()`, `getDatabasePlatform()` and `getSchemaManager()` methods of the `ConnectionEventArgs` class has been deprecated.
- The usage of the `getDatabasePlatform()` method of the `SchemaColumnDefinitionEventArgs` class has been deprecated.
- The usage of the `getHost()`, `getPort()`, `getUsername()` and `getPassword()` methods of the `Connection` class has been deprecated.
- Passing multiple SQL statements as an array to `SchemaAlterTableAddColumnEventArgs::addSql()` and the same method in other `SchemaEventArgs`-based classes is deprecated.
- Calling `AbstractSchemaManager::tablesExist()` with a string argument is deprecated.
- Calling `OracleSchemaManager::createDatabase()` without an argument or by passing `NULL` is deprecated.
- Unused schema manager methods are deprecated.
   -  `AbstractSchemaManager::_getPortableFunctionsList()`,
   - `AbstractSchemaManager::_getPortableFunctionDefinition()`,
   - `OracleSchemaManager::_getPortableFunctionDefinition()`,
   - `SqliteSchemaManager::_getPortableTableIndexDefinition()`.
- The usage of `NULL` to indicate empty `$username` or `$password` when calling `Doctrine\DBAL\Driver::connect()` is deprecated.
- Method `Doctrine\DBAL\Platforms::_getAlterTableIndexForeignKeySQL()` has been deprecated as no longer used.
- Property `Doctrine\DBAL\Driver\OCI8\OCI8Statement::$_PARAM` has been deprecated as not used.
- Method `Doctrine\DBAL\Driver::getName()` is deprecated.
- The usage of user-provided `PDO` instance is deprecated.
- `Type::*` constants are deprecated.
- The `Doctrine\DBAL\Driver\SQLSrv\SQLSrvStatement::LAST_INSERT_ID_SQL` constant has been deprecated.
- The constants in `Doctrine\DBAL\SQLParserUtils` have been deprecated.
- The `Doctrine\DBAL\Logging\LoggerChain::addLogger` method has been deprecated.

Please see the details in the [UPGRADE.md](UPGRADE.md) documentation.

## New Features and Improvements

- [3674: Add missing MySQL 8.0 reserved keywords](https://github.com/doctrine/dbal/pull/3674) thanks to @loilo
- [3512: Support for comments on table in all databases](https://github.com/doctrine/dbal/pull/3512) thanks to @moufmouf
- [3418: Add column charset for MySql](https://github.com/doctrine/dbal/pull/3418) thanks to @AlterTable

**MySQL-related changes:**

 - [3668: Quote collation on MySQL](https://github.com/doctrine/dbal/pull/3668) thanks to @staudenmeir
 - [3374: Clean up `MySqlPlatform::getListTableIndexesSQL()` fields](https://github.com/doctrine/dbal/pull/3374) thanks to @BenMorel
 - [3311: Ensuring correct `ALTER TABLE` statement for creation of an `AUTO INCREMENT` column as new `PRIMARY KEY`](https://github.com/doctrine/dbal/pull/3311) thanks to @arnegroskurth

**Driver level changes:**

- [3677: Relax statement type declaration](https://github.com/doctrine/dbal/pull/3677) thanks to @greg0ire
- [3521: Maintain platform parameter in connection params](https://github.com/doctrine/dbal/pull/3521) thanks to @jwage and @Perf
- [3588: Add commit result bool](https://github.com/doctrine/dbal/pull/3588) thanks to @otazniksk

**Schema management:**

- [2960: Handle default values as values, not SQL expressions](https://github.com/doctrine/dbal/pull/2960) thanks to @morozov

**Types improvements:**

 - [3356: Extract constants for built-in types from Type to Types](https://github.com/doctrine/dbal/pull/3356) thanks to @Majkl578
 - [3354: Extract type factory and registry from Type into TypeRegistry](https://github.com/doctrine/dbal/pull/3354) thanks to @Majkl578

**Compatibility with Symfony 5:**

 - [3706: add missing exit codes to ensure Symfony 5 compatibility](https://github.com/doctrine/dbal/pull/3706) thanks to @dmaicher
 - [3563: Allow Symfony 5](https://github.com/doctrine/dbal/pull/3563) thanks to @nicolas-grekas

**Query Builder:**

 - [3696: Add support for `DISTINCT` clause](https://github.com/doctrine/dbal/pull/3696) thanks to @bingo-soft

**Logging:**

 - [3572: Make LoggerChain use constructor to add loggers instead of adder method](https://github.com/doctrine/dbal/pull/3572) thanks to @ostrolucky

**Code quality improvements:**

 - [3667: Phpstan fix backport](https://github.com/doctrine/dbal/pull/3667) thanks to @morozov
 - [3663: Updated PHPStan to v0.11.15](https://github.com/doctrine/dbal/pull/3663) thanks to @morozov
 - [3604: Updated Jetbrains PhpStorm stubs to 2019.1](https://github.com/doctrine/dbal/pull/3604) thanks to @morozov
 - [3549: Removed the assertion which doesn't work with a user-provided PDO connection](https://github.com/doctrine/dbal/pull/3549) thanks to @morozov
 - [3489: Update doctrine coding standard from 5.0 to 6.0](https://github.com/doctrine/dbal/pull/3489) thanks to @amaabdou
 - [3481: Updated PHPStan to v0.11.3](https://github.com/doctrine/dbal/pull/3481) thanks to @morozov
 - [3443: PHPStan Level 7](https://github.com/doctrine/dbal/pull/3443) thanks to @morozov
 - [3442: PHPStan Level 6](https://github.com/doctrine/dbal/pull/3442) thanks to @morozov
 - [3436: PHPStan Level 5](https://github.com/doctrine/dbal/pull/3436) thanks to @morozov
 - [3435: PHPStan Level 4](https://github.com/doctrine/dbal/pull/3435) thanks to @morozov
 - [3432: Updated PHPStan to v0.11](https://github.com/doctrine/dbal/pull/3432) thanks to @morozov

**Test suite improvements:**

 - [3705: Don't skip a test for sqlite](https://github.com/doctrine/dbal/pull/3705) thanks to @Federkun
 - [3689: Updated PHPUnit to 8.4.1](https://github.com/doctrine/dbal/pull/3689) thanks to @morozov
 - [3664: Refactor usage of MockBuilder's deprecated setMethods()](https://github.com/doctrine/dbal/pull/3664) thanks to @baspeeters
 - [3643: Bumped PHPUnit requrement to ^8.3.3, removed dependency on symfony/phpunit-bridge](https://github.com/doctrine/dbal/pull/3643) thanks to @morozov
 - [3609: Reworked the mocks generated by Prophecy using PHPUnit](https://github.com/doctrine/dbal/pull/3609) thanks to @morozov
 - [3608: Added a unit test for Doctrine\DBAL\Logging\LoggerChain](https://github.com/doctrine/dbal/pull/3608) thanks to @morozov
 - [3600: Updated PHPUnit to 8.2.1](https://github.com/doctrine/dbal/pull/3600) thanks to @morozov
 - [3575: Enforced parameter and return value types in test classes](https://github.com/doctrine/dbal/pull/3575) thanks to @morozov
 - [3566: Upgraded to PHPUnit 8.1.6 and reworked the remaining driver exception mock](https://github.com/doctrine/dbal/pull/3566) thanks to @morozov
 - [3555: Removed the rest of mock classes](https://github.com/doctrine/dbal/pull/3555) thanks to @morozov
 - [3546: Reworked driver exception tests](https://github.com/doctrine/dbal/pull/3546) thanks to @morozov
 - [3530: Improve ExceptionTest::testConnectionExceptionSqLite](https://github.com/doctrine/dbal/pull/3530) thanks to @jwage
 - [3474: Remove more hard-coded mock classes](https://github.com/doctrine/dbal/pull/3474) thanks to @morozov
 - [3470: Replaced MockPlatform with the ones generated by PHPUnit](https://github.com/doctrine/dbal/pull/3470) thanks to @morozov
 - [3468: Marked some test classes abstract](https://github.com/doctrine/dbal/pull/3468) thanks to @morozov
 - [3446: Upgraded PHPUnit to 8.0](https://github.com/doctrine/dbal/pull/3446) thanks to @morozov

**Documentation improvements:**

 - [3616: Fix typo in docblock](https://github.com/doctrine/dbal/pull/3616) thanks to @rdarcy1
 - [3559: add .github/FUNDING.yml](https://github.com/doctrine/dbal/pull/3559) thanks to @jwage
 - [3556: Removed 2.8 from README](https://github.com/doctrine/dbal/pull/3556) thanks to @morozov
 - [3514: Expand list of keywords in composer.json](https://github.com/doctrine/dbal/pull/3514) thanks to @Majkl578
 - [3504: fix #3479 (typos in example-code in QueryBuilder)](https://github.com/doctrine/dbal/pull/3504) thanks to @DavidBruchmann
 - [3503: Fix the branch alias for master](https://github.com/doctrine/dbal/pull/3503) thanks to @stof
 - [3463: fixed a typo in PoolingShardConnection phpdoc](https://github.com/doctrine/dbal/pull/3463) thanks to @Adapik
 - [3408: Removed unused build files](https://github.com/doctrine/dbal/pull/3408) thanks to @morozov
 - [3404: Link to Slack instead of Gitter](https://github.com/doctrine/dbal/pull/3404) thanks to @greg0ire
 - [3376: Bump version to 2.10.0-DEV](https://github.com/doctrine/dbal/pull/3376) thanks to @morozov

**CI improvements:**

 - [3688: Temporarily disable the usage of PHPUnit 8.4 due to a regression](https://github.com/doctrine/dbal/pull/3688) thanks to @morozov
 - [3654: fix Appveyor builds](https://github.com/doctrine/dbal/pull/3654) thanks to @mmucklo
 - [3644: Using command line options to configure MySQL 8 instead of mounting a config file](https://github.com/doctrine/dbal/pull/3644) thanks to @morozov
 - [3509: Enabled the build against IBM DB2 on PHP 7.3 on Travis CI](https://github.com/doctrine/dbal/pull/3509) thanks to @morozov
 - [3528: Reworked SQL Server installer on Travis CI](https://github.com/doctrine/dbal/pull/3528) thanks to @morozov
 - [3484: Use latest stable versions of sqlsrv and pdo_sqlsrv on CI](https://github.com/doctrine/dbal/pull/3484) thanks to @morozov
 - [3475: Make PHP 7.3 the primary PHP version on Travis CI](https://github.com/doctrine/dbal/pull/3475) thanks to @morozov
 - [3473: Avoid database connection from PHPUnit data providers](https://github.com/doctrine/dbal/pull/3473) thanks to @morozov
 - [3469: Replaced Xdebug with PCOV for code coverage](https://github.com/doctrine/dbal/pull/3469) thanks to @morozov
 - [3405: Travis CI: PHP 7.3 tests on MySQL 8.0](https://github.com/doctrine/dbal/pull/3405) thanks to @BenMorel
 - [3394: Grouped PHPStan and PHP_CodeSniffer for parallel execution](https://github.com/doctrine/dbal/pull/3394) thanks to @morozov
 - [3388: Require PHP 7.2, drop <7.2 in Composer & on CI](https://github.com/doctrine/dbal/pull/3388) thanks to @morozov
 - [3122: Introduced a smoke testing phase on Travis to run SQLite tests and CS checks first](https://github.com/doctrine/dbal/pull/3122) thanks to @morozov

**Deprecations:**

 - [3708: New deprecations for 2.10](https://github.com/doctrine/dbal/pull/3708) thanks to @morozov and @jwage
 - [3598: Deprecated some unused code bits](https://github.com/doctrine/dbal/pull/3598) thanks to @morozov
 - [3558: Deprecated Driver::getName()](https://github.com/doctrine/dbal/pull/3558) thanks to @morozov
 - [3554: The usage of user-provided PDO instance is deprecated](https://github.com/doctrine/dbal/pull/3554) thanks to @morozov
 - [3542: Deprecate SQLSrvStatement::LAST_INSERT_ID_SQL constant.](https://github.com/doctrine/dbal/pull/3542) thanks to @jwage
 - [3541: Deprecate the public constants in SQLParserUtils](https://github.com/doctrine/dbal/pull/3541) thanks to @jwage
  • v2.9.3
    7345cd59 · Release v2.9.3 · 
    Release v2.9.3

[![Build Status](https://travis-ci.org/doctrine/dbal.svg?branch=v2.9.3)](https://travis-ci.org/doctrine/dbal)

This release fixes regressions introduced in previous releases and other bugs.

- Total issues resolved: **5**
- Total pull requests resolved: **14**
- Total contributors: **9**

**Regressions**

 - [3686: Fixed query result caching when `FetchMode::COLUMN` is used](https://github.com/doctrine/dbal/pull/3686) thanks to @morozov and @Junker

 - [3456: Compare type class when comparing columns.](https://github.com/doctrine/dbal/pull/3456) thanks to @garret-gunter and @cs278

**Other bugs**

 - [3679: fix begin trasaction after reconnect](https://github.com/doctrine/dbal/pull/3679) thanks to @kalinin-k-a

 - [3547: Default column expressions do not work on SQL Server](https://github.com/doctrine/dbal/pull/3547) thanks to @morozov

 - [3420: Index length can be a `string`: ensure that it is an integer when read by the `MySqlSchemaManager`](https://github.com/doctrine/dbal/pull/3420) thanks to @leofeyer

**CI improvements and maintenance**

 - [3702: Updated SQL Server extensions to fix build failures on PHP 7.4](https://github.com/doctrine/dbal/pull/3702) thanks to @morozov

 - [3662: Marked connection exception test incomplete on MySQL 8](https://github.com/doctrine/dbal/pull/3662) thanks to @morozov

 - [3622: Switched from ibmcom/db2express-c to ibmcom/db2](https://github.com/doctrine/dbal/pull/3622) thanks to @morozov

 - [3465: Replaced MySQL 5.7 installed from a PPA with an official Docker image](https://github.com/doctrine/dbal/pull/3465) thanks to @morozov

 - [3454: CI: Test against PHP 7.4snapshot instead of nightly (8.0)](https://github.com/doctrine/dbal/pull/3454) thanks to @Majkl578

 - [3452: Fixed AppVeyor build configuration and the issue on SQL Server](https://github.com/doctrine/dbal/pull/3452) thanks to @morozov and @Majkl578

 - [3447: Replaced custom docker image for PostgreSQL with the official one](https://github.com/doctrine/dbal/pull/3447) thanks to @morozov

 - [3407: CI: Test against MySQL 8.0 on Travis](https://github.com/doctrine/dbal/pull/3407) thanks to @morozov

**PHP 7.4 support**

 - [3642: Fixed test failures on PHP 7.4](https://github.com/doctrine/dbal/pull/3642) thanks to @morozov
  • v2.9.2
    22800bd6 · Release v2.9.2 · 
    Release v2.9.2

[![Build Status](https://travis-ci.org/doctrine/dbal.svg?branch=v2.9.2)](https://travis-ci.org/doctrine/dbal)

This release fixes regressions introduced in v2.9.1.

- Total issues resolved: **2**

**MySQL, Schema Introspection:**

 - [3410: MySqlSchemaManager::parseCreateOptions() must be of the type string, null given](https://github.com/doctrine/dbal/issues/3410) thanks to @jarnovanleeuwen and @morozov

**MySQL, Schema Comparison:**

 - [3414: Schema migration doesn't detect index length change](https://github.com/doctrine/dbal/issues/3414) thanks to @leofeyer and @morozov
  • v2.9.1
    ec74d6e3 · Release v2.9.1 · 
    Release v2.9.1

[![Build Status](https://travis-ci.org/doctrine/dbal.svg?branch=v2.9.1)](https://travis-ci.org/doctrine/dbal)

This release fixes regressions introduced in v2.9.0 and issues specific for the SQL Anywhere platform.

- Total issues resolved: **11**

**MySQL, Schema Introspection:**

- [3389: Column option "autoincrement" => "auto" causes schema diffs](https://github.com/doctrine/dbal/issues/3389) thanks to @sandermarechal
- [3393: Fixed parsing MySQL create table flags (options without a value)](https://github.com/doctrine/dbal/pull/3393) thanks to @morozov and @AdrianSherwood
- [3398: BC Break in 2.9.0 for MySQL Tables containing partitions](https://github.com/doctrine/dbal/issues/3398) thanks to @bcremer

**SQL Anywhere:**

- [3375: [SQL Anywhere] Fix bound parameter references in PHP 7](https://github.com/doctrine/dbal/pull/3375) thanks to @deeky666
- [3378: [SQL Anywhere] Fix query limit values "0" and "null"](https://github.com/doctrine/dbal/pull/3378) thanks to @deeky666
- [3385: [SQL Anywhere] Fix fetching empty values via fetchAll()](https://github.com/doctrine/dbal/pull/3385) thanks to @deeky666
- [3386: [SQL Anywhere] Fix view schema introspection test](https://github.com/doctrine/dbal/pull/3386) thanks to @deeky666

**Schema Comparison:**

- [3382: Reverted strict comparison back to loose because of a new regression](https://github.com/doctrine/dbal/pull/3382) thanks to @morozov and @Majkl578

**Connections:**

- [3305: Fix Fetch mode query in MasterSlaveConnection](https://github.com/doctrine/dbal/pull/3305) thanks to @BradCrumb

**Cache:**

- [3381: ResultCacheStatement lost its cache capability on fetchAll method](https://github.com/doctrine/dbal/pull/3381) thanks to @roger-codina

**Documentation:**

- [3392: fixed annotations of parameter $columns in Table](https://github.com/doctrine/dbal/pull/3392) thanks to @LukasVitek and @ricardofiorani
  • v2.8.1
    a9019c1e · Release v2.8.1 · 
    Release v2.8.1

This release backports the bug fixes implemented in newer DBAL versions.

- Total issues resolved: **8**

**PostgreSQL:**

- [3158: postgres: correctly produce alter table sql comment to update column definition](https://github.com/doctrine/dbal/pull/3158) thanks to @bendavies
- [3226: Ignore case when matching ARRAY](https://github.com/doctrine/dbal/pull/3226) thanks to @ohvitorino
- [3268: Force Sequence::$initialValue type](https://github.com/doctrine/dbal/pull/3268) thanks to @vpArth

**Oracle:**

- [3297: Do not generate SID or SERVICE_NAME when dbname or service name is not specified](https://github.com/doctrine/dbal/pull/3297) thanks to @morozov and @lcp0578
- [3330: Fixed quoting of string literals containing backslash](https://github.com/doctrine/dbal/pull/3330) thanks to @morozov

**SQL Anywhere:**

- [3362: [SQL Anywhere] Disable exact row count retrieval on SQL Anywhere](https://github.com/doctrine/dbal/pull/3362) thanks to @deeky666

**Continuous Integration:**

- [3327: Use locked version of PHPStan to avoid accidental build failures](https://github.com/doctrine/dbal/pull/3327) thanks to @morozov
  • v2.9.0
    21fdabe2 · Release v2.9.0 · 
    Release v2.9.0

This is a minor release of Doctrine DBAL that aggregates over 40 fixes and improvements developed by 18 contributors over the last 5 months.

This release includes all changes of the 2.8.x series, as well as feature additions and improvements that couldn't land in patch releases.

## Backwards Compatibility Breaks

This doesn't contain any intentional Backwards Compatibility (BC) breaks.

## Deprecations

* The usage of `NULL` to specify the absence of an offset in `LIMIT`ed queries is deprecated. Use `0` instead.
* It's not recommended to rely on the default length specified by implementations of `Type`. These values are not used by the library and will be removed.
* It's not recommended to rely on the string representation of `Type` objects.
* Regular-expression based asset filters are deprecated in favor of callback-based as more extensible.
* Calling `Statement::fetchColumn()` with an invalid column index is deprecated.
* The `dbal:import` CLI command is deprecated. Please use other database client applications for import.

Please see details in the [UPGRADE.md](UPGRADE.md) documentation.

## New Features

* Added support for MariaDB 10.3.
* Added support for Windows authentication for SQL Server.
* Added support for column length in index definitions on MySQL.

## Improvements and Fixes

* Implemented handling BLOB objects represented as streams in the MySQL (`mysqli`) driver.
* Implemented handling BLOB objects represented as streams in the IDM DB2 driver.
* DBAL is now continuously tested with the PDO driver for Oracle.
* Implemented handling of URLs in master-slave and pooling-shard connection configuration.
* The codebase is now fully compatible with the Doctrine Coding Standard v5.0.

Total issues resolved: **45**

**Deprecations:**

- [3244: Deprecated dbal:import CLI command](https://github.com/doctrine/dbal/pull/3244) thanks to @morozov
- [3253: Deprecated usage of the NULL offset in LIMITed queries](https://github.com/doctrine/dbal/pull/3253) thanks to @morozov
- [3256: Deprecate Doctrine\DBAL\Types\Type::getDefaultLength()](https://github.com/doctrine/dbal/pull/3256) thanks to @Majkl578
- [3258: Deprecate Doctrine\DBAL\Types\Type::__toString()](https://github.com/doctrine/dbal/pull/3258) thanks to @Majkl578
- [3316: Deprecated regex-based asset filters](https://github.com/doctrine/dbal/pull/3316) thanks to @morozov
- [3359: Removed DataAccessTest::testFetchColumnNonExistingIndex() since it covers a bug in PDO](https://github.com/doctrine/dbal/pull/3359) thanks to @morozov

**New Features:**

- [2412: Add mysql specific indexes with lengths](https://github.com/doctrine/dbal/pull/2412) thanks to @bburnichon
- [3278: Add support for MariaDB 10.3](https://github.com/doctrine/dbal/issues/3278) thanks to @javiereguiluz
- [3283: MariaDB improvements, support 10.3](https://github.com/doctrine/dbal/pull/3283) thanks to @sidz
- [3333: Allow windows (userless/passwordless) authentication for SQL Server](https://github.com/doctrine/dbal/pull/3333) thanks to @odinsey

**Bug Fixes:**

- [3355: Implemented comparison of default values as strings regardless of their PHP types](https://github.com/doctrine/dbal/pull/3355) thanks to @morozov and @Majkl578

**Improvements:**

- [3201: Fix support for URL to account for master-slave and pooling-shard connections](https://github.com/doctrine/dbal/pull/3201) thanks to @stof
- [3217: Fix that MysqliStatement cannot handle streams](https://github.com/doctrine/dbal/pull/3217) thanks to @mpdude
- [3235: Use PSR-4 autoloader](https://github.com/doctrine/dbal/pull/3235) thanks to @Majkl578
- [3254: Throw ConversionException when unserialization fail for array and object types](https://github.com/doctrine/dbal/pull/3254) thanks to @seferov
- [3259: Update export ignores](https://github.com/doctrine/dbal/pull/3259) thanks to @Majkl578
- [3309: Implemented handling BLOBs represented as stream resources for IBM DB2](https://github.com/doctrine/dbal/pull/3309) thanks to @morozov and @mpdude
- [3331: Fetch all should use the driver statement's fetchAll method](https://github.com/doctrine/dbal/pull/3331) thanks to @michaelcullum

**Documentation Improvements:**

- [3223: GitHub template grammar/spelling fixes](https://github.com/doctrine/dbal/pull/3223) thanks to @GawainLynch
- [3232: Removed NOW() from QueryBuilder usage examples](https://github.com/doctrine/dbal/pull/3232) thanks to @morozov
- [3239: 2.8 in README & branch alias to 2.9](https://github.com/doctrine/dbal/pull/3239) thanks to @Majkl578
- [3269: Fixed type hints in DockBlocks](https://github.com/doctrine/dbal/pull/3269) thanks to @marforon
- [3275: Add .doctrine-project.json to root of the project.](https://github.com/doctrine/dbal/pull/3275) thanks to @jwage
- [3276: Update homepage](https://github.com/doctrine/dbal/pull/3276) thanks to @Majkl578
- [3280: Use behaviuor instead of  behavior](https://github.com/doctrine/dbal/pull/3280) thanks to @BackEndTea
- [3285: Remove old comment from MysqliStatement](https://github.com/doctrine/dbal/pull/3285) thanks to @mpdude
- [3318: Removed link to www.doctrine-project.org from doc blocks](https://github.com/doctrine/dbal/pull/3318) thanks to @morozov
- [3319: remove ClassLoader](https://github.com/doctrine/dbal/pull/3319) thanks to @garak
- [3337: Fix of links in documentation](https://github.com/doctrine/dbal/pull/3337) thanks to @SenseException
- [3350: Remove pdo_sqlsrv from known vendor issues list](https://github.com/doctrine/dbal/pull/3350) thanks to @ostrolucky
- [3357: Fix typo](https://github.com/doctrine/dbal/pull/3357) thanks to @BenMorel
- [3370: Removed 2.7 from README](https://github.com/doctrine/dbal/pull/3370) thanks to @morozov

**Code Quality Improvements:**

- [3252: Replaced call_user_func_array() of a fixed method with the usage of variadic arguments](https://github.com/doctrine/dbal/pull/3252) thanks to @morozov
- [3306: Fixed coding standard violations in the codebase](https://github.com/doctrine/dbal/pull/3306) thanks to @morozov
- [3303: Updated doctrine/coding-standard to 5.0, ](https://github.com/doctrine/dbal/pull/3303) thanks to @morozov
- [3317: Implemented proper escaping of string literals in platforms and schema managers](https://github.com/doctrine/dbal/pull/3317) thanks to @morozov
- [3363: Remove redundant implements](https://github.com/doctrine/dbal/pull/3363) thanks to @BenMorel

**Continuous Integration Improvements:**

- [3307: Test against the latest stable sqlsrv extension](https://github.com/doctrine/dbal/pull/3307) thanks to @morozov
- [3320: Trying to fix failing DB builds](https://github.com/doctrine/dbal/pull/3320) thanks to @morozov
- [3325: Updated PHPUnit to 7.4](https://github.com/doctrine/dbal/pull/3325) thanks to @morozov
- [3339: ContinuousPHP configuration for PDO Oracle driver](https://github.com/doctrine/dbal/pull/3339) thanks to @morozov
- [3365: Reorganize Travis build matrix](https://github.com/doctrine/dbal/pull/3365) thanks to @BenMorel