Release Notes - Doctrine Project

Release Notes - Doctrine DBAL - Version 2.4 - HTML format

Configure Release Notes

Bug

[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/doctrine2#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-444] - OraclePlatform getSequenceNextValSQL not handling case/quoting properly on 11g
[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-539] - [GH-332] [DDC-2470] Use column name instead of alias to modify order by clause

Improvement

[DBAL-81] - Add support for auto-commit = NO accross databases
[DBAL-96] - Make approach towards identifier quoting consistent
[DBAL-131] - Remove Static Types
[DBAL-162] - BeforeInsertID & AfterInsertID emulation workflow, wie bei MDB2
[DBAL-163] - Upsert support in DBAL
[DBAL-325] - [GH-186] Added third an optional argument `types` to use prepared statement
[DBAL-331] - [GH-192] ExpressionBuilder in and notIn methods
[DBAL-403] - [GH-240] Fix for DBAL-209

New Feature

[DBAL-182] - Insert and Merge Query Objects
[DBAL-221] - Schema toSQL() and toDropSQL() both need to delegete creation/drop of schema-level elements
[DBAL-225] - Add events for onBeginTransaction, onCommit, onCommitFailure
[DBAL-242] - Catch and re-throw exceptions with common messages + codes

Task

[DBAL-217] - Introduction Interface for Connection
[DBAL-218] - Add Object for BulkInsert Abstraction

Sub-task

[DBAL-69] - Varchar definition should automatically switch to CLOB for sizes larger than max varchar length.

Edit/Copy Release Notes

The text area below allows the project release notes to be edited and copied to another document.

Release Notes - Doctrine DBAL - Version 2.4
    
<h2>        Bug
</h2>
<ul>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-340'>DBAL-340</a>] -         [GH-196] Fixed mini-typo
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-344'>DBAL-344</a>] -         [GH-200] params not passed from execute to logger
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-350'>DBAL-350</a>] -         [GH-205] Added exit code for dbal:reserved-words command
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-355'>DBAL-355</a>] -         [GH-208] Optimize autoload prefix in composer.json
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-356'>DBAL-356</a>] -         [GH-209] Added query micro-optimization
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-366'>DBAL-366</a>] -         [GH-218] [MySQL] Fixed bug with comments not adding quotes for tables
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-370'>DBAL-370</a>] -         [GH-220] Added support for alter table, foreign keys and autoincrement detection to Sqlite platform and schema
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-381'>DBAL-381</a>] -         [GH-227] MySql TEXT and BLOB type declarations
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-383'>DBAL-383</a>] -         [GH-228] fixed typo for enabling DEFERRED support
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-396'>DBAL-396</a>] -         [GH-236] DBAL-200 Missing docs for 1 parameter in Connection::update
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-417'>DBAL-417</a>] -         [GH-250] Lightweight export as of doctrine/doctrine2#543
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-431'>DBAL-431</a>] -         [GH-261] Fix OFFSET without LIMIT cause MySQL syntax error.
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-432'>DBAL-432</a>] -         [GH-262] Add Symfony Console dependency to composer.json
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-435'>DBAL-435</a>] -         [GH-264] Allow passing empty arrays as parameters
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-438'>DBAL-438</a>] -         [GH-266] Removed outdated methods in DatabasePlatformMock.
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-439'>DBAL-439</a>] -         [GH-267] Add SQLServerPlatform supports schemas
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-440'>DBAL-440</a>] -         [GH-268] Remove deprecated getShowDatabasesSQL() from Platforms
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-442'>DBAL-442</a>] -         Break the query building with multiple from parts
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-444'>DBAL-444</a>] -         OraclePlatform getSequenceNextValSQL not handling case/quoting properly on 11g
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-445'>DBAL-445</a>] -         [GH-271] added the possibility to use column names as keys for the types in Connection::insert()
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-447'>DBAL-447</a>] -         [GH-272] Refactor SQL Server keyword dictionaries and MsSQL leftovers
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-455'>DBAL-455</a>] -         [GH-278] OraclePlatform sequence naming for primary keys
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-459'>DBAL-459</a>] -         [GH-282] Add column collation support for SQL Server
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-460'>DBAL-460</a>] -         [GH-283] Fix SchemaManagerFunctionalTestCase composite foreign keys test
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-462'>DBAL-462</a>] -         [GH-284] Correcting code example
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-473'>DBAL-473</a>] -         [GH-292] Add length in the OCI8 bindParam
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-476'>DBAL-476</a>] -         [GH-294] Allow removing column comment on some platforms
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-478'>DBAL-478</a>] -         [GH-295] Fix ModifyLimitQueryTest
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-484'>DBAL-484</a>] -         [GH-298] Fix SQL Server default constraints
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-485'>DBAL-485</a>] -         [GH-299] Fix list SQL Server composite foreign keys
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-486'>DBAL-486</a>] -         [GH-300] Improve list SQL Server table indexes
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-494'>DBAL-494</a>] -         [GH-304] Fix for DBAL-442
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-497'>DBAL-497</a>] -         SQLServerPlatform modifies limit query incorrectly when column names start with &quot;from&quot;
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-498'>DBAL-498</a>] -         [GH-306] [DBAL-497] Fixed SQL Server platform replacing &#39;FROM&#39; in column names during limit
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-499'>DBAL-499</a>] -         [GH-307] Postgres fix for a possible unavailable dbname
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-500'>DBAL-500</a>] -         [GH-308] added index flags to schema table
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-506'>DBAL-506</a>] -         [GH-312] [DBAL-264] Support for UIDs in PostgreSQL
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-508'>DBAL-508</a>] -         MySqlSchemaManager accessing undefined index tableColumn[comment]
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-511'>DBAL-511</a>] -         Schema\ColumnDiff incorrect with default varchar value and postgresql
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-520'>DBAL-520</a>] -         [GH-319] Delete unnecessary &quot;use PDO&quot; statement
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-522'>DBAL-522</a>] -         BC break : executeQuery with an array containing null value(s).
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-530'>DBAL-530</a>] -         sqlite: foreignKey - definition wrong when tables has databasename as prefix
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-539'>DBAL-539</a>] -         [GH-332] [DDC-2470] Use column name instead of alias to modify order by clause
</li>
</ul>
        
<h2>        Improvement
</h2>
<ul>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-81'>DBAL-81</a>] -         Add support for auto-commit = NO accross databases
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-96'>DBAL-96</a>] -         Make approach towards identifier quoting consistent
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-131'>DBAL-131</a>] -         Remove Static Types
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-162'>DBAL-162</a>] -         BeforeInsertID &amp; AfterInsertID emulation workflow, wie bei MDB2
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-163'>DBAL-163</a>] -         Upsert support in DBAL
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-325'>DBAL-325</a>] -         [GH-186] Added third an optional argument `types` to use prepared statement
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-331'>DBAL-331</a>] -         [GH-192] ExpressionBuilder in and notIn methods
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-403'>DBAL-403</a>] -         [GH-240] Fix for DBAL-209
</li>
</ul>
    
<h2>        New Feature
</h2>
<ul>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-182'>DBAL-182</a>] -         Insert and Merge Query Objects
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-221'>DBAL-221</a>] -         Schema toSQL() and toDropSQL() both need to delegete creation/drop of schema-level elements
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-225'>DBAL-225</a>] -         Add events for onBeginTransaction, onCommit, onCommitFailure
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-242'>DBAL-242</a>] -         Catch and re-throw exceptions with common messages + codes
</li>
</ul>
    
<h2>        Task
</h2>
<ul>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-217'>DBAL-217</a>] -         Introduction Interface for Connection
</li>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-218'>DBAL-218</a>] -         Add Object for BulkInsert Abstraction
</li>
</ul>
    
<h2>        Sub-task
</h2>
<ul>
<li>[<a href='http://doctrine-project.org/jira/browse/DBAL-69'>DBAL-69</a>] -         Varchar definition should automatically switch to CLOB for sizes larger than max varchar length.
</li>
</ul>