Double JOIN with order

[ZenCocoon]

I guess the example below will speak on it's own :

named_scope :select_with_authors, :joins => "LEFT OUTER JOIN authors ON authors.id = posts.author_id"

Post.select_with_authors.descend_by_author_name ActiveRecord::StatementInvalid: Mysql::Error: Not unique table/alias: 'authors': SELECT posts.* FROM posts INNER JOIN authors ON authors.id = posts.author_id LEFT OUTER JOIN authors ON authors.id = posts.author_id ORDER BY authors.name DESC

Please let me know if you like further details.

[pschrammel]

this happens with :include in the named_scope, too.

[experteer]

Can somebody confirm that if you use mislav's will_paginate in version 2.3.11 this error disappears. Using 2.3.2 fails (at least for me).

[demersus]

I keep running into this problem when I try to eager load one of my associations with :include. It does a LEFT OUTER JOIN for the search conditions and an INNER JOIN to include data for the eager load.

[laurynas]

Bump

[graywh]

Just ran into this today with the INNER JOIN for :include'd has_one association and LEFT OUTER JOIN for search conditions on the same has_one association. MySQL throws a "Not unique table/alias" error.