[ https://issues.apache.org/jira/browse/PHOENIX-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chenglei updated PHOENIX-5217: ------------------------------ Attachment: PHOENIX-5217_v1-master.patch > 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: 4.14.1: incorrect > 4.6: correct. > > Reporter: Chen Feng > Assignee: chenglei > Priority: Critical > Fix For: 4.15.0, 5.1.0, 4.14.2 > > Attachments: PHOENIX-5217_v1-4.x-HBase-1.4.patch, > PHOENIX-5217_v1-master.patch > > > For table t1(pk1, col1, CONSTRAINT(pk1)) > upsert into "t1" values (1, 1); > upsert into "t1" values (2, 2); > sql A: select count("pk1") from "t1" limit 1, return 2 [correct] > sql B: select count(disctinct("pk1")) from "t1" limit 1, return 1 [incorrect] -- This message was sent by Atlassian JIRA (v7.6.3#76005)