summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2013-06-08 19:11:06 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2013-06-08 19:11:06 -0400
commit10a672e6058048f0f3bc02b180ac7369fc53f6b4 (patch)
tree10a94fbe0dfeb064cfae4b2cc6005a38ee597b64
parenta144f55e651427f73bfb62af09fec8041e548243 (diff)
downloadsqlalchemy-10a672e6058048f0f3bc02b180ac7369fc53f6b4.tar.gz
oracle 9 does support this, oracle 8 is a special case.
-rw-r--r--doc/build/changelog/migration_09.rst11
1 files changed, 6 insertions, 5 deletions
diff --git a/doc/build/changelog/migration_09.rst b/doc/build/changelog/migration_09.rst
index e651b08d4..9f4ed488b 100644
--- a/doc/build/changelog/migration_09.rst
+++ b/doc/build/changelog/migration_09.rst
@@ -66,11 +66,12 @@ This was due to the fact that SQLite, even today, cannot parse a statement of th
Error: no such column: b.id
sqlite>
-Back in 2005, it's possible, though not confirmed, that maybe older versions of MySQL
-(like in the 4 series) or Oracle (perhaps in the 8 or 9 series) also couldn't handle the above form;
-though today, every database tested except SQLite now supports it. To make matters worse,
-SQLAlchemy's usual workaround of applying a SELECT often degrades performance on platforms
-like Postgresql and MySQL::
+Back in 2005, it wasn't clear if other databases had trouble with this form,
+but today it seems clear every database tested except SQLite now supports it
+(Oracle 8, a very old database, doesn't support the JOIN keyword at all,
+but SQLAlchemy has always had a simple rewriting scheme in place for Oracle's syntax).
+To make matters worse, SQLAlchemy's usual workaround of applying a
+SELECT often degrades performance on platforms like Postgresql and MySQL::
SELECT a.*, anon_1.* FROM a JOIN (
SELECT b.id AS b_id, c.id AS c_id