[Checkins] SVN: relstorage/branches/1.1/relstorage/adapters/common.py Oracle is picky about USING clauses

[Shane Hathaway]

Log message for revision 85485:
  Oracle is picky about USING clauses
  

Changed:
  U   relstorage/branches/1.1/relstorage/adapters/common.py

-=-
Modified: relstorage/branches/1.1/relstorage/adapters/common.py
===================================================================
--- relstorage/branches/1.1/relstorage/adapters/common.py	2008-04-18 23:42:39 UTC (rev 85484)
+++ relstorage/branches/1.1/relstorage/adapters/common.py	2008-04-19 00:26:49 UTC (rev 85485)
@@ -737,7 +737,8 @@
                     CASE WHEN packed = %(TRUE)s THEN 1 ELSE 0 END,
                     CASE WHEN pack_state_tid.tid IS NOT NULL THEN 1 ELSE 0 END
                 FROM transaction
-                    LEFT JOIN pack_state_tid USING (tid)
+                    LEFT JOIN pack_state_tid ON (
+                        transaction.tid = pack_state_tid.tid)
                 WHERE transaction.tid > 0
                     AND transaction.tid <= %(pack_tid)s
                     AND (packed = %(FALSE)s OR pack_state_tid.tid IS NOT NULL)