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

3.8.0

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

3.7.3

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