Upgrade Groovy to support using Lambda in row expressions

[linghengqian]

Feature Request

For English only, other languages will not accept.

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

Please answer these questions before submitting your issue. Thanks!

Is your feature request related to a problem?

Maybe related to #13240 .

Describe the feature you would like.

I would like to upgrade the version of org.codehaus.groovy:groovy to 3.0.9 or higher to support in actual-data-nodes or algorithm-expression in the usage scenario of the equal-line expression, the Lambda syntax of Java 8 is used. As stated in http://groovy-lang.org/releasenotes/groovy-3.0.html , after groovy 3, use stream() Functional writing provides support.

In the current version of ShardingSphere( 5.1.0 ), it is not easy to customize actualDataNodes. Taking time slicing as an example, you may write something like ds$->{0..1}.t_order_$->{2021..2022}${(1..12).collect{t ->t.toString().padLeft(2,'0')} } sentence, if you build some tables by day, you must use JAVA API dealing with things like leap years, and in non-Java environments, the process of configuring the ShardingSphere Proxy is not straightforward. I believe the Groovy version that supports Lambda simplifies the process.

An additional consideration is that org.apache.groovy:groovy:4.0.0 has improved support for JPMS ( as stated in http://groovy-lang.org/releasenotes/groovy-4.0.html ), which helps to deal with the issues in #13080 mentioned issues. But currently Groovy 4.0.0 does not support Grails (introduced in grails/grails-core#12373), skipping Groovy 3.x may cause additional impact.

[linghengqian]

I'm not sure if ShardingSphere has a child component that uses Java 7, and if it does, it clearly shouldn't be upgraded to Groovy V3.

[terrymanu]

ShardingSphere just for jdk 1.8 and above

[terrymanu]

maybe we can try to upgrade groovy version，this is so cool

[linghengqian]

I submitted a PR to deal with this issue, not sure if it will affect some untested components of a series of projects in ShardingSphere Example, maybe I'll have to wait for more responses.

[linghengqian]

Only provide tips for some friends who need them. SpringBoot will increase Groovy to 4.0.0 in 3.x, and 2.x will not be changed. Refer to spring-projects/spring-boot#30278