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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
