[SPARK-28589] Introduce a new type coercion mode by following PostgreSQL - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Attach files

Attach Screenshot

Bulk Copy Attachments

Bulk Move Attachments

Add vote

Voters

Watch issue

Watchers

Create sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

Delete

XML

Word

Printable

JSON

The type coercion rules in Spark SQL are not consistent with any system. Sometimes, it is confusing to end users.

We can introduce a new type coercion mode so that Spark can function as some popular DBMS. For example, PostgreSQL.

1.	Introduce ANSI store assignment policy for table insertion	Resolved	Gengliang Wang	Actions
2.	Return null result on cast an out-of-range value to a integral type	Resolved	Unassigned	Actions
3.	New optional mode: throw runtime exceptions on casting failures	Resolved	Gengliang Wang	Actions
4.	Configurable type coercion policy for table insertion	Resolved	Gengliang Wang	Actions
5.	New optional mode: Throw exceptions when casting to integers causes overflow	Resolved	Gengliang Wang	Actions
6.	Follow ANSI store assignment rules in table insertion by default	Resolved	Gengliang Wang	Actions
7.	ANSI store assignment policy: throw exception on insertion failure	Resolved	Gengliang Wang	Actions
8.	store assignable if there exists an appropriate user-defined cast function	Resolved	Unassigned	Actions
9.	Legacy store assignment should not fail on error under ANSI mode	Resolved	Gengliang Wang	Actions