[news] Yii DB and drivers updates


Yii Database package was tagged along with its drivers.
Yii Database 1.2

  • Deprecate TableSchemaInterface::compositeForeignKey() and SchemaInterface::TYPE_JSONB
  • Enhanced documentation of batchInsert() and update() methods of DMLQueryBuilderInterface interface
  • Refactor Quoter
  • Move methods from concrete Command class to AbstractPdoCommand class
  • Typecast values in AbstractDMLQueryBuilder::batchInsert() if column names with table name and brackets
  • Typecast values in AbstractDMLQueryBuilder::batchInsert() if values with string keys
  • Fix collected debug actions
  • Fix Quoter::quoteTableName() for sub-query with alias
  • Quote aliases of CTE in WITH queries
  • Fix AbstractDMLQueryBuilder::batchInsert() for values as associative arrays

Yii DB PostgreSQL Driver 1.2

  • Fix incorrect convert string value for BIT type
  • Fix retrieving sequence name from default value
  • Refactor JsonExpressionBuilder, ArrayExpressionBuilder and ColumnSchema
  • Refactor related with Yii DB 1.2

Yii DB MySQL Driver 1.1

  • Remove QueryBuilder::getColumnType() child method as legacy code
  • Refactor insert default values
  • Refactor related with Yii DB 1.2

Yii DB SQLite Driver 1.1

  • Support json type
  • Fix foreign keys: support multiple foreign keys referencing to one table and possible null columns for reference
  • Refactor related with Yii DB 1.2

Yii DB MSSQL Server Driver 1.1

  • Remove RECURSIVE expression from CTE queries
  • Fix type boolean
  • Fix DDLQueryBuilder::alterColumn() for columns with default null
  • Refactor related with Yii DB 1.2

Yii DB Oracle Driver 1.2

  • Improve column type detection
  • Remove RECURSIVE expression from CTE queries
  • Refactor related with Yii DB 1.2