mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-03 12:30:40 +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>
9 lines
278 B
SQL
9 lines
278 B
SQL
SELECT ts, host, val, msg, score FROM t_column_default ORDER BY ts, host;
|
|
|
|
INSERT INTO t_column_default (ts, host) VALUES
|
|
('2024-02-03 00:03:00+0000', 'host_d');
|
|
|
|
SELECT ts, host, val, msg, score FROM t_column_default WHERE host = 'host_d';
|
|
|
|
SHOW CREATE TABLE t_column_default;
|