mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-14 01:02:55 +00:00
802229de87
* update valid results Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * accomplish datatype Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * cast null Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix unit tests Signed-off-by: Ruihang Xia <waynestxia@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com>
96 lines
4.2 KiB
Plaintext
96 lines
4.2 KiB
Plaintext
-- scripts table has different table ids in different modes
|
|
select *
|
|
from information_schema.tables
|
|
where table_name != 'scripts'
|
|
order by table_schema, table_name;
|
|
|
|
+---------------+--------------------+------------+-----------------+----------+-------------+
|
|
| table_catalog | table_schema | table_name | table_type | table_id | engine |
|
|
+---------------+--------------------+------------+-----------------+----------+-------------+
|
|
| greptime | information_schema | columns | LOCAL TEMPORARY | 4 | |
|
|
| greptime | information_schema | tables | LOCAL TEMPORARY | 3 | |
|
|
| greptime | public | numbers | LOCAL TEMPORARY | 2 | test_engine |
|
|
+---------------+--------------------+------------+-----------------+----------+-------------+
|
|
|
|
select * from information_schema.columns order by table_schema, table_name;
|
|
|
|
+---------------+--------------------+------------+---------------+-----------+---------------+
|
|
| table_catalog | table_schema | table_name | column_name | data_type | semantic_type |
|
|
+---------------+--------------------+------------+---------------+-----------+---------------+
|
|
| greptime | information_schema | columns | table_catalog | String | FIELD |
|
|
| greptime | information_schema | columns | table_schema | String | FIELD |
|
|
| greptime | information_schema | columns | table_name | String | FIELD |
|
|
| greptime | information_schema | columns | column_name | String | FIELD |
|
|
| greptime | information_schema | columns | data_type | String | FIELD |
|
|
| greptime | information_schema | columns | semantic_type | String | FIELD |
|
|
| greptime | information_schema | tables | table_catalog | String | FIELD |
|
|
| greptime | information_schema | tables | table_schema | String | FIELD |
|
|
| greptime | information_schema | tables | table_name | String | FIELD |
|
|
| greptime | information_schema | tables | table_type | String | FIELD |
|
|
| greptime | information_schema | tables | table_id | UInt32 | FIELD |
|
|
| greptime | information_schema | tables | engine | String | FIELD |
|
|
| greptime | public | numbers | number | UInt32 | TAG |
|
|
+---------------+--------------------+------------+---------------+-----------+---------------+
|
|
|
|
create
|
|
database my_db;
|
|
|
|
Affected Rows: 1
|
|
|
|
use my_db;
|
|
|
|
Affected Rows: 0
|
|
|
|
create table foo
|
|
(
|
|
ts TIMESTAMP TIME INDEX
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
select table_name
|
|
from information_schema.tables
|
|
where table_schema = 'my_db'
|
|
order by table_name;
|
|
|
|
+------------+
|
|
| table_name |
|
|
+------------+
|
|
| foo |
|
|
+------------+
|
|
|
|
select table_catalog, table_schema, table_name, table_type, engine
|
|
from information_schema.tables
|
|
where table_catalog = 'greptime'
|
|
and table_schema != 'public'
|
|
and table_schema != 'information_schema'
|
|
order by table_schema, table_name;
|
|
|
|
+---------------+--------------+------------+------------+--------+
|
|
| table_catalog | table_schema | table_name | table_type | engine |
|
|
+---------------+--------------+------------+------------+--------+
|
|
| greptime | my_db | foo | BASE TABLE | mito |
|
|
+---------------+--------------+------------+------------+--------+
|
|
|
|
select table_catalog, table_schema, table_name, column_name, data_type, semantic_type
|
|
from information_schema.columns
|
|
where table_catalog = 'greptime'
|
|
and table_schema != 'public'
|
|
and table_schema != 'information_schema'
|
|
order by table_schema, table_name;
|
|
|
|
+---------------+--------------+------------+-------------+----------------------+---------------+
|
|
| table_catalog | table_schema | table_name | column_name | data_type | semantic_type |
|
|
+---------------+--------------+------------+-------------+----------------------+---------------+
|
|
| greptime | my_db | foo | ts | TimestampMillisecond | TIMESTAMP |
|
|
+---------------+--------------+------------+-------------+----------------------+---------------+
|
|
|
|
use public;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop schema my_db;
|
|
|
|
Error: 1001(Unsupported), SQL statement is not supported: drop schema my_db;, keyword: schema
|
|
|