[SPARK-13321] Add nested union test cases

• Type: Test
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Component/s: SQL
• Target Version/s: 2.0.0
• Assignee: L. C. Hsieh
• Reporter: L. C. Hsieh
• Created: 15/Feb/16 06:07
• Updated: 01/Apr/16 08:47
• Resolved: 01/Apr/16 08:47

Description

The following SQL can not be parsed with current parser:

SELECT  `u_1`.`id` FROM (((SELECT  `t0`.`id` FROM `default`.`t0`) UNION ALL (SELECT  `t0`.`id` FROM `default`.`t0`)) UNION ALL (SELECT  `t0`.`id` FROM `default`.`t0`)) AS u_1

We should fix it.

The above description is for ANTLR3 parser. As ANTLR4 parser supports it now, we just need to add test cases.

Issue Links

• links to: [Github] Pull Request #11204 (viirya)
• links to: [Github] Pull Request #11361 (viirya)