phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Loknath Priyatham Teja Singamsetty (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (PHOENIX-3795) SELECT query returns inconsistent results when the output result set fields are given
Date Tue, 18 Apr 2017 18:25:41 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-3795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Loknath Priyatham Teja Singamsetty  reassigned PHOENIX-3795:
------------------------------------------------------------

    Assignee: Loknath Priyatham Teja Singamsetty 

> SELECT query returns inconsistent results when the output result set fields are given

> --------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3795
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3795
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.10.0
>            Reporter: Loknath Priyatham Teja Singamsetty 
>            Assignee: Loknath Priyatham Teja Singamsetty 
>
> CREATE TABLE IF NOT EXISTS FEEDS.FEED_ENTITY_READ
> (
> ORGANIZATION_ID CHAR(15) NOT NULL,
> FEED_ENTITY_ID CHAR(15) NOT NULL,
> USER_ID CHAR(15) NOT NULL,
> LAST_READ_DATE TIMESTAMP NULL,
> FEED_ENTITY_READ_ID CHAR(15),
> NETWORK_ID CHAR(15)
> CONSTRAINT PKVIEW PRIMARY KEY
> (
> ORGANIZATION_ID,
> FEED_ENTITY_ID,
> USER_ID
> )
> ) VERSIONS=1,MULTI_TENANT=TRUE,IMMUTABLE_ROWS=TRUE,REPLICATION_SCOPE=1
> This table maintains information of the date when the user last read the feed element.
Note this is an immutable table and the app does upserts.
> Queries: 
> Select FEED_ENTITY_ID, USER_ID, LAST_READ_DATE from FEEDS.FEED_ENTITY_READ where ORGANIZATION_ID
= 'X' and FEED_ENTITY_ID = 'Y';
> Results in 6 records (as shown in the pic above). This is the expected result.
> 2.Select FEED_ENTITY_ID, USER_ID, LAST_READ_DATE from FEEDS.FEED_ENTITY_READ where ORGANIZATION_ID
= 'X' and FEED_ENTITY_ID = 'Y' order by LAST_READ_DATE DESC;



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message