phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chen Feng (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-5217) Incorrect result for COUNT DISTINCT ... limit ...
Date Thu, 28 Mar 2019 10:50:00 GMT
Chen Feng created PHOENIX-5217:
----------------------------------

             Summary: Incorrect result for COUNT DISTINCT ... limit ...
                 Key: PHOENIX-5217
                 URL: https://issues.apache.org/jira/browse/PHOENIX-5217
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.14.1
         Environment: Phoenix 4.14.1 returns the incorrect answer.

Phoenix 4.6 is correct.

No other version is tested.

 
            Reporter: Chen Feng


For table t1(pk1, col1, CONSTRAINT(pk1))

upsert into "t1" values (1, 1);
 upsert into "t1" values (2, 2);

sql1: select count("pk1") from "t1" limit 1, return 2 [correct]

sql2: select count(disctinct("pk1")) from "t1" limit 1, return 1 [incorrect]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message