Done at https://issues.apache.org/jira/browse/PHOENIX-4869
On Sat, 25 Aug 2018 at 15:32 Thomas D'Silva <tdsi...@salesforce.com> wrote: > 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. >> >> > >
