Revision: Tue, 18 Feb 2020 08:24:29 GMT

Database - Errata

Documentation section lists non-obvious behaviors of DBAL component and ways to avoid them.


Consider using 'datetime' type for your columns instead of 'timestamp' as it gives you more unified support and ability to define proper default values.

Timestamp fields behavior is different in MySQL 5.5 and MySQL 5.6+!

Driver Specific notes

Not all drivers are implemented equally:

MySQL Driver

MySQL driver is fully supported by DBAL layer with all functionality being available.

Default table engine is set to InnoDB.

Postgres Driver

Postgres driver includes custom implementation of InsertQuery in order to address the return value of auto-incremental PK, it will automatically add RETURNING {primary key} to the generated SQL query.

SQLServer Driver

SQLServer includes a fallback mechanism to limit your selection without orderBy specified. In some cases, it might add additional _row_number_ column at the end of the selected columns.

SQLServer is optimized to work with 12+ versions of Microsoft SQL Server.

SQLite Driver

SQLite DBMS does not support a set of table altering operations, in order to address some of the schema migrations will be performed using temporary tables and data copy.

Edit this page