[GitHub] [shardingsphere] LGHome commented on issue #18090: Cross schema query sql with 'order by' Error

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

LGHome commented on issue #18090:
URL: https://github.com/apache/shardingsphere/issues/18090#issuecomment-1174491149

   configuration:
   
   
   
   
   spring:
     shardingsphere:
       datasource:
         #数据源名称
         names: filedb,platformdb
         #数据源信息
         filedb:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.cj.jdbc.Driver
           jdbc-url: ${SPRING_DATASOURCE_URL:jdbc:mysql://xxx.xxx.xxx:3306/xxx_db?useUnicode=true&characterEncoding=utf-8&useSSL=false}
           username: ${SPRING_DATASOURCE_USERNAME:xxxx}
           password: ${SPRING_DATASOURCE_PASSWORD:xxxx}
           #数据库连接池的其它属性
           # 连接池最小空闲连接数
           minimum-idle: ${SPRING_DATASOURCE_MINIMUM_IDLE:20}
           # 连接池允许的最大连接数
           maximum-pool-size: ${SPRING_DATASOURCE_MAXIMUM_POOL_SIZE:200}
           # 等待连接池分配连接的最大时长（毫秒）
           connection-timeout: ${SPRING_DATASOURCE_CONNECTION_TIMEOUT:30000}
         #数据源信息
         platform:
           type: com.zaxxer.hikari.HikariDataSource
           driverClassName: com.mysql.cj.jdbc.Driver
           jdbc-url: ${SPRING_DATASOURCE_URL_PLATFORM:jdbc:mysql://xxxx.xxxx.xxxx:3306/xxxx_xxx_db?useUnicode=true&characterEncoding=utf-8&useSSL=false}
           username: ${SPRING_DATASOURCE_USERNAME:xxx}
           password: ${SPRING_DATASOURCE_PASSWORD:xxx}
           #数据库连接池的其它属性
           # 连接池最小空闲连接数
           minimum-idle: ${SPRING_DATASOURCE_MINIMUM_IDLE:20}
           # 连接池允许的最大连接数
           maximum-pool-size: ${SPRING_DATASOURCE_MAXIMUM_POOL_SIZE:200}
           # 等待连接池分配连接的最大时长（毫秒）
           connection-timeout: ${SPRING_DATASOURCE_CONNECTION_TIMEOUT:30000}
       rules:
         sharding:
           tables:
             xxxx_xxxx:
               actual-data-nodes: filedb.xxxx_xxxx$->{0..63}
               table-strategy:
                 hint:
                   sharding-algorithm-name: hfleFileHintShardingAlgorithm
       props:
         sql-show: true
         #支持跨库join查询
         sql-federation-enabled: true


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