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/03/13 06:40:44 UTC

[GitHub] [incubator-shardingsphere] wgy8283335 removed a comment on issue #4665: order by not support string column when query more than one database

wgy8283335 removed a comment on issue #4665: order by not support string column when query more than one database
URL: https://github.com/apache/incubator-shardingsphere/issues/4665#issuecomment-598574794
 
 
   @xiaoxiong581 
   ```
   schemaName: databasemanager
   
   dataSources:
     ds_0:
       url: jdbc:mysql://192.168.137.102:3306/databasemanager?serverTimezone=UTC&useSSL=false
       username: root
       password: xxxxx
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
     ds_1:
       url: jdbc:mysql://192.168.137.102:3307/databasemanager?serverTimezone=UTC&useSSL=false
       username: root
       password: xxxx
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
   
   shardingRule:
     tables:
       t_cluster:
         actualDataNodes: ds_${0..1}.t_cluster
         tableStrategy:
           none:
         databaseStrategy:
           inline:
             shardingColumn: clusterId
             algorithmExpression: ds_${clusterId.hashCode().abs() % 2}
       t_cluster_instance:
         actualDataNodes: ds_${0..1}.t_cluster_instance
         tableStrategy:
           none:
         databaseStrategy:
           inline:
             shardingColumn: clusterId
             algorithmExpression: ds_${clusterId.hashCode().abs() % 2}
     bindingTables:
       - t_cluster,t_cluster_instance
     defaultDatabaseStrategy:
       none:
     defaultTableStrategy:
       none:
   ```
   
   

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


With regards,
Apache Git Services