github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/database/system_table.sql (about)

     1  SELECT * FROM `information_schema`.`character_sets` LIMIT 0,1000;
     2  SELECT * FROM `information_schema`.`columns` where TABLE_NAME = 'mo_tables' order by ORDINAL_POSITION LIMIT 2;
     3  SELECT * FROM `information_schema`.`key_column_usage` LIMIT 0,1000;
     4  SELECT * FROM `information_schema`.`PROCESSLIST` LIMIT 0,1000;
     5  SELECT * FROM `information_schema`.`profiling` LIMIT 0,1000;
     6  SELECT * FROM `information_schema`.`schemata` where schema_name = 'information_schema';
     7  SELECT * FROM `information_schema`.`triggers` LIMIT 0,1000;
     8  SELECT * FROM `information_schema`.`user_privileges` LIMIT 0,1000;
     9  SELECT * FROM `mysql`.`columns_priv` LIMIT 0,1000;
    10  SELECT * FROM `mysql`.`db` LIMIT 0,1000;
    11  SELECT * FROM `mysql`.`procs_priv` LIMIT 0,1000;
    12  SELECT * FROM `mysql`.`tables_priv` LIMIT 0,1000;
    13  SELECT * FROM `mysql`.`user` LIMIT 0,1000;
    14  use mysql;
    15  show tables;
    16  show columns from `user`;
    17  show columns from `db`;
    18  show columns from `procs_priv`;
    19  show columns from `columns_priv`;
    20  show columns from `tables_priv`;
    21  use information_schema;
    22  show tables;
    23  show columns from `KEY_COLUMN_USAGE`;
    24  show columns from `COLUMNS`;
    25  show columns from `PROFILING`;
    26  show columns from `PROCESSLIST`;
    27  show columns from `USER_PRIVILEGES`;
    28  show columns from `SCHEMATA`;
    29  show columns from `CHARACTER_SETS`;
    30  show columns from `TRIGGERS`;
    31  show columns from `TABLES`;