Xinyi Yan created PHOENIX-6662:
----------------------------------
Summary: 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
{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)
