Dbal Laravel Package

Release Notes for 4.4.3

4.4.3

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

Bug

• 7336: Fix Json object mapping thanks to @VincentLanglet

Bug,QueryBuilder

• 7326: Make it possible to create union main part for a CTE thanks to @sbuerk

Release Notes for 4.4.2

4.4.2

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

Test Suite

• 7306: Avoid mocks without expectations thanks to @derrabus

Bug,Error Handling,Transactions,mysqli

• 7276: Catch mysqli_sql_exception from mysqli::begin_transaction() thanks to @morozov

Bug,Default Values,Schema Definition,Schema Introspection

• 7275: Introspect default expressions as DefaultExpression thanks to @morozov

Bug,Columns,Schema Definition

• 7238: Fix enumType handling in Column thanks to @VincentLanglet

Changes from lower branches

• This release includes all changes from the 3.10.5 release.

Release Notes for 3.10.5

3.10.5

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

CI

• 7319: Bump laminas/automatic-releases from 1.25.0 to 1.26.2 thanks to @dependabot[bot]
• 7259: Bump dessant/lock-threads from 5 to 6 thanks to @dependabot[bot]
• 7258: Bump actions/upload-artifact from 5 to 6 thanks to @dependabot[bot]
• 7257: Bump actions/download-artifact from 6 to 7 thanks to @dependabot[bot]
• 7235: chore: show parameters in name of CI jobs thanks to @alexislefebvre

Dependencies,Test Suite

• 7298: Bump PHPUnit version thanks to @greg0ire

Dependencies

• 7292: Bump coding standard tools thanks to @greg0ire

CI,MariaDB,MySQL

• 7283: Test against newer MySQL/MariaDB releases thanks to @derrabus

CI,SQL Server

• 7279: Test against SQL Server 2025 in nightly builds thanks to @morozov
• 7265: Test against SQL Server 2025 thanks to @derrabus

Bug

• 7272: Add phpstan-baseline.neon, CONTRIBUTING.md, README.md to export-ignore list thanks to @sasezaki

CI,PHP,pdo_oci

• 7236: Test Oracle drivers on PHP 8.5 thanks to @derrabus

Documentation

• 7233: Prepare the 4.4.0 release thanks to @derrabus

Release Notes for 4.4.1

4.4.1

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

Bug,Transactions

• 7240: Don't attempt to rollback when connections are lost thanks to @lcobucci

Release Notes for 4.4.0

4.4.0

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

Improvement,MariaDB,MySQL,Schema Comparison,Schema Definition

• 7221: Change MySQL bool declaration from TINYINT(1) to TINYINT thanks to @rixafy and @derrabus

Schema Management,Test Suite

• 7200: Remove redundant unit test thanks to @morozov

Default Values,Deprecation,Improvement,Schema Definition

• 7195: Introduce DefaultExpression thanks to @morozov

Deprecation,Schema Definition

• 7186: Deprecate creation of empty namespaces thanks to @morozov
• 7102: Deprecate using keys of table-scoped object collections as names thanks to @morozov
• 7100: Deprecate extending schema classes thanks to @morozov

SQLite,Schema Management

• 7172: Reorganize SQLitePlatform comment methods thanks to @morozov

Deprecation,Foreign Keys,Schema Comparison,Schema Management

• 7157: Deprecate TableDiff::getDroppedForeignKeys() thanks to @morozov

Documentation,Foreign Keys,Schema Management

• 7155: Remove obsolete upgrade note thanks to @santysisi

Deprecation,Improvement,Schema Introspection

• 7153: Introduce new schema introspection API thanks to @morozov

Bug,Schema Comparison,Schema Management

• 7143: Deprecate unnamed foreign key constraints in $droppedForeignKeys of TableDiff thanks to @santysisi

Bug,Deprecation,Foreign Keys,Schema Definition

• 7125: Deprecate overwriting existing foreign key constraints thanks to @santysisi

Deprecation,Schema Comparison

• 7115: Deprecate Sequence setters thanks to @morozov

Deprecation,Improvement

• 7109: Introduce view editor thanks to @morozov

Deprecation,Improvement,Schema Definition

• 7108: Introduce sequence editor thanks to @morozov

Improvement,Schema Definition

• 7101: Implement IteratorAggregate in ObjectSet subclasses thanks to @morozov

Deprecation,Schema

• 7094: Deprecate AbstractAsset::getName() thanks to @morozov

Deprecation,Identifiers

• 7084: Deprecate AbstractAsset::isQuoted() thanks to @morozov

Documentation

• 7054: Document the JSON_OBJECT type thanks to @VincentLanglet

New Feature,Type Conversion,Types

• 7053: [RFC] Introduce Types::JSON_OBJECT thanks to @VincentLanglet

Bug,Configuration,Deprecation,oci8,pdo_oci

• 7042: Deprecate "service" connection parameter thanks to @morozov

New Feature,QueryBuilder

• 7040: Add a nice way to create a builder for subqueries thanks to @derrabus

New Feature,Schema Definition

• 7034: Use provided length for enum type if given for non-mysql platform thanks to @VincentLanglet

Release Notes for 4.3.5

4.3.5

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

CI

• 7203: Bump dependabot target branch thanks to @greg0ire

MySQL,Prepared Statements,Regression,SQL Parser

• 7202: Use MySQL syntax for parsing SQL in AbstractMySQLPlatform thanks to @morozov

Changes from older releases

• This release contains all the changes of the 3.10.4 release.

Release Notes for 3.10.4

3.10.4

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

CI

• 7229: Bump GitHub actions thanks to @derrabus
• 7228: Test against stable Symfony 8 thanks to @derrabus
• 7225: Bump doctrine/.github/.github/workflows/coding-standards.yml from 12.2.0 to 13.0.0 thanks to @dependabot[bot]
• 7224: Bump doctrine/.github/.github/workflows/documentation.yml from 12.2.0 to 13.0.0 thanks to @dependabot[bot]
• 7223: Bump doctrine/.github/.github/workflows/phpstan.yml from 12.2.0 to 13.0.0 thanks to @dependabot[bot]
• 7209: Bump docs workflow thanks to @greg0ire
• 7207: Bump actions/stale from 9 to 10 thanks to @dependabot[bot]
• 7206: Bump actions/upload-artifact from 4 to 5 thanks to @dependabot[bot]
• 7205: Bump actions/checkout from 4 to 5 thanks to @dependabot[bot]

CI,PHP

• 7219: Run CI on PHP 8.5 thanks to @derrabus

Bug,Connecting,PDO

• 7214: Hide sensitive parameters in PDOConnect::doConnect() thanks to @dmitryuk

Static Analysis

• 7210: Ignore PHPStan issue about missing offset thanks to @greg0ire

Release Notes for 4.3.4

4.3.4

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

Bug,PHP,Types

• 7180: Fix the unsigned BIGINT check for PHP 8.5 thanks to @derrabus

Drivers,Test Suite

• 7178: Remove driver unit test boilerplate thanks to @morozov

Documentation,Schema Definition

• 7176: Documentation on object names thanks to @morozov

Bug,Identifiers,Schema Introspection

• 7147: Trigger invalid name deprecation only for outside calls thanks to @morozov and @keulinho

Release Notes for 3.10.3

3.10.3

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

Test Suite

• 7188: phpunit/phpunit (9.6.23 => 9.6.29) thanks to @derrabus

Static Analysis

• 7187: phpstan/phpstan (2.1.22 => 2.1.30) thanks to @derrabus

Documentation

• 7183: Improve DBAL migration docs for object, array and json_array type removals. thanks to @beberlei

Db2,Documentation

• 7177: Consistently reference IBM Db2 as Db2 thanks to @morozov

PHP,Schema Management

• 7174: replace SplObjectStorage::attach() with SplObjectStorage::offsetSet() thanks to @xabbuh

Improvement

• 7173: do not call setAccessible() on PHP >= 8.1 thanks to @xabbuh

Dependencies

• 7170: Bump doctrine/coding-standard to v14 thanks to @greg0ire

CI,MariaDB

• 7148: Add MariaDB 12 to our CI thanks to @derrabus

CI,ibm_db2

• 7130: Test with ibm_db2 on PHP 8.4 thanks to @morozov

Release Notes for 4.3.3

4.3.3

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

Documentation

• 7138: Remove obsolete upgrade note thanks to @derrabus
• 7099: fix: see PrimaryKeyConstraint annotation thanks to @simPod

Changes from Lower Branches

This release contains all changes of the 3.10.2 release.

Release Notes for 3.10.2

3.10.2

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

Backport: PDO subclasses on PHP 8.4+

This release contains a backport of a feature shipped with DBAL 4.2 originally. This was necessary because of deprecations introduced in PHP 8.5.

On PHP 8.4, if you call getNativeConnection() on a connection established through one of the PDO drivers, you will get an instance of the new PDO subclasses, e.g. Pdo\Mysql or Pdo\Pgsql instead of just PDO.

• 7132: Leverage PHP 8.4 PDO classes, fix PHP 8.5 deprecation thanks to @nicolas-grekas
• 7141: Make options check strict again thanks to @derrabus
• 7137: Document the PDO subclasses backport thanks to @derrabus

Bugfixes

• 7136: Workaround for MySQL 8.4 and unknown users thanks to @derrabus

CI Improvements

• 7142: Don't test against Symfony Cache 8 thanks to @derrabus
• 7134: Downgrade PHP for the DB2 workflow thanks to @derrabus
• 7133: Run tests on MySQL 8.4 LTS and 9.4 thanks to @derrabus
• 7118: Remove integration with AppVeyor thanks to @morozov

Code Style

• 7091: Bump doctrine/coding-standard thanks to @greg0ire

Static Analysis

• 7089: phpstan/phpstan (2.1.17 => 2.1.22) thanks to @derrabus
• 7080: phpstan/phpstan (2.1.17 => 2.1.22) thanks to @derrabus

Test Suite

• 7076: Fix argument count of data providers thanks to @derrabus

Release Notes for 4.3.2

4.3.2

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

Deprecation

• 7073: Deprecate the new MariaDB110700Platform class thanks to @derrabus

Improvement

• 7065: Improve deprecation thanks to @greg0ire

Documentation,Schema Definition

• 7064: Update schema definition documentaion thanks to @morozov

Bug,Schema Introspection,pdo_pgsql

• 7052: Fix introspection on PDO_pgsql with PDO::STRINGIFY_FETCHES enabled thanks to @keulinho

Changes from Lower Branches

• This release contains all changes from the 3.10.1 release.

Release Notes for 3.10.1

3.10.1

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

CI,SQL Server

• 7069: CI: Update SQL Server to version 2022 thanks to @derrabus

Bug,MariaDB,Reserved Keywords

• 7061: Add support of new reserved word VECTOR (MariaDB 11.7+) thanks to @susnux

Bug,Prepared Statements,pgsql

• 7059: Fix binding null as a boolean parameter on pgsql thanks to @derrabus

Documentation

• 7039: Remove obsolete todo thanks to @derrabus

Test Suite,oci8,pdo_oci

• 7037: Do not hardcode allowed parameters in TestUtil thanks to @morozov

Documentation,pdo_mysql,pdo_pgsql

• 7019: Update documentation on driver parameters thanks to @morozov

Release Notes for 4.3.1

4.3.1

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

Bug,SQLite,Schema Introspection

• 7050: Fix case sensitivity in SQLite column types thanks to @27pchrisl

Bug,Oracle

• 7043: Quote Oracle user password thanks to @morozov

Bug,PostgreSQL,Schema Management

• 7035: Avoid useless extra query in Psql thanks to @VincentLanglet

Bug,Schema Introspection

• 7028: Fix length type in MySQLSchemaManager with ATTR_STRINGIFY_FETCHES enabled thanks to @keulinho

Bug,MariaDB,Schema Introspection

• 7025: Quote MySQL constraint names for foreign keys thanks to @grooverdan

Release Notes for 3.10.0

3.10.0

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

Documentation

• 7018: Prepare 3.10.0 thanks to @derrabus
• 7011: [DOC] mysqli supports persistent connections thanks to @liayn

Improvement,SQL Parser

• 6926: feat: improve performance of sql parser thanks to @shyim

Cache,Dependencies,Improvement

• 6740: Make doctrine/cache optional thanks to @derrabus

Release Notes for 4.3.0

4.3.0

• Total issues resolved: 3
• Total pull requests resolved: 103
• Total contributors: 9

New Features

• 6966: Add more TableEditor methods thanks to @morozov
• 6927: Add shorthand name-related methods to schema object editors thanks to @morozov
• 6890: Introduce ComparatorConfig::withReportModifiedIndexes() thanks to @morozov and @sbuerk
• 6686: Add a NumberType that maps to the BcMath\Number value object thanks to @derrabus
• 6660: Introduce table editor thanks to @morozov
• 6621: Add CTE support to select in QueryBuilder thanks to @nio-dtp
• 6300: Make column and index renaming configurable thanks to @ausi

Improvements

• 6981: Clean up SQL Server LIKE wildcard characters thanks to @morozov
• 6965: Populate indexed column lengths only with non-null values thanks to @morozov
• 6964: Populate foreign key constraint options only with non-default values thanks to @morozov
• 6962: Require Doctrine Deprecations 1.1.5 thanks to @morozov
• 6958: Preserve the non-clustered property of the PK constraint thanks to @morozov
• 6944: Clean up SQLite column definition parsing thanks to @morozov
• 6943: Include object name in editor exception messages thanks to @morozov
• 6934: Update TableEditor API thanks to @morozov
• 6933: Simplify Postgres column introspection thanks to @morozov
• 6932: Clean up MySQL column type parsing thanks to @morozov
• 6931: Clean up SQL Server column type parsing thanks to @morozov
• 6923: Mark classes as read-only, internal and final thanks to @morozov
• 6907: Rework foreign key constraint introspection on SQLite thanks to @morozov
• 6904: Rework index introspection on SQLite thanks to @morozov
• 6901: Reintroduce PHP 8.2 support thanks to @derrabus
• 6889: Require PHP 8.3 thanks to @morozov
• 6887: Rework index column introspection on Postgres thanks to @morozov
• 6873: Remove DB2Platform:getPreAlterTableIndexForeignKeySQL() thanks to @morozov
• 6867: Introduce PrimaryKeyConstraint thanks to @morozov
• 6864: Use consistent formatting in PRIMARY KEY DDL thanks to @morozov
• 6854: Clean up schema introspection parsing code thanks to @morozov
• 6823: Extract UnquotedIdentifierFolding from AbstractPlatform thanks to @morozov
• 6822: Clean up SQLitePlatform column mapping code thanks to @morozov
• 6815: Remove AbstractName and mark GenericName as internal thanks to @morozov
• 6783: Use InvalidState instead of NameIsNotInitialized thanks to @morozov
• 6803: Clean up OraclePlatform auto-increment code thanks to @morozov
• 6796: Refactor SQL Server code for calling stored procedures thanks to @morozov
• 6787: Introduce IndexedColumn thanks to @morozov
• 6785: feat: support non-libc collations in postgres thanks to @simPod
• 6784: Accept OptionallyQualifiedName in TableEditor::setName() thanks to @morozov
• 6746: Introduce AbstractSchemaManager::getCurrentSchemaName() thanks to @morozov
• 6754: Refactor building schema introspection queries thanks to @morozov
• 6752: Use function db2_field_name thanks to @morozov
• 6745: Remove SQLite "schema emulation" leftovers thanks to @morozov
• 6744: Refactor AbstractSchemaManager::fetch*/select*() API thanks to @morozov
• 6730: Introspect foreign key constraint deferrability on Oracle thanks to @morozov
• 6728: Deprecate ForeignKeyConstraint features and introduce ForeignKeyConstraintEditor thanks to @morozov
• 6714: Rename Identifier::toSql() to Identifier::toSQL() thanks to @morozov
• 6705: Remove final constructor for Type thanks to @ruudk
• 6698: OCI8: Remove PHP 7 compat code thanks to @derrabus
• 6685: Deprecate UniqueConstraint features and introduce UniqueConstraintEditor thanks to @morozov
• 6646: Introduce value objects representing database object names thanks to @morozov
• 6578: Rename column in indexes and constraints thanks to @morozov
• 6550: Simplify tracking implicitly created indexes thanks to @morozov
• 6549: Remove handling unique constraint column names as associative array thanks to @morozov

Deprecations

• 7000: Deprecate support for MariaDB 10.5 thanks to @derrabus
• 6945: Deprecate Column features and introduce ColumnEditor thanks to @morozov
• 6940: Deprecate "version" column platform option thanks to @morozov
• 6939: Introduce JSONB type, deprecate "jsonb" column platform option thanks to @morozov
• 6886: Deprecate Index features and introduce IndexEditor thanks to @morozov
• 6849: Deprecate invalid auto-increment column definitions on SQLite thanks to @morozov
• 6841: Deprecate auto-increment being dropped with the PK on MySQL thanks to @morozov
• 6831: Deprecate modified indexes in TableDiff thanks to @morozov
• 6827: Deprecate modified foreign keys in TableDiff thanks to @morozov
• 6799: Fix false-positive primary key column length deprecation thanks to @morozov
• 6769: Introduce Identifier::toNormalizedValue(), deprecate AbstractSchemaManager::_normalizeName() thanks to @morozov
• 6768: Deprecate introspection of unquoted table names with dot thanks to @morozov
• 6755: Deprecate AbstractSchemaManager::_getPortableTableDefinition() thanks to @morozov
• 6734: Deprecate usage of Schema as AbstractAsset thanks to @morozov
• 6710: Deprecate Table::columnsAreIndexed() thanks to @morozov
• 6707: Deprecate conversion of RESTRICT to NO ACTION thanks to @morozov
• 6701: Deprecate introspection of incomplete SQLite schema thanks to @morozov
• 6677: Deprecate mixing qualified and unqualified names thanks to @morozov
• 6674: Deprecate AbstractAsset::getQuotedName() thanks to @morozov
• 6657: Deprecate AbstractAsset::getShortestName() thanks to @morozov
• 6610: Deprecate AbstractAsset::_setName() thanks to @morozov
• 6671: Deprecate empty index name thanks to @morozov
• 6664: Deprecated AbstractAsset namespace-related methods thanks to @morozov
• 6654: Deprecate Sequence::isAutoIncrementsFor() thanks to @morozov
• 6635: Deprecate altering table configuration thanks to @morozov
• 6607: Deprecate reserved keyword lists thanks to @morozov
• 6592: Deprecate relying on the current implementation of the database object name parser thanks to @morozov
• 6590: Deprecate AbstractPlatform::quoteIdentifier() thanks to @morozov
• 6560: Deprecate Table::removeForeignKey() and ::removeUniqueConstraint() thanks to @morozov
• 6559: Deprecate dropping columns referenced by constraints thanks to @morozov

Bugfixes

• 6971: Omit implicit indexes in Table::edit() thanks to @morozov
• 6882: Clean up Table::renameIndex() code thanks to @morozov
• 6801: Unmark Index as final thanks to @morozov
• 6739: Implement empty Schema::setName() thanks to @morozov
• 6737: Unable to instantiate Schema objects without deprecations thanks to @xabbuh
• 6738: Add missing sentence and placeholder. thanks to @greg0ire
• 6718: Fix deferrable/deferred constraint DDL on PostgreSQL thanks to @morozov
• 6717: Invalid DDL for deferred constraints on PostgreSQL thanks to @morozov
• 6908: fix replacing method name in deprecation message thanks to @xabbuh

Static Analysis

• 6914: Mark identifiers as non-empty strings thanks to @morozov
• 6899: Mark ComparatorConfig::getReportModifiedIndexes() as internal thanks to @morozov
• 6832: Enable PHPStan checks for exceptions thanks to @morozov
• 6805: Annotate some internal array shapes thanks to @morozov
• 6788: Mark protected platform and schema manager methods as internal thanks to @morozov
• 6608: Mark Identifier as internal thanks to @morozov

Test Suite

• 7006: phpunit/phpunit (11.5.15 => 11.5.23) thanks to @derrabus
• 6894: PHPUnit 11 thanks to @morozov
• 6995: Rework schema introspection tests that use reflection thanks to @morozov
• 6980: Remove redundant PHPUnit 11 configuration thanks to @morozov
• 6972: Rework tests that create or modify tables thanks to @morozov
• 6872: Fix testChangeIndexWithForeignKeys() configuration thanks to @morozov
• 6794: Accept schema name as object in FunctionalTest::dropAndCreateSchema() thanks to @morozov

CI

• 6999: Remove "minimal" dependency setting thanks to @derrabus

Changes from lower branches

This release contains improvements shipped with the 3.10.0 release:

• 6926: feat: improve performance of sql parser thanks to @shyim

Release Notes for 4.2.5

4.2.5

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

Bugfixes

• 7010: Extend the detection of connection lost in the PostgreSQL ExceptionConverter thanks to @petaak

Release Notes for 4.2.4

4.2.4

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

Dependencies,Test Suite

• 7004: phpunit/phpunit (10.5.39 => 10.5.46) thanks to @derrabus

CI,Test Suite

• 6978: Fail PHPUnit on notice, output more failure details thanks to @morozov
• 6959: Fail on PHPUnit deprecations thanks to @morozov

Documentation

• 6930: Fix typo in first example thanks to @Crell
• 6916: Fix query builder code examples thanks to @BackEndTea

Bug,Columns,SQLite,Schema Management,Tables

• 6892: Do not trim single quote in comments on SQLite thanks to @morozov

Configuration,Test Suite,pdo_sqlsrv

• 6871: Fix merging driver options in the pdo_sqlsrv driver test thanks to @morozov

Auto-increment,MySQL,PostgreSQL,Primary Keys,Schema Management,Test Suite

• 6865: Remove duplicate schema management tests thanks to @morozov

IBM Db2,Test Suite

• 6859: Revert IBM Db2 health check improvement thanks to @morozov

Static Analysis

• 6858: Use boolean values in while loops thanks to @morozov

Test Suite

• 6855: Move PHPUnit's "display warnings" from CLI to configuration thanks to @morozov

MySQL,Primary Keys,Test Suite

• 6850: Remove duplicate schema manager tests thanks to @morozov

Auto-increment,Schema Introspection,Test Suite

• 6848: Rework auto-increment introspection tests thanks to @morozov

Auto-increment,Bug,MySQL,Primary Keys,Schema Management

• 6836: Do not lose auto-increment when altering primary key thanks to @morozov

Bug,DSN Parser

• 6790: Only trim the leading slash from the DSN if a host is also available thanks to @TimWolla

Changes from Lower Branches

• This release contains all changes of the 3.9.5 release.

Release Notes for 3.9.5

3.9.5

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

Dependencies,Static Analysis,Test Suite

• 7002: Bump dev tools thanks to @derrabus

CI,MySQL

• 7001: Run tests on MySQL 9.3 instead of 9.1 thanks to @derrabus

CI,pdo_sqlsrv,sqlsrv

• 6992: Use latest stable sqlsrv extensions thanks to @morozov

CI,MariaDB

• 6991: CI MariaDB: add 11.8 thanks to @jaylinski

CI

• 6985: Bump doctrine/.github from 7.2.2 to 7.3.0 thanks to @dependabot[bot]
• 6952: GitHub Actions tweaks thanks to @morozov
• 6946: Refactor GitHub Actions workflows thanks to @morozov
• 6763: Bump doctrine/.github from 7.1.0 to 7.2.0 thanks to @dependabot[bot]

Schema Introspection,Test Suite

• 6984: Deterministic ordering in schema manager results thanks to @mbeccati

Bug,Prepared Statements,pgsql

• 6936: fix: Normalize boolean parameter binding for native pgsql driver thanks to @ashutoshagrawal1010

CI,Dependencies

• 6915: Use Ubuntu 22.04 for builds with lowest dependencies thanks to @morozov

Static Analysis

• 6875: Fix build thanks to @greg0ire

Code Style

• 6874: Upgrade to doctrine/coding-standard 13 thanks to @greg0ire

Schema,Schema Management,Test Suite

• 6786: Tests: Added drop and create schema helper methods thanks to @cristi-contiu

Bug,Identifiers,Indexes,PostgreSQL,Schema,Schema Management

• 6779: PostgreSQL: Add schema name to DROP INDEX when table not in default schema thanks to @cristi-contiu

Bug,Foreign Keys,Identifiers,PostgreSQL,Schema,Schema Management

• 6773: Trim quotes in unqualified foreign table names when diffing foreign keys thanks to @cristi-contiu

Bug,PostgreSQL,SQL Server,Schema,Schema Introspection,Schema Management,Tables

• 6753: Fix introspection of table options in non-default schemas thanks to @morozov

Bug,Configuration,Connecting,pgsql

• 6344: fix(PgSQL): Allow to pass IPv6 address in URI notation for postgres thanks to @susnux

Bug,SQLite,Schema Management

• 6337: Allow to disable SQLite schema emulation in SqliteSchemaManager thanks to @mvorisek

Release Notes for 4.2.3

4.2.3

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

Foreign Keys,Schema Management,Test Suite

• 6825: Add an integration test for replacing a foreign key constraint thanks to @morozov

Primary Keys,Test Suite

• 6820: Convert some unit tests to integration tests thanks to @morozov
• 6819: Fix SchemaManagerFunctionalTestCase::testSwitchPrimaryKeyOrder() thanks to @morozov

Bug,Oracle

• 6816: Do not over increment identitiy sequence on Oracle thanks to @morozov

Bug,Error Handling,Transactions

• 6812: Convert driver exceptions when starting transactions thanks to @lcobucci

Documentation

• 6776: Fix link in docs thanks to @HypeMC

• 6700: [DOCS] Fix binary type format documentation thanks to @jaapio

Release Notes for 4.2.2

4.2.2

• Total issues resolved: 1
• Total pull requests resolved: 18
• Total contributors: 12

Static Analysis

• 6697: Cleanup obsolete PHPStan ignore rules thanks to @derrabus
• 6574: Remove non thrown exception from phpdoc thanks to @Tofandel

Bug,PostgreSQL,Schema Comparison

• 6693: Enable platformOptions to be considered for ColumnDiff (PostgreSQL jsonb support) thanks to @DanielBadura

Test Suite

• 6692: PHPUnit 10.5.39 thanks to @derrabus

Documentation

• 6688: Remove documentation of legacy types thanks to @derrabus

Bug,Schema Management

• 6668: Fix creation of unnamed unique constraints thanks to @morozov

CI

• 6661: Create website schema validation workflow thanks to @SenseException
• 6632: Source IBM DB2 CLI driver from GitHub thanks to @morozov
• 6625: Rework continuous integration for v4 thanks to @greg0ire

Bug,Connecting,Connections,PDO,PHP

• 6623: Revert workaround for persistent PDO connections thanks to @derrabus

Bug,Quoting,SQL Server,Schema Management

• 6602: Fix renaming to quoted names on SQL Server thanks to @morozov

Bug,PostgreSQL,Quoting,Schema Management

• 6599: Fix dropping the PK on a PostgreSQL table with quoted name thanks to @morozov

Bug,Prepared Statements,oci8

• 6596: Use exception in OCI8 driver, instead of relying on assert thanks to @segrax

Connecting,Drivers,New Feature,Oracle

• 6593: Added support to override the protocol used when connecting to Oracle. thanks to @martinedge

Bug,Type Mapping

• 6579: Fix max string length resolution in AbstractPlatform::getEnumDeclaration() thanks to @davidxkurka

Bug,Cache

• 6552: Query Cache mangled if saved by-reference thanks to @Slamdunk

• 6546: Fix incorrect transactional() handling when DB auto-rolled back the transaction (v4) thanks to @simPod

Bug,Type Conversion

• 6410: Fix bigint PHP_INT_MIN/PHP_INT_MAX string to int convert thanks to @mvorisek

Changes from Lower Branches

• This release contains all changes of the 3.9.4 release.

Release Notes for 3.9.4

3.9.4

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

Static Analysis

• 6719: Drop Psalm in favor of PHPStan thanks to @greg0ire
• 6690: PHPStan 2.1.1 thanks to @derrabus

CI

• 6708: Pin the version of PCOV for Windows thanks to @greg0ire
• 6649: Bump doctrine/.github from 6.0.0 to 7.1.0 thanks to @dependabot[bot]
• 6642: Bump doctrine/.github from 5.3.0 to 6.0.0 thanks to @dependabot[bot]
• 6630: Bump doctrine/.github from 5.2.0 to 5.3.0 thanks to @dependabot[bot]
• 6624: Bump the PHP version used in the CI thanks to @greg0ire
• 6613: Rework the continuous integration jobs thanks to @greg0ire
• 6611: Bump codecov/codecov-action from 4 to 5 thanks to @dependabot[bot]
• 6601: Enable Windows Update service on AppVeyor thanks to @morozov
• 6580: Distinguish between Appveyor and github-action thanks to @greg0ire

Test Suite

• 6691: PHPUnit 9.6.22 thanks to @derrabus
• 6564: Create stubs instead of mocks thanks to @simPod
• 6563: Cover how transactional() behaves in different auto commit modes thanks to @simPod
• 6562: Cover scenario BEGIN TRANSACTION; COMMIT; BEGIN TRANSACTION; --failure thanks to @simPod
• 6558: test: remove ->expects(self::any()) thanks to @simPod
• 6547: test: cover nested transactions thanks to @simPod

Bug,Prepared Statements,mysqli

• 6681: bugfix: deallocate mysqli prepared statement thanks to @petermein

Bug,Quoting,SQLite,Schema Introspection

• 6600: Fix parsing quoted table name on SQLite thanks to @morozov

CI,PostgreSQL

• 6575: Run tests against PostgreSQL 17 thanks to @IndraGunawan

Documentation

• 6572: Fix broken links thanks to @SchmidtClaudia
• 6556: Fix typo in PostgreSql documentation reference thanks to @JoshuaBehrens
• 6553: Acknowledge the existence of 3.10 thanks to @greg0ire

CI,MySQL

• 6568: Run tests with MySQL 9.1 thanks to @derrabus

• 6561: Inherit issue templates from the centralized repository thanks to @greg0ire

Bug

• 6545: Fix incorrect transactional() handling when DB auto-rolled back the transaction thanks to @simPod

Bug,Connections,Error Handling

• 6543: Run risky code in finally block thanks to @simPod

Release Notes for 4.2.1

4.2.1

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

Release Notes for 3.9.3

3.9.3

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

Documentation

• 6541: Remove broken links from php doc block thanks to @abuhamza

Release Notes for 4.2.0

4.2.0

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

CI

• 6537: CI: remove duplicate key thanks to @derrabus

MariaDB,MySQL,New Feature,Schema Introspection,Schema Management,Types

• 6536: Implement an EnumType for MySQL/MariaDB thanks to @derrabus

Connecting,Connections,New Feature,PDO

• 6532: Leverage the new PDO subclasses thanks to @derrabus

New Feature,PostgreSQL,Schema Introspection

• 6516: Passive support for partitioned tables on Postgres thanks to @nikophil

Cache,Improvement,Results

• 6510: Invalidate old query cache format thanks to @derrabus

Cache,New Feature,Results

• 6504: Handle cached result column names and rows separately thanks to @morozov

Release Notes for 3.9.2

3.9.2

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

Documentation

• 6540: Prepare the 4.2.0 release thanks to @derrabus

Static Analysis

• 6535: PHPStan 1.12.6 thanks to @derrabus

CI

• 6534: Bump doctrine/.github from 5.1.0 to 5.2.0 thanks to @dependabot[bot]
• 6527: Bump GitHub actions thanks to @derrabus

CI,Documentation

• 6531: Setup documentation workflow thanks to @greg0ire

CI,PHP

• 6528: Run tests with PHP 8.4 thanks to @nickvergessen

Release Notes for 4.1.1

4.1.1

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

Bug,Connecting,Drivers,PDO

• 6513: PDO: Raise a proper exception if user or password is false thanks to @derrabus

Bug,Results

• 6505: Raise a proper exception when calling getColumnName() with negative index thanks to @derrabus

Test Suite

• 6503: Remove beStrictAboutTodoAnnotatedTests from PHPUnit configuration thanks to @morozov
• 6499: PHPUnit 10.5.30 thanks to @derrabus
• 6497: Remove obsolete PHP version check thanks to @derrabus

Static Analysis

• 6500: Psalm 5.25.0 thanks to @derrabus

Changes from Lower Branches

• This release contains all changes of the 3.9.1 release.

Release Notes for 3.9.1

3.9.1

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

Documentation

• 6514: fix typo in docs thanks to @Lynnaut

Test Suite

• 6508: Use generators for large data providers thanks to @derrabus

Static Analysis

• 6507: PHPStan 1.12 thanks to @derrabus
• 6498: PHPStan 1.11.10 thanks to @derrabus

CI

• 6501: Try removing quotes thanks to @greg0ire

Release Notes for 4.1.0

4.1.0

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

Deprecation,Platforms,PostgreSQL

• 6495: Deprecate support for Postgres 10 and 11 thanks to @derrabus

Bug,PostgreSQL,Schema Comparison

• 6490: Ensure PostgreSQL field length change is executed again thanks to @sbuerk

Deprecation,New Feature,Schema Management

• 6482: Add deprecation layer for TableDiff methods thanks to @derrabus

Test Suite

• 6481: Fix tests thanks to @derrabus

New Feature,Type Mapping,Types

• 6471: Add SmallFloat type thanks to @berkut1

Improvement,QueryBuilder

• 6439: Default to distinct union queries thanks to @derrabus

Deprecation,Drivers,New Feature,Results

• 6428: Add the Result::getColumnName method thanks to @stof

Improvement

• 6376: Remove internal flag on DriverException thanks to @gitomato
• 6326: Remove redundant variable thanks to @michalbundyra

New Feature,QueryBuilder

• 6369: Add QueryBuilder support for UNION clause thanks to @sbuerk

Deprecation,MariaDB,MySQL,Platforms

• 6343: Deprecate MariaDB 10.4 and MySQL 5.7 support thanks to @derrabus

Static Analysis

• 6301: Establish link between isConnected() and _conn thanks to @greg0ire

New Feature,Schema Management

• 6280: Add explicit renameColumn method thanks to @Tofandel

Changes from Lower Branches

• This release contains all changes of the 3.9.0 release.

Release Notes for 3.9.0

3.9.0

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

Documentation

• 6494: Document the new PostgreSQL120Platform thanks to @derrabus
• 6492: Prepare 3.9.0 and 4.1.0 thanks to @derrabus

Bug,SQL Server,Schema Introspection

• 6463: Add DBTypes that are missing for TypeMapping thanks to @patrick1100

Improvement,MariaDB,Platforms

• 6434: Add MariaDb1010Platform for fetchTableOptionsByTable thanks to @grooverdan

Improvement,MySQL,Reserved Keywords

• 6408: MySQL 8.4 removed keywords thanks to @wmouwen
• 6385: MySQL 8.4 Platform thanks to @wmouwen

Bug,SQL Server

• 6389: Fix condition on Ascii String for SQL Server thanks to @Yovach

Bug,PostgreSQL,Schema Introspection

• 6199: Stop considering generated column definition as being its default value thanks to @allan-simon

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.