MySQL Error 1055 information_schema.PROFILING.SEQ on every query

Question

I'm using a recent install of mysql from the mysql repository, installed on Ubuntu 14.04. Every query I run results in the error below and I have been unable to find anything that discusses this via google or here.

For example, this (obviously for demonstration purposes only) query returns the following:

---

[SQL]SELECT * FROM tabcLocations

Affected rows: 0 Time: 0.705s

[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

It returns the results of the query just fine, but throws an error on every query, which will obviously affect error handling in my applications. Any suggestions on how to resolve this? It's fairly maddening at the moment.

Answer 1

Put a line with sql-mode="" into your mysqld.cnf (linux) or my.ini (win) and restart MySQL server.

As of MySQL 5.7.5, the default SQL mode includes ONLY_FULL_GROUP_BY. (Before 5.7.5, MySQL does not detect functional dependency and ONLY_FULL_GROUP_BY is not enabled by default.

See docs here: http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html