zend-db 2.11.0

Added

• #336 adds InsertIgnore class for "INSERT IGNORE" usage (usable in MySQL platform).

• #356 adds support for IN (NULL) for empty value-set.

Changed

• Nothing.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #146 fixes setting correct value for lastInsertValue pre-insert in SequenceFeature.

zend-db 2.10.1

Added

• Nothing.

Changed

• Nothing.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #382 fixes Zend\Db\Sql\Expression to allow 0 value for parameter.

• #395 fixes PHP 7.4 compatibility.

• #392 fixes MetadataFeature to work with TableIdentifier.

• #399 fixes accessing constraint metadata within the Oracle adapter.

• #375 fixes detecting number of replacements in Zend\Db\Sql\Expression.

• #377 allows any AdapterInterface instance in RowGateway.

• #342 fixes deleting from aliased tables.

• #386 fixes too strongly casting integer parameters in PDO adapter.

zend-db 2.10.0

NOTE: this release introduces a potential BC break in Zend\Db\Adapter\Driver\Mysqli\Result::currentData with the change of default value from false to null (regression from 2.8). This was the previous behavior of version 2.8, changed in 2.9. This change may affect classes that extends Zend\Db\Adapter\Driver\Mysqli\Result.

Added

• #157 added support of Zend\Db\Sql\TableIdentifier in DDL
• #345 allow usage with zend-hydrator v3
• #346 adds support for PHP 7.3

Changed

• Nothing.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #303 fixes #295 issue: handle empty array as datasource at AbstractResultSet::initialize() at PHP 7.2
• #313 test AbstractResultSet::current() to return null on empty array
• #329 fixes Exception thrown when calling prepareStatementForSqlObject on a Select with a sub-Select that has limit and/or offset set
• #337 fixes #330 current NULL for mysqli
• #338 restore missing use ResultSet in AbstractTableGateway
• #341 fixes undefined variable bug in MetadataFeature
• #357 fixes named params in subquery - limit and offset (issue #355)

zend-db 2.9.3

Added

• Nothing.

Changed

• Nothing.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #295 fix error when datasource passed to AbstractResultSet::initialize() is empty array at PHP 7.2 environment

• #300 fix error for nested queries inside field parameters

• #301 fix for issue with set fields that exists in different tables in one query

• #304 fix PDO bind parameter name to use field name with extended charset (PDO only supports alphanumeric and underscore for placeholder/parameter names)

zend-db 2.9.2

Added

• Nothing.

Changed

• Nothing.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #292 ensures that you may reference bound parameter names using a leading colon (:) character when using the PDO adapter. (The leading colon is not technically necessary, as the adapter will prefix for you; however, this ensures portability with vanilla PDO.)

zend-db 2.9.1

Added

• Nothing.

Changed

• #289 reverts a change introduced in 2.9.0 and modifies the behavior of the PDO adapter slightly to remove a regression. In 2.9.0, when binding parameters with names that contained characters not supported by PDO, we would pass the parameter names to md5(); this caused a regression, as the SQL string containing the parameter name was not also updated.

  This patch modifies the behavior during a bind-operation to instead raise an exception if a parameter name contains characters not supported by PDO.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• Nothing.

zend-db 2.9.0

Added

• #216 added AFTER support in ALTER TABLE syntax for MySQL
• #223 added support for empty values set with IN predicate
• #271 added support for dash character on MySQL identifier
• #273 added support for implementing an error handler for db2_prepare
• #275 added support for LIMIT OFFSET for db2
• #280 added version dsn parameter for pdo_dblib

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #205 fixes the spaces in ORDER BY syntax
• #224 fixes how parameters are bound to statements in the PDO adapter. PDO has a restriction on parameter names of [0-9a-zA_Z_]; as such, the driver now hashes the parameter names using md5() in order to ensure compatibility with other drivers.
• #229 fixes the support of SSL for mysqli
• #255 fixes ResultSet with array values
• #261 fixes Exception in Firebird driver doesn't support lastInsertId
• #276 fixes the support of PHP 7.2
• #287 fixes the usage of count() with PHP 7.2

zend-db 2.8.2

Added

• #110 prepared the
  documentation for publication at https://zendframework.github.io/zend-db/
• #114 add
  Adapter\Adapter::class to alias against Adapter\AdapterInterface::class

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #154 fixes the how the
  COMBINE operator is applied to SQLite adapters, ensuring a valid UNION
  statement is generated.
• #112 fixes the test on
  the number of replacements when using the same variable name.
• #115 TableGateway update
  method was incorrect when specifying default join declaration.
• #145 Fix MSSQL Select
  when encounting DISTINCT and OFFSET and LIMIT together.
• #153 Runtime exception
  threw fatal error due to incorrect spelling of the class when a DSN did not
  exist.

zend-db 2.8.1

Added

• Nothing.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• #100 fixes the JOIN behavior to re-allow selecting an empty column set from the joined table.
• #106 fixes an issue in the test suite when ext/pgsql is enabled, but no databases are available.

zend-db 2.8.0

Added

• #92 adds the class Zend\Db\Sql\Join for creating and aggregating JOIN specifications. This is now consumed by all Zend\Db\Sql implementations in order to represent JOIN statements.
• #92 adds support for JOIN operations to UPDATE statements.
• #92 adds support for joins to AbstractTableGateway::update; you can now pass an array of specifications via a third argument to the method.
• #96 exposes the package as config-provider/component, but adding:
  • Zend\Db\ConfigProvider, which maps the AdapterInterface to the AdapterServiceFactory, and enables the AdapterAbstractServiceFactory.
  • Zend\Db\Module, which does the same, for a zend-mvc context.

Deprecated

• Nothing.

Removed

• Nothing.

Fixed

• Nothing.