[CALCITE-6416] Remove unnecessary SUBSTRING rewrite in SparkSqlDialect

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.37.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: xiong duan
• Reporter: xiong duan
• Created: 23/May/24 06:05
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

SparkSqlDialect have a unnecessary rewrite about SUBSTRING func.

In CALCITE-3247, We handle the SUBSTRING rewrite in HiveSqlDialect.

In CALCITE-3072, We handle the SUBSTRING rewrite in SparkSqlDialect.

In CALCITE-5677, We refactor the SUBSTRING as the default behaviour and remove the SUBSTRING rewrite in HiveSqlDialect. This PR will remove the Spark.

Issue Links

• links to: GitHub Pull Request #3796