[SPARK-41047] Remove legacy example of round function with negative scale

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 3.2.2
• Fix Version/s: 3.4.0
• Component/s: Documentation, SQL
• Assignee: Pan Bingkun
• Reporter: liyang
• Created: 08/Nov/22 09:58
• Updated: 11/Jan/23 22:40
• Resolved: 11/Jan/23 22:39

Description

Run this sql in spark-sql: select round(1.233, -1);
Error: org.apache.spark.sql.AnalysisException: Negative scale is not allowed: -1. You can use spark.sql.legacy.allowNegativeScaleOfDecimal=true to enable legacy mode to allow it.;

But the document of round function implies that negative scale argument is allowed.

Issue Links

• links to: [Github] Pull Request #39510 (panbingkun)
• links to: [Github] Pull Request #39511 (panbingkun)
• links to: [Github] Pull Request #39511 (panbingkun)