Closed t375152973 closed 1 year ago
Greetings.
Your statement works with JSQLParser 4.7 Snapshot and you can try it online here.
Regarding MyBatis, please be aware that 2 empty lines \n\n
terminate a statement.
but how do i get 4.7-SNAPSHOT version by maven?
Please see https://manticore-projects.com/JSQLParser/usage.html#build-dependencies
However, latest Commit have not been deployed to Sonatype yet so download the Jar or Installing to Maven Local may be your best bet.
ok.i will try 4.7-SNAPSHOT version. by the way, thank you very much
Please see https://manticore-projects.com/JSQLParser/usage.html#build-dependencies
However, latest Commit have not been deployed to Sonatype yet so download the Jar or Installing to Maven Local may be your best bet.
sorry..a new question. i use jsqlparser because used 'mybatis-plus' plugins. it only supperted jsqlparser lower than 4.6 version,because PaginationInnerInterceptor will use SelectExpressionItem. i can't find SelectExpressionItem in 4.7-SNAPSHOT version.
Changes for the upcoming 5.0 (which will be derived from 4.7 Snapshot) are explained here: https://manticore-projects.com/JSQLParser/migration.html
I can't help you with MyBatis Plus, you will need to contact them directly please.
Closing, since no further questions has been asked.
Failing SQL Feature:
can not parser the sql.maybe caused by 'LENGTH()' or 'CONVERT' function in 'order by'
SQL Example:
Software Information:
ERROR info:
[ERROR][2023-07-19 14:15:58:928] [szwa-business,10931121eb3d4cfd,10931121eb3d4cfd,] [http-nio-9192-exec-1-com.hrx.szwa.common.aspect.RestControllerAspect--124 line] - org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNamesCause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNamesorg.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNamesCause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNamesCaused by: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNamesCause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNamesCaused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Failed to process, Error SQL: SELECT b.*,GROUP_CONCAT(g.
groupName
) AS groupNames FROMtable1
b LEFT JOINtable1_map
m ON m.contactId
=b.id
LEFT JOINtable1_group
g ON g.id
= m.groupId
WHERE b.isDelete
!= '1'Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," at line 11, column 38.
Was expecting one of:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," "," at line 11, column 38.
Was expecting one of: