我有一些查询来选择基于skipped_play_id的所有数据,但是当我执行查询时,它仍然返回一些重复的skipped_play_id
user = User.first
skipped_plays=user.user_skipped_plays.select(:skipped_play_id,:created_at).group(:created_at,:skipped_play_id)如果我只需要按skipped_play_id分组的查询,为什么我要提供:created_at作为group by参数之一?如果我将查询更改为user.user_skipped_plays.select(:skipped_play_id,:created_at).group(:skipped_play_id)
它会回来的
ActiveRecord::StatementInvalid: PG::GroupingError: ERROR: column "user_skipped_plays.created_at" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT "user_skipped_plays"."skipped_play_id", "user_skippe...
^
: SELECT "user_skipped_plays"."skipped_play_id", "user_skipped_plays"."created_at" FROM "user_skipped_plays" WHERE "user_skipped_plays"."user_id" = $1 GROUP BY "user_skipped_plays"."skipped_play_id" ORDER BY "user_skipped_plays"."id" ASC LIMIT $2
from /Users/fourtyonestudio/.rvm/gems/ruby-2.3.1/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:657:in `prepare我真的很感谢你的建议
https://stackoverflow.com/questions/47504276
复制相似问题