Tags: ash-m/dbal
Tags
Release 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](doctrine#3410) thanks to @jarnovanleeuwen and @morozov **MySQL, Schema Comparison:** - [3414: Schema migration doesn't detect index length change](doctrine#3414) thanks to @leofeyer and @morozov
](https://travis-ci.org/doctrine/dbal){kind=link}
Release 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](doctrine#3389) thanks to @sandermarechal - [3393: Fixed parsing MySQL create table flags (options without a value)](doctrine#3393) thanks to @morozov and @AdrianSherwood - [3398: BC Break in 2.9.0 for MySQL Tables containing partitions](doctrine#3398) thanks to @bcremer **SQL Anywhere:** - [3375: &doctrine#91;SQL Anywhere&doctrine#93; Fix bound parameter references in PHP 7](doctrine#3375) thanks to @deeky666 - [3378: &doctrine#91;SQL Anywhere&doctrine#93; Fix query limit values "0" and "null"](doctrine#3378) thanks to @deeky666 - [3385: &doctrine#91;SQL Anywhere&doctrine#93; Fix fetching empty values via fetchAll()](doctrine#3385) thanks to @deeky666 - [3386: &doctrine#91;SQL Anywhere&doctrine#93; Fix view schema introspection test](doctrine#3386) thanks to @deeky666 **Schema Comparison:** - [3382: Reverted strict comparison back to loose because of a new regression](doctrine#3382) thanks to @morozov and @Majkl578 **Connections:** - [3305: Fix Fetch mode query in MasterSlaveConnection](doctrine#3305) thanks to @BradCrumb **Cache:** - [3381: ResultCacheStatement lost its cache capability on fetchAll method](doctrine#3381) thanks to @roger-codina **Documentation:** - [3392: fixed annotations of parameter $columns in Table](doctrine#3392) thanks to @LukasVitek and @ricardofiorani
](https://travis-ci.org/doctrine/dbal){kind=link}
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](doctrine#3244) thanks to @morozov - [3253: Deprecated usage of the NULL offset in LIMITed queries](doctrine#3253) thanks to @morozov - [3256: Deprecate Doctrine\DBAL\Types\Type::getDefaultLength()](doctrine#3256) thanks to @Majkl578 - [3258: Deprecate Doctrine\DBAL\Types\Type::&doctrine#95;&doctrine#95;toString()](doctrine#3258) thanks to @Majkl578 - [3316: Deprecated regex-based asset filters](doctrine#3316) thanks to @morozov - [3359: Removed DataAccessTest::testFetchColumnNonExistingIndex() since it covers a bug in PDO](doctrine#3359) thanks to @morozov **New Features:** - [2412: Add mysql specific indexes with lengths](doctrine#2412) thanks to @bburnichon - [3278: Add support for MariaDB 10.3](doctrine#3278) thanks to @javiereguiluz - [3283: MariaDB improvements, support 10.3](doctrine#3283) thanks to @sidz - [3333: Allow windows (userless/passwordless) authentication for SQL Server](doctrine#3333) thanks to @odinsey **Bug Fixes:** - [3355: Implemented comparison of default values as strings regardless of their PHP types](doctrine#3355) thanks to @morozov and @Majkl578 **Improvements:** - [3201: Fix support for URL to account for master-slave and pooling-shard connections](doctrine#3201) thanks to @stof - [3217: Fix that MysqliStatement cannot handle streams](doctrine#3217) thanks to @mpdude - [3235: Use PSR-4 autoloader](doctrine#3235) thanks to @Majkl578 - [3254: Throw ConversionException when unserialization fail for array and object types](doctrine#3254) thanks to @seferov - [3259: Update export ignores](doctrine#3259) thanks to @Majkl578 - [3309: Implemented handling BLOBs represented as stream resources for IBM DB2](doctrine#3309) thanks to @morozov and @mpdude - [3331: Fetch all should use the driver statement's fetchAll method](doctrine#3331) thanks to @michaelcullum **Documentation Improvements:** - [3223: GitHub template grammar/spelling fixes](doctrine#3223) thanks to @GawainLynch - [3232: Removed NOW() from QueryBuilder usage examples](doctrine#3232) thanks to @morozov - [3239: 2.8 in README & branch alias to 2.9](doctrine#3239) thanks to @Majkl578 - [3269: Fixed type hints in DockBlocks](doctrine#3269) thanks to @marforon - [3275: Add .doctrine-project.json to root of the project.](doctrine#3275) thanks to @jwage - [3276: Update homepage](doctrine#3276) thanks to @Majkl578 - [3280: Use behaviuor instead of behavior](doctrine#3280) thanks to @BackEndTea - [3285: Remove old comment from MysqliStatement](doctrine#3285) thanks to @mpdude - [3318: Removed link to www.doctrine-project.org from doc blocks](doctrine#3318) thanks to @morozov - [3319: remove ClassLoader](doctrine#3319) thanks to @garak - [3337: Fix of links in documentation](doctrine#3337) thanks to @SenseException - [3350: Remove pdo&doctrine#95;sqlsrv from known vendor issues list](doctrine#3350) thanks to @ostrolucky - [3357: Fix typo](doctrine#3357) thanks to @BenMorel - [3370: Removed 2.7 from README](doctrine#3370) thanks to @morozov **Code Quality Improvements:** - [3252: Replaced call&doctrine#95;user&doctrine#95;func&doctrine#95;array() of a fixed method with the usage of variadic arguments](doctrine#3252) thanks to @morozov - [3306: Fixed coding standard violations in the codebase](doctrine#3306) thanks to @morozov - [3303: Updated doctrine/coding-standard to 5.0, ](doctrine#3303) thanks to @morozov - [3317: Implemented proper escaping of string literals in platforms and schema managers](doctrine#3317) thanks to @morozov - [3363: Remove redundant implements](doctrine#3363) thanks to @BenMorel **Continuous Integration Improvements:** - [3307: Test against the latest stable sqlsrv extension](doctrine#3307) thanks to @morozov - [3320: Trying to fix failing DB builds](doctrine#3320) thanks to @morozov - [3325: Updated PHPUnit to 7.4](doctrine#3325) thanks to @morozov - [3339: ContinuousPHP configuration for PDO Oracle driver](doctrine#3339) thanks to @morozov - [3365: Reorganize Travis build matrix](doctrine#3365) thanks to @BenMorel
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](doctrine#3158) thanks to @bendavies - [3226: Ignore case when matching ARRAY](doctrine#3226) thanks to @ohvitorino - [3268: Force Sequence::$initialValue type](doctrine#3268) thanks to @vpArth **Oracle:** - [3297: Do not generate SID or SERVICE&doctrine#95;NAME when dbname or service name is not specified](doctrine#3297) thanks to @morozov and @lcp0578 - [3330: Fixed quoting of string literals containing backslash](doctrine#3330) thanks to @morozov **SQL Anywhere:** - [3362: &doctrine#91;SQL Anywhere&doctrine#93; Disable exact row count retrieval on SQL Anywhere](doctrine#3362) thanks to @deeky666 **Continuous Integration:** - [3327: Use locked version of PHPStan to avoid accidental build failures](doctrine#3327) thanks to @morozov
Release v2.8.0 [](https://travis-ci.org/doctrine/dbal) This is a minor release of Doctrine DBAL that aggregates over 30 fixes and improvements developed over the last 3 months. This release includes all changes of the 2.7.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. **Dependency Changes** * The dependency on [doctrine/common](https://github.com/doctrine/common) is removed. DBAL now depends on [doctrine/cache](https://github.com/doctrine/cache) and [doctrine/event-manager](https://github.com/doctrine/event-manager) instead. Please see details in the [UPGRADE.md](UPGRADE.md) documentation. **Deprecations** * The usage of binary fields whose length exceeds the maximum field size on a given platform is deprecated. Please use binary fields of a size which fits all target platforms, or use blob explicitly instead. * The usage of DB-generated UUIDs is deprecated. Their format is inconsistent across supported platforms and therefore the feature is not portable. Use a PHP library (e.g. [ramsey/uuid](https://packagist.org/packages/ramsey/uuid)) to generate UUIDs on the application side. **New features** * Initial support of MySQL 8. * Initial support of PostgreSQL 11. * Ability to evaluate arbitrary SQL expressions via `AbstractPlatform::getDummySelectSQL()`. **Improvements and Fixes** * Improved support of binary fields on Oracle and IBM DB2. * Improved SQL Server configuration capabilities via both `sqlsrv` and `pdo_sqlsrv`. * Improved handling of `AUTOINCREMENT`ed primary keys in SQLite. * Integration tests are run against IBM DB2 on Travis CI. * Code coverage is collected for the Oracle platform on continuousphp. Total issues resolved: **33** **Deprecations:** - [3187: Deprecate usage of binary fields whose length exceeds maximum](doctrine#3187) thanks to @morozov - [3188: Deprecated usage of binary fields whose length exceeds the platform maximum](doctrine#3188) thanks to @morozov - [3192: Added more information to the deprecation notice](doctrine#3192) thanks to @morozov - [3212: Deprecated usage of DB-generated UUIDs](doctrine#3212) thanks to @morozov **New Features:** **Bug Fixes:** - [3149: Introduced binary binding type to support binary parameters on Oracle](doctrine#3149) thanks to @morozov - [3178: Fix incorrect exception thrown from SQLAnywhere16Platform](doctrine#3178) thanks to @Majkl578 - [3044: Functional test for allowing dynamic intervals in date sub/add](doctrine#3044) thanks to @AshleyDawson - [3049: Test failures caused by invalid database connection result in fatal error](doctrine#3049) thanks to @Majkl578 **Improvements:** - [3033: Added support for available DSN parameters for the PDOSqlsrv driver](doctrine#3033) thanks to @aashmelev - [3128: Add MySQL 8 reserved keywords](doctrine#3128) thanks to @mlocati - [3143: initialize sql array into platform files](doctrine#3143) thanks to @AlessandroMinoccheri - [3173: Fix composer branch aliases](doctrine#3173) thanks to @Majkl578 - [3157: When building a limit query, zero offset without a limit should be ignored](doctrine#3157) thanks to @morozov - [3109: Allow to specify arbitrary SQL expression in AbstractPlatform::getDummySelectSQL()](doctrine#3109) thanks to @morozov - [3141: allow creating PRIMARY KEY AUTOINCREMENT fields for sqlite (unit tests)](doctrine#3141) thanks to @TimoBakx - [3180: Import simplified version of Common\Util\Debug for var dumping purposes](doctrine#3180) thanks to @Majkl578 **Documentation Improvements:** - [3117: Added badges for the develop branch in README](doctrine#3117) thanks to @morozov - [3125: Upgrading docs](doctrine#3125) thanks to @jwage - [3144: added improvement type into pull request template](doctrine#3144) thanks to @AlessandroMinoccheri **Code Quality Improvements:** - [3025: Added PHPStan, apply changes for level 3](doctrine#3025) thanks to @Majkl578 - [3200: Php Inspections (EA Ultimate): minor code tweaks](doctrine#3200) thanks to @kalessil - [3204: Fix typo in AbstractPlatform](doctrine#3204) thanks to @Majkl578 - [3205: Ignore OCI-* classes in static analysis (no stubs)](doctrine#3205) thanks to @Majkl578 **Continuous Integration Improvements:** - [3102: Use newer PHPUnit to prevent crashes on failures](doctrine#3102) thanks to @Majkl578 - [3112: Removed hard-coded configuration filenames from the test runner](doctrine#3112) thanks to @morozov - [3133: Travis DB2](doctrine#3133) thanks to @Majkl578, @morozov - [3135: AppVeyor tweaks, retry coverage upload on failure](doctrine#3135) thanks to @Majkl578 - [3137: Workaround for the inability to use a post-PHPUnit script on ContinuousPHP](doctrine#3137) thanks to @morozov - [3151: MSSQL DLL 5.2.0 has been released.](doctrine#3151) thanks to @photodude - [3160: Test against Postgres 11](doctrine#3160) thanks to @Majkl578 **Dependencies** - [3193: DBAL 2.8 needs Common 2.9](doctrine#3193) thanks to @Majkl578 - [3176: Eliminate dependency on doctrine/common](doctrine#3176) thanks to @Majkl578 - [3181: Remove dependency on doctrine/common](doctrine#3181) thanks to @Majkl578
](https://travis-ci.org/doctrine/dbal){kind=link}
Release v2.7.2 [](https://travis-ci.org/doctrine/dbal) This release backports the bug fixes implemented in newer DBAL versions. Total issues resolved: **7** **Platforms:** - [3103: Added keywords OVER and RETURNING for MariaDb102](doctrine#3103) thanks to @mdriessen **Schema Comparison:** - [3086: Postgres, Oracle and SQL Server Sequence increment&doctrine#95;by & min&doctrine#95;value as int](doctrine#3086) thanks to @simPod - [3210: Unnecessary alter sequence queries generated on Oracle db during schema update](doctrine#3210) thanks to @bobvandevijver **Performance:** - [3114: Portability Statement still fetches all data in iterator mode](doctrine#3114) thanks to @morozov - [3115: Replaced ArrayIterator with StatementIterator in Portability\Connection](doctrine#3115) thanks to @morozov **Documentation**: - [3121: Document how to opt-in for deprecations](doctrine#3121) thanks to @Majkl578 - [3123: Opt in deprecations docs](doctrine#3123) thanks to @greg0ire
](https://travis-ci.org/doctrine/dbal){kind=link}
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
PreviousNext