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

     1  SELECT table_catalog,table_schema,table_name,table_type from `information_schema`.`tables` where table_name = 'mo_tables';
     2  SELECT * FROM `information_schema`.`character_sets` LIMIT 0,1000;
     3  SELECT * FROM `information_schema`.`columns` where TABLE_NAME = 'mo_tables' order by ORDINAL_POSITION LIMIT 2;
     4  SELECT * FROM `information_schema`.`key_column_usage` 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  -- keywords:collation
    10  SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, NON_UNIQUE, NULL AS INDEX_QUALIFIER, INDEX_NAME,3 AS TYPE, SEQ_IN_INDEX AS ORDINAL_POSITION, COLUMN_NAME,COLLATION AS ASC_OR_DESC, CARDINALITY, 0 AS PAGES, NULL AS FILTER_CONDITION FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'procs_priv' ORDER BY NON_UNIQUE, INDEX_NAME, SEQ_IN_INDEX limit 1;
    11  SELECT * FROM `mysql`.`columns_priv` LIMIT 0,1000;
    12  SELECT * FROM `mysql`.`db` LIMIT 0,1000;
    13  SELECT * FROM `mysql`.`procs_priv` LIMIT 0,1000;
    14  SELECT * FROM `mysql`.`tables_priv` LIMIT 0,1000;
    15  SELECT * FROM `mysql`.`user` LIMIT 0,1000;
    16  use mysql;
    17  show tables;
    18  show columns from `user`;
    19  show columns from `db`;
    20  show columns from `procs_priv`;
    21  show columns from `columns_priv`;
    22  show columns from `tables_priv`;
    23  use information_schema;
    24  show tables;
    25  show columns from `KEY_COLUMN_USAGE`;
    26  show columns from `COLUMNS`;
    27  show columns from `PROFILING`;
    28  show columns from `USER_PRIVILEGES`;
    29  show columns from `SCHEMATA`;
    30  show columns from `CHARACTER_SETS`;
    31  show columns from `TRIGGERS`;
    32  show columns from `TABLES`;
    33  show columns from `PARTITIONS`;
    34  drop database if exists test;
    35  create database test;
    36  use test;
    37  drop table if exists t2;
    38  create table t2(b int, a int);
    39  desc t2;
    40  drop table t2;
    41  drop database test;