ERROR [http-nio-9999-exec-8] com.jsh.erp.service.material.MaterialService - 异常码[300],异常提示[数据查询异常],异常[{}]
org.springframework.jdbc.BadSqlGrammarException:

Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #25:系统管理→角色管理，新增角色后点击保存，新增的角色没有显示出来，预计能新增成功，且新增的角色显示在界面上。 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

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

The error may involve com.jsh.erp.datasource.mappers.MaterialMapperEx.selectByConditionMaterial-Inline

The error occurred while setting parameters

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 me.tenant_id = 63 AND m.id = me.material_id AND ifnull(me.delete_Flag, '0') != '1' LEFT JOIN jsh_unit u ON u.tenant_id = 63 AND m.unit_id = u.id AND ifnull(u.delete_Flag, '0') != '1' LEFT JOIN jsh_material_category mc ON mc.tenant_id = 63 AND m.category_id = mc.id AND ifnull(mc.delete_Flag, '0') != '1' WHERE m.tenant_id = 63 AND 1 = 1 AND ifnull(m.delete_flag, '0') != '1' GROUP BY m.id ORDER BY m.id DESC LIMIT ?, ?

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #25:系统管理→角色管理，新增角色后点击保存，新增的角色没有显示出来，预计能新增成功，且新增的角色显示在界面上。 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 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #25:系统管理→角色管理，新增角色后点击保存，新增的角色没有显示出来，预计能新增成功，且新增的角色显示在界面上。 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
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy91.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at com.baomidou.mybatisplus.core.override.PageMapperMethod.executeForMany(PageMapperMethod.java:173)
at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:86)
at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64)
at com.sun.proxy.$Proxy143.selectByConditionMaterial(Unknown Source)
at com.jsh.erp.service.material.MaterialService.select(MaterialService.java:133)
at com.jsh.erp.service.material.MaterialService$$FastClassBySpringCGLIB$$cd725707.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
at com.jsh.erp.service.material.MaterialService$$EnhancerBySpringCGLIB$$1578ed93.select()
at com.jsh.erp.service.material.MaterialComponent.getMaterialList(MaterialComponent.java:48)
at com.jsh.erp.service.material.MaterialComponent.select(MaterialComponent.java:31)
at com.jsh.erp.service.CommonQueryManager.select(CommonQueryManager.java:49)
at com.jsh.erp.service.CommonQueryManager$$FastClassBySpringCGLIB$$e1f1f1d0.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
at com.jsh.erp.service.CommonQueryManager$$EnhancerBySpringCGLIB$$8fa6438e.select()
at com.jsh.erp.controller.ResourceController.getList(ResourceController.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)