3.4.0

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