method

columns_for_distinct

Importance_1
Ruby on Rails latest stable (v7.1.3.2) - 0 notes - Class: AbstractMysqlAdapter
columns_for_distinct(columns, orders) public

In MySQL 5.7.5 and up, ONLY_FULL_GROUP_BY affects handling of queries that use DISTINCT and ORDER BY. It requires the ORDER BY columns in the select list for distinct queries, and requires that the ORDER BY include the distinct column. See dev.mysql.com/doc/refman/en/group-by-handling.html

Show source
Register or log in to add new notes.