3.6.2

Release Notes for 3.6.2

3.6.2

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

Bug,Configuration,DSN Parser

• 6009: Fix normalizer regex at DsnParser::parse() thanks to @phansys

Documentation

• 6008: fix: @links in comment in Column thanks to @simPod
• 5987: Fix reference to removed DATE_INTERVAL_UNIT_* constants thanks to @derrabus
• 5973: Fix typo thanks to @OskarStark
• 5971: Document the serverVersion option in a forward-compatible manner thanks to @derrabus
• 5952: [Docs] Update database list and vendors thanks to @phansys

Bug,Packaging

• 5999: Ignore static-analysis/ in git archives thanks to @phansys

Static Analysis

• 5986: Improve Params array shape documentation thanks to @derrabus

Static Analysis,Test Suite

• 5982: PHPUnit 9.6.6, PHPStan 1.10.9 thanks to @derrabus

Bug,Connections,Replication

• 5981: For PrimaryReadReplicaConnection passthrough primary server version thanks to @jdelaune

CI,MariaDB

• 5960: Run tests against MariaDB 10.11 thanks to @derrabus

PostgreSQL,Test Suite

• 5955: Skip test on Postgres 10/11 thanks to @derrabus

CI,IBM DB2

• 5951: [CI] Update Docker image location for IBM DB2 thanks to @phansys

CI,ibm_db2

• 5949: Leverage "shivammathur/setup-php" action for "ibm_db2" extension install thanks to @phansys

3.6.1

Release Notes for 3.6.1

3.6.1

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

Documentation

• 5947: Add 3.7.x branch thanks to @derrabus
• 5923: Fix comment thanks to @HypeMC
• 5919: [Docs] fixes count typo at Driver usage thanks to @mvhirsch

Test Suite

• 5943: PHPUnit 9.6.4 thanks to @derrabus

Bug,Prepared Statements,pgsql

• 5942: Support resources as parameters with pgsql thanks to @derrabus and @morozov

Static Analysis

• 5935: PHPStan 1.10.3, PHP Code Sniffer 3.7.2 thanks to @derrabus
• 5933: [SCA] Update requirement for "phpstan/phpstan" thanks to @phansys
• 5932: PHPStan 1.10 thanks to @derrabus

Bug,PHP

• 5930: Fixes PHP initialization error thanks to @aimeos

CI,IBM DB2,ibm_db2

• 5925: [CI] Test "ibm_db2" driver against PHP 8.x thanks to @phansys

Bug,PostgreSQL,Schema Management

• 5800: Ensure the pg_depend relation is for a table object thanks to @allenisalai

4.0.0-beta2

What's Changed

• Update project metadata by @morozov in #5790
• Revert "Clean up MySQL version detection logic" by @greg0ire in #5795
• Fix typo in exception message by @derrabus in #5799
• Run tests with MariaDB 10.9 by @derrabus in #5798
• Remove unwanted suffix by @greg0ire in #5801
• Bump dev tools by @derrabus in #5806
• PHPStan 1.9.1 by @derrabus in #5807
• Merge tests for fetch behavior of freed results by @derrabus in #5810
• Document breaking changes about serverVersion by @greg0ire in #5797
• Bump tools and workflows by @derrabus in #5828
• Doctrine CS 11.0 by @derrabus in #5831
• Document tuple return type of generateCacheKeys() by @derrabus in #5834
• Update Branch metadata by @derrabus in #5840
• Introduce a ArrayParameterType enum by @derrabus in #5838
• Restore Connection::ARRAY_PARAM_OFFSET by @derrabus in #5842
• Introduce a ArrayParameterType enum by @derrabus in #5839
• Trigger a deprecation for versions that will be parsed differently by @derrabus in #5844
• PHPStan 1.9.4 by @derrabus in #5845
• Standalone DSN parser by @derrabus in #5843
• Fix test cases for URL parsing by @derrabus in #5848
• Remove database URLs from tests by @derrabus in #5852
• Remove the url connection param by @derrabus in #5850
• Allow to explicitly set the wrapper class to the default one by @derrabus in #5851
• Use a narrower return type for DriverManager::getAvailableDrivers() by @MidnightDesign in #5853
• Test the return type of DriverManager::getAvailableDrivers() by @MidnightDesign in #5854
• Reuse the Params type alias for getConnection() by @derrabus in #5855
• Use narrower return types for convertTo*Value methods by @MidnightDesign in #5856
• Formally allow url in DriverManager::getConnection() by @someniatko in #5857
• fix platform comparator issues when using compareTables by @dmaicher in #5861
• Allow passing url to override params by @keulinho in #5862
• PHPStan 1.9.11, PHPUnit 9.5.28, Doctrine CS 11.1 by @derrabus in #5864
• Flag parameters as sensitive if they could contain the database password by @derrabus in #5866
• PHPStan 1.9.14 by @derrabus in #5871
• Add missing doc blocks to Index and UniqueConstraint by @derrabus in #5875
• Use psalm-assert to get rid of assert() calls by @derrabus in #5877
• Explain why the number of affected rows can be a string by @GromNaN in #5872
• [Docs] Add IBM DB2 to configuration.rst by @phansys in #5881
• Make sure only PDO parameter types are passed to PDO methods by @derrabus in #5883
• Add the PgSQL driver by @derrabus in #5880
• Introduce the SchemaManagerFactory interface by @derrabus in #5876
• Optimize pgsql queries without parameters by @derrabus in #5889
• Raise exception if pg_send_*() calls fail by @derrabus in #5888
• Deallocate prepared statements in destructor by @derrabus in #5893
• Make PDO transaction methods throw PDOException&DriverException by @maxm86545 in #5890
• PHPUnit 9.6.0 by @derrabus in #5899
• Close pgsql connection in destructor by @derrabus in #5892
• Widen the return type of Result::rowCount() by @derrabus in #5879
• Remove InvalidParameterType exception by @derrabus in #5896
• Use TestLogger instead of mocks by @derrabus in #5903
• Modernize pgsql driver for PHP 8.1 by @derrabus in #5904
• PHPUnit 9.6.3 by @derrabus in #5907
• Free pgsql results on destruct by @derrabus in #5908
• Bump laminas/automatic-releases to 1.24.0 by @derrabus in #5910
• Fix type assumptions about Connection::lastInsertId() by @phansys in #5909
• Prepare release 3.6.0 by @derrabus in #5878
• Run tests with MariaDB 10.10 by @derrabus in #5913

New Contributors

• @MidnightDesign made their first contribution in #5853
• @someniatko made their first contribution in #5857
• @keulinho made their first contribution in #5862
• @GromNaN made their first contribution in #5872

Full Changelog: 4.0.0-beta1...4.0.0-beta2

3.6.0

Release Notes for 3.6.0

3.6.0

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

CI,MariaDB

• 5913: Run tests with MariaDB 10.10 thanks to @derrabus

Drivers,Improvement,PostgreSQL,pgsql

• 5908: Free pgsql results on destruct thanks to @derrabus
• 5889: Optimize pgsql queries without parameters thanks to @derrabus

Drivers,Improvement,PostgreSQL,Prepared Statements,pgsql

• 5893: Deallocate prepared statements in destructor thanks to @derrabus

Bug,Connections,PostgreSQL,pgsql

• 5892: Close pgsql connection in destructor thanks to @derrabus

Drivers,Error Handling,Improvement,PostgreSQL,pgsql

• 5888: Raise exception if pg_send_*() calls fail thanks to @derrabus

Documentation

• 5878: Prepare release 3.6.0 thanks to @derrabus

Static Analysis

• 5877: Use psalm-assert to get rid of assert() calls thanks to @derrabus
• 5855: Reuse the Params type alias for getConnection() thanks to @derrabus
• 5854: Test the return type of DriverManager::getAvailableDrivers() thanks to @MidnightDesign
• 5853: Use a narrower return type for DriverManager::getAvailableDrivers() thanks to @MidnightDesign

Deprecation,New Feature

• 5876: Introduce the SchemaManagerFactory interface thanks to @derrabus

Configuration,Connecting,New Feature,PHP

• 5866: Flag parameters as sensitive if they could contain the database password thanks to @derrabus

• 5856: Use narrower return types for convertTo*Value methods thanks to @MidnightDesign

Test Suite

• 5852: Remove database URLs from tests thanks to @derrabus
• 5848: Fix test cases for URL parsing thanks to @derrabus

Configuration,Deprecation,MariaDB,MySQL,Platform Detection

• 5844: Trigger a deprecation for versions that will be parsed differently thanks to @derrabus

Configuration,Connections,Deprecation,New Feature

• 5843: Standalone DSN parser thanks to @derrabus

Bug

• 5842: Restore Connection::ARRAY_PARAM_OFFSET thanks to @derrabus

Deprecation,Improvement,Prepared Statements

• 5838: Introduce a ArrayParameterType enum thanks to @derrabus

3.5.4

Release Notes for 3.5.4

3.5.4

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

CI

• 5910: Bump laminas/automatic-releases to 1.24.0 thanks to @derrabus

Test Suite

• 5907: PHPUnit 9.6.3 thanks to @derrabus
• 5903: Use TestLogger instead of mocks thanks to @derrabus
• 5899: PHPUnit 9.6.0 thanks to @derrabus

Bug,Connections,Drivers,PDO

• 5890: Make PDO transaction methods throw PDOException&DriverException thanks to @maxm86545

Static Analysis

• 5883: Make sure only PDO parameter types are passed to PDO methods thanks to @kang8 and @derrabus
• 5871: PHPStan 1.9.14 thanks to @derrabus
• 5862: Allow passing url to override params thanks to @keulinho

Documentation

• 5881: [Docs] Add IBM DB2 to configuration.rst thanks to @phansys

Static Analysis,Test Suite

• 5864: PHPStan 1.9.11, PHPUnit 9.5.28, Doctrine CS 11.1 thanks to @derrabus

3.5.3

Release 3.5.3

3.5.3

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

Bugfixes

• 5861: fix platform comparator issues when using compareTables thanks to @dmaicher
• 5851: Allow to explicitly set the wrapper class to the default one thanks to @derrabus

Static Analysis

• 5857: Formally allow url in DriverManager::getConnection() thanks to @someniatko
• 5845: PHPStan 1.9.4 thanks to @derrabus

Documentation

• 5840: Update Branch metadata thanks to @derrabus

3.5.2

Release 3.5.2

3.5.2

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

Static Analysis

• 5834: Document tuple return type of generateCacheKeys() thanks to @derrabus
• 5807: PHPStan 1.9.1 thanks to @derrabus

Static Analysis,Test Suite

• 5828: Bump tools and workflows thanks to @derrabus
• 5806: Bump dev tools thanks to @derrabus

Test Suite

• 5810: Merge tests for fetch behavior of freed results thanks to @derrabus

Documentation

• 5801: Remove unwanted suffix thanks to @greg0ire

Bug,sqlite3

• 5799: Fix typo in exception message thanks to @derrabus

CI,MariaDB

• 5798: Run tests with MariaDB 10.9 thanks to @derrabus

3.5.1

Release 3.5.1

3.5.1

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

Bug,Regression

• 5795: Revert "Clean up MySQL version detection logic" thanks to @greg0ire

4.0.0-beta1

Release 4.0.0-beta1

4.0.0-beta1

• Total issues resolved: 31
• Total pull requests resolved: 198
• Total contributors: 18

BC Break,QueryBuilder

• 5789: Remove QueryBuilder::getConnection() thanks to @morozov

BC Break,Connecting,Events,Schema Introspection,Schema Management,Transactions

• 5788: Remove extension via Doctrine Event Manager thanks to @morozov

Error Handling

• 5777: Remove irrelevant @throws annotations thanks to @morozov

BC Break,Schema Comparison

• 5775: Remove Comparator::diffTable() thanks to @morozov
• 5683: Remove TableDiff::$name and getName() thanks to @morozov
• 5677: Remove support for renaming tables via TableDiff thanks to @morozov
• 5676: Remove SchemaDiff::$fromSchema thanks to @morozov
• 5649: Remove property-based schema comparison APIs thanks to @morozov
• 5647: Remove ColumnDiff::$oldColumnName and ::getOldColumnName() thanks to @morozov
• 4786: Require the original column to be set on the column diff thanks to @morozov

BC Break,Schema Comparison,Schema Management

• 5774: Remove SchemaDiff::toSql() and SchemaDiff::toSaveSql() thanks to @morozov
• 5763: Remove handling orphaned foreign keys thanks to @morozov

BC Break,Schema Management

• 5769: Remove the APIs deprecated in DBAL 3.x thanks to @morozov
• 5464: Make AbstractSchemaManager::_getPortableTableForeignKeyDefinition() abstract thanks to @morozov
• 5456: Non-public API cleanup in AbstractSchemaManager thanks to @morozov
• 5441: Remove AbstractSchemaManager::getDatabasePlatform() thanks to @morozov

Improvement,Schema Comparison

• 5768: Rename parameters of the diff-related methods thanks to @morozov

Schema Comparison

• 5767: Declare internal properties of SchemaDiff as private thanks to @morozov
• 5753: Declare internal properties of TableDiff as private thanks to @morozov
• 5684: Mark ColumnDiff properties as private and read-only thanks to @morozov
• 5652: Make internal Comparator methods protected thanks to @morozov

BC Break,SQLite

• 5759: Remove user defined SQLite functions thanks to @derrabus

BC Break,Drivers,SQLite,pdo_sqlite

• 5744: Remove deprecated API to register custom SQLite functions thanks to @derrabus

BC Break,Error Handling,Improvement

• 5735: Convert Doctrine\DBAL\Schema\SchemaException to an interface thanks to @morozov
• 5726: Convert Doctrine\DBAL\Exception to an interface thanks to @morozov
• 3124: Split DBALException into smaller specific exceptions, consider dropping "Exception" suffixes thanks to @Majkl578

BC Break,Foreign Keys,Primary Keys,Schema Management

• 5733: Remove Table methods thanks to @morozov

BC Break,Error Handling,Schema Management

• 5730: Remove SchemaException error codes thanks to @morozov

Error Handling,Improvement

• 5727: Clarify semantics of logic exceptions thanks to @morozov
• 3536: Improve consistency of exception message formatting. thanks to @jwage

Error Handling,Schema Definition

• 5725: Improve ergonomics of invalid colum declaration exceptions thanks to @morozov

BC Break

• 5724: Removing deprecated isFullfilledBy() method thanks to @nexxai
• 5337: Remove the doctrine-dbal binary thanks to @derrabus
• 5255: Drop support for collate option thanks to @greg0ire
• 5067: Remove Platform API about commented types thanks to @greg0ire

BC Break,Configuration,Connections,PostgreSQL

• 5711: Remove PostgreSQL-specific connection parameters and behavior thanks to @morozov

SQLite,Schema Comparison,Schema Management

• 5710: Remove property-based false-positive diff workaround from SQLite schema manager thanks to @morozov

BC Break,Configuration,Connections,Platform Detection

• 5709: Remove platform detection fallback thanks to @morozov

BC Break,Configuration,Connections

• 5704: Remove driver name aliases thanks to @morozov
• 5703: Remove platform parameter of wrapper Connection thanks to @morozov

Error Handling,PHP,PostgreSQL

• 5696: Remove workaround for PHP bug in PostgreSQL exception handler thanks to @morozov

BC Break,Platforms,SQL Server

• 5679: Remove leftovers of renaming default contraints thanks to @morozov

Foreign Keys,MySQL,Schema Introspection

• 5675: Remove conditional comments for MySQL older than 5.1.16 thanks to @morozov

BC Break,Foreign Keys,MySQL,Schema Management

• 5664: Remove leftovers of handling foreign keys on non-InnoDB engines for MySQL thanks to @morozov

BC Break,Default Values,Improvement,SQL Server,Schema Management

• 5662: Introspect default constraint name thanks to @morozov

BC Break,Columns

• 5655: Remove support for "unique" and "check" column properties thanks to @morozov

BC Break,Schema Introspection

• 5648: Remove AbstractSchemaManager::createSchema() thanks to @morozov
• 5605: Remove AbstractSchemaManager::listTableDetails() thanks to @morozov
• 5289: Remove $database from AbstractSchemaManager::list*() methods thanks to @morozov
• 5280: Declare abstract AbstractSchemaManager methods as such thanks to @morozov

PostgreSQL,Schema Management

• 5641: Do not use ColumnDiff::$changedProperties in PostgreSQLPlatform::getAlterTableSQL() thanks to @morozov

SQL Server,Schema Management

• 5640: Do not use ColumnDiff::$changedProperties in SQLServerPlatform::getAlterTableSQL() thanks to @morozov

BC Break,Columns,Schema Definition

• 5631: Require precision and scale for decimal columns thanks to @morozov

Schema Management

• 5630: Rework AbstractSchemaManager::_execSql() thanks to @morozov

Schema Management,Test Suite

• 5629: Clean up test scenarios related to altering columns thanks to @morozov

Oracle,Schema Management

• 5623: Do not use ColumnDiff::$changedProperties in OraclePlatform::getAlterTableSQL() thanks to @morozov
• 5620: Remove code compensating for a schema comparison flaw thanks to @morozov
• 4598: [GH-4503] Make OracleSchemaManager::dropAutoincrement() protected thanks to @morozov

BC Break,Connection...

3.5.0

Release 3.5.0

3.5.0

• Total issues resolved: 1
• Total pull requests resolved: 40
• Total contributors: 5

Connecting,Deprecation,Events,Transactions

• 5786: Deprecate extension via Doctrine Event Manager thanks to @morozov

Deprecation,Events,Schema Introspection,Schema Management

• 5785: Deprecate extension via certain types of events thanks to @morozov

Deprecation,Events

• 5784: Deprecate extension via Doctrine Event Manager thanks to @morozov

Deprecation,QueryBuilder

• 5780: Deprecate QueryBuilder::getConnection() thanks to @morozov

MariaDB,MySQL,Platform Detection

• 5779: Clean up MySQL version detection logic thanks to @morozov

Deprecation,Improvement,Schema Comparison

• 5770: Non-nullabe result of comparing tables thanks to @morozov
• 5642: Introduce property-specific ColumnDiff methods thanks to @morozov

Deprecation,Schema Comparison,Schema Management

• 5766: Deprecate SchemaDiff::toSql() and SchemaDiff::toSaveSql() thanks to @morozov

• 5761: Improve error message for index SQL creation thanks to @radar3301

Deprecation,Schema Comparison

• 5758: Mark SchemaDiff public properties internal thanks to @morozov
• 5717: Mark TableDiff public properties internal thanks to @morozov
• 5678: Deprecate not passing $fromColumn to TableDiff thanks to @morozov
• 5666: Deprecate SchemaDiff::$fromSchema thanks to @morozov
• 5663: Deprecate renaming tables via TableDiff thanks to @morozov
• 5657: Mark ColumnDiff public properties as internal thanks to @morozov
• 5650: Deprecate and mark internal APIs related to schema comparison thanks to @morozov
• 5622: Schema Diff API cleanup thanks to @morozov

Platforms,SQLite

• 5755: Use the % operator instead of MOD() in SQLite thanks to @derrabus

Dependencies

• 5750: Allow doctrine/event-manager 2 thanks to @derrabus

Deprecation,Platforms,SQLite

• 5749: Deprecate LOCATE() emulation on SQLite thanks to @derrabus

Deprecation,Schema Management

• 5747: Deprecate Table::changeColumn() thanks to @morozov
• 5612: Mark AbstractSchemaManager::_execSql() as internal thanks to @morozov

Schema Comparison,Schema Management,Test Suite

• 5746: Rework some tests that instantiate TableDiff thanks to @morozov
• 5714: Rework some tests that instantiate TableDiff thanks to @morozov

Deprecation,Drivers,pdo_sqlite

• 5742: Deprecated the userDefinedFunctions driver option for pdo_sqlite thanks to @derrabus

Drivers,New Feature,SQLite,sqlite3

• 5737: New driver: SQLite3 thanks to @derrabus

Deprecation,Foreign Keys,Primary Keys,Schema Management

• 5731: Deprecate Table methods thanks to @morozov

Deprecation,Error Handling,Schema Management

• 5728: Deprecate SchemaException codes thanks to @morozov

Deprecation

• 5721: Deprecating misspelled isFullfilledBy() method thanks to @nexxai

Configuration,Connections,Platform Detection

• 5707: Deprecate fallback connection to determine platform thanks to @morozov

Configuration,Connections,Deprecation,PostgreSQL

• 5705: Deprecate PostgreSQL-specific connection parameters and behavior thanks to @morozov

Configuration,Connections,Deprecation

• 5699: Deprecate platform parameter of wrapper Connection thanks to @morozov
• 5697: Deprecate driver name aliases thanks to @morozov

Logging,Transactions

• 5686: fix: always log savepoint release thanks to @simPod

SQLite,Schema Management,Test Suite

• 5660: Remove implementation of alterTable() for SQLite thanks to @morozov

Columns,Deprecation

• 5656: Deprecate "unique" and "check" column properties thanks to @morozov

Platforms

• 5654: Reduce duplication of collation declaration code thanks to @morozov

Columns,Deprecation,Schema Definition

• 5637: Deprecate default precision and scale for decimal columns thanks to @morozov

IBM DB2,Schema Management

• 5621: Remove redundant condition from DB2 platform thanks to @morozov

Deprecation,Schema Introspection

• 5613: Deprecate AbstractSchemaManager::createSchema() in favor of introspectSchema() thanks to @morozov
• 5595: Deprecate AbstractSchemaManager::listTableDetails() thanks to @morozov