Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5217

Incorrect result for COUNT DISTINCT limit

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 4.14.1
    • 4.15.0, 5.1.0, 4.14.2, 5.0.1
    • None
    • None
    • 4.14.1: incorrect

      4.6: correct.

       

    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]

      Attachments

        1. PHOENIX-5217_v1-4.x-HBase-1.4.patch
          9 kB
          chenglei
        2. PHOENIX-5217_v2-master.patch
          9 kB
          chenglei
        3. PHOENIX-5217-4.14-HBase-1.4.patch
          9 kB
          chenglei

        Issue Links

          Activity

            People

              comnetwork chenglei
              fengchen8086 Chen Feng
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: