[
https://issues.apache.org/jira/browse/KYLIN-4068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16892842#comment-16892842
]
ASF subversion and git services commented on KYLIN-4068:
--------------------------------------------------------
Commit 92baa2f6e8265d4d05a0865b7360ac9ff467eedd in kylin's branch
refs/heads/master from weibin0516
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=92baa2f ]
[KYLIN-4068] append limit and offset to sql reliably
> Automatically add limit has bug
> -------------------------------
>
> Key: KYLIN-4068
> URL: https://issues.apache.org/jira/browse/KYLIN-4068
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v2.6.2
> Reporter: weibin0516
> Assignee: weibin0516
> Priority: Major
>
> {code:sql}
> SELECT E_Name FROM Employees_China
> UNION
> SELECT E_Name FROM Employees_USA
> {code}
> will convert to
> {code:sql}
> SELECT E_Name FROM Employees_China
> UNION
> SELECT E_Name FROM Employees_USA
> LIMIT 50000
> {code}
> 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.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
