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 > > > > Ie. this gives a syntax error: > > > > SELECT * FROM productversions pv > > JOIN producttypes pt ON pv.producttype = pt.producttype > > > > Whereas this is fine: > > > > SELECT * FROM productversions pv > > JOIN producttypes pt > > WHERE pv.producttype = pt.producttype > > > > Can anyone think of anything I can do (perhaps by subclassing or > > monkeypatching MySQLDialect) to automatically convert > queries like the > > former into the latter? SQLAlchemy seems to be infitely flexible in > > dealing with syntax quirks of various databases, so I've > got my fingers > > crossed... > > 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. > > -j
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...) Cheers, Simon --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
