Yii DB version 2.1.0 was released. In this version:
- Add
UuidValueexpression that represents a UUID value independently of DBMS - Support
UnitEnumenums as column values - Add
Identifierexpression for strict identifier quoting - Add
IdentifierQuoterInterfaceand implement it inQuoter - Add
SerializationFailureExceptionthat is thrown when a transaction fails with SQLSTATE code 40001 - Improve the exception message of
DbUuidHelper::toUuid()when the value isn't a valid UUID - Refactor
Query::queryScalar()to use a clonedQueryobject - Make
$psrCacheparameter ofSchemaCacheconstructor and$schemaCacheparameter ofAbstractSchemaandAbstractPdoConnectionconstructors optional, removepsr/simple-cache-implementationfromrequireincomposer.json - Index the result of
AbstractSchema::getSchemaMetadata()by table name, sogetSchemaChecks(),getSchemaDefaultValues(),getSchemaForeignKeys(),getSchemaIndexes(),getSchemaPrimaryKeys(),getSchemaUniques()andgetTableSchemas()expose the table each item belongs to - Fix
ColumnDefinitionParserto parse an unquotedDEFAULT NULLas SQLNULLinstead of the string'NULL'