[
https://issues.apache.org/jira/browse/PHOENIX-7109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17787938#comment-17787938
]
Aron Attila Meszaros edited comment on PHOENIX-7109 at 11/20/23 10:34 AM:
--------------------------------------------------------------------------
Investigated the issue with git bisect, it seems that the bug was introduced by
commit [868c8eff|[https://github.com/apache/phoenix/commit/868c8eff]]
Further verification needed, there's a chance this just revealed the error as
there's no direct connection between the two.
was (Author: JIRAUSER293246):
Investigated the issue with git bisect, it seems that the bug was introduced by
commit [868c8eff|[https://github.com/apache/phoenix/commit/868c8eff].]
Further verification needed, there's a chance this just revealed the error as
there's no direct connection between the two.
> Incorrect query results when using OFFSET
> -----------------------------------------
>
> Key: PHOENIX-7109
> URL: https://issues.apache.org/jira/browse/PHOENIX-7109
> Project: Phoenix
> Issue Type: Bug
> Components: phoenix
> Affects Versions: 5.1.3
> Reporter: Aron Attila Meszaros
> Assignee: Aron Attila Meszaros
> Priority: Major
>
> 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
> {noformat}
> select * from test where i1=10 and i4=20 offset X;{noformat}
> where X is bigger than the number of rows satisfying the condition.
> There are rows returned by phoenix (expected result is empty set.)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
