. 46 Cipher column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Query assistant column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Plain column Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360 7.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360 7.4.7 Parse Engine not continuous 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, >, <, >=, <=)? . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . 48 Assisted query column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Like query column . . . . . . . . . . . . . . . . . . . . . . . . Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499 12.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499 12.4.7 Parse Engine not continuous and most of them end with even numbers? . . 551 13.4.7 Sharding How to allow range query with using inline sharding strategy (BE‐ TWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . .

. 45 Cipher column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Query assistant column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Plain column Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387 7.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387 7.4.7 Parse Engine not continuous 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, >, <, >=, <=)? . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . 48 Assisted query column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Like query column . . . . . . . . . . . . . . . . . . . . . . . . Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 528 12.4.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 528 12.4.7 Parse Engine not continuous and most of them end with even numbers? . . 579 13.3.7 Sharding How to allow range query with using inline sharding strategy (BE‐ TWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . .

22 SQL Parsing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 SQL Route . BASE transaction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 3.3 Replica query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 3.3.1 Background metadata loading when service starts up? . . . . . . . . . . . . . . 300 7.19 How to allow range query with using inline sharding strategy(BETWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . . .

. 62 Cipher Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 Query Assistant Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 Plain Column . Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 7.1.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 7.1.7 Parse Engine . . . . . . . . . . . . . . . . . . . . . . . . . 306 7.7.13 13. [Sharding] How to allow range query with using inline sharding strat‐ egy(BETWEEN AND, >, <, >=, <=)? . . . . . . . . . . . . . . .

. 59 Cipher Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Query Assistant Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Plain Column . Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 7.2.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 7.2.7 Parse Engine not continuous and 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, >, <, >=, <=)? . . . . . . . . . . . . . . .

. 61 Cipher Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Query Assistant Column . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61 Plain Column . Result Merger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 7.2.6 Query Optimization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 7.2.7 Parse Engine not continuous and 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, >, <, >=, <=)? . . . . . . . . . . . . . . .

encryptorName: aes_encryptor assistedQuery: name: assisted_query_username encryptorName: assisted_encryptor likeQuery: name: like_query_username encryptorName: like_encryptor pwd: cipher: name: aes_encryptor 9.1. ShardingSphere-JDBC 65 Apache ShardingSphere document assistedQuery: name: assisted_query_pwd encryptorName: assisted_encryptor encryptors: aes_encryptor: type: AES props: aes-key-value: encryptorName: aes_encryptor assistedQueryColumn: assisted_query_username assistedQueryEncryptorName: assisted_encryptor likeQueryColumn: like_query_username likeQueryEncryptorName: like_encryptor pwd:

encryptorName: aes_encryptor assistedQuery: name: assisted_query_username encryptorName: assisted_encryptor likeQuery: name: like_query_username encryptorName: like_encryptor pwd: cipher: name: aes_encryptor 9.1. ShardingSphere-JDBC 66 Apache ShardingSphere document assistedQuery: name: assisted_query_pwd encryptorName: assisted_encryptor encryptors: aes_encryptor: type: AES props: aes-key-value: encryptorName: aes_encryptor assistedQuery: name: assisted_query_user encryptorName: assisted_encryptor likeQuery: name: like_query_user encryptorName: like_encryptor order_id: cipher: name: