Loknath Priyatham Teja Singamsetty created PHOENIX-3795:
------------------------------------------------------------
Summary: 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
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)
