Juan, Can you please create a JIRA that allows us to repro this in a test?
Thanks, Thomas On Fri, Aug 24, 2018 at 9:12 PM, Juan Pablo Gardella < gardellajuanpa...@gmail.com> wrote: > Hi all, > > Today I faced a bug -I think-. I'm using Phoenix shipped > <https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/bk_release-notes/content/patch_phoenix.html>at > HDP 2.6.3 > <https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html>. I > have a table defined as: > > create table test ( > > id VARCHAR not null primary key, > > json VARCHAR, > > nifi_capture_ts TIMESTAMP > > ) > > > It has 2559774 rows. If I execute the following query, it returns a row > with a null value. > > > select * from > > ( > > SELECT ID > > FROM test > > LIMIT 100000 OFFSET 100000 > > ) > > where ID is null > > > I was reviewing the git logs and I didn't see any commit related to > that[1]. Notice the query for OFFSET and LIMIT lowers than 10000 does not > fail. I've attached a capture of the query results. > > [image: image.png] > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > > [image: image.png] > Let me know if I should file a ticket at JIRA. For now I'm unable to > verify with a newer server, but AFAIK there is no commit related to that > from today until version 4.7.0. > > Thanks in advance, > Juan > > [1] Similar but not equal is PHOENIX-3422 > <https://issues.apache.org/jira/browse/PHOENIX-3342>. The results is no > data instead of null row. > >
