Description
Steps to reproduce:
- create table test (i1 integer not null, i2 integer not null, i3 integer, i4 integer, CONSTRAINT pk PRIMARY KEY (i1, i2));
- upsert into test select rand()*40, rand()*10000000, null, rand()*100 from SYSTEM.CATALOG limit 130000;
- 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
- is related to
-
PHOENIX-7024 Issues in ServerPaging
- Resolved
- links to