Error querying database syntax error at or near “$1“

Error querying database syntax error at or near “$1”

查询数据库时出错 第1个参数附件语法错误

↵### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"↵ 位置：665 ↵### The error may exist in file [E:\demo\service\target\classes\\DemoMapper.xml] ↵### The error may involve defaultParameterMap ↵### The error occurred while setting parameters ↵### SQL: select id, name, sex, age from "TB1" where age between ? and ? and name = ? and sex ? ↵### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "$4"↵ 位置：665↵; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: syntax error at or near "$4"↵ 位置：665"

第1个参数附件语法错误 ，请检查第一个参数是有问题 mapper接口方法中是否传了该参数。