3.7.2

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

4.0.0-RC1

Breaking Changes

• Cast BIGINT values to int if possible by @cizordj and @derrabus in #6177

Improvements

• PHPUnit 10.4.0 by @derrabus and @morozov in #6123

Changes from Lower Branches

• [CI] Leverage built-in healthcheck for "db2" service by @phansys in #6159
• Fix comparator type detection by @ausi in #6168
• Correct Column->getDefault() annotation by @lolli42 in #6125
• PHPStan 1.10.38 by @derrabus in #6178

New Contributors

• @ausi made their first contribution in #6168
• @cizordj made their first contribution in #6177

Full Changelog: 4.0.0-beta3...4.0.0-RC1

3.7.1

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

4.0.0-beta3

What's Changed

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

New Contributors

• @janedbal made their first contribution in #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: 4.0.0-beta2...4.0.0-beta3

3.7.0

Release Notes for 3.7.0

3.7.0

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

New Features

• 6134: Add binary array type thanks to @shyim
• 6130: Add Type::lookupName() shortcut method thanks to @mvorisek
• 6059: Allow DsnParser to parse driverClass via $schemeMapping thanks to @kbond
• 6046: Add support for unlogged tables in PostgreSQL thanks to @f-lombardo
• 6010: Add support for SQLite shorthand form in foreign key constraints thanks to @phansys
• 5946: Support RENAME INDEX on MariaDB thanks to @Khartir
• 5916: Use Native JSON type instead of LONGTEXT for MariaDB thanks to @cgknx

Improvements

• 6150: Add a configuration setting to disable generating type comments thanks to @stof
• 6136: Support Symfony 7 by adding return types conditionally thanks to @derrabus
• 6082: Optimize TypeRegistry::lookupName() from O(N) to O(1) thanks to @mvorisek
• 6023: Remove redundant initialization of column options thanks to @morozov
• 6018: Use constants for DBAL types thanks to @phansys
• 6004: [MySQLi] Convert private property Statement::$paramTypeMap to class constant PARAM_TYPE_MAP thanks to @phansys
• 5996: Replace "magic" values with constants at DB2Platform thanks to @phansys
• 5995: Use constants for DBAL types at DB2Platform::initializeDoctrineTypeMappings() thanks to @phansys

Deprecations

• 6017: Narrow responsibilities in datetime related types thanks to @phansys
• 5957: Trigger a runtime deprecation for Connection::executeUpdate() thanks to @derrabus
• 5948: Trigger runtime deprecations for legacy API thanks to @derrabus

Static Analysis

• 5926: Restrict the possible values for the casing options under the Portability\ NS thanks to @phansys

Documentation

• 6165: Prepare release 3.7.0 thanks to @derrabus
• 6069: Add documentation for #6044 thanks to @f-lombardo

Dependencies

• 6066: Prerequisites for PHPUnit update to version 10 in 4.0.x thanks to @morozov
• 6164: PHPUnit 9.6.13, PHPStan 1.10.35 thanks to @derrabus

CI

• 6163: Update MariaDB workflows thanks to @derrabus
• 6110: Sync MariaDB support strategy with upstream thanks to @derrabus

Test Suite

• 6019: Use constants for DBAL types in tests thanks to @phansys
• 5917: Add test for Mysqli\Result thanks to @phansys

Code Style

• 6015: [CS] Apply SlevomatCodingStandard.Commenting.AnnotationName rule thanks to @phansys

3.6.7

Release Notes for 3.6.7

3.6.7

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

Bug,Drivers,MySQL,Platform Detection

• 6156: Link to correct MR for mysql deprecation thanks to @BackEndTea

CI,PostgreSQL

• 6154: Run tests against Postgres 16 thanks to @derrabus

CI

• 6152: Bump CI workflows thanks to @derrabus

Static Analysis,Test Suite

• 6151: PHPStan 1.10.34, PHPUnit 9.6.12 thanks to @derrabus
• 6139: PHPUnit 9.6.11, PHPStan 1.10.32 thanks to @derrabus

Documentation

• 6147: Fix invalid SQL in the document thanks to @takaram
• 6145: docs: link to the testing guidelines in CONTRIBUTING.md thanks to @greg0ire
• 6137: Remove duplicate alias and slug thanks to @greg0ire

Documentation,SQL Server,pdo_sqlsrv,sqlsrv

• 6140: Document driverOptions for SQL Server connections thanks to @patrick1100

3.6.6

Release Notes for 3.6.6

3.6.6

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

Bugfixes

• 6132: fix: don't trigger deprecation if called internally thanks to @dkarlovi
• 6113: Fix self deprecation from getCustomSchemaOptions thanks to @VincentLanglet
• 6108: Avoid self deprecation about listTableColumn thanks to @VincentLanglet

Documentation

• 6119: Fix a typo and a space thanks to @williamdes

Static Analysis

• 6131: PHPStan 1.10.29 thanks to @derrabus
• 6116: PHPStan 1.10.26 thanks to @derrabus

CI

• 6118: Run tests with MySQL 8.1 thanks to @derrabus

Code Style

• 6111: Pin Slevomat Coding Standard thanks to @derrabus

3.6.5

Release Notes for 3.6.5

3.6.5

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

Bug,Prepared Statements,ibm_db2

• 6093: Fix blob binding overwrite on DB2 thanks to @melekhovets

Bug

• 6086: Use Deprecation::triggerIfCalledFromOutside in listTableDetails thanks to @Aweptimum

Documentation

• 6077: Document alternative to Type::getName thanks to @Tofandel

Static Analysis,Test Suite

• 6073: PHPStan 1.10.21, PHPUnit 9.6.9, JetBrains Stubs 2023.1 thanks to @derrabus

Bug,SQL Server,Schema Introspection,Schema Management

• 6072: Fix binding unused parameter thanks to @derrabus

3.6.4

Release Notes for 3.6.4

3.6.4

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

Bug,Platforms

• 6064: trigger if called outside for AbstractPlatform::supportsCreateDropDatabase thanks to @dmaicher

CI,PHP

• 6060: Run tests with PHP 8.3 thanks to @derrabus

Bug,Schema

• 6053: Fix deprecation layer in Table thanks to @nicolas-grekas

3.6.3

Release Notes for 3.6.3

3.6.3

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

Bugfixes

• 6051: Reference the right argument thanks to @greg0ire

Static Analysis

• 6030: PHPStan 1.10.14, PHPUnit 9.6.7 thanks to @derrabus

Code Style

• 6029: Doctrine Coding Standard 12 thanks to @derrabus

Documentation

• 6036: Gender Neutral Language thanks to @edent
• 6032: Note on bindValue positional needle thanks to @edent
• 6011: [docs] Fix anchor text at types.rst thanks to @phansys