[SPARK-27763] Port test cases from PostgreSQL to Spark SQL

• Type: Umbrella
• Status: Resolved
• Priority: Major
• Resolution: Done
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Target Version/s: 3.0.0
• Assignee: Yuming Wang
• Reporter: Xiao Li
• Created: 19/May/19 00:25
• Updated: 12/Dec/22 18:10
• Resolved: 07/Nov/19 07:09

Description

To improve the test coverage, we can port the regression tests from the other popular open source projects to Spark SQL. PostgreSQL is one of the best SQL systems. Below are the links to the test cases and results. 

• Regression test cases: https://github.com/postgres/postgres/tree/master/src/test/regress/sql
• Expected results: https://github.com/postgres/postgres/tree/master/src/test/regress/expected

Spark SQL does not support all the feature sets of PostgreSQL. In the current stage, we should first comment out these test cases and create the corresponding JIRAs in SPARK-27764. We can discuss and prioritize which features we should support. Also, these PostgreSQL regression tests could also expose the existing bugs of Spark SQL. We should also create the JIRAs and track them in SPARK-27764. 

Issue Links

• is related to: SPARK-28342 Replace REL_12_BETA1 to REL_12_BETA2 in PostgresSQL SQL tests
• is related to: SPARK-27764 Feature Parity between PostgreSQL and Spark
• is related to: SPARK-27921 Convert applicable *.sql tests into UDF integrated test base