ER_WRONG_FIELD_WITH_GROUP

Question

code: 'ER_WRONG_FIELD_WITH_GROUP',
  errno: 1055,
  sqlMessage: "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fashioncart.items.item_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by",

Why do this error comes for? How can I resolve it?

update your question add you query code .. a proper data sample and the expected result — ScaisEdge, Dec 24 '19 at 10:28
you can turn off `only_full_group_by` using `SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));` — Devsi Odedra, Dec 24 '19 at 10:37
Please review https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html — P.Salmon, Dec 24 '19 at 12:35

score 5 · Answer 1 · answered Dec 31 '20 at 15:30

This is related to the annoying 'ONLY_FULL_GROUP_BY' default setting in mysql. My advice, permanently switch it off.

mysql> SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

Refer this for more details: Disable ONLY_FULL_GROUP_BY

ER_WRONG_FIELD_WITH_GROUP

1 Answers1