[SPARK-46998] Deprecate `spark.sql.legacy.allowZeroIndexInFormatString`

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 07/Feb/24 09:39
• Updated: 02/Oct/24 05:03
• Resolved: 08/Feb/24 02:20

Description

The SQL config spark.sql.legacy.allowZeroIndexInFormatString doesn't allow to use the zero index. Even set it to true, users get the error:

> select format_string('%0$s', 'Hello');

Illegal format argument index = 0
java.util.IllegalFormatArgumentIndexException: Illegal format argument index = 0
	at java.base/java.util.Formatter$FormatSpecifier.index(Formatter.java:2808)
	at java.base/java.util.Formatter$FormatSpecifier.<init>(Formatter.java:2879)

Issue Links

• links to: GitHub Pull Request #45057