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>
17 lines
472 B
SQL
17 lines
472 B
SQL
CREATE TABLE t_column_default(
|
|
ts TIMESTAMP TIME INDEX,
|
|
host STRING PRIMARY KEY,
|
|
val INT DEFAULT 42,
|
|
msg STRING DEFAULT 'hello',
|
|
score DOUBLE DEFAULT 1.5
|
|
);
|
|
|
|
INSERT INTO t_column_default (ts, host) VALUES
|
|
('2024-02-03 00:00:00+0000', 'host_a'),
|
|
('2024-02-03 00:01:00+0000', 'host_b');
|
|
|
|
INSERT INTO t_column_default (ts, host, val, msg, score) VALUES
|
|
('2024-02-03 00:02:00+0000', 'host_c', 100, 'override', 9.5);
|
|
|
|
ADMIN FLUSH_TABLE('t_column_default');
|