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 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Added the ezcDatabase::getIdentifiers() method that returns a list of identifiers of the registered database instances. 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 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Fixed bug #9220: Wrong attribute used in ezcDbHandler::commit(). - Fixed bug #9221: ezcDbTransactionException::__construct() does not handle message argument correctly. 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 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Fixed bug #8360: ezcQueryExpressionOracle::concat() calls non-existing method. - Added ezcQuery::resetBinds() which allows you to reset the bound values and parameters associated with a query. 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 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Fixed bug #7764: ezcQuerySelect doesn't reset queries correctly 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: * ezcQueryOracle to ezcQuerySelectOracle - 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: * Changed ezcQuery to an abstract class, which forms the base for the more specific classes. * Added ezcQuerySelect which now contains the functionality ezcQuery had before. * Added ezcQueryUpdate. * Added ezcQueryInsert. * Added ezcQueryDelete. * Added ezcQueryExpression with all the SQL expressions. ezcQuery has a publically available pointer to it through 'expr'. * The various query types can now be retrieved through create(Select/Insert/Update/Delete) query in the handler classes. 1.0beta1 - Friday 25 November 2005 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ - Initial release of this package.