4.3.4

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

3.10.3

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

4.3.3

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.

3.10.2

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

4.3.2

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.

3.10.1

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

4.3.1

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

4.3.0

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

4.2.5

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

3.10.0

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