开启多租户插件后，列表查询会出现ParseException异常

### 错误表现
> Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "AND" "AND"
![输入图片说明](https://foruda.gitee.com/images/1695711017894339918/2ebc5ff4_87865.png "屏幕截图")
![输入图片说明](https://foruda.gitee.com/images/1695711041749426346/78e4170b_87865.png "屏幕截图")
### 复现步骤：
1. 开启多租户

```

@Configuration
public class MybatisPlusConfig {

/**
     * 分页插件
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        PaginationInnerInterceptor page = new PaginationInnerInterceptor(DbType.H2);
        page.setOptimizeJoin(false);
        //开启多租户
        interceptor.addInnerInterceptor(new TenantLineInnerInterceptor(new TenantLineHandler() {
            @Override
            public Expression getTenantId() {
                return new LongValue(1);
            }

@Override
            public String getTenantIdColumn() {
                return "create_by";
            }
        }));
        interceptor.addInnerInterceptor(page);
        interceptor.addInnerInterceptor(new SqlInterceptor());
        return interceptor;
    }
}
```

2. 查询

```
@Test
void testSelectJoinList() {
    MPJLambdaWrapper<UserDO> wrapper = new MPJLambdaWrapper<UserDO>()
            .eq(UserDO::getPid, 1);
    List<UserDTO> list = userMapper.selectJoinList(UserDTO.class, wrapper);
    // 也会异常
    // List<Map<String, Object>> list = userMapper.selectJoinMaps(wrapper);
    System.out.println(list);
}
```
3. 问题原因
经检查，是SQL语句中的换行符导致的。租户插件会去解析SQL，然后拼接租户过滤条件，在解析前替换掉`\n`，就不会报错了。

yulichang/mybatis-plus-join

内容风险标识

评论 (3)

yulichang/mybatis-plus-join .gitee-modal { width: 500px !important; }

内容风险标识