JSqlParser supports SquareBracketQuotation in version 3.0 but I dont see in your plugin PaginationInterceptor. It's support special character as "[" for SQL Server. Please add the option in the next version. Thank you so much.
Comment From: miemieYaho
your mybatis-plus.version is ???
Comment From: thapld
I use mybatis-plus version 3.3.0. I have to rewrite:
Select selectStatement = (Select) CCJSqlParserUtil.parse(originalSql, parser -> parser.withSquareBracketQuotation(true));
Comment From: miemieYaho
https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-core/3.3.0 jsqlparser version is 3.1
Comment From: thapld
Yes, jsqlparser version 3.1, but It supports SquareBracketQuotation from version 3.0. I think you should support the option (SquareBracketQuotation) in your mybatis-plus plugin such as PaginationInterceptor, BlockAttackSqlParser...
Comment From: miemieYaho
only rewrite it, maybe can rewrite it more easily
Comment From: miemieYaho
use 3.3.2.1-SNAPSHOT and rewrite it
Comment From: thapld
Thank you so much!
On Fri, May 15, 2020 at 12:05 miemieYaho notifications@github.com wrote:
Closed #2174 https://github.com/baomidou/mybatis-plus/issues/2174.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/baomidou/mybatis-plus/issues/2174#event-3339364472, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJHRCP72E6EXHVWYESROHVTRRTESVANCNFSM4K5TA2BQ .
-- Thanks, Thapld