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

index split while running group by query is returning duplicate results

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • None
    • 4.7.0
    • None
    • None

    Description

      When there is a index split while running group by query is returning duplicate results.
      Instead of returning 500,000 records it's returning 729,500 records.

      +------------------------------------------+------------------------------------------+
      | 4999                                     | 499999                                   |
      +------------------------------------------+------------------------------------------+
      500,000 rows selected (11.996 seconds)
      
      +------------------------------------------+------------------------------------------+
      | 4999                                     | 499999                                   |
      +------------------------------------------+------------------------------------------+
      729,500 rows selected (15.291 seconds)
      

      Attachments

        1. PHOENIX-2665.patch
          7 kB
          Rajeshbabu Chintaguntla

        Activity

          People

            rajeshbabu Rajeshbabu Chintaguntla
            rajeshbabu Rajeshbabu Chintaguntla
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: