public class UnionLimitTest extends BaseTest {
    @Autowired
    private StudentMapper mapper;

    @Test
    void unionAll() {
        IQuery query = StudentQuery.emptyQuery()
            .selectId()
            .where.id().lt(20).end()
            .limit(100)
            .unionAll(StudentQuery.emptyQuery()
                .select.id().end()
                .where.userName().endWith("2").end()
                .limit(50)
            );
        mapper.listObjs(query);
        db.sqlList().wantFirstSql().eq("" +
            "(SELECT `id` FROM fluent_mybatis.student WHERE `id` < ? LIMIT ?, ?) " +
            "UNION ALL " +
            "(SELECT `id` FROM fluent_mybatis.student WHERE `user_name` LIKE ? LIMIT ?, ?)", StringMode.SameAsSpace);
        db.sqlList().wantFirstPara().eqList(20, 0, 100, "%2", 0, 50);
    }
}