MySQL Error 1055 information_schema.PROFILING.SEQ for each query

Question

I am using the latest mysql installation from the mysql repository installed on Ubuntu 14.04. Each request that I run leads to an error below, and I could not find anything that discusses this through google or here.

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

---

[SQL] SELECT * FROM tabcLocations

Affected Rows: 0 Time: 0.705s

[Err] 1055 - Expression # 1 of the ORDER BY clause is not in the GROUP BY clause and contains the non-aggregated column "information_schema.PROFILING.SEQ", which is functionally independent of the columns in the GROUP BY clause; this is incompatible with sql_mode = only_full_group_by

It returns the results of the query just fine, but it throws an error for each request, which will obviously affect the error handling in my applications. Any suggestions to fix this? This is pretty crazy at the moment.

Answer 1

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

As with MySQL 5.7.5, SQL mode by default enables ONLY_FULL_GROUP_BY. (Prior to 5.7.5, MySQL does not detect a functional dependency, and ONLY_FULL_GROUP_BY is not enabled by default.

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

Answer 2

information_schema mysql? / shoud , , .