v2.5.3

Total issues resolved: 2

• 818: Rebuild SQLServerPlatform::doModifyLimitQuery again to use a CTE
• 2268: #2260 - loosening doctrine/common requirement: allowing 2.6.x

v2.5.2

Total issues resolved: 24

Bug

• [DBAL-1115] - [GH-773] Fix quoted identifiers for database creation SQL on SQL Anywhere
• [DBAL-1121] - [GH-777] Make host and server connection parameters optional for sqlanywhere driver
• [DBAL-1128] - [GH-782] Fix: SQLite offset with no limit support
• [DBAL-1132] - [GH-786] Fix removing autoincrement column from a primary key
• [DBAL-1137] - Infinite recursion on non-unique table/join alias in QueryBuilder
• [DBAL-1154] - [GH-806] Fix broken functional test for SQL server
• [DBAL-1169] - [GH-815] Fix for inconsistent use of getSQLDeclaration
• [DBAL-1181] - [GH-822] Fix for bad profiling data, showing an indefinitely long query
• [DBAL-1183] - [GH-823] fix client_encoding setting to support pgbouncer
• [DBAL-1186] - [GH-826] fix incorrect ordering of columns in clustered indexes on sql server
• [DBAL-1189] - [GH-828] rehashed charset implementation to support old versions of postgresql
• [DBAL-1192] - [GH-831] allow hhvm/mysqli failure so poor travis can feel better
• [DBAL-1215] - [GH-844] template1 as default database for PostgreSQL
• [DBAL-1217] - [GH-846] Fix retrieving the database name connected to for SQL Server
• [DBAL-1218] - [GH-847] [DBAL-1217] Fix retrieving the database name connected to for SQL Anywhere
• [DBAL-1220] - [GH-849] Fix dropping database with active connection on PostgreSQL
• [DBAL-1233] - TEXT type in MSSQL should be NVARCHAR(MAX) not VARCHAR(MAX)
• [DBAL-1240] - [GH-864] Fix undefined notices within MasterSlaveConnection
• [DBAL-1260] - [GH-878] Fix call on non-object in ping() with PDO wrapper
• [DBAL-1296] - [GH-903] Override methods for sharding connection

Documentation

• [DBAL-1174] - [GH-817] Fixed a minor typo

Improvement

• [DBAL-1159] - [GH-809] travis: PHP 7.0 nightly added
• [DBAL-1270] - [GH-886] Add test for MariaDB 5.5, 10.0 and 10.1 on Travis

Task

• [DBAL-1299] - [GH-906] [2.5] Fix allowed failures for HHVM + MariaDB builds on Travis

v2.5.1

Total issues resolved: 24

Bug

• [DBAL-1033] - [GH-716] Do not TRIM() parentheses around partial indexe conditions
• [DBAL-1038] - [GH-720] Type json_array is not consistent with NULL values
• [DBAL-1051] - [GH-730] Update index name quoting in MySQL table creation
• [DBAL-1058] - It seems that MSSQL syntax was changed
• [DBAL-1060] - [GH-736] [DBAL-1058] Fix database and namespace introspection for SQL Server
• [DBAL-1062] - upgrade from v2.4.3 to v2.5.0 is forcing recreating Indexes making Doctrine unusable
• [DBAL-1063] - Exceptions from SchemaTool when running with DBAL 2.5.0
• [DBAL-1072] - [GH-741] [DBAL-1051] Quote index name in inline index declaration SQL
• [DBAL-1073] - [GH-742] Take care about mariadb platform
• [DBAL-1087] - [GH-751] Length of fixed string type (char) is ignored on Postgre schema update
• [DBAL-1088] - [GH-752] Fix error handling restore
• [DBAL-1090] - [GH-754] Changing string to fixed string is not recognized in PostgreSQL Platform
• [DBAL-1092] - [GH-756] [DBAL-1062] Fix renaming indexes used by foreign key constraints
• [DBAL-1093] - [GH-757] Fix creating and dropping database on PostgreSQL
• [DBAL-1095] - [GH-759] [DBAL-1095] Fix index introspection on SQL Anywhere
• [DBAL-1097] - [GH-760] [DBAL-1097] Fix foreign key constraint referential action on Oracle
• [DBAL-1100] - [GH-762] PostgreSQL needs explicitly closed connection in functional test
• [DBAL-1102] - [GH-764] [DBAL-1063] Allow defining duplicate indexes on a table
• [DBAL-1109] - unique-constraints names not quoted on create
• [DBAL-1111] - [GH-771] Fix unique index exception handling for an index on multiple columns in PHP 5.4

Documentation

• [DBAL-1075] - [GH-744] Removed non-phpdoc @internal tags
• [DBAL-1078] - [GH-746] minor phpdoc fixes in the platform files

Improvement

• [DBAL-1079] - [GH-747] minor phpdoc fixes in the schema files
• [DBAL-1108] - [GH-769] Allow overriding implicit indexes

v2.4.4

Total issues resolved: 9

Bug

• [DBAL-1029] - [GH-712] Backporting a fix to allow connection without dbname
• [DBAL-1038] - [GH-720] Type json_array is not consistent with NULL values
• [DBAL-1058] - It seems that MSSQL syntax was changed
• [DBAL-1061] - [GH-737] [DBAL-1058] [2.4] Fix database names introspection for SQL Server
• [DBAL-1087] - [GH-751] Length of fixed string type (char) is ignored on Postgre schema update
• [DBAL-1090] - [GH-754] Changing string to fixed string is not recognized in PostgreSQL Platform
• [DBAL-1093] - [GH-757] Fix creating and dropping database on PostgreSQL
• [DBAL-1097] - [GH-760] [DBAL-1097] Fix foreign key constraint referential action on Oracle
• [DBAL-1109] - unique-constraints names not quoted on create

v2.5.0

We are happy to announce the immediate availability of Doctrine DBAL 2.5.0 Stable. This release is a landmark in making DBAL more consistent and stable than it ever was.

Starting with 2.5 DBAL will have a new release-master, Steve Müller. Steve has been working on DBAL for the last two years and contributed many of the big features that make up this fantastic release. He will replace Benjamin Eberlei who was the release master since version 2.0.

You can install DBAL through Composer:

{
    "require": {
        "doctrine/dbal": "2.5.0"
    }
}

This version is mostly backwards compatible with only some minor breaks, when using PDO IBM, creating a custom platform or using non-default DateTime formats. You can see the breaks in the UPGRADE.md file. DBAL 2.5 is also compatible with ORM 2.4, there is no need to wait for ORM 2.5 to be released.

The following list contains the major new features of DBAL:

• Support for SAP Sybase SQL Anywhere versions 10, 11, 12 and 16 (DBAL-475)
• Support for auto-commit=NO on all drivers and platforms. (DBAL-81)
• Refactor exceptions to use common error-codes and exception classes that derive from Doctrine\DBAL\DBALException. (DBAL-407)
• Add support to retry connections with Doctrine\DBAL\Connection#ping() method. (DBAL-275)
• Add INSERT support to QueryBuilder (DBAL-320)
• Add Binary type for VARBINARY support (DBAL-714)
• Add charset and SSL connection support to PostgreSQL (DBAL-567, DBAL-702)
• Add options support for Myqli (DBAL-643)
• Add support for using database uris with the url parameter in DriverManager::getConnection() which supports several forms used by PaaS providers out of the box (DBAL-1050).
• Auto detection of platform to use based on database (DBAL-757)
• Improved SQL Server LIMIT emulation support. (Multiple tickets)
• Improvements to HHVM Support (no full support yet)

See all the changes for the 2.5.0 Release on Jira, an amazing total of 316 issues:

• DBAL 2.5.0

If you find any problems or backwards compatbililty breaks with this release please report them on JIRA or open up Pull Requests on Github.

v2.4.3

Total issues resolved: 12

• DBAL-760 - Don't return warnings as errors in sqlsrv driver #490
• DBAL-766 - PostgreSQL: Fix statement for getTableWhereClause method #492
• DBAL-759 - Fix driver error while introspecting sequences in SQL Server 2012 #489
• DDC-2883 - DBAL-766 - PostgreSQL: Fix statement for getTableWhereClause method #492
• DBAL-787 - Fix modifying limit/offset for statements with subqueries on SQL Server #512
• DBAL-792 - Fix sqlite autoincrement detection #515
• #625 - Fix pg boolean conversion
• DBAL-950 - Backport #625 - pgsql boolean conversion
• DBAL-951 - Remove duplicate suggest section in composer.json #641
• DBAL-963 - Add close() method in MasterSlaveConnection.php #652
• DBAL-976 - Fix evaluation of NOLOCK table hint on SQL Server #663
• DBAL-1006 - DBAL-717 - DBAL-335 - Fix bug in MasterSlaveConnection with keepSlave option and switch back after transaction #690

v2.4.0

[DBAL-340] - [GH-196] Fixed mini-typo
[DBAL-344] - [GH-200] params not passed from execute to logger
[DBAL-350] - [GH-205] Added exit code for dbal:reserved-words command
[DBAL-355] - [GH-208] Optimize autoload prefix in composer.json
[DBAL-356] - [GH-209] Added query micro-optimization
[DBAL-366] - [GH-218] [MySQL] Fixed bug with comments not adding quotes for tables
[DBAL-370] - [GH-220] Added support for alter table, foreign keys and autoincrement detection to Sqlite platform and schema
[DBAL-381] - [GH-227] MySql TEXT and BLOB type declarations
[DBAL-383] - [GH-228] fixed typo for enabling DEFERRED support
[DBAL-396] - [GH-236] DBAL-200 Missing docs for 1 parameter in Connection::update
[DBAL-417] - [GH-250] Lightweight export as of doctrine/orm#543
[DBAL-431] - [GH-261] Fix OFFSET without LIMIT cause MySQL syntax error.
[DBAL-432] - [GH-262] Add Symfony Console dependency to composer.json
[DBAL-435] - [GH-264] Allow passing empty arrays as parameters
[DBAL-438] - [GH-266] Removed outdated methods in DatabasePlatformMock.
[DBAL-439] - [GH-267] Add SQLServerPlatform supports schemas
[DBAL-440] - [GH-268] Remove deprecated getShowDatabasesSQL() from Platforms
[DBAL-442] - Break the query building with multiple from parts
[DBAL-445] - [GH-271] added the possibility to use column names as keys for the types in Connection::insert()
[DBAL-447] - [GH-272] Refactor SQL Server keyword dictionaries and MsSQL leftovers
[DBAL-455] - [GH-278] OraclePlatform sequence naming for primary keys
[DBAL-459] - [GH-282] Add column collation support for SQL Server
[DBAL-460] - [GH-283] Fix SchemaManagerFunctionalTestCase composite foreign keys test
[DBAL-462] - [GH-284] Correcting code example
[DBAL-473] - [GH-292] Add length in the OCI8 bindParam
[DBAL-476] - [GH-294] Allow removing column comment on some platforms
[DBAL-478] - [GH-295] Fix ModifyLimitQueryTest
[DBAL-484] - [GH-298] Fix SQL Server default constraints
[DBAL-485] - [GH-299] Fix list SQL Server composite foreign keys
[DBAL-486] - [GH-300] Improve list SQL Server table indexes
[DBAL-494] - [GH-304] Fix for DBAL-442
[DBAL-497] - SQLServerPlatform modifies limit query incorrectly when column names start with "from"
[DBAL-498] - [GH-306] [DBAL-497] Fixed SQL Server platform replacing 'FROM' in column names during limit
[DBAL-499] - [GH-307] Postgres fix for a possible unavailable dbname
[DBAL-500] - [GH-308] added index flags to schema table
[DBAL-506] - [GH-312] [DBAL-264] Support for UIDs in PostgreSQL
[DBAL-508] - MySqlSchemaManager accessing undefined index tableColumn[comment]
[DBAL-511] - Schema\ColumnDiff incorrect with default varchar value and postgresql
[DBAL-520] - [GH-319] Delete unnecessary "use PDO" statement
[DBAL-522] - BC break : executeQuery with an array containing null value(s).
[DBAL-530] - sqlite: foreignKey - definition wrong when tables has databasename as prefix
[DBAL-533] - [GH-327] #DDC-2313: QueryBuilder Deep Cloning
[DBAL-539] - [GH-332] [DDC-2470] Use column name instead of alias to modify order by clause
[DBAL-549] - [GH-339] Removed an unused method in AbstractPlatform.
[DBAL-568] - [GH-348] Portability wrapper _defaultFetchMode
[DBAL-583] - [GH-360] Don't add 'NOT NULL' to the 'ALTER TABLE' when that hasn't changed
Improvement
[DBAL-331] - [GH-192] ExpressionBuilder in and notIn methods
[DBAL-403] - [GH-240] Fix for DBAL-209