[PHOENIX-7109] Incorrect query results when using OFFSET

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.1.3
• Fix Version/s: 5.2.0, 5.1.4
• Component/s: phoenix
• Assignee: Aron Attila Meszaros
• Reporter: Aron Attila Meszaros
• Created: 13/Nov/23 09:49
• Updated: 01/Dec/23 17:25
• Resolved: 01/Dec/23 17:25

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.)

Issue Links

• is related to: PHOENIX-7024 Issues in ServerPaging
• links to: GitHub Pull Request #1741