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>
14 lines
560 B
SQL
14 lines
560 B
SQL
SELECT kind, json_to_string(j) FROM t_legacy_json_non_object ORDER BY kind;
|
|
|
|
SELECT kind FROM t_legacy_json_non_object WHERE json_is_array(j) ORDER BY kind;
|
|
|
|
SELECT kind FROM t_legacy_json_non_object WHERE json_is_string(j) ORDER BY kind;
|
|
|
|
SELECT kind FROM t_legacy_json_non_object WHERE json_is_int(j) ORDER BY kind;
|
|
|
|
SELECT kind FROM t_legacy_json_non_object WHERE json_is_bool(j) ORDER BY kind;
|
|
|
|
SELECT kind FROM t_legacy_json_non_object WHERE json_is_null(j) ORDER BY kind;
|
|
|
|
SELECT kind FROM t_legacy_json_non_object WHERE json_is_object(j) ORDER BY kind;
|