mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-07-04 04:50:37 +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>
13 lines
340 B
SQL
13 lines
340 B
SQL
CREATE TABLE t_information_schema_old_table(
|
|
ts TIMESTAMP TIME INDEX,
|
|
host STRING PRIMARY KEY,
|
|
val DOUBLE,
|
|
code INT
|
|
);
|
|
|
|
INSERT INTO t_information_schema_old_table VALUES
|
|
('2024-02-09 00:00:00+0000', 'host_a', 1.0, 200),
|
|
('2024-02-09 00:01:00+0000', 'host_b', 2.0, 500);
|
|
|
|
ADMIN FLUSH_TABLE('t_information_schema_old_table');
|