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>
16 lines
339 B
SQL
16 lines
339 B
SQL
SELECT host, json_to_string(j)
|
|
FROM t_json2_compat
|
|
ORDER BY host;
|
|
|
|
SELECT host, json_get_int(j, 'a') AS a
|
|
FROM t_json2_compat
|
|
WHERE json_get_int(j, 'a') >= 20
|
|
ORDER BY host;
|
|
|
|
SELECT host, json_get_string(j, 'nested.b') AS nested_b
|
|
FROM t_json2_compat
|
|
WHERE json_get_bool(j, 'flag') = true
|
|
ORDER BY host;
|
|
|
|
SHOW CREATE TABLE t_json2_compat;
|