joomla/joomla-platform — pull request #1250 by pasamio (2012-06-05 06:16:18+00:00)
Title: Fixes for Oracle driver, Oracle query and PDO driver

This pull request introduces various fixes for the Oracle driver, Oracle query class and PDO driver.

# Summarised changes:

- Add double quote as the Oracle name quote to handle name quoting properly.
- Added support for supplying a query to execute to verify that a connection is active.
- Override default connection verification query for Oracle to support "dual" idiom.
- Update getTableColumns() to support rewriting a prefix on Oracle.
- Fix getTableColumns() to return results consistent with other drivers.
- Add replacePrefix() to Oracle driver to ignore double quoted items (it being the name quote character).
- Fix getEscaped() for PDO driver to not automatically quote it's results inline with other drivers.
- Store a copy of the error message in PDO execute() before trying to run keep-alive query which wipes out previous value.
- Suppress error message from lastInsertId() to avoid PDO warning you that a given database platform doesn't support it natively.
- Add a sudden death when trying to check if connected when already trying to check if connected to prevent infinite loop.
- Update Oracle query to only mangle the query for limiting and offset when applicable otherwise pass the query through unmodified.