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接口方法中是否传了该参数。