Database: ChangeLog
[ ]
[ Oracle setup ]
[ ]
[ ]
[ ]
[ ]
- Fixed issue #13188: Sub select queries are no more quoted in SQLite IN
statements.
- Fixed issue #12150: Connect to MSSQL database fails due to wrong driver
specification.
- Implemented issue #10753: ezcDbQuery should implement __toString().
- Implemented issue #12540: subselect support for other query types besides
SELECT.
- 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.
- 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.
- Fixed bug #11345: Encoding problem with Database component (No info about
it).
- 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.
- 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.
- 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.
- 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.
- 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.
- Fixed handling queries like "SELECT 1+1" in Oracle.
- Fixed bug #8835: Documentation of lOr and lAnd.
- Fixed bug #8428: LIMIT doesn't work correctly, inverted values.
- Added examples of using multi-join and subselect syntax to the tutorial.
- Fixed problem where rollback would not be performed even though it was the
innermost call to it.
- Improved support for SQLite right join emulation.
- 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.
- 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.
- 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.
- 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.
- Initial release of this package.
Last updated: Mon, 10 Nov 2008
