mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-05 21:02:58 +00:00
92a9802343
* feat: canonicalize all unquoted identifier to lowercase Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add more tests Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * test altering table Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * primary key declare Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix primary key declare Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * partition by and time index Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * remove redundent call to canonicalize Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
101 lines
2.5 KiB
Plaintext
101 lines
2.5 KiB
Plaintext
TRUNCATE TABLE not_exists_table;
|
|
|
|
Error: 4001(TableNotFound), Table not found: greptime.public.not_exists_table
|
|
|
|
CREATE TABLE monitor (host STRING, ts TIMESTAMP, cpu DOUBLE DEFAULT 0, memory DOUBLE, TIME INDEX (ts), PRIMARY KEY(host));
|
|
|
|
Affected Rows: 0
|
|
|
|
INSERT INTO monitor(ts, host, cpu, memory) VALUES
|
|
(1695217652000, 'host1', 66.6, 1024),
|
|
(1695217652000, 'host2', 66.6, 1024),
|
|
(1695217652000, 'host3', 66.6, 1024),
|
|
(1695217654000, 'host1', 77.7, 2048),
|
|
(1695217654000, 'host2', 77.7, 2048),
|
|
(1695217654000, 'host3', 77.7, 2048),
|
|
(1695217656000, 'host1', 88.8, 4096),
|
|
(1695217656000, 'host2', 88.8, 4096),
|
|
(1695217656000, 'host3', 88.8, 4096);
|
|
|
|
Affected Rows: 9
|
|
|
|
SELECT ts, host, cpu, memory FROM monitor ORDER BY ts;
|
|
|
|
+---------------------+-------+------+--------+
|
|
| ts | host | cpu | memory |
|
|
+---------------------+-------+------+--------+
|
|
| 2023-09-20T13:47:32 | host1 | 66.6 | 1024.0 |
|
|
| 2023-09-20T13:47:32 | host2 | 66.6 | 1024.0 |
|
|
| 2023-09-20T13:47:32 | host3 | 66.6 | 1024.0 |
|
|
| 2023-09-20T13:47:34 | host1 | 77.7 | 2048.0 |
|
|
| 2023-09-20T13:47:34 | host2 | 77.7 | 2048.0 |
|
|
| 2023-09-20T13:47:34 | host3 | 77.7 | 2048.0 |
|
|
| 2023-09-20T13:47:36 | host1 | 88.8 | 4096.0 |
|
|
| 2023-09-20T13:47:36 | host2 | 88.8 | 4096.0 |
|
|
| 2023-09-20T13:47:36 | host3 | 88.8 | 4096.0 |
|
|
+---------------------+-------+------+--------+
|
|
|
|
TRUNCATE monitor;
|
|
|
|
Affected Rows: 0
|
|
|
|
SELECT ts, host, cpu, memory FROM monitor ORDER BY ts;
|
|
|
|
++
|
|
++
|
|
|
|
INSERT INTO monitor(ts, host, cpu, memory) VALUES
|
|
(1695217660000, 'host1', 88.8, 4096),
|
|
(1695217662000, 'host2', 88.8, 4096),
|
|
(1695217664000, 'host3', 88.8, 4096);
|
|
|
|
Affected Rows: 3
|
|
|
|
SELECT ts, host, cpu, memory FROM monitor ORDER BY ts;
|
|
|
|
+---------------------+-------+------+--------+
|
|
| ts | host | cpu | memory |
|
|
+---------------------+-------+------+--------+
|
|
| 2023-09-20T13:47:40 | host1 | 88.8 | 4096.0 |
|
|
| 2023-09-20T13:47:42 | host2 | 88.8 | 4096.0 |
|
|
| 2023-09-20T13:47:44 | host3 | 88.8 | 4096.0 |
|
|
+---------------------+-------+------+--------+
|
|
|
|
TRUNCATE monitor;
|
|
|
|
Affected Rows: 0
|
|
|
|
SELECT ts, host, cpu, memory FROM monitor ORDER BY ts;
|
|
|
|
++
|
|
++
|
|
|
|
DROP TABLE monitor;
|
|
|
|
Affected Rows: 0
|
|
|
|
CREATE TABLE "MoNiToR" ("hOsT" STRING PRIMARY KEY, "tS" TIMESTAMP TIME INDEX, "cPu" DOUBLE DEFAULT 0);
|
|
|
|
Affected Rows: 0
|
|
|
|
TRUNCATE "MoNiToR";
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE "MoNiToR";
|
|
|
|
Affected Rows: 0
|
|
|
|
CREATE TABLE MoNiToR (hOsT STRING PRIMARY KEY, tS TIMESTAMP TIME INDEX, cPu DOUBLE DEFAULT 0);
|
|
|
|
Affected Rows: 0
|
|
|
|
TRUNCATE MoNiToR;
|
|
|
|
Affected Rows: 0
|
|
|
|
DROP TABLE MoNiToR;
|
|
|
|
Affected Rows: 0
|
|
|