MyBatis-plus 使用Select 注解进行自定义SQL 查询 报错Error querying database. Cause: java.sql.SQLSyntaxErrorExcept

报错信息：

Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 10' at line 29
### The error may exist in com/mall/Mapper/UserNeedMapper.java (best guess)
### The error may involve com.mall.Mapper.UserNeedMapper.getUserProductNeedList-Inline
### The error occurred while setting parameters
### SQL: SELECT      n.id AS n_id,     n.user_id,      n.product_id,      n.text,      n.update_time,     u.id AS u_id,      u.openid,      u.unionid,     u.nick_name,     u.avatar_url,     u.gender,     u.city,     u.register_time,     p.id AS p_id,      p.name,      p.description,     p.image,     p.price,     p.stock,     p.categories,     p.member_price,     p.tag FROM      `user_need` AS n JOIN      `user` AS u ON u.id = n.user_id JOIN      `product` AS p ON p.id = n.product_id; LIMIT ?
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 10' at line 29

这个保持错很明显是sql 错误
我们把sql 提出来在 Sql 工具中进行查询

并没有任何问题啊？

还原一下场景

Mapper 配置

 @Select("SELECT \n" +
            "    n.id AS n_id,\n" +
            "    n.user_id, \n" +
            "    n.product_id, \n" +
            "    n.text, \n" +
            "    n.update_time,\n" +
            "    u.id AS u_id, \n" +
            "    u.openid, \n" +
            "    u.unionid,\n" +
            "    u.nick_name,\n" +
            "    u.avatar_url,\n" +
            "    u.gender,\n" +
            "    u.city,\n" +
            "    u.register_time,\n" +
            "    p.id AS p_id, \n" +
            "    p.name, \n" +
            "    p.description,\n" +
            "    p.image,\n" +
            "    p.price,\n" +
            "    p.stock,\n" +
            "    p.categories,\n" +
            "    p.member_price,\n" +
            "    p.tag\n" +
            "FROM \n" +
            "    `user_need` AS n\n" +
            "JOIN \n" +
            "    `user` AS u ON u.id = n.user_id\n" +
            "JOIN \n" +
            "    `product` AS p ON p.id = n.product_id;")
    IPage<UserProductNeedVo> getUserProductNeedList(Page<UserProductNeedVo> page);

service 实现

@Autowired
    UserNeedMapper userNeedMapper;
    public IPage<UserProductNeedVo> getUserProductNeedPage(int current, int size) {
        // 创建分页对象
        Page<UserProductNeedVo> page = new Page<>(current, size);

        // 调用分页查询
        return userNeedMapper.getUserProductNeedList(page);
    }

控制器

    @RequestMapping("/getUserProductNeed")
    public ResponseResult getUserProductNeed(@RequestParam int page,@RequestParam int limit) {
        IPage<UserProductNeedVo> productNeedPage = userNeedService.getUserProductNeedPage(page, limit);
        return ResponseResult.success(productNeedPage);
    }

百度加gpt 一番后无果

结论

直接说结论吧

眼尖的小伙伴应该已经发现了，这个有一个;号，它在sql 中代表该语句已经结束了