You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/12/30 03:23:11 UTC

[GitHub] [shardingsphere] lostnana opened a new issue #8819: SQL parsing error

lostnana opened a new issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819


   ## Bug Report
   When I execute this SQL
   `
   select
       <include refid="Base_Column_List"/>
         from t_refund_apply_log
         where id in (
         select MAX(id) from t_refund_apply_log where
         refund_item_id IN (
            <foreach collection="refundItemIds" separator="," item="refundItemId">#{refundItemId}</foreach>
         )
         group by refund_id,`operate_type`,refund_item_id
       )
       order by `id` desc
   `
   throw Exception
   `Caused by: io.shardingsphere.core.parsing.parser.exception.SQLParsingException: SQL syntax error, expected token is 'RIGHT_PAREN', actual token is 'MAX', literals is 'MAX'.
   `
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu closed issue #8819: SQL parsing error

Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu commented on issue #8819: SQL parsing error

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819#issuecomment-752815799


   @lostnana Can you use `5.0.0-alpha`?   it is ok.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] jingshanglu commented on issue #8819: SQL parsing error

Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819#issuecomment-752317737


   @lostnana  Which version you use? can you show the sql that can run in mysql or others?


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] terrymanu commented on issue #8819: SQL parsing error

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819#issuecomment-761764472


   Closed because of no response.


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] lostnana commented on issue #8819: SQL parsing error

Posted by GitBox <gi...@apache.org>.
lostnana commented on issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819#issuecomment-752344940


   then version is 3.0.0 ,it can be executed normally in mysql


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] lostnana commented on issue #8819: SQL parsing error

Posted by GitBox <gi...@apache.org>.
lostnana commented on issue #8819:
URL: https://github.com/apache/shardingsphere/issues/8819#issuecomment-752821713


   Ok, I'll try it，thanks!


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org