[SPARK-43362] Special handling of JSON type for MySQL connector

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Tianhan Hu
• Reporter: Tianhan Hu
• Created: 03/May/23 22:58
• Updated: 03/Apr/24 07:56
• Resolved: 08/May/23 01:26

Description

MySQL JSON type is converted into JDBC VARCHAR type with precision of -1 on some MariaDB drivers.
When receiving VARCHAR with negative precision, Spark will throw an error.

This ticket purposes to special case this scenario by directly converting JSON type into StringType in MySQLDialect.

Issue Links

• links to: GitHub Pull Request #45835