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