Tags: fabriciojs/dbal
Tags
This release fixes unintentional BC breaks: 1. It was impossible to use deprecated fetch modes with PDO-based drivers. 2. An unsupported option passed to the `Column` object prevented subsequent options from being applied. 3. Date interval values stored prior to upgrade to `v2.7.0` were reported as invalid. Total issues resolved: **10** **Backwards Compatibility Fixes:** - [3082: Custom PDO fetch modes and 2.7.0](doctrine#3082) thanks to @corphi - [3088: Fix doctrine#3082: Add BC for PDO-only fetch modes](doctrine#3088) thanks to @corphi - [3089: Don't skip column options.](doctrine#3089) thanks to @andytruong - [3093: When updating to version v2.7 type DateInterval throws errors](doctrine#3093) thanks to @fnagel - [3097: Fix compatibility for pre-2.7 DateIntervalType format](doctrine#3097) thanks to @Majkl578 **Documentation Improvements:** - [3083: Document the correct way of configuring a MariaDB database with serverVersion](doctrine#3083) thanks to @tristanbes - [3084: README: Add 2.7, drop 2.5](doctrine#3084) thanks to @Majkl578 **Continuous Integration Improvements:** - [3085: Tests: remove implicit verbose flag](doctrine#3085) thanks to @Majkl578 - [3090: Add symfony tests listener](doctrine#3090) thanks to @greg0ire - [3095: CI: Add missing listener for MariaDB @ mysqli](doctrine#3095) thanks to @Majkl578
This is a minor release of Doctrine DBAL that aggregates over 80 fixe… …s and improvements developed over the last 8 months. This release includes all changes of the `2.6.x` series, as well as feature additions and improvements that couldn't land in patch releases. **Backwards Compatibility Breaks** This release comes with one potential Backwards Compatibility (BC) break that is to be considered during upgrade. Please see the details below. **Dependency requirement changes** There are no changes in requirements to runtime dependencies. **Deprecations** * Direct usage of `PDO::` constants in calls to DBAL API is deprecated. * Calls to `\PDOStatement` methods on a `\Doctrine\DBAL\Driver\PDOStatement` instance are deprecated. * A series of enum-like constants are deprecated. * Setting unsupported options on a schema column object is deprecated. Please see details in the [UPGRADE.md](UPGRADE.md) documentation. **New features** This release introduces the following major additions: * MariaDB 10.2 platform support * PostgreSQL 10 platform support **Improvements and Fixes** This release comes with a few bug fixes and a significant set of improvements in continuous integration processes, code style and documentation: * The code is continuously tested on all supported versions of SQL Server on Windows and Linux. * The code is tested with lowest compatible versions of dependencies. * New improved code style requirements have been introduced. * The codebase has been cleaned up from the fragments required to support the older PHP versions and uses the full power of the PHP 7.1. * All pull request are validated for compliance with the coding standards before getting accepted. * Handling of platform-specific features has been improved. A detailed list of fixes can be found below. Total issues resolved: **81** **BC Breaks:** - [2579: DateIntervalType (negative support) resolves doctrine#2578](doctrine#2579) thanks to @galeaspablo **Deprecations:** - [2846: Ensure column options map to an existing method](doctrine#2846) thanks to @greg0ire - [2996: Forward compatibility with 3.x](doctrine#2996) thanks to @morozov - [2998: Extract some constants into TransactionIsolationLevel, TrimMode and DateIntervalUnit](doctrine#2998) thanks to @Majkl578 **New Features:** - [2825: MariaDB 10.2 initial support](doctrine#2825) thanks to @belgattitude - [2893: PostgreSQL 10 support](doctrine#2893) thanks to @simPod **Bug Fixes:** - [2819: PHP Fatal error: Uncaught Doctrine\\DBAL\\DBALException: Failed to connect to the database: Invalid platform version "5.5.5-10.1.25-MariaDB](doctrine#2819) thanks to @stfast - [2868: Doctrine\DBAL\Exception\InvalidFieldNameException when working with DB schema on PostgreSQL 10](doctrine#2868) thanks to @skobkin - [2988: renameColumn will changed default from NULL to 'NULL'](doctrine#2988) thanks to @kingshark8848 **Improvements:** - [2551: Implement the column collation for Mysql](doctrine#2551) thanks to @mikeSimonson - [2578: DateIntervalType (negative support)](doctrine#2578) thanks to @galeaspablo - [2588: Inherit charset from master connection if not set explicitly](doctrine#2588) thanks to @Deltachaos - [2718: Add iterators for non pdo drivers.](doctrine#2718) thanks to @jenkoian - [2616: CI testing of MSSQL on windows with AppVeyor](doctrine#2616) thanks to @photodude - [2617: Testing of MSSQL on Windows with AppVeyor](doctrine#2617) thanks to @photodude - [2835: Stop relying on Type::&doctrine#95;&doctrine#95;toString](doctrine#2835) thanks to @greg0ire - [2851: Test default value declaration for the date type](doctrine#2851) thanks to @greg0ire - [2919: Add tests for column collation to prove it works](doctrine#2919) thanks to @Tobion - [2952: Enabled testFetchLongBlob() for PDO SQL Server driver](doctrine#2952) thanks to @morozov - [2954: The IBM DB2 Statement driver suppresses errors triggered by db2&doctrine#95;execute](doctrine#2954) thanks to @morozov - [2955: Removed error suppression in IBM DB2 Statement](doctrine#2955) thanks to @morozov - [3009: PHPUnit 7](doctrine#3009) thanks to @carusogabriel - [3013: Escape LIKE metacharacters](doctrine#3013) thanks to @greg0ire - [3019: Allow dynamic intervals in DATE&doctrine#95;ADD & DATE&doctrine#95;SUB for SQLite](doctrine#3019) thanks to @fogs - [3020: Improve handling of schemas in SQL Server >= 2008](doctrine#3020) thanks to @stlrnz - [3031: Connection parameters are cached hashed](doctrine#3031) thanks to @fullbl **Documentation Improvements:** - [2793: Fix articles of words sounding with a consonant (SQL => ESS-kew-ELL)](doctrine#2793) thanks to @afoeder - [2799: Fix Shard Manager docs with more accurate docblocks in `SQLAzureShardManager` and `PoolingShardManager`](doctrine#2799) thanks to @tolbon - [2813: fixed return type into OCI8Statement](doctrine#2813) thanks to @AlessandroMinoccheri - [2814: Incorrect documentation example for `QueryBuilder#set()`](doctrine#2814) thanks to @Dormilich - [2818: doctrine#2814 removing incorrect `QueryBuilder#set()` documentation, which was showing wrong password hashing and value binding practices (combo!)](doctrine#2818) thanks to @Dormilich - [2827: use intended semantics](doctrine#2827) thanks to @greg0ire - [2840: Proofread types doc](doctrine#2840) thanks to @greg0ire - [2874: Tenant documentation typos](doctrine#2874) thanks to @phil-davis - [2875: Doc typos and grammar](doctrine#2875) thanks to @phil-davis - [2864: Removed the "OCI8: SQL Queries with Question Marks" section](doctrine#2864) thanks to @morozov - [2935: Improve deprecation wording in `Doctrine\DBAL\Schema\Column#setOptions()`](doctrine#2935) thanks to @greg0ire - [2940: Clean up note on query builder setParameter documentation](doctrine#2940) thanks to @jnvsor - [3027: Documentation: Warn against using object fields in MySQL and MariaDB](doctrine#3027) thanks to @Jasu - [3068: typo in known vendor issues documentation](doctrine#3068) thanks to @gdc676463 - [3069: fix typo in known vendor issues documentation](doctrine#3069) thanks to @gdc676463 **Continuous Integration Improvements:** - [2801: added badges for continuousphp and other badges for 2.6](doctrine#2801) thanks to @ppaulis - [2849: Update build to use stages (adding PHPCS to check for CS violations)](doctrine#2849) thanks to @lcobucci - [2920: Improve build configuration](doctrine#2920) thanks to @lcobucci - [2936: Incremental check for coding standards in pull requests](doctrine#2936) thanks to @morozov - [2946: Attempt to run PostgeSQL 10 on Travis](doctrine#2946) thanks to @Majkl578 - [2956: Travis: Test against lowest and dev dependencies](doctrine#2956) thanks to @Majkl578 - [2961: Code style check fails on develop](doctrine#2961) thanks to @morozov - [2962: Fixed code style check failures for pull request against non-master branches](doctrine#2962) thanks to @morozov - [3050: Test SQL Server 17 on Travis](doctrine#3050) thanks to @Majkl578 - [3056: Set Appveyor to use PHP 7.2](doctrine#3056) thanks to @photodude - [3062: Added badges for AppVeyor](doctrine#3062) thanks to @morozov **Code Style Improvements:** - [2789: Use short array declarations](doctrine#2789) thanks to @AlessandroMinoccheri - [2797: Typing final class DriverManager](doctrine#2797) thanks to @tolbon - [2798: Fix PSR2 rules : "the static declaration should come after visibility"](doctrine#2798) thanks to @tolbon - [2800: Fix inconsistent/missing return statements](doctrine#2800) thanks to @tolbon - [2809: Missing @throws declarations in Connection](doctrine#2809) thanks to @bestform - [2810: add @throws declarations to docs in Connection](doctrine#2810) thanks to @bestform - [2856: use newer PHP syntax](doctrine#2856) thanks to @AlessandroMinoccheri - [2857: use newer PHP syntax](doctrine#2857) thanks to @AlessandroMinoccheri - [2858: Style improvements](doctrine#2858) thanks to @greg0ire - [2869: fixed typo into security documentation](doctrine#2869) thanks to @AlessandroMinoccheri - [2927: Refactoring tests](doctrine#2927) thanks to @carusogabriel - [2932: Refactoring tests](doctrine#2932) thanks to @carusogabriel - [2934: Use Null Coalesce Operator](doctrine#2934) thanks to @carusogabriel - [2937: Clean elses](doctrine#2937) thanks to @carusogabriel - [2942: Combine consecutives unsets](doctrine#2942) thanks to @carusogabriel - [2957: Whitespaces clean-up in docs](doctrine#2957) thanks to @carusogabriel - [2965: Update Doctrine CS requirement](doctrine#2965) thanks to @Majkl578 - [2980: Simplify returns](doctrine#2980) thanks to @carusogabriel - [2999: CS: correct annotation types to use symbols specified in the CS rules](doctrine#2999) thanks to @carusogabriel - [3002: Use @var instead of @param](doctrine#3002) thanks to @carusogabriel - [3008: removed an else condition, fixed a parameter annotation and make little improvements](doctrine#3008) thanks to @AlessandroMinoccheri - [3015: A cast statement must be followed by a single space](doctrine#3015) thanks to @carusogabriel - [3026: Bump CS version to 3.0](doctrine#3026) thanks to @Majkl578 - [3077: CS bump to 4.0, imports for global functions & constants](doctrine#3077) thanks to @Majkl578 **Chore:** - [2950: Removed pre-7.1 quirks](doctrine#2950) thanks to @Majkl578 - [2989: Update license's copyright](doctrine#2989) thanks to @SenseException - [3024: Fixed unqualified PDO class name](doctrine#3024) thanks to @morozov - [3060: Development branch build fails on SQL Server](doctrine#3060) thanks to @morozov - [3061: Fixed build failure on SQL Server](doctrine#3061) thanks to @morozov - [3071: Start SQL Server using a synchronous command to avoid intermittent login failures](doctrine#3071) thanks to @morozov
This release fixes the generation of default values of immutable date… …/datetime times, default values of PostgreSQL's SERIAL types, and the required arguments for SSL connections using MySQLi. Also includes a fix for a BC-break related to json types comparison. Total issues resolved: **11** - [2815: mysqli ssl_key and ssl_cert should not be mandatory](doctrine#2815) thanks to @gauauu - [2816: doctrine#2815 don't require `ssl_key` and `ssl_cert` to use `ssl_ca`](doctrine#2816) thanks to @gauauu - [2596: Schema diff keeps thinking custom mapping types have changed](doctrine#2596) thanks to @vicdelfant - [2905: Fixes custom type comment regex](doctrine#2905) thanks to @jeremy-smith-maco - [2679: Fix: Doctrine custom types now accepts anything but ')'](doctrine#2679) thanks to @PedroTroller - [2907: Don't Set a Default Value on PostgreSQL SERIAL Fields](doctrine#2907) thanks to @chrisguitarguy - [2906: Cannot Generate [BIG]SERIAL Columns Without a Default or NOT NULL](doctrine#2906) thanks to @chrisguitarguy - [2859: DateTimeImmutable error with default value CURRENT_TIMESTAMP](doctrine#2859) thanks to @tok-amsiq - [2861: Default value declaration for immutable types](doctrine#2861) thanks to @tok-amsiq - [2880: Symfony 3 - Postgresql JSON type always appear in diff](doctrine#2880) thanks to @PapsOu - [2855: Fix BC-break regarding JsonArrayType](doctrine#2855) thanks to @lcobucci
This release fixes an incorrect optimisation in `Doctrine\DBAL\Query\Expression\CompositeExpression` which could have led to dropping query expression components. Also, DBAL was ignoring some important platform settings when determining which cache keys to use when looking for result caches: that could have led to sharing caches for results produced by different DB connections. Total issues resolved: **2** - [2785: Fix `CompositeExpression#add()` optimization, which was leading to broken `CompositeExpression` instances](doctrine#2785) thanks to @Grzesie2k - [2821: Platform from params are not correctly passed to a `QueryCacheProfile`](doctrine#2821) thanks to @kimhemsoe
This release fixes an unintentional BC break that prevented using `DateTimeImmutable` interfaces in the pre-existing date-related types. Users are still encouraged to migrate to the newly introduced immutable date types. Total issues resolved: **2** - [2794: BC Break in Date/Time related types: can no longer convert `DateTimeImmutable` to database value](doctrine#2794) thanks to @LangJ - [2795: doctrine#2794 revert bc break preventing `DateTimeImmutable` conversion](doctrine#2795) thanks to @Ocramius
This is a minor release of Doctrine DBAL that aggregates over 200 fixes and improvements that we have tested, checked, reviewed and stabilised over the last year. This release includes 10000 all changes of the `2.5.x` series, as well as feature additions and improvements that couldn't land in patch releases. **Backwards Compatibility Breaks** This release comes with few potential Backwards Compatibility (BC) breaks that, while unlikely affecting consumers of the library, are to be considered. Please take some time to read the [UPGRADE.md](UPGRADE.md) documentation. The issues related to these BC breaks are listed below. **Dependency requirement changes** The dependency requirements for DBAL 2.6.0 onwards have also changed: * HHVM is no longer officially supported * PHP 7.1.0 is the minimum supported PHP version * The PDO extension is now a required dependency **Deprecations** * The `json_array` type is now to be considered deprecated * The `Doctrine\DBAL\Schema\Table#renameColumn()` API is deprecated and disabled * The `Doctrine\DBAL\Connection#getDatabasePlatform()` may now trigger database connections, if a platform version isn't provided upfront **New features** This release introduces a few major additions: * PostgreSQL 9.4+ platform support * MySQL 5.7.9 (GA) platform support * A `JsonType` that maps to JSON column types when supported by the underlying RDBMS * `DateIntervalType` * `DateTimeImmutableType` * `DateTimeTzImmutableType` * `DateImmutableType` * `TimeImmutableType` * `PDO::FETCH_OBJ` emulation for `mysqli` and `oci8` statements * SSL root certificate configuration support for `pdo_pgsql` * SSL support for `mysqli` **Improvements and Fixes** This release comes with a myriad of improvements and bug-fixes that should improve both compatibility with exotic database engines and overall performance. We focused on stability and reliability of existing features, and improved the overall consistency of cross-platform behavior of the library. A detailed list of fixes can be found below. Total issues resolved: **224** **BC Breaks:** - [2527: Normalize method signatures for `fetch()` and `fetchAll()`, ensuring compatibility with the `PDOStatement` signature](doctrine#2527) thanks to @phansys - [2519: `ResultStatement#fetchAll()` must define 3 arguments in order to be compatible with `PDOStatement#fetchAll()`](doctrine#2519) thanks to @phansys - [2504: URL-decode URL-style DSN](doctrine#2504) thanks to @c960657 - [990: DBAL-1057 Connection is not lazy anymore when platform detection is necessary](doctrine#990) - [1072: DBAL-1130 doctrine#784 Connection is not lazy anymore, since platform detection was introduced - exposing the issue via broken test](doctrine#1072) **Deprecations:** - [916: Fix return type of `Table#renameColumn()` and mark it as deprecated](doctrine#916) thanks to @aivus - [1276: DBAL-1318 doctrine#916 Fix return type of `Table#renameColumn()` and mark it as deprecated](doctrine#1276) - [2782: Stop using the deprecated `json_array` type internally](doctrine#2782) thanks to @lcobucci **New Features:** - [718: Identify retryable transaction errors and cause them to raise specific exception types](doctrine#718) thanks to @Tobion - [798: Add `application_name` to PostgreSQL driver connection ](doctrine#798) thanks to @davividal - [814: Allow `serverVersion` to be explicitly unspecified (`null`)](doctrine#814) thanks to @BreiteSeite - [819: Added support for column inline comments in SQLite](doctrine#819) thanks to @hason - [824: DBAL-1143 Added Postgres 9.4 platform](doctrine#824) thanks to @mbeccati - [854: add `DateInterval` type](doctrine#854) thanks to @vbartusevicius - [892: DDC-3863 add a `json` type that doesn't have the flaws of `json_array`](doctrine#892) thanks to @Taluu - [919: add `sslrootcert` connection option to the `pdo_pgsql` driver](doctrine#919) thanks to @peterjmit - [1028: DBAL-1091 doctrine#755 Update `MysqliStatement` to emulate `PDO::FETCH_OBJ` behavior](doctrine#1028) - [1043: DBAL-1104 DBAL-1104 doctrine#766 Add support for object hydration in oci8 driver](doctrine#1043) - [1086: DBAL-1143 add JSONB type to PostgreSQL](doctrine#1086) - [1127: DBAL-1184 DBAL-1143 doctrine#824 Added Postgres 9.4 platform](doctrine#1127) - [1176: DBAL-1228 doctrine#854 add `DateInterval` type](doctrine#1176) - [1280: DBAL-1321 doctrine#919 add `sslrootcert` connection option to the `pdo_pgsql` driver](doctrine#1280) - [1882: DBAL-662 Support `DateTimeImmutable`](doctrine#1882) - [2266: Add native JSON type support for MySQL >=5.7.8](doctrine#2266) thanks to @ismailbaskin - [2284: Added parameter `default_dbname` to pdo_pgsql driver, used to override the default database](doctrine#2284) thanks to @kimhemsoe - [2306: Add "easy connect string" support for the Oci8Driver](doctrine#2306) thanks to @bobvandevijver - [2307: Add support for Easy Connect string as connection parameter in OracleDB](doctrine#2307) thanks to @bobvandevijver - [2450: Add immutable date types support](doctrine#2450) thanks to @deeky666 - [2455: Use native JSON type on MySQL >=5.7](doctrine#2455) thanks to @rh389 - [2570: Allow secure connections using SSL on mysqli](doctrine#2570) thanks to @pgrau - [2688: Support `IS NULL` checking in `Connection#delete()` and `Connection#update()` generated criteria, allowing for `null` column searches](doctrine#2688) thanks to @jnvsor **Bug Fixes:** - [713: Prevent result cache key collisions when sharing caches across different connections](doctrine#713) thanks to @vilartoni - [784: Connection is not lazy anymore, since platform detection was introduced - exposing the issue via broken test](doctrine#784) thanks to @weaverryan - [827: Fix `DISTINCT` queries with `LIMIT` and no `ORDER` on SQLServer 2012](doctrine#827) thanks to @billschaller - [871: `SqlConsoleCommand` should show results of queries containing `RETURNING`](doctrine#871) thanks to @bountin - [918: Fix typo in `DBALException` message](doctrine#918) thanks to @chadrien - [923: DBAL-1302 Avoid rewrapping `Docrine\DBAL\Exception\DriverException` with nested drivers](doctrine#923) thanks to @mathroc - [924: Correcting reference to the `Connection#rollBack()` method - case sensitivity](doctrine#924) thanks to @rawkode - [1018: DBAL-1082: `SchemaTool` does not generate DDL for MySQL `unsigned float`](doctrine#1018) - [1019: DBAL-1083 DBAL-1082 doctrine#749 Fix `SchemaTool`, which does not generate DDL for MySQL `unsigned float`](doctrine#1019) - [1130: DBAL-1187 doctrine#827 Fix `DISTINCT` queries with `LIMIT` and no `ORDER` on SQLServer 2012](doctrine#1130) - [1138: DBAL-1194 doctrine#832 Fix test failures on Windows due to differing newlines](doctrine#1138) - [1139: DBAL-1196 doctrine#834 Remove documentation for non-existing events from `Connection#rollBack()` docblock](doctrine#1139) - [1281: DBAL-1322 Correct typo in driver exception message](doctrine#1281) - [1344: DBAL-1783 doctrine#924 Correcting reference to the `Connection#rollBack()` method - case sensitivity](doctrine#1344) - [2250: Unit tests are failing on OracleDB](doctrine#2250) thanks to @DeepDiver1975 - [2252: `ModifyLimitQueryTest::testModifyLimitQuerySubSelect()` fails on OracleDB](doctrine#2252) thanks to @DeepDiver1975 - [2253: SchemaManagerFunctionalTestCase::testDropsDatabaseWithActiveConnections() fails on OracleDB](doctrine#2253) thanks to @DeepDiver1975 - [2254: Correct `SchemaManagerFunctionalTestCase::testDropsDatabaseWithActiveConnections()` on OracleDB](doctrine#2254) thanks to @DeepDiver1975 - [2255: Use shorter table names, as OracleDB allows max 30 characters](doctrine#2255) thanks to @DeepDiver1975 - [2263: Fix failing unit tests on OracleDB](doctrine#2263) thanks to @DeepDiver1975 - [2276: Fix test case on OracleDB](doctrine#2276) thanks to @deeky666 - [2335: Correct case sensitivity of usages of the `Connection#rollBack()` method](doctrine#2335) thanks to @kadala - [2314: `DateIntervalType` supports conversion of invalid values](doctrine#2314) thanks to @MisatoTremor - [2316: Fix `DateInterval` database value truncation (string overflow)](doctrine#2316) thanks to @vbartusevicius - [2372: Handle arbitrary whitespaces when parsing SQL in order to apply `LIMIT` for MS SQL Server](doctrine#2372) thanks to @morozov - [2413: Ensure deterministic results in the `ModifyLimitQueryTest`, which may otherwise fail depending on database settings and provisioning](doctrine#2413) thanks to @Deltachaos - [2427: Postgres SchemaManager is reading a default of `-1` as `(-1)` for postgres 9.4](doctrine#2427) thanks to @DeepDiver1975 - [2565: Both PostgreSQL 9.5 and PostgreSQL 9.6 are currently failing on Travis](doctrine#2565) thanks to @photodude - [2592: Ensure the database name is always provided when trying to use pgsql in the test suite](doctrine#2592) thanks to @mikaelkael - [2594: Schema generator is not adding `COMMENT` to custom types](doctrine#2594) thanks to @fkrauthan - [2595: `assertValidIdentifier()` is too restrictive against OracleDB schema object naming rules ](doctrine#2595) thanks to @IMP3ter - [2604: DBAL-2595 Fix retrieving last insert ID for FQN sequence name with OCI8 - allows `.` symbol in sequence names](doctrine#2604) thanks to @deeky666 - [2614: DBAL-2427 Fix negative default value introspection on PostgreSQL 9.4](doctrine#2614) thanks to @deeky666 - [2631: Fix `CREATE`/`DROP DATABASE` support on SQL Server](doctrine#2631) thanks to @deeky666 - [2632: Fix `"application_name"` connection parameter tests for PostgreSQL < 9.2](doctrine#2632) thanks to @deeky666 - [2640: Fix drivers' `exec()` method to not execute queries via prepared statements](doctrine#2640) thanks to @deeky666 - [2669: Add missing SSL parameters to the pdo_pgsql driver](doctrine#2669) thanks to @fsok - [2671: DBAL-990 Attempt platform detection even when the database name is not set](doctrine#2671) thanks to @deeky666 - [2674: Correct `testListTableColumns` checked keys](doctrine#2674) thanks to @mdwheele - [2692: Fix default isolation level for the MySqlPlatform](doctrine#2692) thanks to @jnvsor - [2701: `DB2SchemaManager#listTableNames()` does not call `filterAssetNames`](doctrine#2701) thanks to @asgrim - [2702: Added missing filtering of table name assets in DB2SchemaManager](doctrine#2702) thanks to @asgrim - [2709: Adding PDO as hard dependency as per discussion in doctrine#808](doctrine#2709) thanks to @Ocramius - [2733: Correct documented parameter and return types for `Connection#quote()`](doctrine#2733) thanks to @lolli42 - [2745: Wrong `Connection#quote()` parameter hinting, incompatible with `PDO::PARAM_*` constants](doctrine#2745) thanks to @helsner - [2747: Correct `Connection#quote()` parameter hinting, now compatible with `PDO::PARAM_*` constants](doctrine#2747) thanks to @helsner **Improvements:** - [768: DBAL-1106 Improve schema introspection performance on Oracle](doctrine#768) thanks to @deeky666 - [779: DBAL-1123 Initialize database schema only once per PHPUnit run](doctrine#779) thanks to @deeky666 - [781: Call `detectDatabasePlatform` only once](doctrine#781) thanks to @rosier - [810: Remove redundant `Connection#connect()` calls](doctrine#810) thanks to @rosier - [829: Add PostgreSQL connection test with the new `charset` parameter](doctrine#829) thanks to @billschaller - [841: Documentation and code styling fixes](doctrine#841) thanks to @BenMorel - [848: DBAL-1219 Add missing `IBMDB2` driver functional tests](doctrine#848) thanks to @deeky666 - [867: Add test for schema diffing on a table with a renamed foreign key column referencing a renamed table](doctrine#867) thanks to @billschaller - [869: Make date and time types throw exception when invalid values are passed to `convertToDatabaseValue`](doctrine#869) thanks to @billschaller - [897: Various typo and wording fixes in the codebase](doctrine#897) thanks to @SpacePossum - [899: add `requiresSQLCommentHint` in `DateIntervalType`](doctrine#899) thanks to @vbartusevicius - [902: doctrine#869 cleanups and hardening of tests around date-related types](doctrine#902) thanks to @Ocramius - [966: DBAL-1035 doctrine#718 Identify retryable transaction errors and cause them to raise specific exception type](doctrine#966) - [1011: DBAL-1076: doctrine#745 Added `doModifyLimitQuery` for the `SQLServer2012Platform`, which uses `OFFSET... FETCH` instead of `LIMIT`](doctrine#1011) - [1045: DBAL-1106 DBAL-1106 doctrine#768 Improve schema introspection performance on Oracle](doctrine#1045) - [1068: DBAL-1127 doctrine#781 Call `detect 10000 DatabasePlatform` only once](doctrine#1068) - [1085: DBAL-1142 doctrine#796 Map `tsvector` type as `text` in PostgreSQL Platform](doctrine#1085) - [1089: DBAL-1146 doctrine#798 Add `application_name` to PostgreSQL driver connection](doctrine#1089) - [1103: DBAL-1161 doctrine#810 Remove redundant `Connection#connect()` calls](doctrine#1103) - [1109: DBAL-1167 doctrine#814 allow `serverVersion` to be explicitly unspecified (`null`)](doctrine#1109) - [1118: DBAL-1176 doctrine#819 Added support for column inline comments in SQLite](doctrine#1118) - [1134: DBAL-1190 doctrine#829 Add PostgreSQL connection test with the new `charset` parameter](doctrine#1134) - [1155: DBAL-1209 doctrine#841 Documentation and code styling fixes](doctrine#1155) - [1166: DBAL-1219 DBAL-1219 doctrine#848 Add missing `IBMDB2` driver functional tests](doctrine#1166) - [1199: DBAL-1249 doctrine#869 Make date and time types throw exception when invalid values are passed to `convertToDatabaseValue`](doctrine#1199) - [1213: DBAL-1261 return callable result from `Doctrine\DBAL\Connection::transactional()`](doctrine#1213) - [1238: DBAL-1284 doctrine#897 Various typo and wording fixes in the codebase](doctrine#1238) - [1242: DBAL-1288 doctrine#899 add `requiresSQLCommentHint` in `DateIntervalType`](doctrine#1242) - [1247: DBAL-1292 Drop PHP 5.3 support](doctrine#1247) - [1248: DBAL-1293 Make date and time types throw exception when invalid values are passed to `convertToDatabaseValue`](doctrine#1248) - [1249: DBAL-1294 doctrine#869 doctrine#902 cleanups and hardening of tests around date-related types](doctrine#1249) - [2309: Remove useless ternary in the `DecimalType`](doctrine#2309) thanks to @JHGitty - [2317: Add the `ReservedWordsCommand` `-l` or `--list` parameter to the usage hints](doctrine#2317) thanks to @rquadling - [2349: Fluent methods in QueryBuilder are now documented as returning `self`](doctrine#2349) thanks to @mrclay - [2363: Add test case scenario for `LIMIT`/`OFFSET` when selecting from a sub-`SELECT`](doctrine#2363) thanks to @Deltachaos - [2419: Remove PHP 5.5 support](doctrine#2419) thanks to @Ocramius - [2422: Map custom exceptions for the "no default value" (1364) error in the MySQL drivers](doctrine#2422) thanks to @MorrisJobke - [2425: Explicitly use `CompositeExpression#count()` method rather than `count($this)`](doctrine#2425) thanks to @Progdom - [2432: Removed nearly all `call_user_*` usages](doctrine#2432) thanks to @kimhemsoe - [2437: Improve the phpdoc on `Connection`](doctrine#2437) thanks to @mnapoli - [2485: Remove unused parameter from `ConversionException::conversionFailedSerialization()`](doctrine#2485) thanks to @greg0ire - [2493: Reuse prepared statements in the SQL Server driver](doctrine#2493) thanks to @morozov - [2494: Use the same statement resource for repeated execution of the same statement on SQL Server](doctrine#2494) thanks to @morozov - [2495: Optimize and improve parameter conversion in OCI8Statement](doctrine#2495) thanks to @morozov - [2547: Replacing spaces in the pgsql DSN string with semicolons for consistency with pdo_pgsql](doctrine#2547) thanks to @Chrisissorry - [2603: DBAL-2594 Implicitly mark types as commented in all platforms](doctrine#2603) thanks to @deeky666 - [2622: Remove dead code from `MasterSlaveConnection::connect()`](doctrine#2622) thanks to @jnvsor - [2630: DBAL-2626 Add PHPUnit config for ContinuousPHP OracleDB testing](doctrine#2630) thanks to @deeky666 - [2653: Merge MySQL 5.7.9 (GA) semantics into MySQL57Platform](doctrine#2653) thanks to @deeky666 - [2657: Enhance phpdoc of `QueryBuilder::setParameter()`](doctrine#2657) thanks to @UFOMelkor - [2658: Making the `DBALException` implement `Throwable`](doctrine#2658) thanks to @svycka - [2704: Add error as well as exception handling to Mysqli drivers](doctrine#2704) thanks to @develancer - [2724: Improve `Table#getColumns()` performance by reducing its runtime complexity](doctrine#2724) thanks to @evgpisarchik - [2735: Mysqli is missing some driver connection options](doctrine#2735) thanks to @leadboots5 - [2742: Use short array declarations in the `Driver` namespace](doctrine#2742) thanks to @AlessandroMinoccheri - [2746: Using short array declarations in the `MasterSlaveConnection` namespace](doctrine#2746) thanks to @AlessandroMinoccheri - [2768: Add all missing MariaDB keywords to the MySQL platform](doctrine#2768) thanks to @roelvanduijnhoven - [2774: Use short array declarations in the `Query` namespace](doctrine#2774) thanks to @AlessandroMinoccheri - [2776: Use short array declarations in the `Sharding` namespace](doctrine#2776) thanks to @AlessandroMinoccheri - [2778: Use short array declaration inside the `Tools` namespace](doctrine#2778) thanks to @AlessandroMinoccheri - [2786: Map error code 1429 to `ConnectionException` in the `AbstractMySQLDriver`](doctrine#2786) thanks to @SpacePossum **Documentation Improvements:** - [761: Fixed typo in types documentation](doctrine#761) thanks to @BenMorel - [834: Remove documentation for non-existing events from `Connection#rollBack()` docblock](doctrine#834) thanks to @slider - [901: Update docs dependencies script and readme to target Ubuntu 14.04](doctrine#901) thanks to @billschaller - [904: Fix `tearDown` of some functional test cases](doctrine#904) thanks to @deeky666 - [907: Corrected MySQL collation support documentation](doctrine#907) thanks to @mRoca - [909: Fix typo in transactions documentation](doctrine#909) thanks to @xelan - [915: Correcting 2 anchors in the docs that don't exist anymore](doctrine#915) thanks to @mikeSimonson - [1034: DBAL-1098 doctrine#761 Fixed typo in types documentation](doctrine#1034) - [1245: DBAL-1290 doctrine#901 Update docs dependencies script and readme to target Ubuntu 14.04](doctrine#1245) - [1257: DBAL-1300 doctrine#907 Corrected MySQL collation support documentation](doctrine#1257) - [1260: DBAL-1303 doctrine#909 Fix typo in transactions documentation](doctrine#1260) - [1275: DBAL-1317 doctrine#915 Correcting 2 anchors in the docs that don't exist anymore](doctrine#1275) - [2271: Correct minor formatting glitches in the transactions documentation](doctrine#2271) thanks to @jonpasquier - [2290: Document exceptions for retryable transactions](doctrine#2290) thanks to @deeky666 - [2293: Fixed some broken links in the types documentation](doctrine#2293) thanks to @jeanCarloMachado - [2322: Improve overall DBAL raised Events documentation](doctrine#2322) thanks to @SenseException - [2382: Remove arbitrary line number from github link in the caching documentation](doctrine#2382) thanks to @jacobhenke - [2453: Documentation for test suite runner references non-existing files](doctrine#2453) thanks to @miholeus - [2454: doctrine#2453 Update test runner parameters in the documentation](doctrine#2454) thanks to @miholeus - [2521: Reference global namespace classes via FQCN in the transactions documentation](doctrine#2521) thanks to @frost-nzcr4 - [2599: Corrected styling around the `GUID` type in the types documentation](doctrine#2599) thanks to @tolbon - [2623: Generic SQL Sharding Support - Documentation of the `wrapperClass` parameter is invalid](doctrine#2623) thanks to @ivanbogomoloff - [2641: DBAL-2623 Fix Generic SQL Sharding Support documentation examples](doctrine#2641) thanks to @deeky666 - [2664: Add oci8 persistent connection support to the configuration documentation](doctrine#2664) thanks to @mathieubouchard - [2703: Correct documentation examples for the Doctrine\DBAL\Id\TableGenerator](doctrine#2703) thanks to @JustBlackBird - [2736: Correcting references to `Driver\Connection` in the documentation](doctrine#2736) thanks to @b0nd0 - [2740: Correct classes referenced in the `Driver` implementation details in the documentation](doctrine#2740) thanks to @b0nd0 - [2760: Add documentation regarding transactional exceptions](doctrine#2760) thanks to @dsantang - [2761: Fix documentation format regarding retryable exceptions](doctrine#2761) thanks to @dsantang - [2770: Fix namespace separator in the exceptions in the transactional handling documentation](doctrine#2770) thanks to @Tobion **Chore:** - [770: Moved `Doctrine\Tests` namespace to composer `autoload-dev`](doctrine#770) thanks to @guilhermeblanco - [778: DBAL-1122 Cleanup PHPUnit test suite bootstrap](doctrine#778) thanks to @deeky666 - [787: Add left-over console file to the mapped composer binaries](doctrine#787) thanks to @t0xicCode - [825: Add postgresql 9.4 to travis builds](doctrine#825) thanks to @billschaller - [830: `README.md` nicer badges, cleanup, 2.3 dropped](doctrine#830) thanks to @TomasVotruba - [832: Fix test failures on Windows due to differing newlines](doctrine#832) thanks to @billschaller - [837: Revert the addition of the wrong `bin` script to `composer.json`](doctrine#837) thanks to @stof - [853: Remove HHVM-nightly builds](doctrine#853) thanks to @stof - [876: Remove unused git submodules](doctrine#876) thanks to @Koc - [880: Drop PHP 5.3 from Travis-CI build matrix](doctrine#880) thanks to @billschaller - [884: Travis-CI - Switch to container-based infrastructure](doctrine#884) thanks to @TomasVotruba - [888: Allow testing against `doctrine/common` `2.6`](doctrine#888) thanks to @nicolas-grekas - [911: Fix test suite on windows: skip on missing extensions, correct path flags](doctrine#911) thanks to @Tobion - [917: Remove GIT submodule entries and use `autoload-dev` for the test suite](doctrine#917) thanks to @Tobion - [992: DBAL-1059: doctrine#735 Bump branch alias to version `2.6.0-DEV`](doctrine#992) - [1006: DBAL-1071: doctrine#740 Add `2.5` build status to `README.md`](doctrine#1006) - [1031: DBAL-1094: doctrine#758 Cleanup travis database creation](doctrine#1031) - [1050: DBAL-1110 doctrine#770 Moved `Doctrine\Tests` namespace to composer `autoload-dev`](doctrine#1050) - [1063: DBAL-1122 doctrine#778 Cleanup PHPUnit test suite bootstrapper](doctrine#1063) - [1064: DBAL-1123 doctrine#779 Initialize database schema only once per PHPUnit run](doctrine#1064) - [1075: DBAL-1133 doctrine#787 Add left-over console file to the mapped composer binaries](doctrine#1075) - [1128: DBAL-1185 doctrine#825 Add postgresql 9.4 to travis builds](doctrine#1128) - [1135: DBAL-1191 doctrine#830 `README.md` nicer badges, cleanup, 2.3 dropped](doctrine#1135) - [1143: DBAL-1199 doctrine#837 Revert the addition of the wrong `bin` script to `composer.json`](doctrine#1143) - [1174: DBAL-1226 doctrine#853 Remove HHVM-nightly builds](doctrine#1174) - [1209: DBAL-1258 doctrine#876 Remove unused git submodules](doctrine#1209) - [1215: DBAL-1263 doctrine#880 Drop PHP 5.3 from Travis-CI build matrix](doctrine#1215) - [1219: DBAL-1267 doctrine#884 Travis-CI - Switch to container-based infrastructure](doctrine#1219) - [1226: DBAL-1273 doctrine#888 Allow testing against `doctrine/common` `2.6`](doctrine#1226) - [1252: DBAL-1297 doctrine#904 Fix `tearDown` of some functional test cases](doctrine#1252) - [1277: DBAL-1319 doctrine#917 Remove GIT submodule entries and use `autoload-dev` for the test suite](doctrine#1277) - [1282: DBAL-1323 Remove submodule entries and improve test setup](doctrine#1282) - [2274: Removed `2.4.x` build status from `README.md`](doctrine#2274) thanks to @Ocramius - [2278: Allow PHP 7 failure on Travis-CI](doctrine#2278) thanks to @deeky666 - [2282: Allow PHP 7 + `pdo_pgsql` failures on Travis-CI again](doctrine#2282) thanks to @deeky666 - [2340: Fix SQL queries numbering in test failure output](doctrine#2340) thanks to @guilliamxavier - [2364: Display further contextual information on failed functional tests](doctrine#2364) thanks to @Deltachaos - [2435: Replace `getMock()` with `createMock()`](doctrine#2435) thanks to @deeky666 - [2488: Blacklist buggy phpunit-mock-objects v3.2.5 from the dev dependencies](doctrine#2488) thanks to @greg0ire - [2480: Exclude buggy phpunit-mock-objects v3.2.4 from the allowed dev dependencies](doctrine#2480) thanks to @greg0ire - [2550: Bump HHVM version to 3.15.2+](doctrine#2550) thanks to @photodude - [2564: Add PostgreSQL 9.6 to the build pipeline](doctrine#2564) thanks to @photodude - [2590: Remove support for PHP 5.x](doctrine#2590) thanks to @railto - [2607: DBAL-2565 Remove fragile test that cannot be abstracted across all PostgreSQL versions](doctrine#2607) thanks to @deeky666 - [2626: Test OracleDB abstractions in a continuous integration environment](doctrine#2626) thanks to @photodude - [2629: HHVM testing needs to be in PHP 7 mode](doctrine#2629) thanks to @photodude - [2633: Run SQL Azure tests conditionally](doctrine#2633) thanks to @deeky666 - [2655: Simplify Travis-CI build matrix](doctrine#2655) thanks to @photodude - [2660: Revert PgSQL and MariaDB Travis-CI build matrix simplification](doctrine#2660) thanks to @photodude - [2732: Update `docs/en/_theme` submodule references](doctrine#2732) thanks to @eibt - [2750: Require PHP 7.1](doctrine#2750) thanks to @lcobucci - [2755: Ensure compatibility with different MySQL versions](doctrine#2755) thanks to @lcobucci - [2756: Add Scrutinizer-CI to the build pipeline](doctrine#2756) thanks to @malukenho - [2757: Add mysql version 5.6 and 5.7 to Travis-CI](doctrine#2757) thanks to @epinxteren - [2758: Generate code coverage via PHPUnit, pass it to Scrutinizer-CI](doctrine#2758) thanks to @malukenho - [2764: Add mysql versions 5.6 and 5.7 to Travis-CI](doctrine#2764) thanks to @zghosts
This release fixes a number of issues around the PostgreSQL, OracleDB and MySQL platforms database introspection. Connection DSN generation fixes were applied for the SQLAnywhere driver. Corrections on how record fetching mode have been applied to the DB2 driver. Fixes were applied to the handling of cursors and result caching with pdo_sqlsrv. Total issues resolved: **16** - [889: doctrine#1234 On OracleDB, a "Table has no primary key" error is raised when the index and the constraint name don't match](doctrine#889) thanks to @nitso - [1131: DBAL-1188: OracleDB: List table columns are returned in the wrong order](doctrine#1131) thanks to @doctrinebot - [1234: DBAL-1280: "Table has no primary key" when generating entities for Oracle tables](doctrine#1234) thanks to @doctrinebot - [2405: SQLAnywhere corrections for DSN generation and persistent connections](doctrine#2405) thanks to @andipohl - [2647: DBAL-2644: Fix `fetchAll(PDO::FETCH_COLUMN)` on DB2 with Portability wrapper](doctrine#2647) thanks to @morozov - [2650: Fix result cache and PDO connection test on `pdo_sqlsrv`](doctrine#2650) thanks to @deeky666 - [2651: Fix closing statement cursor on `pdo_sqlsrv` if not executed yet](doctrine#2651) thanks to @deeky666 - [2654: Make functional sqlanywhere driver tests conditional](doctrine#2654) thanks to @deeky666 - [2670: Slash before `_` in postgresql `LIKE` condition with any `pg_` prefix to prevent confusion with the wildcard character](doctrine#2670) thanks to @blackbjorn - [2673: doctrine#1131 On OracleDB, `getListTableColumnsSQL` returns columns ordered by position instead of by name](doctrine#2673) thanks to @mdwheele - [2686: doctrine#889 On OracleDB, primary key is considered missing if `index_name != constraint_name`](doctrine#2686) thanks to @SkydiveMarius - [2696: MySQL: Fix primary key alteration when adding new columns](doctrine#2696) thanks to @drieschel - [2714: `Sequence::isAutoIncrementsFor()` is not normalising PK column, and is unable to distinguish different casing](doctrine#2714) thanks to @dhensby - [2715: doctrine#2714 `Sequence::isAutoIncrementsFor()` is now case-insensitive](doctrine#2715) thanks to @dhensby - [2720: `SQLParserUtils::getPlaceholderPositions()` fails if there are quoted strings containing only backslashes](doctrine#2720) thanks to @mondrake - [2730: Corrected duplicate `COMMENT` part in DDL statement](doctrine#2730) thanks to @mondrake
This release fixes some regressions introduced in OracleDB support in… … 2.5.11. Specifically, closing a cursor caused an `ORA-01002` exception to be raised in some scenarios. Further fixes include: * support for dropping "in use" databases in OracleDB and SQL Server (must disconnect first) * corrections in how the last insert ID is fetched on SQL Server * re-use of parameters bound to an sqlsrv statement via `bindValue()` Total issues resolved: **8** - [2634: Fix fetching last insert ID for sequences on SQL Server](doctrine#2634) - [2635: Fix date diff test](doctrine#2635) - [2636: Fix dropping in use databases on SQL Server and Oracle](doctrine#2636) - [2637: ORA-01002: fetch out of sequence](doctrine#2637) - [2638: Tear down active transactions in functional test cases](doctrine#2638) - [2639: Update Version.php](doctrine#2639) - [2645: &doctrine#91;DBAL-2637&doctrine#92; Fix closing prepared statement cursor with LOB column on Oracle](doctrine#2645) - [2646: Fix the reuse of a statement on sqlsrv with explicit bindValue()](doctrine#2646 PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org iF4EABEKAAYFAlibFbwACgkQn2X7whLsLfgh0gEAs6l4uTzevo7fRg0LmiBbq/Tv bW7rz9ckb/ZJg+X/fe8A/jG0wC7qkgWdaSypNb2cFekrRvbIYq85fdli0SqwO0hr =yGNT -----END PGP SIGNATURE-----
This release fixes a number of inconsistencies around prepared statem… …ents when `closeCursor()` is called, or when a prepared statement is re-used multiple times. Total issues resolved: **5** - [2487: Store results of subsequents statement executions same as of the first one](doctrine#2487) - [2489: Rebind row values to the statement after freeing result](doctrine#2489) - [2536: Bind result variables after each execution in order to prevent string truncation](doctrine#2536) - [2546: Prepared statements become unusable after calling closeCursor() on IBM DB2, Oracle and MS SQL Server.](doctrine#2546) - [2557: Inconsistent semantics of close cursor](doctrine#2557)
This release fixes: * some PHP 5.3 compatibility issues that caused the test suite to fail for the previous release * index renaming for indexes that had particular assigned options, and that were being added rather than renamed or recreated under a different name * `date` and `datetimetz` OracleDB type introspection: these two types were incorrectly recognized as `datetime` Total issues resolved: **4** - [2508: Renaming index does not rename the index, but creates new one](doctrine#2508) - [2555: schema generation maps oracledb `DATE` fields to `datetime`](doctrine#2555) - [2611: doctrine#2508 Pass through index options when renaming index on table](doctrine#2611) - [2612: doctrine#2555 Fix `date` and `datetimetz` type mapping on Oracle](doctrine#2612 PGP SIGNATURE----- Comment: GPGTools - https://gpgtools.org iF4EABEKAAYFAliGkFwACgkQn2X7whLsLfjXbwD/bS02kuFF45JzZ9zknMjCgdAb Ob2RFyYcgrNy3AcZSg4A/3cgjOrJVc8J7dss/WbxeHy1nrBH7f4w1qlo9e5pnwX9 =n1nX -----END PGP SIGNATURE-----
PreviousNext