[
https://issues.apache.org/jira/browse/PHOENIX-7046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7046:
----------------------------------
Fix Version/s: 5.2.0
> Query results return different values when PKs of view have DESC order
> ----------------------------------------------------------------------
>
> Key: PHOENIX-7046
> URL: https://issues.apache.org/jira/browse/PHOENIX-7046
> Project: Phoenix
> Issue Type: Bug
> Reporter: Jacob Isaac
> Assignee: Viraj Jasani
> Priority: Major
> Fix For: 5.2.0
>
> Attachments: Screenshot 2023-09-21 at 10.54.08 AM.png
>
>
> To reproduce -
> CREATE TABLE IF NOT EXISTS TEST_ENTITY.T1(OID CHAR(15) NOT NULL,KP CHAR(3)
> NOT NULL, COL1 VARCHAR CONSTRAINT pk PRIMARY KEY (OID,KP))
> MULTI_TENANT=true,COLUMN_ENCODED_BYTES=0;
> CREATE VIEW IF NOT EXISTS TEST_ENTITY.G1_P01(ID1 INTEGER not null, COL4
> VARCHAR, CONSTRAINT pk PRIMARY KEY (ID1 DESC)) AS SELECT * FROM
> TEST_ENTITY.T1 WHERE KP = 'P01';
> CREATE VIEW IF NOT EXISTS TEST_ENTITY.TV_P01(ROW_ID CHAR(15) NOT NULL,COLA
> VARCHAR CONSTRAINT pk PRIMARY KEY (ROW_ID)) AS SELECT * FROM
> TEST_ENTITY.G1_P01 WHERE ID1 = 42724;
> UPSERT INTO TEST_ENTITY.TV_P01(OID, ROW_ID, COL4, COLA)
> VALUES('00D0y0000000001', '00Z0y0000000001','d07223','a05493');
> SELECT ID1, COL4 FROM TEST_ENTITY.TV_P01;
> SELECT ID1, COL4 FROM TEST_ENTITY.G1_P01;
>
>
> !Screenshot 2023-09-21 at 10.54.08 AM.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
