mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-05 21:40:38 +00:00
6b587eb0a5
* test: add recent sqlness compat cases Signed-off-by: discord9 <discord9@163.com> * test: add more sqlness compat cases Signed-off-by: discord9 <discord9@163.com> --------- Signed-off-by: discord9 <discord9@163.com>
16 lines
339 B
SQL
16 lines
339 B
SQL
SELECT host, ts, cpu
|
|
FROM t_last_row_append_mode
|
|
ORDER BY host, ts, cpu;
|
|
|
|
ALTER TABLE t_last_row_append_mode SET 'append_mode' = 'true';
|
|
|
|
SHOW CREATE TABLE t_last_row_append_mode;
|
|
|
|
INSERT INTO t_last_row_append_mode VALUES
|
|
('host1', 0, 100.0),
|
|
('host2', 1, 200.0);
|
|
|
|
SELECT host, ts, cpu
|
|
FROM t_last_row_append_mode
|
|
ORDER BY host, ts, cpu;
|