[GitHub] [shardingsphere] pcyan commented on issue #17477: sharding-jdbc: Oracle pagination query error

[GitBox <gi...@apache.org>]

pcyan commented on issue #17477:
URL: https://github.com/apache/shardingsphere/issues/17477#issuecomment-1124709782

   > Hi @pcyan, thank you for your feedback. Can you provide your sharding configuration and create table statement?
   
   @strongduanmu exception occurred while parsing sql, not about the configuration or create table statement。just use the case below and you will get ClassCastException
   ```
   def pagination_sql4 = """
       select * from (
       select t1."num",rownum as "rownum_" from(
           select 'a'  as "num" from dual)t1)
       where t2."rownum_" > ? and t2."rownum_" <= (?+?)
   """
   ```
   
   seems that shardingSphere cannot deal with common expression while pagination
   


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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