Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1:部分单据输入未选择下拉框，会出现报错 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.jsh_material_extend.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The error may exist in class path resource [mapper_xml/MaterialExtendMapperEx.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT id, material_id, bar_code, commodity_unit, purchase_decimal, commodity_decimal, wholesale_decimal, low_decimal, default_flag, create_time, create_serial, update_serial, update_time, tenant_id, delete_Flag FROM jsh_material_extend WHERE jsh_material_extend.tenant_id = 63 AND 1 = 1 AND ifnull(delete_Flag, '0') != '1' AND material_id IN (?, ?, ?, ?, ?, ?, ?) GROUP BY material_id

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1:部分单据输入未选择下拉框，会出现报错 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jsh_erp.jsh_material_extend.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by