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>
14 lines
434 B
SQL
14 lines
434 B
SQL
SELECT table_schema, table_name, table_type, engine
|
|
FROM information_schema.tables
|
|
WHERE table_name = 't_information_schema_old_table'
|
|
ORDER BY table_schema;
|
|
|
|
SELECT column_name, data_type, semantic_type
|
|
FROM information_schema.columns
|
|
WHERE table_name = 't_information_schema_old_table'
|
|
ORDER BY table_schema, column_name;
|
|
|
|
SELECT count(*)
|
|
FROM information_schema.table_semantics
|
|
WHERE table_name = 't_information_schema_old_table';
|