rails 5 不用 mysql_MySQL:使用.group()| Rails 5.2时包含未聚合列错误

ActiveRecord::Relation

rails控制台中的以下命令返回错误:

2.4.0 :015 > Post.group(:published)

Post Load (3.9ms) SELECT `posts`.* FROM `posts` GROUP BY `posts`.`published` LIMIT 11

ActiveRecord::StatementInvalid: Mysql2::Error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'app_dev.posts.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by: SELECT `posts`.* FROM `posts` GROUP BY `posts`.`published` LIMIT 11

但是,加上

.sum()

正确运行,没有错误。。。

> Post.group(:published).sum(:views)

在架构.rb

create_table "post", options: "ENGINE=InnoDB DEFAULT CHARSET=utf8", force: :cascade do |t|

t.string "title", null: false

t.text "body", null: false

t.boolean "published", null: false, default: false

t.bigint "views", null: false, default: 0

t.datetime "created_at", null: false

t.datetime "updated_at", null: false

end

谢谢