Release 3.4.2

3.4.2

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

Bug,Namespaces,PostgreSQL,Regression,Schema Management,Sequences

• 5604: Fix DropSchemaObjectsSQLBuilder issues thanks to @morozov and @HypeMC

PostgreSQL,Test Suite

• 5599: Fix condition in PostgreSQL only test thanks to @HypeMC

Bug,Foreign Keys,SQLite,Schema Introspection

• 5597: Fix parsing SQLite FK reference not containing whitepace thanks to @morozov and @oraslaci

Release 3.4.1

3.4.1

• Total issues resolved: 7
• Total pull requests resolved: 9
• Total contributors: 9

Oracle,Schema Introspection,Test Suite

• 5591: Add a test for quoting table names in schema thanks to @morozov and @mondrake

Documentation,Schema Comparison

• 5590: Update documentation on schema comparison thanks to @morozov

Columns,Static Analysis

• 5589: Allow to call $column1->setColumnDefinition($column2->getColumnDefinition()) thanks to @VincentLanglet

Bug,Namespaces,PostgreSQL,Regression,Schema Introspection

• 5586: Index components for listTables() by portable table definition thanks to @morozov and @NoiseByNorthwest

Bug,Drivers,Static Analysis,pdo_sqlsrv,sqlsrv

• 5585: Expect an SQLServerPlatform instance in AbstractSQLServerDriver thanks to @morozov and @elavrom

Bug,Regression,SQL Server,Schema Introspection

• 5581: Filter out the "sysdiagrams" table on SQL Server thanks to @morozov and @lampi87

Bug,MySQL,Oracle,Regression,Schema Introspection

• 5580: Filter MySQL and Oracle columns by table type thanks to @morozov and @dmolineus

Bug,Foreign Keys,Regression,SQLite

• 5577: Do not add artificial name to anonymous SQLite constraint thanks to @morozov and @simonworkhouse

Bug,Foreign Keys,Identifiers,Indexes,PostgreSQL,Quoting,Regression,Reserved Keywords,Schema Introspection

• 5576: Rework introspection of table indexes and foreign keys on Postgres thanks to @morozov and @acirulis

Release 3.4.0

3.4.0

• Total issues resolved: 8
• Total pull requests resolved: 71
• Total contributors: 11

Documentation,Platforms,Schema Introspection

• 5568: Mark remaining schema introspection platform methods as internal thanks to @morozov

Deprecation,Prepared Statements

• 5563: Deprecate Statement::bindParam() thanks to @morozov
• 5558: Deprecate not passing parameter type to bindParam() and bindValue() thanks to @morozov
• 5556: Deprecate passing parameters to Statement::execute*() thanks to @morozov
• 5550: Deprecate using NULL as prepared statement parameter type thanks to @morozov

Documentation

• 5555: Fix upgrade note thanks to @derrabus
• 5279: Nest deprecations for 3.4 under 3.4 thanks to @greg0ire

Deprecation,QueryBuilder

• 5551: Deprecate QueryBuilder APIs exposing its internal state thanks to @morozov

Documentation,Prepared Statements

• 5549: Mark Connection::ARRAY_PARAM_OFFSET internal thanks to @morozov

Cache,New Feature,QueryBuilder

• 5539: Added result caching for QueryBuilder thanks to @twoleds

Static Analysis,Test Suite

• 5536: Enforce property types in tests thanks to @derrabus

Deprecation,Platforms,Schema Management

• 5529: Deprecate passing assets as names thanks to @morozov

Deprecation,Platforms

• 5527: Deprecate internal AbstractPlatform methods or mark them as such thanks to @morozov
• 5392: Additional documentation for prior deprecations thanks to @morozov
• 5388: Deprecate AbstractPlatform methods exposing quote characters thanks to @morozov
• 5385: Deprecate passing date interval parameters as integers thanks to @morozov
• 5373: Deprecate AbstractPlatform::getVarcharTypeDeclarationSQL() thanks to @morozov
• 5230: Deprecated AbstractPlatform::getListTableConstraintsSQL() thanks to @morozov

Platforms,SQLite

• 5517: Allow to disable schema emulation on SQLite thanks to @mvorisek
• 5486: Do not drop table indexes before dropping SQLite table thanks to @mvorisek

Databases,Deprecation,Platforms,Schema,Sequences

• 5513: Deprecate internal and non-portable AbstractPlatform methods thanks to @morozov

Deprecation,SQLite,Types

• 5511: Deprecate SqlitePlatform::getTinyIntTypeDeclarationSQL() and ::getMediumIntTypeDeclarationSQL() thanks to @morozov

Deprecation,Platforms,Types

• 5509: Deprecate AbstractPlatform::hasNative*Type() and Type::requiresSQLCommentHint() thanks to @morozov

CI,Dependencies

• 5504: Bump Symfony components to supported version ranges thanks to @derrabus

SQLite,Schema Management

• 5500: Table schema clone is not needed in SqlitePlatform thanks to @mvorisek

• 5488: AbstractSchemaManager::listTableForeignKeys() should support listing for all tables at once thanks to @mvorisek

• 5419: Remove SchemaDiffVisitor thanks to @morozov

• 5397: Remove redundant (array) casts thanks to @morozov

Configuration,Deprecation,Schema Introspection

• 5483: Deprecate NULL schema asset filter thanks to @morozov

Bug,Regression,Schema Introspection,Tables

• 5482: Fix filtering tables according to the configuration thanks to @morozov

Configuration,Deprecation,Logging

• 5480: Deprecate Configuration::getSQLLogger() and setSQLLogger() thanks to @morozov

Columns,Deprecation

• 5476: Deprecate custom schema options thanks to @morozov

Deprecation,Types

• 5470: Deprecate array and object column types thanks to @morozov
• 5049: Deprecate Type::getName() thanks to @greg0ire

Improvement,PHP

• 5461: Add native property types thanks to @derrabus

Code Style

• 5460: Use the null-coalescing assignment operator thanks to @derrabus

PHP

• 5459: Drop support for PHP 7.3 thanks to @morozov

Deprecation,Drivers,Improvement,Schema Management

• 5458: Deprecate Driver::getSchemaManager() in favor of AbstractPlatform::createSchemaManager() thanks to @morozov

Improvement,Schema Introspection

• 5457: Implement AbstractSchemaManager::_getPortableTableForeignKeyDefinition() across platforms thanks to @morozov

PostgreSQL,Sequences

• 5453: Remove PostgreSQLSchemaManager::_getPortableSequencesList() thanks to @morozov
• 5244: Diff command with PostgreSQLPlatform fails when there is a sequence thanks to @maxm86545

Schema Introspection

• 5452: Rework introspection of table names thanks to @morozov
• 5281: Reimplement more Schema Manager listTable*() methods with the new API thanks to @morozov

IBM DB2

• 5451: Rework listing table names for DB2 thanks to @morozov
• 5450: Rework table introspection for DB2 thanks to @morozov

Improvement,PostgreSQL

• 5449: Optimize introspection of table comments on PostgreSQL thanks to @morozov

Deprecation,Tools

• 5439: Deprecate ConsoleRunner thanks to @morozov

Deprecation,Schema

• 5435: Deprecate Visitor API thanks to @morozov

Deprecation,Reserved Keywords

• 5433: Deprecate KeywordList::getName() thanks to @morozov

Deprecation,Namespaces,Schema Management

• 5432: Deprecate removal of namespaced assets from schema thanks to @morozov

Deprecation,Reserved Keywords,Tools

• 5431: Deprecate checking keywords in schema object names thanks to @morozov

Bug,Platforms,SQL Server

• 5428: Fix NCHAR typo for MSSQL thanks to @mvorisek

Deprecation,Foreign Keys,Improvement,SQLite

• 5427: Mark SQLite platform as supporting foreign keys thanks to @morozov

Bug,SQLite,Schema Comparison

• 5425: Fix redundant orphaned foreign key thanks to @morozov

Deprecation,Improvement,Schema Management

• 5416: Replace schema SQL collectors with SQL builders thanks to @morozov

Deprecation,Foreign Keys,MySQL,Schema Management

• 5414: Deprecate ignoring foreign keys DDL on non-InnoDB MySQL thanks to @morozov

Bug,Foreign Keys,Improvement,SQLite

• 5404: Run more foreign key tests on SQLite thanks to @morozov

Improvement,SQLite,Schema Introspection

• 5402: Natural order of SQLite foreign keys thanks to @morozov

Bug,PostgreSQL,Schema Management

• 5394: Remove PostgreSQLPlatform::isNumericType() thanks to @morozov

Deprecation,Schema Management

• 5387: Deprecate AbstractSchemaManager::getDatabasePlatform() thanks to @morozov

Deprecation

• 5383: Deprecate transaction nesting without savepoints thanks to @greg0ire
• 5222: Signal deprecation at runtime thanks to @greg0ire
• 5204: Deprecate methods related to type comments thanks to @greg0ire

Static Analysis

• 5378: Use more precise phpdoc thanks to @greg0ire
• 5333: Leverage int-mask-of to make types more precise thanks to @greg0ire

Deprecation,IBM DB2,MySQL,Oracle,SQL Server,Schema Definition

• 5377: Add runtime deprecations for default string column length thanks to @morozov

Foreign Keys,SQLite

• 5365: SQLite should properly check if foreign keys are supported and/or omit foreign key statements when a table diff is analyzed thanks to @BigMichi1

Static Analysis,Transactions

• 5357: Make transacional function return type generic thanks to @snapshotpl

Default Values,Improvement,MariaDB

• 5332: Support TEXT/BLOB default values on MariaDB thanks to @morozov and @gregor-tb

Platforms

• 5290: Remove user related methods from the schema manager thanks to @morozov

Deprecation,Schema Introspection

• 5287: Deprecate passing $database to AbstractSchemaManager::list*() thanks to @morozov

Deprecation,Improvement,Performance,Schema Introspection

• 5268: Optimize schema managers' ::listTables() methods thanks to @morozov and @mathieubouchard

Improvement,Platforms,PostgreSQL

• 5256: Single PostgreSQLPlatform::getListSequencesSQL thanks to @maxm86545

Test Suite

• 5181: Delete run-all.sh thanks to @mvorisek

Bug,PostgreSQL,Schema Comparison,Schema Management

• 4745: Improper management of autoincrement sequence in PostgreSQL platform thanks to @morozov

Bug,Foreign Keys,Improvement,Platforms,SQLite

• 1204: DBAL-1253: Sqlite: inconsistent (non-)support of foreign keys thanks to @doctrinebot

Release 3.3.8

3.3.8

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

Bug,Type Conversion

• 5566: Do not treat deprecation level as errors thanks to @wouterj

Test Suite

• 5535: Use assertCount() when possible thanks to @derrabus

Dependencies

• 5533: Update PHPStan to 1.8.2 thanks to @morozov

Documentation,Schema Comparison

• 5503: Fix link in deprecation message thanks to @derrabus

Code Style

• 5479: Fix AbstractMySQLPlatform comment typo thanks to @mvorisek
• 5475: Use double quotes for strings containing contractions thanks to @morozov

Documentation

• 5478: Refer to the correct parameter in comment thanks to @greg0ire

Bug,Schema Comparison,Schema Management

• 5471: Infer omitted column charset from collation thanks to @morozov

Static Analysis,Test Suite

• 5469: Bump dev tools thanks to @derrabus

Bug,Prepared Statements,ibm_db2

• 5467: Fix order of binding parameters on ibm_db2 thanks to @morozov

Bug,Prepared Statements,oci8

• 5466: Bind only non-NULL BLOB values as BLOB on oci8 and ibm_db2 thanks to @morozov and @eisberg

CI,PHP

• 5442: Run tests on PHP 8.2 thanks to @derrabus

Release 3.3.7

3.3.7

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

Code Style,Static Analysis

• 5444: PHP CodeSniffer 3.7, PHPStan 1.7.13 thanks to @derrabus

Static Analysis

• 5426: PHPStan 1.7.9 thanks to @derrabus
• 5417: Run Psalm with language level PHP 8.1 thanks to @morozov

Documentation,Type Mapping

• 5415: Update documentation for the guid type thanks to @kaznovac

Bug,PostgreSQL,Schema Management

• 5395: Check integer types via PhpIntegerMappingType thanks to @morozov and @umherirrender

Bug,PHP,PostgreSQL

• 5381: Fix using deprecated syntax thanks to @nicolas-grekas

Documentation

• 5379: Refresh docs about transactions thanks to @greg0ire

CI

• 5374: Remove CA bundle from AppVeyor thanks to @morozov

Release 3.3.6

3.3.6

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

Dependencies

• 5371: Allow doctrine/deprecations 1.0 thanks to @derrabus

Static Analysis

• 5370: Psalm 4.23, PHPStan 1.6.3 thanks to @derrabus

Static Analysis,Test Suite

• 5362: PHPStan 1.6.0, PHPUnit 9.5.20 thanks to @derrabus

Connections,Static Analysis,ibm_db2

• 5356: Update JetBrains PhpStorm stubs to 2022.1 thanks to @morozov

Bug,Events,Platforms

• 5320: Inject EventManager when using a custom platform thanks to @spideyfusion and @zerocrates

Release 3.3.5

3.3.5

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

Bug

• 5345: Redact connection URL from logs as it may contain sensitive data thanks to @andrew-demb

Release 3.3.4

3.3.4

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

Bugfixes

• 5326: Source column defaults from its own table thanks to @morozov and @surikman
• 5325: Fix assertion in AbstractPostgreSQLDriver::getSchemaManager() thanks to @morozov and @astronom

Release 3.3.3

3.3.3

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

Documentation

• 5294: Modernize array syntax used in code examples thanks to @derrabus

Bug,MariaDB,Reserved Keywords

• 5292: OFFSET keyword for MariaDB thanks to @yurikuzn

Documentation,MySQL

• 5277: Recommend a better charset by default thanks to @greg0ire

CI,pdo_sqlite

• 5266: Add CI Job for testing with SQLite on Ubuntu 18.04 thanks to @derrabus

Static Analysis

• 5263: Remove obsolete PHPStan rules regarding compareSchemas() calls thanks to @derrabus
• 5261: More accurate params thanks to @greg0ire

Release 2.13.8

2.13.8

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

CI,SQL Server

• 5303: Run workflow on AppVeyor only if certain files changed thanks to @morozov

Dependencies,Static Analysis

• 5300: Psalm 4.22.0, PHPUnit 9.5.16 thanks to @derrabus

Bug,PHP,mysqli

• 5296: Fix PHP 8.1 deprecation on mysqli::real_connect() calls thanks to @iammati

Error Handling,Static Analysis,mysqli

• 5269: Run static analysis jobs on PHP 8.1 thanks to @morozov

Static Analysis

• 5262: PHPStan 1.4.6, Psalm 4.20.0, PHPUnit 9.5.13 thanks to @derrabus
• 5178: PHPStan 1.4.0 thanks to @derrabus

CI

• 5238: Run PHP 7.4 on AppVeyor thanks to @derrabus

Documentation

• 5187: Update README for release 3.3 thanks to @derrabus

Connections,Reserved Keywords,Static Analysis

• 5166: Enforce consistent constructor in dynamically instantiated classes thanks to @morozov

Release 3.3.2

3.3.2

• Total issues resolved: 2
• Total pull requests resolved: 7
• Total contributors: 9

Bugfixes

• 5224: Ignore columnDefinition in schema comparison thanks to @bcremer and @dmaicher
• 5226: Oracle: Convert array keys to lowercase thanks to @yajra
• 5232: Consider CASE_LOWER being equal to 0 in portability middleware thanks to @morozov
• 5246: Add support for collation option to MySQL thanks to @greg0ire

Static Analysis

• 5245: Fix typo thanks to @staabm

Documentation

• 5229: Add section on result types not being guaranteed thanks to @aszenz

Release 3.3.1

3.3.1

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

Bugfixes

• 5220: Allow dynamic call to compareSchemas thanks to @greg0ire
• 5202: Optimize AbstractMySQLPlatform::getListTableForeignKeysSQL() thanks to @morozov and @xprojects-de
• 5196: Handle binding invalid named parameter errors thanks to @morozov and @TimurFlush

Documentation

• 5201: Improve explanation on DC2Type comments thanks to @greg0ire
• 5197: [Doc] Fix a table of Type Mapping Matrix thanks to @javiereguiluz
• 5190: fix typo: \Doctrine\DBAL\Statement vs. \Doctrine\DBAL\Driver\Statement thanks to @staabm

Internal

• 5211: Drop requirement for PostgreSQL 9.4+ thanks to @greg0ire

Release 3.3.0

3.3.0

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

Static Analysis

• 5157: Document $lockMode value range thanks to @derrabus

Test Suite,Tools

• 5155: Remove assets used for testing Dumper thanks to @morozov

Deprecation,IBM DB2

• 5152: Deprecate support for IBM DB2 10.5 and older thanks to @morozov

Deprecation,Types

• 5136: Deprecate Type::canRequireSQLConversion() thanks to @morozov

Platforms,Test Suite

• 5127: Test AbstractPlatform::getModExpression() thanks to @morozov

Improvement,Oracle,Schema Introspection

• 5124: Improve performance of Oracle constraint query. thanks to @AlexHowansky

IBM DB2,Transactions

• 5121: Remove DB2Platform::supportsReleaseSavepoints() thanks to @morozov

Improvement,Prepared Statements

• 5120: Adding the constant PARAM_ASCII_ARRAY to Doctrine\DBAL\Connection thanks to @santoja

Deprecation,Platforms,Sequences

• 5119: Deprecate AbstractPlatform::prefersIdentityColumns() thanks to @morozov

Deprecation,Oracle

• 5109: Deprecate support for Oracle 12c and older thanks to @morozov

Documentation,Schema Management,Type Mapping

• 5106: Mark AbstractSchemaManager::extractDoctrineTypeFromComment() and ::removeDoctrineTypeFromComment() internal thanks to @morozov

Deprecation,MariaDB,Platforms

• 5102: Deprecate support for MariaDB 10.2.6 and older thanks to @morozov

MariaDB,MySQL,Platforms

• 5098: Forward compatibility for MySQL-like platforms thanks to @morozov

Dependencies,Static Analysis

• 5088: Remove suppression of the deprecated class error needed for Composer 1 thanks to @morozov

Deprecation,Tools

• 5084: Deprecate the doctrine-dbal binary thanks to @derrabus
• 5083: Deprecate Graphviz visitor thanks to @morozov

Dependencies

• 5078: Remove package-versions-deprecated dependency thanks to @derrabus

Deprecation,MySQL,Platforms

• 5072: Deprecate support for MySQL 5.6 and older thanks to @morozov

MySQL

• 5071: Clean up SQL generation in MySQL platform thanks to @morozov

Deprecation,Improvement

• 5070: RunSqlCommand: Render results as table thanks to @derrabus

Deprecation

• 5058: Deprecate AbstractPlatform commented type APIs thanks to @greg0ire

Improvement,pdo_sqlsrv

• 5038: Use abstract middleware classes for PDO_sqlsrv thanks to @derrabus

Connections,Deprecation,New Feature

• 5037: Add Connection::getNativeConnection() thanks to @derrabus

Improvement

• 5035: Provide abstract middleware classes thanks to @derrabus

Bug,Oracle,Schema Management

• 5007: Oracle fix duplicate identifier for 3.2.x thanks to @aimeos

Connections,Deprecation

• 4966: Deprecate Connection::getWrappedConnection(), mark Connection::connect() internal thanks to @morozov

Bug,SQL Server,Schema Comparison

• 4817: Use original case to index renamed columns thanks to @morozov

Release 3.2.2

3.2.2

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

Documentation

• 5180: Add middlewares to the architecture documentation thanks to @derrabus

Static Analysis

• 5179: PHPStan 1.4.0 thanks to @derrabus

Bug,Strict Typing,Type Conversion,Types

• 5173: Fix JSON Dbal type to properly encode whole number float values, preserving zero fractions. thanks to @Kova101

Release 3.2.1

3.2.1

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

Bug,pdo_pgsql

• 5161: Remove trailing comma in a PDO object parameters thanks to @mesolaries

Bug,PDO,PHP

• 5145: Use $maxLength = 0 by default when calling PDOStatement::bindParam() thanks to @morozov and @Jeroeny

Bug,SQL Parser

• 5138: Make the SQL parser regular expression less greedy thanks to @morozov

Bug,Documentation

• 5129: Accept strings in AbstractPlatform::get*Expression() methods thanks to @morozov

Bug

• 5079: Fix typos thanks to @derrabus
• 5077: Honor requiresSQLCommentHint() for overriding types thanks to @greg0ire

Documentation

• 5064: Use see instead of link for references to structural elements thanks to @derrabus
• 5059: Document minor BC Break about cache keys thanks to @greg0ire
• 5057: Explain what DC2Type SQL comments are about thanks to @greg0ire

Static Analysis

• 5063: Fix array types on ArrayResult thanks to @derrabus
• 5053: Workaround for "mixed is a reserved word" error thanks to @derrabus
• 5052: Fix doc block thanks to @derrabus
• 5045: Fix return type of _getNestedTransactionSavePointName() thanks to @derrabus

CI,Logging

• 5062: Remove psr/log downgrade from CI thanks to @derrabus

Deprecation,SQL Server

• 5061: Add deprecation annotation to SQLServer2012Platform thanks to @derrabus

Error Handling,Test Suite

• 5050: Remove exception coverter unit tests thanks to @morozov

Code Style

• 5040: Fix coding standard violation in the IBM DB2 driver thanks to @morozov

Bug,Type Mapping

• 4845: Doctrine SQL comments not always generated thanks to @Mediagone

Release 2.13.7

2.13.7

• Total issues resolved: 2
• Total pull requests resolved: 10
• Total contributors: 7

Dependencies

• 5148: Bump PHPStan, Psalm & PHPUnit thanks to @derrabus
• 5090: Update Psalm to 4.14.0 thanks to @morozov
• 5139: Specify allowed plugins for Composer 2.2 thanks to @morozov
• 5110: PHPCS 3.6.2, Psalm 4.15.0 thanks to @derrabus

Static Analysis

• 5118: Fix return docblock thanks to @ajgarlag
• 5042: Add missing unix_socket option to the array shape for the connection params thanks to @ste93cry

CI

• 5094: Add healthcheck default options for Oracle test runs thanks to @mondrake
• 5085: Use gvenzl/oracle-xe service thanks to @mondrake
• 4919: run workflow only if modified file matches the configured paths thanks to @marulitua
• 4854: Optimize build pipeline by taking affected paths into account thanks to @morozov

Documentation

• 5081: Typo fix : "enviroment" ➤ "environment" thanks to @Levure

Release 3.2.0

3.2.0

• Total issues resolved: 12
• Total pull requests resolved: 58
• Total contributors: 19

Improvements

• 3425: Improve ConnectionTest by triggering real exceptions thanks to @grongor
• 4622: Add events for Transaction begin/commit/rollBack. thanks to @Warxcell and @mariusbalcytis
• 4685: Support for more drivers on PHP 8.1 thanks to @morozov
• 4746: Platform-aware schema comparison thanks to @morozov
• 4844: Get view definition for SQL Server thanks to @kitloong
• 4855: Test AbstractPlatform::getLengthExpression() thanks to @morozov
• 4894: Refactor MySQLi statement to make it unaware of the connection thanks to @derrabus
• 4910: Remove redundant reference assignment thanks to @kamil-tekiela
• 4918: Remove redundant assert thanks to @kamil-tekiela
• 4925: Remove obsolete define() check thanks to @derrabus
• 4928: Basic exception handling for SQL Server thanks to @morozov
• 4929: Basic exception handling for IBM DB2 thanks to @morozov
• 4948: Accept PDO as a Connection constructor argument thanks to @morozov
• 4949: Accept connection object/resource as a driver connection constructor argument thanks to @morozov
• 4950: Accept driver-level statement as a wrapper-level statement constructor argument thanks to @morozov
• 4957: Accept the underlying statement as an oci8 statement constructor argument thanks to @morozov
• 4967: Introduce logging middleware thanks to @morozov
• 4986: Add return types to private and final methods thanks to @derrabus

Deprecations

• 4624: Deprecate doctrine/cache in favor of psr/cache thanks to @derrabus
• 4681: Deprecate TableGenerator thanks to @morozov
• 4688: [GH-4687] Deprecate Connection::lastInsertId($name) thanks to @morozov
• 4707: Introduce consistent Comparator API thanks to @trompette
• 4724: Deprecate redundant AbstractPlatform methods thanks to @morozov
• 4743: Deprecate reference from foreign key to its referencing table thanks to @morozov
• 4751: Deprecate VersionAwarePlatformDriver and ServerInfoAwareConnection thanks to @morozov
• 4753: Deprecate AbstractPlatform::getNowExpression() thanks to @morozov
• 4755: Deprecate AbstractPlatform::getName() thanks to @morozov
• 4785: Deprecate not passing $fromColumn to ColumnDiff thanks to @morozov
• 4789: Deprecate features of Table::getColumns() thanks to @morozov
• 4802: Platform API cleanup thanks to @morozov
• 4805: Deprecate AbstractPlatform::canEmulateSchemas() thanks to @morozov
• 4812: Deprecate Schema::getTableNames() thanks to @morozov
• 4814: Deprecate AbstractAsset::getFullQualifiedName() thanks to @morozov
• 4821: Deprecate AbstractSchemaManager::getSchemaSearchPaths() thanks to @morozov
• 4822: Deprecate schema methods related to explicit foreign key indexes thanks to @morozov
• 4839: Deprecate the Constraint interface thanks to @morozov
• 4897: Deprecate AbstractSchemaManager::dropAndCreate() and ::tryMethod() methods thanks to @morozov
• 4969: Declare SQLite as not supporting CREATE|DROP DATABASE thanks to @morozov
• 4999: Use sprintf('%d') like in DB2, SQLServer and Oracle to harden against wrong limit and offset thanks to @nickvergessen
• 4920: Remove redundant code in mysqli Result thanks to @kamil-tekiela
• 4898: Use the driver API to begin a transaction on mysqli thanks to @morozov
• 4887: Remove mysqli_report() call thanks to @derrabus
• 4869: mysqli::real_connect may be called with null $flags thanks to @mondrake
• 4871: OracleSchemaManager::_getPortableTableColumnDefinition throws deprecations on PHP 8.1 thanks to @mondrake

Bugfixes

• 1125: DBAL-1182: No schema difference detected when changing length of a text field thanks to @doctrinebot
• 2566: Column altering in migration from TEXT to LONGTEXT may not apply. thanks to @janokary
• 2663: Comparator fails for BLOBS thanks to @thomashohn
• 2930: Comparator doesn't see changes in the length of TextType field thanks to @WhiteEagle88
• 4178: DDC-2043: Extra cache operation in DBAL\Cache\ResultCacheStatement.php thanks to @doctrinebot
• 5003: Always cache the full result thanks to @morozov
• 5020: Fix hardcoded varchar default length thanks to @mvorisek

Internal

• 4857: Merge AbstractPostgreSQLPlatformTestCase into PostgreSQLPlatformTest thanks to @morozov
• 4891: Bump PHPStan level to 8 thanks to @greg0ire
• 4951: Detect driver in tests based on configured driver name thanks to @morozov
• 5008: Refactor query caching tests thanks to @morozov

Release 3.1.5

3.1.5

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

Documentation

• 5021: Remove references to Doctrine 2 thanks to @greg0ire

Release 2.13.6

2.13.6

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

Bugfixes

• 5017: Cast decimals integers to string on SQLite [PHP 8.1] thanks to @janlanger

Static Analysis

• 5009: PHPStan 1.2.0, Psalm 4.13.0 thanks to @derrabus

Documentation

• 5022: docs: fix docs for the json type thanks to @dunglas

Release 3.1.4

SECURITY RELEASE: All users are advised to upgrade when using doctrine/dbal 3.0.0 - 3.1.3 due to a critical SQL injection that was fixed: https://github.com/doctrine/dbal/security/advisories/GHSA-r7cj-8hjg-x622

3.1.4

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

Bug,oci8

• 4995: Fix getServerVersion for OCI8 when assertions are disabled thanks to @derrabus and @SylvainSimonGPA

Connections,Test Suite

• 4991: Optimize sharing test connection thanks to @morozov

Bug,QueryBuilder

• 4984: Cast LIMIT and OFFSET to int when building limit query thanks to @morozov

Bug,Prepared Statements,Regression,SQL Parser

• 4980: DBAL 3.1: Array parameter conversion does not work with long SQL queries thanks to @AlexeyKosov

Documentation

• 4979: Remove unwanted colon in code samples thanks to @greg0ire
• 4947: [Docs] Removing paragraph about PDO similarity thanks to @ThomasLandauer
• 4931: Fixes spelling error discovered via textlint thanks to @raphaelstolt

Bug,MySQL,Schema Introspection

• 4978: Use correct column order for composite foreign keys thanks to @AndreasA

CI

• 4942: Do not mark issues as stale thanks to @morozov

Bug,Connections,Test Suite,pdo_oci

• 4940: Fix connection leaks in Oracle functional tests thanks to @morozov

Bug,Platforms,SQL Server

• 4939: Use CONCAT() with SQL Server to concatenate strings thanks to @morozov

• 3346: mssql 2016 SQLServer2012Platform::getConcatExpression() missing/wrong thanks to @Lacoi

• 4935: Workflow for closing stale pull requests thanks to @morozov

Prepared Statements,Regression,SQL Parser

• 4927: Rework negation of the special characters in SQL parser thanks to @morozov and @j-schumann
• 4916: Make the SQL parser regular expression less greedy thanks to @morozov and @j-schumann

Bug,PostgreSQL,Prepared Statements,Regression,SQL Parser

• 4904: Fix parsing escaped PostgreSQL JSONB question operator thanks to @morozov and @lugosium

Bug,PHP,mysqli

• 4880: Catch MySQLi exceptions on PHP 8.1 thanks to @derrabus

Test Suite

• 4868: Rework connect/disconnect routines in functional tests thanks to @morozov

CI,Code Style

• 4865: Remove obsolete PHPCS config thanks to @derrabus

SQL Server,Test Suite

• 4856: Merge AbstractSQLServerPlatformTestCase into SQLServerPlatformTestCase thanks to @morozov

Bug,Cache

• 4852: QueryCacheProfiler::generateCacheKey: Param password should be ignore in connection hash thanks to @janbarasek

Bug,SQLite

• 4838: fixed using lower case column names thanks to @eschricker