kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "weibin0516 (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-4068) Automatically add limit has bug
Date Wed, 03 Jul 2019 02:32:00 GMT
weibin0516 created KYLIN-4068:
---------------------------------

             Summary: 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



{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.3#76005)

Mime
View raw message