SQL: SELECT m.*, u.name unitName, mc.name categoryName, me.bar_code, me.purchase_decimal, me.commodity_decimal, me.wholesale_decimal, me.low_decimal, me.sku FROM jsh_material m LEFT JOIN jsh_material_extend me ON m.id = me.material_id AND ifnull(me.delete_Flag, '0') != '1' LEFT JOIN jsh_unit u ON m.unit_id = u.id AND ifnull(u.delete_Flag, '0') != '1' LEFT JOIN jsh_material_category mc ON m.category_id = mc.id AND ifnull(mc.delete_Flag, '0') != '1' WHERE 1 = 1 AND ifnull(m.delete_flag, '0') != '1' GROUP BY m.id ORDER BY m.id DESC LIMIT ?, ?

Cause: java.sql.SQLSyntaxErrorException: Expression #25:Ошибка добавления информации о товаре, если массив ID для удаления штрихкодов пуст, происходит... of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.me.bar_code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #25:Ошибка добавления информации о товаре, если массив ID для удаления штрихкодов пуст, происходит... of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.me.bar_code' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by