IS NOT NULL parse error

[luyf1030]

Please answer these questions before submitting your issue. Thanks!

2.0.0

查询条件中出现 is not null 的时候 用limit 0，1，应该最多只能查询一条记录

查询出来的不止一条记录

查询语句里面含有 is not null 判断 limit 0， 1

String sql = "select smUuid, customerId " +

                "from tbl_app_identify_batch_record t1 " +
                "where t1.deliverResult IS Not NULL and validateFlag in(1,2,4,5)  " +
                "and batchId != 0 limit 0, 1";

[terrymanu]

fixed at 2.0.2