[GitHub] [shardingsphere] cilfm commented on issue #10126: sqlserver row_number() over() faild，Error preparing statement. Cause: org.antlr.v4.runtime.misc.ParseCancellationException

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

cilfm commented on issue #10126:
URL: https://github.com/apache/shardingsphere/issues/10126#issuecomment-822207965


   the image is  the block of shardingsphere in application.yml file
     shardingsphere:
       props:
         sql-show: true
       datasource:
         common:
           type: com.alibaba.druid.pool.DruidDataSource
           driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
           validationQuery: SELECT 1
         names: ds0
       rules:
         sharding:
           tables:
             SMZ_ACCESSRECORD:
               actual-data-nodes: ds0.SMZ_ACCESSRECORD_$->{0..19}
               table-strategy:
                 standard:
                   sharding-column: ID
                   sharding-algorithm-name: table-inline-smz-accessrecord
               key-generate-strategy:
                 column: ID
                 key-generator-name: snowflake
           sharding-algorithms:
             table-inline-smz-accessrecord:
               type: INLINE
               props:
                 algorithm-expression: SMZ_ACCESSRECORD_$->{ID % 20}
           key-generators:
             snowflake:
               type: SNOWFLAKE
               props:
                 worker-id: 123


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