[
https://issues.apache.org/jira/browse/PHOENIX-6662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xinyi Yan updated PHOENIX-6662:
-------------------------------
Priority: Critical (was: Major)
> Failed to delete rows when PK has one or more DESC column with IN clause
> ------------------------------------------------------------------------
>
> Key: PHOENIX-6662
> URL: https://issues.apache.org/jira/browse/PHOENIX-6662
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.16.1
> Reporter: Xinyi Yan
> Priority: Critical
>
> {code:java}
> 0: jdbc:phoenix:localhost> CREATE TABLE DUMMY_THREE_PKS (PK1 VARCHAR(15), PK2
> DOUBLE(10,3) NOT NULL, PK3 BIGINT NOT NULL CONSTRAINT PK PRIMARY KEY (PK1,
> PK2 DESC,PK3));
> No rows affected (1.309 seconds)
> 0: jdbc:phoenix:localhost>
> 0: jdbc:phoenix:localhost> UPSERT INTO DUMMY_THREE_PKS VALUES
> ('00DXXXXXXXXXXXX',10.0,10);
> 1 row affected (0.033 seconds)
> 0: jdbc:phoenix:localhost> UPSERT INTO DUMMY_THREE_PKS VALUES
> ('00DXXXXXXXXXXXX',20.0,20);
> 1 row affected (0.003 seconds)
> 0: jdbc:phoenix:localhost>
> 0: jdbc:phoenix:localhost>
> 0: jdbc:phoenix:localhost> SELECT * FROM DUMMY_THREE_PKS;
> +-----------------+------------------------------------------+------------------------------------------+
> | PK1 | PK2 |
> PK3 |
> +-----------------+------------------------------------------+------------------------------------------+
> | 00DXXXXXXXXXXXX | 20.0 | 20
> |
> | 00DXXXXXXXXXXXX | 10.0 | 10
> |
> +-----------------+------------------------------------------+------------------------------------------+
> 2 rows selected (0.027 seconds)
> 0: jdbc:phoenix:localhost> DELETE FROM DUMMY_THREE_PKS WHERE (PK1,PK2) IN
> (('00DXXXXXXXXXXXX',10.0,10),('00DXXXXXXXXXXXX',20.0,20));
> No rows affected (0.013 seconds)
> 0: jdbc:phoenix:localhost> SELECT * FROM DUMMY_THREE_PKS;
> +-----------------+------------------------------------------+------------------------------------------+
> | PK1 | PK2 |
> PK3 |
> +-----------------+------------------------------------------+------------------------------------------+
> | 00DXXXXXXXXXXXX | 20.0 | 20
> |
> | 00DXXXXXXXXXXXX | 10.0 | 10
> |
> +-----------------+------------------------------------------+------------------------------------------+
> 2 rows selected (0.012 seconds)
> 0: jdbc:phoenix:localhost> EXPLAIN DELETE FROM DUMMY_THREE_PKS WHERE
> (PK1,PK2) IN (('00DXXXXXXXXXXXX',10.0,10),('00DXXXXXXXXXXXX',20.0,20));
> +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
> | PLAN | EST_BYTES_READ
> | EST_ROWS_READ |
> EST_INFO_TS |
> +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
> | DELETE ROWS SERVER SELECT | null
> | null | null
> |
> | CLIENT 1-CHUNK PARALLEL 1-WAY SKIP SCAN ON 2 KEYS OVER DUMMY_THREE_PKS
> ['00DXXXXXXXXXXXX',~20.0] - ['00DXXXXXXXXXXXX',~10.0] | null
> | null |
> | SERVER FILTER BY FIRST KEY ONLY AND (PK1, PK2) IN
> ([48,48,68,88,88,88,88,88,88,88,88,88,88,88,88,0,63,203,255,255,255,255,255,254,128,0,0,20],[48,48,68,88,88,88,88,88,88,88,88,88,88,88,88,0,63,
> |
> +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
