[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html] and [HDP 2.6.3|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) -- POPULATE THE TABLE -- Create an index. CREATE INDEX testix ON test (ts) INCLUDE(id,json); {code} *IMPORTANT*: Without the index the issue does not happen. It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 10 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. was: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html] and [HDP 2.6.3|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) -- POPULATE THE TABLE -- Create an index. CREATE INDEX testix ON test (ts) INCLUDE(id,json); {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 10 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png, sample.PNG > > > I'm using [Phoenix shipped > |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at > [HDP > 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html] > and [HDP > 2.6.3|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html]. I > have a table defined as: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR, >ts timestamp > ) > -- POPULATE THE TABLE > -- Create an index. > CREATE INDEX testix ON test (ts) INCLUDE(id,json); > {code} > *IMPORTANT*: Without the index the issue does not happen. > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 10 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html] and [HDP 2.6.3|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) -- POPULATE THE TABLE -- Create an index. CREATE INDEX testix ON test (ts) INCLUDE(id,json); {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 10 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. was: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) CREATE INDEX testix ON test (ts ) INCLUDE(id,json); {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 10 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png, sample.PNG > > > I'm using [Phoenix shipped > |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at > [HDP > 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html] > and [HDP > 2.6.3|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.3/index.html]. I > have a table defined as: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR, >ts timestamp > ) > -- POPULATE THE TABLE > -- Create an index. > CREATE INDEX testix ON test (ts) INCLUDE(id,json); > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 10 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Attachment: sample.PNG > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png, sample.PNG > > > I'm using [Phoenix shipped > |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at > [HDP > 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I > have a table defined as: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR, >ts timestamp > ) > CREATE INDEX testix ON test (ts ) INCLUDE(id,json); > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 10 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) CREATE INDEX testix ON test (ts ) INCLUDE(id,json); {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 10 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. was: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) CREATE INDEX testix ON test (ts ) INCLUDE(id,json); {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png > > > I'm using [Phoenix shipped > |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at > [HDP > 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I > have a table defined as: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR, >ts timestamp > ) > CREATE INDEX testix ON test (ts ) INCLUDE(id,json); > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 10 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR, ts timestamp ) CREATE INDEX testix ON test (ts ) INCLUDE(id,json); {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. was: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png > > > I'm using [Phoenix shipped > |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at > [HDP > 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I > have a table defined as: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR, >ts timestamp > ) > CREATE INDEX testix ON test (ts ) INCLUDE(id,json); > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 1 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: I'm using [Phoenix shipped |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at [HDP 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I have a table defined as: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. was: 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: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png > > > I'm using [Phoenix shipped > |https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/bk_release-notes/content/patch_phoenix.html]at > [HDP > 2.6.1|https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.1/index.html]. I > have a table defined as: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR > ) > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 1 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: 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: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row. was: 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: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row.[1] > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png > > > 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: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR > ) > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 1 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
[ https://issues.apache.org/jira/browse/PHOENIX-4869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gardella Juan Pablo updated PHOENIX-4869: - Description: 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: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] [1] Similar but not equal is PHOENIX-3422. The results is no data instead of null row.[1] was: 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: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E > Empty row when using OFFSET + LIMIT > --- > > Key: PHOENIX-4869 > URL: https://issues.apache.org/jira/browse/PHOENIX-4869 > Project: Phoenix > Issue Type: Bug >Affects Versions: 4.7.0 >Reporter: Gardella Juan Pablo >Priority: Major > Attachments: empty_row.png, no_results.png > > > 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: > {code:sql} > > create table test ( > id VARCHAR not null primary key, > json VARCHAR > ) > {code} > It has 2559774 rows. If I execute the following query, it returns a row with > a null value. > {code:sql} > select * from > ( > SELECT ID > FROM test > LIMIT 10 OFFSET 10 > ) > where ID is null > {code} > > 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 1 does not fail. I've > attached a capture of the query results. > !empty_row.png! > Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty > result as expected. > !no_results.png! > > Thread: > [https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E] > [1] Similar but not equal is PHOENIX-3422. The results is no data instead of > null row.[1] > -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Created] (PHOENIX-4869) Empty row when using OFFSET + LIMIT
Gardella Juan Pablo created PHOENIX-4869: Summary: Empty row when using OFFSET + LIMIT Key: PHOENIX-4869 URL: https://issues.apache.org/jira/browse/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 |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: {code:sql} create table test ( id VARCHAR not null primary key, json VARCHAR ) {code} It has 2559774 rows. If I execute the following query, it returns a row with a null value. {code:sql} select * from ( SELECT ID FROM test LIMIT 10 OFFSET 10 ) where ID is null {code} 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 1 does not fail. I've attached a capture of the query results. !empty_row.png! Notice if I execute SELECT ID FROM test WHERE ID IS NULL returns an empty result as expected. !no_results.png! Thread: https://lists.apache.org/thread.html/fd54a0cf623a20ad54d1ac65656d01add8eeef74ad51fb1674afb566@%3Cuser.phoenix.apache.org%3E -- This message was sent by Atlassian JIRA (v7.6.3#76005)