[KYLIN-4068] Automatically add limit has bug

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v2.6.2
• Fix Version/s: v3.0.0-alpha2
• Component/s: Query Engine
• Assignee: weibin0516
• Reporter: weibin0516
• Created: 03/Jul/19 02:31
• Updated: 21/Jan/20 07:36
• Resolved: 09/Sep/19 06:29

Description

SELECT E_Name FROM Employees_China
UNION
SELECT E_Name FROM Employees_USA

will convert to

SELECT E_Name FROM Employees_China
UNION
SELECT E_Name FROM Employees_USA
LIMIT 50000

This limit is not working on the result of union, but on SELECT E_Name FROM Employees_USA.
We should use a more secure way to achieve the limit effect.

Issue Links

• links to: GitHub Pull Request #729