DistSQL about ENCRYPT RULE can not work, need recode

[hhw3KevinHou]

Bug Report

CREATE/alter/drop/show ENCRYPT RULE are all wrong output. Some result wrong, Some persist wrong. Author need recode DistSQL.

Which version of ShardingSphere did you use?

5.4.1 with Mysql repository.

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Expected behavior

Like SQL insert ,update ,delete behavior.

Actual behavior

CREATE/alter/drop/show ENCRYPT RULE are all wrong. Some result error, Some persist error. Author need recode DistSQL.

Metadata in memory and Mysql are not consist.

I have cost a whole week to confirm this.

[zhaojinchao95]

Can you describe your detail operation?

[hhw3KevinHou]

Can you describe your detail operation?

Create ENCRYPT RULE bug see https://github.com/apache/shardingsphere/issues/29431. Alter bug: alter a encrypte rule->restart->alter no effect. Drop bug: drop a rule -> show ENCRYPT RULE -> other rules are all dropped (reason is rules.removeIf(each -> each.getConfiguration().getClass().isAssignableFrom(ruleConfig.getClass()));)

[RaigorJiang]

@hhw3KevinHou Hi, are you test with standalone mode, and the persist repository is MySQL?

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.