[GitHub] [shardingsphere] onevroad commented on issue #15975: Cannot select count in Oracle

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

onevroad commented on issue #15975:
URL: https://github.com/apache/shardingsphere/issues/15975#issuecomment-1076237081


   > 试试把配置的规则中表名配置为大写， `S_USER$->{Math.abs(loan_no.hashCode())` % 2} `ds0.S_USER$->{0..1}` 像这样，oracle中会有这个问题 rules: sharding: key-generators: snowflake: type: snowflake props: worker-id: 123
   > 
   > ```
   >             binding-tables:
   >                 - s_user
   >             sharding-algorithms:
   >                 sharding-user-by-loan-no:
   >                     props:
   >                         algorithm-expression: S_USER$->{Math.abs(loan_no.hashCode()) % 2}
   >                     type: inline
   >             tables:
   >                 s_user:
   >                     key-generate-strategy:
   >                         column: user_code
   >                         key-generator-name: snowflake
   >                     actual-data-nodes: ds0.S_USER$->{0..1}
   >                     table-strategy:
   >                         standard:
   >                             sharding-column: loan_no
   >                             sharding-algorithm-name: sharding-user-by-loan-no
   > ```
   
   yes, it's work, when I change the table name to uppercase in config.
   I find that the exception is only throw in order by or limit.


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