mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-08 22:32:55 +00:00
6100cb335a
* test: test for delete rows from table with non null columns * test: test delete and reopen * fix: allow deleting rows with non null column
39 lines
1.2 KiB
Plaintext
39 lines
1.2 KiB
Plaintext
CREATE TABLE monitor (host STRING NOT NULL, ts TIMESTAMP NOT NULL, cpu DOUBLE NOT NULL, memory DOUBLE NOT NULL, TIME INDEX (ts), PRIMARY KEY(host));
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO monitor(ts, host, cpu, memory) VALUES
|
|
(1655276557000, 'host1', 10.0, 1024),
|
|
(1655276557000, 'host2', 20.0, 1024),
|
|
(1655276557000, 'host3', 30.0, 1024);
|
|
|
|
Affected Rows: 3
|
|
|
|
SELECT ts, host, cpu, memory FROM monitor ORDER BY ts, host;
|
|
|
|
+---------------------+-------+------+--------+
|
|
| ts | host | cpu | memory |
|
|
+---------------------+-------+------+--------+
|
|
| 2022-06-15T07:02:37 | host1 | 10.0 | 1024.0 |
|
|
| 2022-06-15T07:02:37 | host2 | 20.0 | 1024.0 |
|
|
| 2022-06-15T07:02:37 | host3 | 30.0 | 1024.0 |
|
|
+---------------------+-------+------+--------+
|
|
|
|
DELETE FROM monitor WHERE host = 'host2';
|
|
|
|
Affected Rows: 1
|
|
|
|
SELECT ts, host, cpu, memory FROM monitor ORDER BY ts, host;
|
|
|
|
+---------------------+-------+------+--------+
|
|
| ts | host | cpu | memory |
|
|
+---------------------+-------+------+--------+
|
|
| 2022-06-15T07:02:37 | host1 | 10.0 | 1024.0 |
|
|
| 2022-06-15T07:02:37 | host3 | 30.0 | 1024.0 |
|
|
+---------------------+-------+------+--------+
|
|
|
|
DROP TABLE monitor;
|
|
|
|
Affected Rows: 0
|
|
|