4.0.3

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.

3.8.5

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

4.0.2

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.

3.8.4

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

4.0.1

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.

3.8.3

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

3.8.2

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

4.0.0

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 #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

3.8.1

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

4.0.0-RC2

Breaking Changes

• Remove deprecated lock-related methods by @derrabus in #6219
• Remove AbstractMySQLPlatform::getColumnTypeSQLSnippets() by @ausi in #6214
• Remove API to disable column comments by @derrabus in #6222

Improvements

• Move getJsonTypeDeclarationSQL() to AbstractMySQLPlatform by @derrabus in #6216
• Relax return types of getExceptionConverter() implementations by @derrabus in #6221

Changes from Lower Branches

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

Full Changelog: 4.0.0-RC1...4.0.0-RC2