数据库错误Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "WHERE"

作者：花生_TL007 | 2024-04-29 13:18:48

踩

syntax error at or near "where

### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "WHERE"

位置：81

### The error may exist in class path resource [mybatis/mapper/Changes.xml]

### The error may involve com.huawei.promethues.demo.dao.ChangesDao.selectChangeCount-Inline

### The error occurred while setting parameters

### SQL: SELECT DISTINCT count(*) FROM SUB_CHANGE_ORDER_DO where STATUS !='ready' WHERE GMT_CREATED>=? and and GMT_CREATED <= ? AND CHANGE_ORDER_TYPE=?

### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "WHERE"

位置：81

; bad SQL grammar []

错误原因：语法错误，<sql></sql>标签中的<where></where>标签自带where，因此不需要再自己写where

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/507960