On 3/14/06, Michael Schoen <[EMAIL PROTECTED]> wrote: > The changes to improve table aliasing in [3776] broke all sorts of > associations for Oracle. > > The issue is that Oracle doesn't allow for table aliases using the AS > keyword. > > ... LEFT OUTER JOIN authors AS authors ... > > is no good, but > > ... LEFT OUTER JOIN authors authors ... > > is just dandy. > > Does the latter also work ok for MySQL, etc? > > I've got a patch prepared, looking for confirmation that dropping the AS > works for the supported dbs. The alternatives seem ugly. >
I can confirm it works for mysql 4.1 and postgres, 8.1 and appears fine on sqlite 2. -- Cheers Koz _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
