Sharding does not support configuring ActualDataNodes to ${01.. 02}. If I want to split the table by month, regardless of year, how should I configure it

[ThisOnly]

Bug Report

Configure the table according to the following diagram, but it cannot be successful. Why is it

For English only, other languages will not accept.

Before report a bug, make sure you have:

• Searched open and closed GitHub issues.
• Read documentation: ShardingSphere Doc.

Please pay attention on issues you submitted, because we maybe need more details.
If no response anymore and we cannot reproduce it on current information, we will close it.

Please answer these questions before submitting your issue. Thanks!

Which version of ShardingSphere did you use?

5.1.2

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

ShardingSphere-Proxy

Expected behavior

The above configuration can be executed correctly

Actual behavior

error

Reason analyze (If you can)

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

Example codes for reproduce this issue (such as a github link).

[linghengqian]

• In fact you can use Groovy Shell to verify, I think you want to use 0${1..2} instead of ${01..02}.

• For the second question, there is actually no need to consider Groovy syntax. You can directly dynamically modify the actualDataNodes through DistSQL, or take out the ContextManager and modify it manually.

• I think you can wait for Make actualDataNodes expose SPI that can define expression with custom rules and add GraalVM Truffle implementation #22899 to be closed, I have a batch of unmerged PRs working on this issue. Once Make actualDataNodes expose SPI that can define expression with custom rules and add GraalVM Truffle implementation #22899 is closed, the configuration of this expression can be customized via SPI.

[linghengqian]

• The new SPI was introduced in the related PR at Make actualDataNodes expose SPI that can define expression with custom rules and add GraalVM Truffle implementation #22899 , this issue can now define List<String> via an new Row Value Expression SPI implementation.

[KeZhimin]

ds_0.t_user_$->{2023..2050}$->{(1..12).collect{t ->t.toString().padLeft(2,'0')}}