Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-258 Use skip scan when SELECT DISTINCT on leading row key column(s)
  3. PHOENIX-2987

DISTINCT/GROUP BY optimization not correct for null values in key parts

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.8.0
    • None
    • None

    Description

      During forward scans with the DistinctPrefix filter set null values are not returned.
      The reason is that that lastKey is initialized with ByteUtil.EMPTY_BYTE_ARRAY, which happens to the equal to a null value in a key part. So the filter determines it has seen the value before.

      Attachments

        1. 2987.txt
          2 kB
          Lars Hofhansl

        Activity

          People

            larsh Lars Hofhansl
            larsh Lars Hofhansl
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: