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
584 B
SQL
16 lines
584 B
SQL
CREATE TABLE t_legacy_json_non_object(
|
|
ts TIMESTAMP TIME INDEX,
|
|
kind STRING PRIMARY KEY,
|
|
j JSON
|
|
);
|
|
|
|
INSERT INTO t_legacy_json_non_object VALUES
|
|
('2024-02-06 00:00:00+0000', 'array', parse_json('[1, 2, 3]')),
|
|
('2024-02-06 00:01:00+0000', 'string', parse_json('"hello"')),
|
|
('2024-02-06 00:02:00+0000', 'int', parse_json('42')),
|
|
('2024-02-06 00:03:00+0000', 'bool', parse_json('true')),
|
|
('2024-02-06 00:04:00+0000', 'null', parse_json('null')),
|
|
('2024-02-06 00:05:00+0000', 'object', parse_json('{"a": 10, "msg": "object"}'));
|
|
|
|
ADMIN FLUSH_TABLE('t_legacy_json_non_object');
|