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

Incorrect query results when using OFFSET

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 5.1.3
    • 5.2.0, 5.1.4
    • phoenix
    • None

    Description

      Steps to reproduce:

      1. create table test (i1 integer not null, i2 integer not null, i3 integer, i4 integer, CONSTRAINT pk PRIMARY KEY (i1, i2));
      2. upsert into test select rand()*40, rand()*10000000, null, rand()*100 from SYSTEM.CATALOG limit 130000;
      3. upsert into test select rand()*40, rand()*10000000, null, rand()*100 from test limit 130000;

      Repeat step 3 a few times, then run

      select * from test where i1=10 and i4=20 offset X;

      where X is bigger than the number of rows satisfying the condition.

      There are rows returned by phoenix (expected result is empty set.)

      Attachments

        Issue Links

          Activity

            People

              ameszaros Aron Attila Meszaros
              ameszaros Aron Attila Meszaros
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: