[
https://issues.apache.org/jira/browse/PHOENIX-3795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Loknath Priyatham Teja Singamsetty updated PHOENIX-3795:
---------------------------------------------------------
Description:
CREATE TABLE IF NOT EXISTS TEST.TEST
(
O_ID CHAR(15) NOT NULL,
F_E_ID CHAR(15) NOT NULL,
U_ID CHAR(15) NOT NULL,
L_R_D TIMESTAMP NULL,
F_E_R_ID CHAR(15),
N_ID CHAR(15)
CONSTRAINT PKVIEW PRIMARY KEY
(
O_ID,
F_E_ID,
U_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 F_E_ID, U_ID, L_R_D from TEST.TEST where O_ID = 'X' and F_E_ID = 'Y';
Results in 6 records (as shown in the pic above). This is the expected result.
2.Select F_E_ID, U_ID, L_R_D from TEST.TEST where O_ID = 'X' and F_E_ID = 'Y'
order by L_R_D DESC;
was:
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;
> 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 TEST.TEST
> (
> O_ID CHAR(15) NOT NULL,
> F_E_ID CHAR(15) NOT NULL,
> U_ID CHAR(15) NOT NULL,
> L_R_D TIMESTAMP NULL,
> F_E_R_ID CHAR(15),
> N_ID CHAR(15)
> CONSTRAINT PKVIEW PRIMARY KEY
> (
> O_ID,
> F_E_ID,
> U_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 F_E_ID, U_ID, L_R_D from TEST.TEST where O_ID = 'X' and F_E_ID = 'Y';
> Results in 6 records (as shown in the pic above). This is the expected result.
> 2.Select F_E_ID, U_ID, L_R_D from TEST.TEST where O_ID = 'X' and F_E_ID = 'Y'
> order by L_R_D DESC;
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
