github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/show/show4.sql (about)

     1  set global enable_privilege_cache = off;
     2  drop database if exists db;
     3  -- report error: not connect to a database
     4  -- it is hard to get the error "not connect to a database" in bvt.
     5  -- but, you can get it when you are executing them in a mysql shell.
     6  
     7  -- show column_number from t1;
     8  -- show columns from t1;
     9  -- show create table t1;
    10  -- show create view v1;
    11  -- show index from t1;
    12  -- show sequences;
    13  -- show tables;
    14  -- show table status;
    15  -- show table_values from t1;
    16  -- select * from t1;
    17  
    18  -- report error: invalid database
    19  
    20  show column_number from db.t1;
    21  show column_number from t1 from db;
    22  show column_number from db.t1 from db;
    23  
    24  show columns from db.t1;
    25  show columns from t1 from db;
    26  show columns from db.t1 from db;
    27  
    28  show create database db;
    29  show create table db.t1;
    30  show create view db.v1;
    31  
    32  show index from db.t1;
    33  show index from t1 from db;
    34  show index from db.t1 from db;
    35  
    36  show sequences from db;
    37  
    38  show table_number from db;
    39  show tables from db;
    40  
    41  show table status from db;
    42  show table_values from t1 from db;
    43  
    44  use db;
    45  select * from db.t1;
    46  
    47  set global enable_privilege_cache = on;