29 Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Distributed . . . . . . . . . . . 360 7.8.9 [Sharding] Why does float number appear in the return result of inline expression?360 7.8.10 [Sharding] If sharding database is partial, should tables without sharding most of them end with even numbers? . 361 7.8.14 [Sharding] How to allow range query with using inline sharding strat‐ egy(BETWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . . . . . . . . . .

29 Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Distributed . . . . . . . . . . . 348 7.8.9 [Sharding] Why does float number appear in the return result of inline expression?348 7.8.10 [Sharding] If sharding database is partial, should tables without sharding most of them end with even numbers? . 349 7.8.14 [Sharding] How to allow range query with using inline sharding strat‐ egy(BETWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . . . . . . . . . .

13 Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Distributed placeholder ⋯in string value ⋯ error? 294 7.5 Why does float number appear in the return result of inline expression? . . . . . . . . . 294 7.6 If sharding database is partial, should tables without sharding when service starts up? . . . . . . . . . . . . . . 300 7.19 How to allow range query with using inline sharding strategy(BETWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . . . . . . . . . . .

285 7.4 Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . . . . . . . . . . . 285 7.5 inline 表达式返回结果为何出现浮点数？ . . . . . . . . . . . . . . . . . . . . . . . . . . 285 7.6 如果只有部分数据库分库分表，是否需要将不分库分表的表也配置在分片规则中？ 290 7.18 服务启动时如何加快 metadata 加载速度？ . . . . . . . . . . . . . . . . . . . . . . . . 290 7.19 如何在 inline 分表策略时，允许执行范围查询操作（BETWEEN AND、>、<、>=、<=）？ 290 7.20 为什么配置了某个数据连接池的 spring‐boot‐starter（比如 druid）和 .1} tableStrategy: standard: shardingColumn: account_id shardingAlgorithmName: account_table_inline keyGenerateStrategy: column: account_id keyGeneratorName: snowflake t_account_detail: actualDataNodes:

. . . . . . . . . . . . 457 8.3.2 Sharding Why does float number appear in the return result of inline expression?457 8.3.3 Sharding If sharding database is partial, should tables without sharding database and most of them end with even numbers? . . 458 8.3.7 Sharding How to allow range query with using inline sharding strategy (BE‐ TWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . . . . . . . . . Logic table name actualDataNodes (?): # Describe data source names and actual tables (refer to Inline syntax rules) databaseStrategy (?): # Databases sharding strategy, use default databases sharding

25 Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 Inline Expression . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Distributed . . . . . . . . . 305 7.7.9 9. [Sharding] Why does float number appear in the return result of inline ex‐ pression? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 306 . . . . . . . . . . . . . . . . . 306 7.7.13 13. [Sharding] How to allow range query with using inline sharding strat‐ egy(BETWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . 496 8.3.2 Sharding Why does float number appear in the return result of inline expression?496 8.3.3 Sharding If sharding database is partial, should tables without sharding database and most of them end with even numbers? . . 497 8.3.7 Sharding How to allow range query with using inline sharding strategy (BE‐ TWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . . . . . . . . . Logic table name actualDataNodes (?): # Describe data source names and actual tables (refer to Inline syntax rules) databaseStrategy (?): # Databases sharding strategy, use default databases sharding

. . 423 8.3.1 分片 Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . . . 423 8.3.2 分片 inline 表达式返回结果为何出现浮点数？ . . . . . . . . . . . . . . . . . . . 424 8.3.3 分片如果只有部分数据库分库分表，是否需要将不分库分表的表也配置在分片规 大多为偶数？ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 424 8.3.7 分片如何在 inline 分表策略时，允许执行范围查询操作（BETWEEN AND、>、<、 >=、<=）？ . . . . . . . . . . . . . . . . . . . . . . . . . . . SHARDING tables: # 数据分片规则配置 (+): # 逻辑表名称 actualDataNodes (?): # 由数据源名 + 表名组成（参考 Inline 语法规则） databaseStrategy (?): # 分库策略，缺省表示使用默认分库策略，以下的分片策略只能选其一 standard: # 用于单分片键的标准分片场景 shardingColumn:

290 7.7.8 8. [分片] Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . 290 7.7.9 9. [分片] inline 表达式返回结果为何出现浮点数？ . . . . . . . . . . . . . . . . . 290 7.7.10 10. [分片] 如果只有部分数据库分库分表，是否需要将不分库分表的表也配置在分 尾数大多为偶数？ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 291 7.7.13 13. [分片] 如何在 inline 分表策略时，允许执行范围查询操作（BETWEEN AND、 >、<、>=、<=）？ . . . . . . . . . . . . . . . . . . . . . . . . . . . shardingRuleConfig.getShardingAlgorithms().put("dbShardingAlgorithm", new ShardingSphereAlgorithmConfiguration("INLINE", dbShardingAlgorithmrProps)); // 配置分表算法 Properties tableShardingAlgorithmrProps = new Properties();

317 7.8.8 [分片] Cloud not resolve placeholder ⋯in string value ⋯异常的解决方法? . . . . 318 7.8.9 [分片] inline 表达式返回结果为何出现浮点数？ . . . . . . . . . . . . . . . . . . 318 7.8.10 [分片] 如果只有部分数据库分库分表，是否需要将不分库分表的表也配置在分片 数大多为偶数？ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 319 7.8.14 [分片] 如何在 inline 分表策略时，允许执行范围查询操作（BETWEEN AND、>、 <、>=、<=）？ . . . . . . . . . . . . . . . . . . . . . . . . . . . getShardingAlgorithms().putIfAbsent( "tOrderInlineShardingAlgorithm", new ShardingSphereAlgorithmConfiguration("INLINE", tOrderShardingInlineProps)); ShardingTableRuleConfiguration tOrderItemRuleConfiguration = new