[ https://issues.apache.org/jira/browse/PHOENIX-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chen Feng updated PHOENIX-5217: ------------------------------- Description: 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] was: 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] > 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 > Priority: Critical > > 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)