[jira] [Updated] (PHOENIX-7046) Query results return different values when PKs of view have DESC order

["Viraj Jasani (Jira)" <ji...@apache.org>]

     [ 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.1.4

> 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, 5.1.4
>
>         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)