King Simon-NFHD78 wrote: > Jason kirtland wrote: >> King Simon-NFHD78 wrote: >>> Hi, >>> >>> I'm connecting to an ancient version of MySQL (3.23.58) >>> that (as far as >>> I can tell) doesn't support basic "JOIN <table> ON >>> <condition>" syntax >> >> This is in r3916. It's a simple change that can be easily monkey >> patched into any version of SA- these just need to be emitted >> as INNER >> JOIN .. ON instead. > > Thanks - that looks much easier than the oracle version. I _almost_ > understand this one! Monkeypatching now... > > (I also hadn't spotted that adding 'INNER' was enough to satisfy > MySQL...)
For hand-patching older SA versions, the recipe is: find the base implementation of visit_join (in compiler.py or wherever, not in databases/), copy it into the MySQL dialect and change 'JOIN' to 'INNER JOIN'. Cheers, Jason --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
