taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster St an da lo ne r e p o s i t o r y Pe rsistRe positor yConfig uration Persist CacheOption Attributes: 9.1. ShardingSphere-JDBC 114 Apache ShardingSphere document na me • D a t a T y p e * Des cription Default Value ini tia lCa pac ity i n t Initial capacity of local cache parser Docker Engine to execute testcontainers-java related unit tests. sudo apt install unzip zip curl sed -y curl -s "https://get.sdkman.io" | bash source "$HOME/.sdkman/bin/sdkman-init.sh" sdk install java

ld no de na me E p h e m e r a l n o d e Description el ec ti on :r aw ‐l at ex :ˋ i ns ta nc eˋ Y E S The IP address of the mas‐ ter node server.Once the node is deleted, a re‐election will be triggered the master nodeUsed for dis‐ tributed locks of curator s ha rd in g: ra w‐ la te x: ne ce ss ar y N O The flag for re‐sharding. If the total number of shards changes, or the job server node goes sharding will not be triggered when the job is executed sh ar di ng :r aw ‐l at ex :ˋ p ro ce ss in gˋ Y E S The node held by the master node during sharding.If there is this node, all job execution will

taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster St an da lo ne r e p o s i t o r y Pe rsistRe positor yConfig uration Persist Configuration Class：org.apache.shardingsphere.sql.parser.api.CacheOption Attributes: na me • D a t a T y p e * Des cription Default Value ini tia lCa pac ity i n t Initial capacity of local cache parser 9.1. ShardingSphere-JDBC 160 Apache ShardingSphere document sudo apt install unzip zip curl sed -y curl -s "https://get.sdkman.io" | bash source "$HOME/.sdkman/bin/sdkman-init.sh" sdk install java

nativeTest。 你必须安装 Docker Engine 以执行 testcontainers-java 相关的单元测试。 sudo apt install unzip zip curl sed -y curl -s "https://get.sdkman.io" | bash source "$HOME/.sdkman/bin/sdkman-init.sh" sdk install java 0.9-graalce sdk use java 17.0.9-graalce sudo apt-get install build-essential libz-dev zlib1g-dev -y git clone git@github.com:apache/shardingsphere.git 9.1. ShardingSphere-JDBC 128 Apache ShardingSphere Metadata 时，应 当在 h t t p s : / / g i t h u b . c o m / o r a c l e / g r a a l v m‐ r e a c h a b i l i t y‐ m e t a d a t a 打开新的 is‐ sue，并提交包含依赖的第三方库缺失的 GraalVM Reachability Metadata 的 PR。ShardingSphere 在

taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster St an da lo ne r e p o s i t o r y Pe rsistRe positor yConfig uration Persist strategy.DynamicReadwriteSplittingStrategyConfiguration Configurable Properties: Name • D a t a T y p e * Description De fault V alue aut oAwareData SourceName S t r i n g Database discovery logic Configuration Class：org.apache.shardingsphere.sql.parser.api.CacheOption Attributes: na me • D a t a T y p e * Des cription Default Value ini tia lCa pac ity i n t Initial capacity of local cache parser

创建数据脱敏规则 CREATE MASK RULE t_mask ( COLUMNS( (NAME=phone_number,TYPE(NAME='MASK_FROM_X_TO_Y', PROPERTIES("from-x"=1, "to-y"=2, "replace-char"="*"))), (NAME=address,TYPE(NAME='MD5')) )); 使用 ifNotExists 子句创建数据脱敏规则 RULE IF NOT EXISTS t_mask ( COLUMNS( (NAME=phone_number,TYPE(NAME='MASK_FROM_X_TO_Y', PROPERTIES("from-x"=1, "to-y"=2, "replace-char"="*"))), (NAME=address,TYPE(NAME='MD5')) )); 9.2. ShardingSphere-Proxy 修改数据脱敏规则 ALTER MASK RULE t_mask ( COLUMNS( (NAME=phone_number,TYPE(NAME='MASK_FROM_X_TO_Y', PROPERTIES("from-x"=1, "to-y"=2, "replace-char"="*"))), (NAME=address,TYPE(NAME='MD5')) )); 保留字 ALTER、MASK、

taType Description D ef au lt Va lu e t y p e String Type of mode configu‐ rationValues could be: Standalone or Cluster St an da lo ne r e p o s i t o r y Pe rsistRe positor yConfig uration Persist strategy.DynamicReadwriteSplittingStrategyConfiguration Configurable Properties: Name • D a t a T y p e * Description De fault V alue aut oAwareData SourceName S t r i n g Database discovery logic Attributes: 4.1. ShardingSphere-JDBC 105 Apache ShardingSphere document, v5.2.0 na me • D a t a T y p e * Des cription Default Value ini tia lCa pac ity i n t Initial capacity of local cache parser

nativeTest。 你必须安装 Docker Engine 以执行 testcontainers-java 相关的单元测试。 sudo apt install unzip zip curl sed -y curl -s "https://get.sdkman.io" | bash source "$HOME/.sdkman/bin/sdkman-init.sh" sdk install java java 22.0.1-graalce sdk use java 22.0.1-graalce sudo apt-get install build-essential zlib1g-dev -y git clone git@github.com:apache/shardingsphere.git cd ./shardingsphere/ ./mvnw -PnativeTestInShardingSphere Metadata 时，应 当在 h t t p s : / / g i t h u b . c o m / o r a c l e / g r a a l v m‐ r e a c h a b i l i t y‐ m e t a d a t a 打开新的 is‐ sue，并提交包含依赖的第三方库缺失的 GraalVM Reachability Metadata 的 PR。ShardingSphere 在

INSERT SQL Supp orted INSERT INTO table (column,⋯) VALUES (value,⋯) Y INSERT INTO table (column,⋯) VALUES (value,⋯),(value,⋯),⋯ Y INSERT INTO table (column,⋯) SELECT column1 from table1 where column1 WHERE column = value Y LIKE/NOT LIKE SELECT/UPDATE/DELETE ⋯ WHERE column LIKE/NOT LIKE value Y IN/NOT IN SELECT/UPDATE/DELETE ⋯ WHERE column IN/NOT IN (value1,value2,⋯) Y BETWEEN SELECT/UPDATE/DELETE Description • D e f a u l t V a l u e * t y p e S tring Type of mode configu‐ rationValues could be: Memory, Standalone, Cluster M e m o r y r e p o s i t o r y Persi stRep osito ryCon figur ation Persist

INSERT SQL Supp orted INSERT INTO table (column,⋯) VALUES (value,⋯) Y INSERT INTO table (column,⋯) VALUES (value,⋯),(value,⋯),⋯ Y INSERT INTO table (column,⋯) SELECT column1 from table1 where column1 WHERE column = value Y LIKE/NOT LIKE SELECT/UPDATE/DELETE ⋯ WHERE column LIKE/NOT LIKE value Y IN/NOT IN SELECT/UPDATE/DELETE ⋯ WHERE column IN/NOT IN (value1,value2,⋯) Y BETWEEN SELECT/UPDATE/DELETE Description • D e f a u l t V a l u e * t y p e S tring Type of mode configu‐ rationValues could be: Memory, Standalone, Cluster M e m o r y r e p o s i t o r y Persi stRep osito ryCon figur ation Persist