| 1.4.7 - [RELEASEDATE] |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #16208: Warning in ezcQuery alias function |
| |
| |
| 1.4.6 - Monday 27 July 2009 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #11784: Fixed quoting of sub-selects in "IN" expression. |
| |
| |
| 1.4.5 - Monday 11 May 2009 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #14855 (IN with subselects generates excessive braces). |
| |
| |
| 1.4.4 - Monday 30 March 2009 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #14464: ezcDbFactory::create shouldn't throw a warning on invalid |
| parameter. |
| |
| |
| 1.4.3 - Monday 09 February 2009 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed ezcQueryInsert and ezcQueryUpdate examples. (Related to issue #14320). |
| |
| |
| 1.4.2 - Monday 05 January 2009 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #14197: ezcQuerySubselect API doc has some typos and words left |
| away. |
| |
| |
| 1.4.1 - Monday 01 December 2008 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #14014: Typo in documentation for ezcQueryUpdate. |
| |
| |
| 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 |
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ |
| |
| - Fixed issue #10802: MSSql handler misses identifierQuoteChars. |
| - Fixed issue #10803: Format of ezcQueryExpressionMssql::now(). |
| - Fixed issue #10797: Do not quote numbers and subqueries in IN() |
| |
| |
| 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. |