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;