Problem with "only_full_group_by"
Posted by: Jose Ferronato
Date: August 02, 2016 03:49PM

Hi, i have a problem with the "only_full_group_by".

I have a ETL file running, to collect data and bulk on another database, but i receive the error below:

Quote

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'zabbix_reports.ft_events_ciclo.seg_month'; this is incompatible with sql_mode=only_full_group_by

But i configure the MySQL do ignore the sql_mode.

Below the MySQL configuration:
Quote

[mysqld]
sql_mode = ""

Or in MySQL CLI

mysql> select @@sql_mode;
+------------+
| @@sql_mode |
+------------+
| |
+------------+
1 row in set (0.00 sec)

I restarted the MySQL.

What is wrong?


Thanks so much

Options: ReplyQuote


Subject
Written By
Posted
Problem with "only_full_group_by"
August 02, 2016 03:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.