dbal

Release Notes for 3.8.7

3.8.7

• Total issues resolved: 0
• Total pull requests resolved: 8
• Total contributors: 6

Bugfixes

• 6483: Make the schema manager aware of the disabling of type comments thanks to @stof
• 6363: Properly handle MySQL error code 4031 from PHP 8.4 thanks to @mbeccati

Static Analysis

• 6476: Bump dev tools thanks to @derrabus
• 6334: Make AbstractSchemaManager covariant to its template argument thanks to @zerkms

Test Suite

• 6462: CI: Add MySQL 9, reduce test matrix thanks to @derrabus

Documentation

• 6461: Complete sentence thanks to @greg0ire

CI

• 6435: mariadb: add nightly workflow to facilitate mariadb "nightlies" thanks to @grooverdan
• 6484: Adapt to mssql-docker breaking change thanks to @greg0ire

Release Notes for 4.0.5

4.0.5

• Total issues resolved: 0
• Total pull requests resolved: 5
• Total contributors: 4

Test Suite

• 6477: PHPUnit 10.5.28 thanks to @derrabus

Documentation

• 6470: Fix update/delete aliases in documentation thanks to @PrinsFrank
• 6460: Docs: update custom platform example to use middlewares thanks to @janedbal

CI

• 6458: ci: nightly - php-8.1 only + workflow_dispatch thanks to @grooverdan
• 6457: ci: nightly - php-8.1 min version thanks to @grooverdan

This release includes changes from 3.8.7 as well

Release Notes for 4.0.4

4.0.4

• Total issues resolved: 0
• Total pull requests resolved: 2
• Total contributors: 1

Test Suite

• 6454: PHPUnit 10.5.22 thanks to @derrabus
• 6447: PHPUnit 10.5.21 thanks to @derrabus

Changes from Lower Branches

• This release contains all changes of the 3.8.6 release.

Release Notes for 3.8.6

3.8.6

• Total issues resolved: 0
• Total pull requests resolved: 4
• Total contributors: 3

Code Style

• 6453: PHP CodeSniffer 3.10.1 thanks to @derrabus

Static Analysis

• 6446: PHPStan 1.11.5 thanks to @derrabus

Bug

• 6445: Revert "Merge pull request #6413 from achterin/bugfix/foreign_key_name_change_detection" thanks to @dmaicher

Bug,SQLite,Schema Management

• 6352: Move schema split for SQLite CREATE INDEX only thanks to @mvorisek

Release Notes for 4.0.3

4.0.3

• Total issues resolved: 0
• Total pull requests resolved: 6
• Total contributors: 5

Test Suite

• 6431: Display warnings when running PHPUnit in CI thanks to @stof
• 6400: PHPUnit 10.5.20 thanks to @derrabus

Bugfix

• 6418: Fix foreign key name change detection thanks to @achterin

Static Analysis

• 6401: Psalm 5.24.0 thanks to @derrabus

Documentation

• 6394: Fix example for QB delete and update in doc block thanks to @Metabor

Code Style

• 6381: Fix SQLiteSchemaManagerTest case thanks to @mvorisek

Changes from 3.8.5 are included as well.

Release Notes for 3.8.5

3.8.5

• Total issues resolved: 0
• Total pull requests resolved: 24
• Total contributors: 9

Bugfixes

• 6425: Fix MariaDB fetching of default table character-set thanks to @grooverdan
• 6423: Fix: Skip type comparison if disableTypeComments is true thanks to @berkut1
• 6413: Fix foreign key name change detection thanks to @achterin
• 6353: Fix SQL Server "extended property" SQL generation thanks to @mvorisek
• 6338: Fix DB name passing in SqliteSchemaManager::listTableForeignKeys() thanks to @mvorisek
• 6315: Fix SQLite temp table name must not contain dot thanks to @mvorisek

Improvement

• 6412: remove duplicate set NLS_DATE_FORMAT thanks to @pilot114

Static Analysis

• 6402: Fix return type of iterateKeyValue() thanks to @derrabus
• 6399: PHPStan 1.11.1 thanks to @derrabus

Documentation

• 6430: Fix typo in the portability documentation thanks to @stof
• 6429: Fix the portability documentation thanks to @stof
• 6407: Fix documentation of supported MariaDB releases thanks to @derrabus

CI

• 6432: CI MariaDB: add 11.4, remove 11.0 thanks to @derrabus
• 6426: CI: Update MariaDB versions thanks to @grooverdan
• 6391: Bump doctrine/.github from 5.0.0 to 5.0.1 thanks to @dependabot[bot]
• 6384: Use 3.8.x as a target for dependabot version updates thanks to @greg0ire
• 6383: Setup dependabot thanks to @greg0ire
• 6379: Bump workflow actions thanks to @greg0ire
• 6374: Provide CODECOV_TOKEN thanks to @greg0ire
• 6373: Specify the minor version number for MySQL image thanks to @greg0ire
• 6372: Set fail_ci_if_error flag to true thanks to @greg0ire
• 6388: Fix "Plugin 'mysql_native_password' is not loaded" thanks to @derrabus
• 6386: Run tests against MySQL 8.4 thanks to @derrabus
• 6387: PHPStan 1.10.67, PHPUnit 9.6.19, PHPCS 3.9.2 thanks to @derrabus

Release Notes for 4.0.2

4.0.2

• Total issues resolved: 0
• Total pull requests resolved: 4
• Total contributors: 3

Documentation

• 6340: [Documentation] Fixing markup thanks to @ThomasLandauer
• 6339: Remove older versions from the docs thanks to @SenseException
• 6336: [Documentation] Adding "versionadded" thanks to @ThomasLandauer
• 6333: Update UPGRADE.md thanks to @kalifg

Changes from Lower Branches

• This release contains all changes of the 3.8.4 release.

Release Notes for 3.8.4

3.8.4

• Total issues resolved: 0
• Total pull requests resolved: 8
• Total contributors: 5

Bug,Connecting,Transactions

• 6362: Connection::setNestTransactionsWithSavepoints() should not break lazy connection thanks to @derrabus

PostgreSQL,Test Suite

• 6359: Avoid calling deprecated Type::getName() thanks to @derrabus

Bug,PostgreSQL,Schema Definition

• 6358: Ensure correct json default value normalization thanks to @sbuerk

CI,Documentation

• 6355: Document how to run integration tests locally thanks to @greg0ire

CI,MariaDB

• 6342: Add MariaDB 11.3 to the test matrix thanks to @derrabus

Documentation

• 6332: Spell which properly thanks to @greg0ire
• 6014: [Docs] Update docs regarding "datetimetz" type thanks to @phansys

Bug,SQLite,Schema Management

• 6325: Fix double quote used wrongly for literal value in SqliteSchemaManager thanks to @mvorisek

Release Notes for 4.0.1

4.0.1

• Total issues resolved: 0
• Total pull requests resolved: 7
• Total contributors: 4

Documentation

• 6318: Remove Type::canRequireSQLConversion from docs thanks to @SchmidtClaudia
• 6298: Fix typo in UPGRADE.md thanks to @txptr
• 6293: Update branch metadata thanks to @derrabus

Test Suite

• 6312: Use native intersection types in test suite thanks to @derrabus
• 6311: Migrate PHPUnit test suite to attributes thanks to @derrabus

Documentation,PostgreSQL

• 6305: [Documentation] Adding exact command for Postgres serial migration thanks to @ThomasLandauer

Static Analysis

• 6294: Psalm 5.21.1 thanks to @derrabus

Changes from Lower Branches

• This release contains all changes of the 3.8.3 release.

Release Notes for 3.8.3

3.8.3

• Total issues resolved: 0
• Total pull requests resolved: 4
• Total contributors: 3

CI

• 6323: Bump CI workflows thanks to @derrabus

Bug,Type Mapping,Types

• 6321: Make all mapped database types case insensitive thanks to @Rainrider

Bug,Configuration,Connecting,pdo_pgsql,pgsql

• 6320: Add gssencmode option to connection string for PgSQL & PDO PgSQL driver thanks to @hacfi

Static Analysis

• 6307: PHPStan 1.10.58, PHPCS 3.9.0 thanks to @derrabus

Release Notes for 3.8.2

3.8.2

• Total issues resolved: 0
• Total pull requests resolved: 4
• Total contributors: 3

Bug,Platforms,Static Analysis

• 6302: AbstractPlatform: allow any string in interval for date interval expression thanks to @ondrejmirtes

Documentation

• 6295: Move type coverage badge thanks to @greg0ire
• 6292: Update branches in README.md thanks to @derrabus
• 6291: Update branch metadata thanks to @derrabus

This is a major release that includes breaking changes. Please refer to the upgrade guide for more details.

API Improvements and Cleanup

• Strict scalar type declarations (#2854).
• Scalar parameter and return value types (#3511, #3569 and others).
• Disallow empty CompositeExpression #3868 and make it immutable #3858
• Improved error handling in prepared statements:
  • Transaction-related Statement methods return void and throw an exception
  • Converted Connection and Statement methods which returned false in case of a failure into void
• Improved behavior of Connection::getDatabase() (#3606)
• Autoincrement via identity columns on PostgreSQL
• Use native syntax for Top-N queries on Oracle (#5150) and IBM DB2 (#5156)
• Handle lost connection during commit #4713
• Reworked AbstractPlatform::get*Expression() methods #3498
• Do not require a WHERE in update() and delete() Connection operations #5567
• Improvements in exception hierarchy and semantics
• Remove defaults for MySQL table charset, collation and engine
• Convert ParameterType to enum
  • Convert enum-like classes to enums https://github.com/doctrine/dbal/pull/5554
• Improved Schema Diff API (no more public properties, almost immutable)

Major Backward Compatibility Breaks

• Get rid of hard-coded default values of maximum field lengths (#3586).
  • Column precision no longer defaults to 10. Scale and precision must be explicitly specified for decomal columns (#3348).
• Made the OFFSET in LIMIT queries non-nullable integer defaulting to 0
• Connection::quote() can only quote strings. Note that using this method is discouraged. Use prepared statements instead.
• Getting rid of the column name index #3583
• Represent table columns as list in the order of declaration #4777
• Drop support for SQL Server 2016 and older
• Drop support for Postgres 9
• Drop support for MySQL 5.6 and older and MariaDB 10.2.6 and older
• Drop support for MariaDB 10.4.2 and older
• Drop support for Oracle 12c and older
• Remove AbstractPlatform::hasNative*Type() methods and Type::requiresSQLCommentHint()
• Removed support for driver name aliases
• Removed extension via Doctrine Event Manager

Major Bugfixes

• Removed Connection::$_schemaManager() and ::getSchemaManager() (#4518)
• Removed Connection::$_expr (#4516) and ::getExpressionBuilder() (#4540)

Detailed Release Notes

• 4.0.0-RC2
• 4.0.0-RC1
• 4.0.0-beta3
• 4.0.0-beta2
• 4.0.0-beta1

Release Notes for 3.8.1

3.8.1

• Total issues resolved: 0
• Total pull requests resolved: 5
• Total contributors: 3

Static Analysis,Test Suite

• 6290: PHPStan 1.10.57, PHPUnit 9.6.16 thanks to @derrabus

Bug,Cache

• 6283: Add safety check about cache value thanks to @VincentLanglet

CI,MySQL

• 6279: Run tests with MySQL 8.3 thanks to @derrabus

Documentation

• 6278: Update branch metadata thanks to @derrabus

Improvement,MariaDB,Schema Introspection

• 6275: Avoid ambigous TABLE_NAME in query thanks to @dsentker

Breaking Changes

• Remove deprecated lock-related methods by @derrabus in https://github.com/doctrine/dbal/pull/6219
• Remove AbstractMySQLPlatform::getColumnTypeSQLSnippets() by @ausi in https://github.com/doctrine/dbal/pull/6214
• Remove API to disable column comments by @derrabus in https://github.com/doctrine/dbal/pull/6222

Improvements

• Move getJsonTypeDeclarationSQL() to AbstractMySQLPlatform by @derrabus in https://github.com/doctrine/dbal/pull/6216
• Relax return types of getExceptionConverter() implementations by @derrabus in https://github.com/doctrine/dbal/pull/6221

Changes from Lower Branches

• Enable establishing exclusive oci8 connections by @morozov in https://github.com/doctrine/dbal/pull/6182
• Add QueryBuilder::resetOrderBy() by @mbabker in https://github.com/doctrine/dbal/pull/6190
• Make the type annotation for CompositeExpression::count more specific by @oliverklee in https://github.com/doctrine/dbal/pull/6188
• Remove irrelevant details from the savepoint name by @morozov in https://github.com/doctrine/dbal/pull/6197
• MySQLSchemaManager: Check expected database type for json columns only by @cgknx in https://github.com/doctrine/dbal/pull/6189
• Fix MariaDB list columns performance by @ausi in https://github.com/doctrine/dbal/pull/6202
• Enable skipping locked rows in QueryBuilder by @morozov in https://github.com/doctrine/dbal/pull/6191
• Move schema part to the index by @greg0ire in https://github.com/doctrine/dbal/pull/6226
• Use different toctrees for different sections by @greg0ire in https://github.com/doctrine/dbal/pull/6240
• Switch to absolute paths by @greg0ire in https://github.com/doctrine/dbal/pull/6241
• Keep NVARCHAR(MAX) length as -1 by @kitloong in https://github.com/doctrine/dbal/pull/6251

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-RC1...4.0.0-RC2

Release Notes for 3.8.0

3.8.0

• Total issues resolved: 0
• Total pull requests resolved: 9
• Total contributors: 4

New Features

• 6190: Add QueryBuilder::resetOrderBy() thanks to @mbabker
• 6182: Enable establishing exclusive oci8 connections thanks to @morozov
• 6191: Enable skipping locked rows in QueryBuilder thanks to @morozov

Improvement

• 6197: Remove irrelevant details from the savepoint name thanks to @morozov

Deprecations

• 6179: Deprecate getting query parts from QueryBuilder thanks to @morozov
• 6193: Add deprecation layer and upgrade path for QueryBuilder::reset*() methods thanks to @derrabus
• 6215: Extend AbstractMySQLPlatform::getColumnTypeSQLSnippets() deprecation layer thanks to @derrabus
• 6213: Deprecate AbstractMySQLPlatform::getColumnTypeSQLSnippets() thanks to @ausi

Bugfixes

• 6195: Replace TODO with proper PR link thanks to @derrabus

Release Notes for 3.7.3

3.7.3

• Total issues resolved: 0
• Total pull requests resolved: 10
• Total contributors: 6

CI,pdo_sqlsrv,sqlsrv

• 6269: Stop using chocolatey shims thanks to @greg0ire

Bug,Documentation

• 6264: Fix deprecation message Parameter::STRING -> ParameterType::STRING thanks to @dritter

Static Analysis,Test Suite

• 6263: PHPStan 1.10.56, PHPUnit 9.6.15, PHPCS 3.8.1 thanks to @derrabus

Documentation

• 6253: Fix connection setup example in PrimaryReadReplicaConnection thanks to @smorimoto
• 6241: Switch to absolute paths thanks to @greg0ire

Bug,SQL Server,Schema Introspection

• 6251: Keep NVARCHAR(MAX) length as -1 thanks to @kitloong

Code Style

• 6238: PHP CodeSniffer 3.8.0 thanks to @derrabus

CI,MariaDB

• 6229: CI: Drop MariaDB 10.10, add MariaDB 11.2 thanks to @derrabus

Bug,SQLite,Schema Definition,Schema Management

• 6226: Move schema part to the index thanks to @greg0ire

CI

• 6148: Allow Symfony 7 in require-dev thanks to @nicolas-grekas

Release Notes for 3.7.2

3.7.2

• Total issues resolved: 0
• Total pull requests resolved: 9
• Total contributors: 5

Static Analysis

• 6223: PHPStan 1.10.42 thanks to @derrabus
• 6211: PHPStan 1.10.41 thanks to @derrabus
• 6188: Make the type annotation for CompositeExpression::count more specific thanks to @oliverklee
• 6178: PHPStan 1.10.38 thanks to @derrabus

CI,Oracle

• 6217: Add Oracle v23 to CI testing thanks to @mvorisek

Schema Introspection,Test Suite

• 6210: Generalize CustomIntrospectionTest thanks to @derrabus

CI,MySQL

• 6207: Run tests on MySQL 8.2 thanks to @derrabus

Bug,MariaDB,Performance,Schema Introspection

• 6202: Fix MariaDB list columns performance thanks to @ausi

Bug,MariaDB,Schema Introspection

• 6189: MySQLSchemaManager: Check expected database type for json columns only thanks to @cgknx

Breaking Changes

• Cast BIGINT values to int if possible by @cizordj and @derrabus in https://github.com/doctrine/dbal/pull/6177

Improvements

• PHPUnit 10.4.0 by @derrabus and @morozov in https://github.com/doctrine/dbal/pull/6123

Changes from Lower Branches

• [CI] Leverage built-in healthcheck for "db2" service by @phansys in https://github.com/doctrine/dbal/pull/6159
• Fix comparator type detection by @ausi in https://github.com/doctrine/dbal/pull/6168
• Correct Column->getDefault() annotation by @lolli42 in https://github.com/doctrine/dbal/pull/6125
• PHPStan 1.10.38 by @derrabus in https://github.com/doctrine/dbal/pull/6178

New Contributors

• @ausi made their first contribution in https://github.com/doctrine/dbal/pull/6168
• @cizordj made their first contribution in https://github.com/doctrine/dbal/pull/6177

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-beta3...4.0.0-RC1

Release Notes for 3.7.1

3.7.1

• Total issues resolved: 0
• Total pull requests resolved: 3
• Total contributors: 3

Bug,Schema Comparison

• 6168: Fix comparator type detection thanks to @ausi

CI,IBM DB2

• 6159: [CI] Leverage built-in healthcheck for "db2" service thanks to @phansys

Static Analysis

• 6125: Correct Column->getDefault() annotation thanks to @lolli42

What's Changed

• Use "numeric-string" return type for methods that return integers as strings by @phansys in https://github.com/doctrine/dbal/pull/5905
• Use closures in portability converter by @derrabus in https://github.com/doctrine/dbal/pull/5936
• Remove unused private platform methods by @derrabus in https://github.com/doctrine/dbal/pull/5944
• Remove the legacy execution and fetch API by @derrabus in https://github.com/doctrine/dbal/pull/5956
• More upgrade documentation for OraclePlatform::getSubstringExpression() by @morozov in https://github.com/doctrine/dbal/pull/5978
• Update Psalm to 5.12.0 by @morozov in https://github.com/doctrine/dbal/pull/6061
• SchemaDiff detecting errors in column definition when using custom type in 4.0.x by @janedbal in https://github.com/doctrine/dbal/pull/5988
• Update PHPUnit to 10 by @morozov in https://github.com/doctrine/dbal/pull/6065
• Psalm 5.13.1 by @derrabus in https://github.com/doctrine/dbal/pull/6075
• Restore reverse lookup determinism by @greg0ire in https://github.com/doctrine/dbal/pull/6097
• Drop support for MariaDB 10.2 and 10.3 by @derrabus in https://github.com/doctrine/dbal/pull/6122
• Psalm 5.14.1, PHPStorm Stubs 2023.2 by @derrabus in https://github.com/doctrine/dbal/pull/6124
• Remove composer-runtime-api dependency by @derrabus in https://github.com/doctrine/dbal/pull/6155
• Stricter DateTime types by @derrabus in https://github.com/doctrine/dbal/pull/6161
• Psalm 5.15.0 by @derrabus in https://github.com/doctrine/dbal/pull/6167

New Contributors

• @janedbal made their first contribution in https://github.com/doctrine/dbal/pull/5988

See also

This release contains all changes of the 3.x series since 3.6.0. For more information, please refer to the individual release announcements:

• https://github.com/doctrine/dbal/releases/tag/3.6.1
• https://github.com/doctrine/dbal/releases/tag/3.6.2
• https://github.com/doctrine/dbal/releases/tag/3.6.3
• https://github.com/doctrine/dbal/releases/tag/3.6.4
• https://github.com/doctrine/dbal/releases/tag/3.6.5
• https://github.com/doctrine/dbal/releases/tag/3.6.6
• https://github.com/doctrine/dbal/releases/tag/3.6.7
• https://github.com/doctrine/dbal/releases/tag/3.7.0

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-beta2...4.0.0-beta3