PG error with v3.2.0

[aoredo]

Hello,

I am getting this error while generating a tag_cloud from a tagged_with instance when upgraded to 3.2.0.

@images = Media.tagged_with(params[:search].strip.gsub(' ', '').gsub('-', '')).order(mylike: :desc).page params[:page]

@tags = @images.tag_counts_on(:tags).limit(20)

@tags is then used to generate the tag_cloud but I am getting the error below. When i revert back to 2.4.1, it worked perfectly. Any suggestions?

_Error_*
ActionView::Template::Error (PG::InvalidColumnReference: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...' AND media_taggings_b910fb9.tag_id = 1 ORDER BY "media"."m...
^
: SELECT COUNT(*) FROM "tags" JOIN (SELECT taggings.tag_id, COUNT(taggings.tag_id) AS tags_count FROM "taggings" INNER JOIN media ON media.id = taggings.taggable_id WHERE (taggings.taggable_type = 'Media' AND taggings.context = 'tags') AND (taggings.taggable_id IN(SELECT DISTINCT media.id FROM "media" JOIN taggings media_taggings_b910fb9 ON media_taggings_b910fb9.taggable_id = "media".id AND media_taggings_b910fb9.taggable_type = 'Media' AND media_taggings_b910fb9.tag_id = 1 ORDER BY "media"."mylike" DESC LIMIT 24 OFFSET 0)) GROUP BY taggings.tag_id HAVING COUNT(taggings.tag_id) > 0) AS taggings ON taggings.tag_id = tags.id):

[seuros]

Can you write a script to reproduce this error ?

[aoredo]

Sorry I am newbie, what do you mean by a script?

[seuros]

A rails application with only the models that causing the error (you can strip out all logic from it)

try to remove : .order(mylike: :desc)

[bf4]

@aoredo Any example code. The model, the schema for the model, the relevant code in the model, the db type and version, the rails version, command you're running when you get the error, the backtrace

[vanboom]

This reproduces it...
User.tagged_with(params[:tag]).order("lower(lname) asc") produces
SELECT DISTINCT USERS.* FROM USERS JOIN TAGGINGS USERS_TAGGINGS_53FE430.TAGGABLE_TYPE = 'USER' ....

User.order("lower(lname) asc") produces
SELECT USERS.* FROM USERS WHERE USERS.ACTIVE='T' ORDER BY LOWER(LNAME) ASC

I believe the addition of the DISTINCT argument is causing the issue.

[seuros]

Ok, i will try to resolve this, once i have free time.

[dkonayuki]

I have this problem too. Probably because of DISTINCT when I try to ORDER by some fields not in SELECT DISTINCT operation.

[seuros]

@dkonayuki Can you provide a dummy application with the issue ??

[smathieu]

FYI, I'm running on the same issue. Any model that uses tagged_with(params[:tags], any: true) and a order(...) clause seems to break this.