本地docker启动,在集合和计划执行的时候报错,有没有人遇到过,已经修改过
<ol role="group" style="min-width: 0px; min-height: 0px; list-style-type: none; padding-left: 12px; color: rgb(32, 33, 36); font-family: consolas, "lucida console", "courier new", monospace; font-size: 12px; white-space-collapse: preserve;"><li role="treeitem" tabindex="0" aria-selected="true" style="min-width: 0px; min-height: 16px; outline-width: 0px; text-overflow: ellipsis; white-space: nowrap; position: relative; display: flex; align-items: center; user-select: text;"><span style="min-width: 0px; min-height: 0px; overflow: hidden; line-height: 16px; display: flex;"><span title="
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by
### The error may exist in com/autotest/LiuMa/database/mapper/CollectionCaseMapper.xml
### The error may involve com.autotest.LiuMa.database.mapper.CollectionCaseMapper.getCollectionCaseCountByType-Inline
### The error occurred while setting parameters
### SQL: select c.`type` as type, count(*) as count from collection_case cc left join `case` c on c.id=cc.case_id where cc.collection_id = ?
### Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by" style="min-width: 0px; min-height: 0px; white-space-collapse: preserve; unicode-bidi: -webkit-isolate; color: var(--color-syntax-1);"><p>{<br> "status": 5000,<br> "message": "未知错误",<br> "data": "\n### Error querying database. Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by\n### The error may exist in com/autotest/LiuMa/database/mapper/PlanCollectionMapper.xml\n### The error may involve com.autotest.LiuMa.database.mapper.PlanCollectionMapper.getPlanCaseCountByType-Inline\n### The error occurred while setting parameters\n### SQL: select c.`type` as type, count(cc.id) as count from collection_case cc left join `case` c on c.id=cc.case_id left join plan_collection pc on pc.collection_id = cc.collection_id where pc.plan_id = ?\n### Cause: java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'liuma.c.type'; this is incompatible with sql_mode=only_full_group_by"<br>}</p></span></span></li><li role="treeitem" tabindex="0" aria-selected="true" style="min-width: 0px; min-height: 16px; outline-width: 0px; text-overflow: ellipsis; white-space: nowrap; position: relative; display: flex; align-items: center; user-select: text;"><p><br></p></li></ol>
收藏(0)
分享
相关标签:
注意:本文归作者所有,未经作者允许,不得转载