phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gardella Juan Pablo (JIRA)" <>
Subject [jira] [Created] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
Date Sat, 25 Aug 2018 21:34:00 GMT
Gardella Juan Pablo created PHOENIX-4869:

             Summary: Empty row when using OFFSET + LIMIT
                 Key: PHOENIX-4869
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
            Reporter: Gardella Juan Pablo
         Attachments: empty_row.png, no_results.png

I'm using [Phoenix shipped |]at
[HDP 2.6.3|]. I have a
table defined as:
create table test (
   id VARCHAR not null primary key,
   json VARCHAR
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


Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected.



This message was sent by Atlassian JIRA

View raw message