[SPARK-44444] Use ANSI SQL mode by default

• 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: Dongjoon Hyun
• Reporter: Yuming Wang
• Created: 15/Jul/23 10:00
• Updated: 19/Apr/24 03:21
• Resolved: 17/Apr/24 08:20

Description

To avoid data issue.

Issue Links

• is related to: SPARK-47905 ANSI Mode: Trim binary values shall result binary type instead of string type
• relates to: SPARK-41794 Reenable ANSI mode in pyspark.sql.tests.connect.test_connect_column
• relates to: SPARK-41547 Reenable ANSI mode in pyspark.sql.tests.connect.test_connect_functions
• relates to: SPARK-47820 Run `ANSI` SQL CI twice per day
• relates to: SPARK-28024 Incorrect numeric values when out of range
• relates to: SPARK-46374 Array Indexing is 1-based via ANSI SQL Standard
• links to: ANSI mode stays OFF in MySQL 8
• links to: GitHub Pull Request #46013