doctrine/dbal

Stars: 9163

Forks: 1267

Pull Requests: 3642

Issues: 2483

Watchers: 114

Last Updated: 2023-09-16 07:51:35

#database #mysql #postgresql #oracle #ibm-db2 #sqlite #sql-server #hacktoberfest #mariadb

Doctrine Database Abstraction Layer

License: MIT License

Languages: PHP, Shell

https://www.doctrine-project.org/projects/dbal.html

Doctrine DBAL

4.0-dev	3.6



N/A

Powerful DataBase Abstraction Layer with many features for database schema introspection and schema management.

More resources:

OPEN ISSUES

See all

DBAL-1020: Postgres and using Schema tool throws cardinality errors by @doctrinebot
DBAL-1048: Function based index by @doctrinebot
DBAL-1077: Query limit for sql server by @doctrinebot
DBAL-1084: MySQL DateTime fractional seconds exception by @doctrinebot
DBAL-1107: Doctrine Migrations diff gets different table name for up and down by @doctrinebot
DBAL-1145: Add support for temporary tables by @doctrinebot
DBAL-1168: Schema's getMigrateFromSql always adds CREATE SCHEMA by @doctrinebot
DBAL-1173: MySQL schema-tool:update fails if there are two tables with the same name (lower and uppercase) by @doctrinebot
DBAL-1193: "requiresSQLCommentHint" is ignored by migration if the SQL type does not change by @doctrinebot
DBAL-1206: Generating Table SQL without indexes is invalid if using AUTO_INCREMENT by @doctrinebot
DBAL-1230: timestamp not supported, although no timestamp is ever defined by @doctrinebot
DBAL-1239: Comparator::compare() erroneously includes schema creation by @doctrinebot
DBAL-1241: Comparator generates wrong result if using database_name.table_name notation by @doctrinebot
DBAL-1243: Unique Key on two columns overrules three column index causing drop index by @doctrinebot
DBAL-1244: Large update with JSON results in segfault by @doctrinebot
DBAL-1245: Unexpected behavior when getting schema updates from ORM by @doctrinebot
DBAL-1253: Sqlite: inconsistent (non-)support of foreign keys by @doctrinebot
DBAL-1254: FIX TINYINT(1) - Make BOOL use BIT by @doctrinebot
DBAL-1256: SqliteSchemaManager do not found type of tableColumn if contain whitespace by @doctrinebot
DBAL-1257: doctrine-dbal will not execute if doctrine/dbal is installed as a dependency by @doctrinebot
DBAL-1259: QueryBuilder leaves LEFT JOIN out of queries by @doctrinebot
DBAL-1271: MySQL MEDIUMINT is mapped as type INT by @doctrinebot
DBAL-1272: Invalid character for every request made with bindValue and execute by @doctrinebot
DBAL-1278: DBAL crashes in DBALException if PHP-JSON is not installed by @doctrinebot
DBAL-1279: When replacing autoincrement primary key with string-based one, autoincrement option must be removed first by @doctrinebot
DBAL-1281: SQLServer modifyLimitQuery does not work with CAST in ORDER BY by @doctrinebot
DBAL-1285: Mapping Oracle XMLTYPE throws Doctrine\DBAL\DBALException by @doctrinebot
DBAL-1291: In PostgreSqlSchemaManager::_getPortableTableColumnDefinition Regex for nextval/sequence does not match by @doctrinebot
DBAL-1295: Float special values (NaN, +/-Inf) are not supported by @doctrinebot
DBAL-1305: Misleading Not Unique Alias Error Message in 2.5.2 Release by @doctrinebot
DBAL-1307: Allow named parameters in WHERE IN condition by @doctrinebot
DBAL-1308: MySQL getListTableForeignKeysSQL Slow for MariaDB by @doctrinebot
DBAL-131: Remove Static Types by @doctrinebot
DBAL-1310: PostgreSQL is the only platform to quote table names in getList* by @doctrinebot
DBAL-1312: Queries not executed when PDO::ATTR_EMULATE_PREPARES is disabled by @doctrinebot
DBAL-1313: Doctrine cannot handle dates before christ by @doctrinebot
DBAL-1660: Going from index to foreign_key fails by @doctrinebot
DBAL-167: Schema comparator doesn't work properly with columnDefinition's by @doctrinebot
DBAL-1778: All foreign keys rebuild when updating schema. by @doctrinebot
DBAL-1780: UTF8 characters in DQL column names by @doctrinebot
DBAL-1822: MSSQL TEXT (array, simple array etc.) is not encoding-safe by @doctrinebot
DBAL-1823: Doctrine2 + pdo_sqlsrv the createQueryBuilder() Order By with varchar field does not work by @doctrinebot
DBAL-235: Column order is not synchronized by Comparator by @doctrinebot
DBAL-292: Multiple use of named parameter doesn't work by @doctrinebot
DBAL-31: Move Schema related Creation code from AbstractPlatform to AbstractSchemaManager by @doctrinebot
DBAL-319: Doctrine\DBAL\Types\Type by @doctrinebot
DBAL-324: SchemaManager should first look into comment instead of infer the type first. by @doctrinebot
DBAL-352: Running doctrine:schema:update throws an exception the first time, succeeds the second time. by @doctrinebot
DBAL-357: Missing way to set types for CAST declaration by @doctrinebot
DBAL-40: Transparent table&column names escaping by @doctrinebot
DBAL-406: PostgreSqlSchemaManager::tablesExist() misses schema-qualified table names if they exist in the first schema on the search path by @doctrinebot
DBAL-474: SchemaManager / Connection on PostgreSQL platform does not respect filterExpression for sequences by @doctrinebot
DBAL-477: Just doublequote all schema names and field names in PostgreSQL sql command generation, and the same for MySQL by @doctrinebot
DBAL-493: Schema\Comparator incorrect diff with sqlite and unsigned integer by @doctrinebot
DBAL-550: Complete/non-overridable event dispatching in DDL methods of AbstractPlatform by @doctrinebot
DBAL-598: Schema Comparator is case insensitive for table names by @doctrinebot
DBAL-599: Add support of insert and insert select statements in DBAL QueryBuilder by @doctrinebot
DBAL-600: Add support of joins in update statements when using DBAL QueryBuilder by @doctrinebot
DBAL-732: MySQL 5.6 - Cannot change column 'fkProjectId': used in a foreign key constraint by @doctrinebot
DBAL-76: PostgreSQL Platform list* SQL code is in need of serious love by @doctrinebot
DBAL-812: SchemaTool ignores multi-columns (composite) indexes when creating a foreign key by @doctrinebot
DBAL-818: Fetching identity value from an insert fails with merge replication enabled by @doctrinebot
DBAL-819: Schema-tools does not work on multiple Oracle's schemas by @doctrinebot
DBAL-837: Cannot drop index needed in a foreign key constraint by @doctrinebot
DBAL-933: Get Statement Column Metadata by @doctrinebot
DBAL-943: dbal db2 platform uses incorrect column modification strategy for clob by @doctrinebot
DBAL-954: Custom QuoteStrategy doesn't work when creating new schema by @doctrinebot
DBAL-96: Make approach towards identifier quoting consistent by @doctrinebot
DBAL-970: Implement partial indexes for missing platforms by @doctrinebot
getListTableColumnsSQL fails on PostgreSQL when schema name contains special characters or there tables with same names in search_path by @kolesar-andras
Implement exception conversion for retryable exceptions in Oracle drivers by @deeky666
Support named PKs by @billschaller
Connection::lastInsertId is not documented by @billschaller
Feature request: support for joining subqueries by @aimfeld
Problem with TEXT type in MSSQL due to VARCHAR(MAX) instead of NVARCHAR(MAX) by @cfales
Charset and Collation across databases by @rijnhard
PostgreSqlPlatform tstzrange unknown database type by @EspadaV8
oracle driver ignores driver options by @butonic
Comparator does not detect renamed foreign keys by @yakobe
Explicitly cast old type's value from new type's value when altering a column's type with PostgreSQL by @devantoine
AbstractSchemaManager failing on column name "enabled" by @baskettcase
Cache key matters by @Seldaek
SQL Server Unique indexes constraint by @j-d
RENAME TABLE instead of re-creation by @ghost
Prevent duplicate DROP FOREIGN KEY by @ghost
PostgreSQL's SchemaDiff doesn't change collumn collation by @j-d
Invalid foreign keys in schema diff by @piotr-s-skygate
Error while renaming column by @mauvm
MySQL AbstractSchemaManager::createDatabase missing charset and collation by @fredw
DBAL QueryBuilder::update not valid syntax in SQLite with table alias by @robertodormepoco
Working with Doctrine Migrations by @o5
Migration diff command always add migration for default values of custom type fields by @josecelano
Namespace is not ignored by schema manager by @mishal
The documentation, Prepared statements and Triggers by @mikeSimonson
Disable foreign key constraint check/generation by @quazardous
postgresql schema diff generate DROP INDEX statement without schema_name by @josensanchez
PostgreSQL jsonb support in schema update tool. by @michalwiking
Update schema has 2 time the same "drop foreign key" by @Nikoms
pdo_sqlite: DROP TABLE not working with dots by @miguelgf
Foreign key creation and index renaming in wrong order on MySQL < 5.7 by @fust
SQL Server : function getListTablesSQL() problem with command line Doctrine orm:schema-tool:update by @cgardiennet
Creating databases (users) on Oracle 12c does not work by @deeky666
Changed table collation does not trigger schema update when using doctrine:schema:update by @podorozhny
Schema Diff \ MySQL to PostgreSQL\ toSQL()\ Invalid Query by @vafrcor
oracle 12.1 autoincrement feature by @brettmc
Join Ordering in Postgresql with QueryBuilder by @madflow
MSSQL IDENTITY_INSERT Issues by @jedkirby
MySQL Decimal being Converted to Numeric by @d42ohpaz
Enable SQLite foreign key on post-connect by @Ocramius
Refactor type system by @greg0ire
getDropIndexSQL Does not properly handle indexes with dashes for SQLite by @nokios
Add microseconds support on datetime/time types by @lcobucci
Rename Foreign Key by @lecneri
Error for Fields Defined as Date Type with SQL Server Connection by @Meir-Shapiro
Schema indexes update by @tasselchof
Incorrect handling changed primary key by @SCIF
Issue with getRenameIndexSQL being case-insensitive by @verganis
[3.0 proposal] Deprecate mutable DateTime-based types by @Majkl578
Unable to drop schema containing unknown custom doctrine types by @scaytrase
getAlterTableName doesn't correctly quote the column name on MySQL by @FSMaxB
[Question] Partial Indexes on SQL Server by @fabiang
Sqlite: JSON support by @Gemorroj
Consider passing AbstractPlatform in Connection constructor directly by @Majkl578
Consider enforcing result cache driver in QueryCacheProfile by @Majkl578
Improve exception hiearchy by @Majkl578
MariaDB 10.3 Native JSON Support by @kiler129
PostgreSQL domain and custom types schema diff by @JindrichPilar
listTables crashes when retrieving information on SQLite database with tables starting with sqlite_ by @pc-explore
Sqlite schema update keeps on recreating index on join table by @ThePeterMick
No backticks used in Migration Up function, but used in Migration Down function by @PBrouwer
Issue with Null fields, schema udpate and latest mariadb version (#2817) is still present ? by @Congelli501
Changing primary key to be based on new auto-increment column fails by @arnegroskurth
BUG: 'schema:update' is not adding/changing 'DC2Type' comment for updated fields by @jifer
Pass proper driverOptions to MasterSlaveConnection by @sirdawidd
Generates invalid up() migration by @svycka
Migrations not ever in sync with the DB by @electricBonfire
Version 2.9.2 keeps generating the same migration on an index where a length is defined on a varchar column by @hostep
Rollback called when outside of a transaction when using deferred constraints by @grongor
Cannot save interval type field data by @mattdillon100
Migrations up() do not respect "schema" annotation variable by @guillaume-a
MysqlPlatform::getCreateDatabaseSQL do not quote database name by @magnetik
Invalid last inserted id when the table has a trigger with insert statements in SQLSrvConnection by @sarven
Expose the underlying statement in DBAL statements by @stof
Connection::getParams() leaks implementation details by @morozov
Preventing default in getting drop table SQL results in null value by @J-roen
SqlitePlatform constantly changing tables due to SMALLINT autoincrement by @Matt-PMCT
Doctrine DBAL MysqliStatement broken for Float to Double conversion in de_DE locale (or locales that use ',' for floats) by @mmucklo
Column names in do not get quoted in shorthand methods by @CodeDuck42
migrations with postgresql database generate index for every single foreign key by @tagarikdi
Nested transactions with multiple levels by @OliverSkroblin
Generating a Schema object from a Table object and converting toSql() for mssql results in incorrect compound index syntax by @Shardj
getMigrateToSql does not check foreign key constraints by @callumstrubi
getQuotedName Does Not Quote Columns With Upper and Mixed Cases by @paulrrogers
Decouple DDL generation into Platform SQL Builders by @guilhermeblanco
Unable to change primary key in a single migration for Sql Server by @akrabat
Named statement parameters are unnecessarily converted to positional on Oracle by @morozov
Trigger deprecation when configuring different versions by @alcaeus
[POSTGRESQL 12] schema problem with IDENTITY by @EnergieZ
Doctrine ORM tries to recreate partial indexes with the same definition every time. by @skobkin
Diff error : "An index with name ... was already defined on table '...'. " by @psohm
Partial unique index on datetime field generates same migration every time by @tejerka
Constant database updates when using @GeneratedValue(strategy="AUTO") by @Bast1onCZ
Error in listTableDetails of class PostgreSqlSchemaManager, when using uppercase letters in table name. by @kotowszczak
DateTimeType ignores timezone of PHP DateTime object by @GPHemsley
Wrong SQL statement causes ORA-22859 error when trying to make nullable a CLOB column by @cesarhein
Error reporting is not understandable when passing a non-array value to a PARAM_STR_ARRAY param by @stof
Comparator::toSql() creates duplicate DROP commands for foreign keys (MySql) by @gregor-tb
MySQL 'ON UPDATE CURRENT_TIMESTAMP' not supported by @djozsef
Cannot change camelCase columns, converts identifier to lowercase by @squareborg
SchemaDiff unable to output diff for SqlitePlatform with foreign key changes by @camilleterol
Support of Multi-Valued index from MySQL 8 by @anaelChardan
DEFAULT NULL get dropped when changing column type by @unixslayer
PostgreSQL jsonb column is ignored by update tool. by @remoteclient
Primary key columns with uppercase characters are treated different to fully lowercase PK columns by @Numynum
QueryBuilder: Add comments to SQL queries by @jkufner
SQLParserUtils::expandListParameters fails to process an array of LOB as an array of params when using findBy by @nicolas-girod
Incorrect Varchar Max Length on MariaDB by @jdsaphir
Diffing Sqlite Schema can in certain conditions lead to illegal alter table generation due to missing platform feature check by @beberlei
transactional() doesn't correctly manage nested transactions with savepoints upon MySQL deadlock by @aboks
Doctrine fails to declare Extended Property on SQL-Server array column (when table name is quoted) by @metaturso
The support for quoting identifiers is fundamentally broken by @morozov

RELEASES