5.7 mtr failed with new SQL error 1055: Expression #<nr> of SELECT list is not in GROUP BY clause and contains nonaggregated column...

Description

error 1055: Expression #<nr> of SELECT list is not in GROUP BY clause and contains nonaggregated column '<cr>' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Happens in tests:
tokudb.bugs.2458 : At line 23: query 'explain select t1.* from t1 left join t2 using(f1) group by t1.f1'

tokudb.cluster_tokudb_bug_993_2 : At line 30: query 'select * from z1 group by a,b' failed: 1055: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.z1.c' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

tokudb.ctype_collate : At line 88: query 'SELECT latin1_f,count FROM t1 GROUP BY latin1_f COLLATE latin1_swedish_ci' failed: 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.t1.latin1_f' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

tokudb.cluster_tokudb_bug_993 : At line 18: query 'select * from z1 group by a,b' failed: 1055: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.z1.c' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

tokudb.type_date : At line 80: query 'SELECT DATE_FORMAT("2002-03-06 10:11:12", CONCAT('%a, %d %M %Y %H:%i:%s ', t2.GMT)) FROM t1, t2 GROUP BY t1.AFIELD' failed: 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.t2.GMT' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Environment

None

Activity

Show:
George Lorch
January 4, 2016, 8:54 PM

Assignee

George Lorch

Reporter

George Lorch

Labels

External issue ID

None

Freshdesk Tickets

None

Fix versions

Affects versions

Priority

Major
Configure