[PHOENIX-5217] Incorrect result for COUNT DISTINCT limit

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 4.14.1
• Fix Version/s: 4.15.0, 5.1.0, 4.14.2, 5.0.1

Environment

4.14.1: incorrect

4.6: correct.

 

• Assignee: chenglei
• Reporter: Chen Feng
• Created: 28/Mar/19 10:49
• Updated: 30/May/19 18:40
• Resolved: 19/Apr/19 06:24

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]

Issue Links

• is caused by: PHOENIX-3501 Push limit to server for distinct optimization