Path

ez components / documentation / api reference / 2008.2.1 / database


eZ Components 2008.2.1

Database: ChangeLog

[ Tutorial ] [ Oracle setup ] [ Class tree ] [ Element index ] [ ChangeLog ] [ Credits ]

1.4.3 - Monday 09 February 2009

1.4.2 - Monday 05 January 2009

1.4.1 - Monday 01 December 2008

1.4 - Monday 16 June 2008

  • Fixed issue #13188: Sub select queries are no more quoted in SQLite IN statements.

1.4rc1 - Tuesday 10 June 2008

  • No changes

1.4beta1 - Tuesday 27 May 2008

  • Fixed issue #12150: Connect to MSSQL database fails due to wrong driver specification.

1.4alpha1 - Monday 05 May 2008

  • Implemented issue #10753: ezcDbQuery should implement __toString().
  • Implemented issue #12540: subselect support for other query types besides SELECT.

1.3.4 - Monday 14 January 2008

  • Fixed issue #11266: ezcQueryExpression->in( 'colname', array() ) produces a strange exception message.
  • Fixed issue #11786: quoteIdentifier() incorrectly quotes unambiguous identifiers.
  • Documented issue #10161: Column names are always lowercase.

1.3.3 - Wednesday 05 December 2007

  • Fixed bug #12152: The SQLite's unixTimestamp() expression function implementation uses the current UTC offset, instead of the UTC offset that belongs to the date for which a Unix timestamp should be generated.

1.3.2 - Wednesday 28 November 2007

  • Fixed bug #11345: Encoding problem with Database component (No info about it).

1.3.1 - Monday 12 November 2007

  • Fixed issue #11609: Subselect query documentation is incorrect.
  • Fixed issue #11687: Mssql DSN with port does not work.
  • Fixed issue #11700: Subselects only work when there is a database instance set.

1.3 - Monday 02 July 2007

  • Documentation updates.

1.3rc1 - Monday 25 June 2007

  • Fixed issue #10884: Database: Limit in Oracle only works with 1000 elements at maximum.
  • Fixed issue #10937: ezcDbHandler::hasFeature() is not implemented properly anywhere.
  • Fixed issue #10943: Add parameter to specify type of value in bindValue() and bindParam().
  • Fixed issue #10986: in() expression test for sub selects fails in PHP 5.1.6.
  • Documentation fixes and updates.

1.3beta2 - Thursday 31 May 2007

1.3beta1 - Monday 07 May 2007

  • Fixed issue #8240: ezcQueryExpression::in does not work with strings.
  • Fixed issue #8520: The non trivial join methods have incomplete documentation.
  • Fixed issue #9526: Implemented expression now() for each database handler.
  • Fixed issue #10529: Tests for quoting of strings in query expressions.
  • Implemented feature #7772: SQL Server implementation for the Database package. Based on contributions by Joel Arvidsson and Friedel Hill.
  • Implemented feature #8473: Oracle Limit/Offset optimization.
  • Implemented feature #8448: Select Distinct not supported
  • Implemented feature #9960 [Database] sql abstraction. Based on contributions by Joel Arvidsson and Friedel Hill.
  • Implemented feature #9965: Support for delayed initialization through ezcBaseInit.

1.2 - Monday 18 December 2006

  • Fixed issue #9219: Added sql HAVING condition. Patch by Christian Michel.
  • Fixed issue #9439: PersistentObject doesn't handle sequence value generation right for Oracle.
  • Fixed issue #9466: Oracle limit does not return $this.
  • Fixed issue #9567: query->bindValue() sets value in query->boundParameters.
  • Fixed issue #9841: Sqlite file DSN on Windows added an incorrect slash.
  • Fixed ezcQueryExpressionOracle, corrected processing subString() in Oracle.

1.2beta2 - Monday 20 November 2006

1.2beta1 - Tuesday 24 October 2006

  • Added the ezcDbHandler::quoteIdentifier() method that you can use to quote identifiers (such as table and column names) with.
  • Added support for SQLite in-memory databases through the DSN: "sqlite://:memory" and the dbParams: "array( 'handler' => 'sqlite', 'port' => 'memory' );".
  • Fixed bug #9159: No alias substitution for 'table.column' syntax.

1.1.4 - Tuesday 24 October 2006

1.1.3 - Monday 09 October 2006

  • Fixed handling queries like "SELECT 1+1" in Oracle.

1.1.2 - Monday 28 August 2006

  • Fixed bug #8835: Documentation of lOr and lAnd.

1.1.1 - Monday 07 August 2006

1.1 - Monday 12 June 2006

  • Fixed bug #8428: LIMIT doesn't work correctly, inverted values.

1.1rc1 - Monday 29 May 2006

  • Added examples of using multi-join and subselect syntax to the tutorial.

1.1beta2 - Tuesday 09 May 2006

  • Fixed problem where rollback would not be performed even though it was the innermost call to it.

1.1beta1 - Wednesday 19 April 2006

  • Improved support for SQLite right join emulation.

ezcQuery

  • Added support for subselects.
  • Added support for multi-join queries.
  • Changed the requirement that select(), from(), where() and the join methods could only be used once for a query object.

1.0.1 - Monday 20 February 2006

1.0 - Monday 30 January 2006

  • Removed ezcDbHandler::begin(). It was a rename of PDO::beginTransaction() because of the strange PDO naming. Unfortunately it caused problems with re-implementations.
  • Removed ezcDbHandler::processLimitOffset. Leftover from old design.

1.0rc1 - Monday 16 January 2006

  • Added support for aliases of column names.
  • Added SQLite driver.
  • Changed exception behavior. All errors will now throw a different exception class.
  • Changed class names:
  • Removed destructor in ezcDbHandler. We should not throw exceptions that can't be caught.

ezcDbFactory

  • Added the static method getImplementations() which returns a list of all available database implementations.
  • Changed exception usage to reveal more information in case no database type is passed, or when a not-supported database type is used.
  • Fixed bug where we did not check if bound parameters actually existed before binding them.

1.0beta2 - Thursday 22 December 2005

  • Refactored query design:

1.0beta1 - Friday 25 November 2005

  • Initial release of this package.
Last updated: Mon, 09 Feb 2009