Hi all, To quote the radio, "Long time listener, first time caller." I just put a ticket in Lighthouse with a patch to fix a fairly serious bug in the AR habtm association preloading SQL. It doesn't affect mysql or postgres; only Oracle. Essentially, the preloading generates something like the following:
SELECT developers.*, t0.project_id as _parent_record_id FROM developers INNER JOIN developers_projects as t0 ON developers.id = t0.developer_id WHERE (t0.project_id IN (1,2)) The problem is that, in standard SQL, "INNER JOIN developers_projects as t0" is invalid. "INNER JOIN developers_projects t0" is the standard notation. Many dbs just deal with the extra "as" but Oracle doesn't. Looking for some +1 loving. Thanks! http://rails.lighthouseapp.com/projects/8994/tickets/1405-patch-fixed-non-standard-sql-generated-by-preloading-has_and_belongs_to_many-associations Brent --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" 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/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---
