tian.yang created PHOENIX-4069:
----------------------------------
Summary: When use row timestamp table,upsert failed after delete
the same row.
Key: PHOENIX-4069
URL: https://issues.apache.org/jira/browse/PHOENIX-4069
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.10.0
Reporter: tian.yang
0: jdbc:phoenix:> CREATE TABLE IF NOT EXISTS T1(
. . . . . . . . > C_DAY BIGINT NOT NULL,
. . . . . . . . > C_KEY VARCHAR NOT NULL,
. . . . . . . . > C_VAL BIGINT
. . . . . . . . > CONSTRAINT PK_T1 PRIMARY KEY(C_DAY ROW_TIMESTAMP,C_KEY));
No rows affected (2.467 seconds)
0: jdbc:phoenix:> UPSERT INTO T1 (C_DAY,C_KEY,C_VAL) VALUES
(1502095662895,'A',9);
1 row affected (0.013 seconds)
0: jdbc:phoenix:> SELECT * FROM T1;
+----------------+--------+--------+
| C_DAY | C_KEY | C_VAL |
+----------------+--------+--------+
| 1502095662895 | A | 9 |
+----------------+--------+--------+
1 row selected (0.029 seconds)
0: jdbc:phoenix:> DELETE FROM T1;
1 row affected (0.011 seconds)
0: jdbc:phoenix:> SELECT * FROM T1;
+--------+--------+--------+
| C_DAY | C_KEY | C_VAL |
+--------+--------+--------+
+--------+--------+--------+
No rows selected (0.028 seconds)
0: jdbc:phoenix:> UPSERT INTO T1 (C_DAY,C_KEY,C_VAL) VALUES
(1502095662895,'A',9);
1 row affected (0.009 seconds)
0: jdbc:phoenix:> SELECT * FROM T1;
+--------+--------+--------+
| C_DAY | C_KEY | C_VAL |
+--------+--------+--------+
+--------+--------+--------+
No rows selected (0.027 seconds)
0: jdbc:phoenix:>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
