phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Pablo Gardella <>
Subject Empty row when using OFFSET + LIMIT
Date Sat, 25 Aug 2018 04:12:06 GMT
Hi all,

Today I faced a bug -I think-. I'm using Phoenix shipped
HDP 2.6.3
<>. 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



   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,

[1] Similar but not equal is PHOENIX-3422
<>. The results is no
data instead of null row.

View raw message