github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/show/show.result (about) 1 drop database if exists test01; 2 create database test01; 3 use test01; 4 create table tt(col2 float comment '"%$^&*()_+@!\''); 5 show create table tt; 6 Table Create Table 7 tt CREATE TABLE `tt` (\n`col2` FLOAT DEFAULT NULL COMMENT '"%$^&*()_+@!'''\n) 8 drop table tt; 9 create table t1 (id int not null, str char(10),name varchar(10)); 10 create table t2 (a int); 11 show tables; 12 Tables_in_test01 13 t1 14 t2 15 show tables from test01; 16 Tables_in_test01 17 t1 18 t2 19 show columns from t1; 20 Field Type Null Key Default Extra Comment 21 id INT(32) NO null 22 str CHAR(10) YES null 23 name VARCHAR(10) YES null 24 show full columns from t1; 25 Field Type Collation Null Key Default Extra Privileges Comment 26 id INT(32) null NO null select,insert,update,references 27 str CHAR(10) null YES null select,insert,update,references 28 name VARCHAR(10) null YES null select,insert,update,references 29 show full columns from t1 like '%'; 30 Field Type Collation Null Key Default Extra Privileges Comment 31 id INT(32) null NO null select,insert,update,references 32 str CHAR(10) null YES null select,insert,update,references 33 name VARCHAR(10) null YES null select,insert,update,references 34 show full columns from t1 where Field ='id'; 35 Field Type Collation Null Key Default Extra Privileges Comment 36 id INT(32) null NO null select,insert,update,references 37 drop database if exists test01; 38 show charset; 39 Charset Description Default collation Maxlen 40 drop database if exists test02; 41 create database test02; 42 use test02; 43 create table t1(a tinyint, b smallint, c int, d bigint); 44 create database test01; 45 use test01; 46 show columns from test02.t1; 47 Field Type Null Key Default Extra Comment 48 a TINYINT(8) YES null 49 b SMALLINT(16) YES null 50 c INT(32) YES null 51 d BIGINT(64) YES null 52 create database if not exists db11111111111; 53 show table status from db11111111111; 54 Name Engine Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment 55 drop database db11111111111; 56 show variables where value = 'MatrixOne'; 57 Variable_name Value 58 version_comment MatrixOne 59 select privilege_name, obj_type, privilege_level from mo_catalog.mo_role_privs where privilege_name = 'values'; 60 privilege_name obj_type privilege_level 61 values table *.* 62 show grants; 63 Grants for dump@localhost 64 GRANT create account ON account `dump`@`localhost` 65 GRANT drop account ON account `dump`@`localhost` 66 GRANT alter account ON account `dump`@`localhost` 67 GRANT create user ON account `dump`@`localhost` 68 GRANT drop user ON account `dump`@`localhost` 69 GRANT alter user ON account `dump`@`localhost` 70 GRANT create role ON account `dump`@`localhost` 71 GRANT drop role ON account `dump`@`localhost` 72 GRANT create database ON account `dump`@`localhost` 73 GRANT drop database ON account `dump`@`localhost` 74 GRANT show databases ON account `dump`@`localhost` 75 GRANT connect ON account `dump`@`localhost` 76 GRANT manage grants ON account `dump`@`localhost` 77 GRANT account all ON account `dump`@`localhost` 78 GRANT upgrade account ON account `dump`@`localhost` 79 GRANT show tables ON database * `dump`@`localhost` 80 GRANT create table ON database * `dump`@`localhost` 81 GRANT create view ON database * `dump`@`localhost` 82 GRANT drop table ON database * `dump`@`localhost` 83 GRANT drop view ON database * `dump`@`localhost` 84 GRANT alter table ON database * `dump`@`localhost` 85 GRANT alter view ON database * `dump`@`localhost` 86 GRANT database all ON database * `dump`@`localhost` 87 GRANT database ownership ON database * `dump`@`localhost` 88 GRANT select ON table *.* `dump`@`localhost` 89 GRANT insert ON table *.* `dump`@`localhost` 90 GRANT update ON table *.* `dump`@`localhost` 91 GRANT truncate ON table *.* `dump`@`localhost` 92 GRANT delete ON table *.* `dump`@`localhost` 93 GRANT reference ON table *.* `dump`@`localhost` 94 GRANT index ON table *.* `dump`@`localhost` 95 GRANT table all ON table *.* `dump`@`localhost` 96 GRANT table ownership ON table *.* `dump`@`localhost` 97 GRANT values ON table *.* `dump`@`localhost` 98 GRANT connect ON account `dump`@`localhost` 99 show grants for 'root'@'localhost'; 100 Grants for root@localhost 101 GRANT create account ON account `root`@`localhost` 102 GRANT drop account ON account `root`@`localhost` 103 GRANT alter account ON account `root`@`localhost` 104 GRANT create user ON account `root`@`localhost` 105 GRANT drop user ON account `root`@`localhost` 106 GRANT alter user ON account `root`@`localhost` 107 GRANT create role ON account `root`@`localhost` 108 GRANT drop role ON account `root`@`localhost` 109 GRANT create database ON account `root`@`localhost` 110 GRANT drop database ON account `root`@`localhost` 111 GRANT show databases ON account `root`@`localhost` 112 GRANT connect ON account `root`@`localhost` 113 GRANT manage grants ON account `root`@`localhost` 114 GRANT account all ON account `root`@`localhost` 115 GRANT upgrade account ON account `root`@`localhost` 116 GRANT show tables ON database * `root`@`localhost` 117 GRANT create table ON database * `root`@`localhost` 118 GRANT create view ON database * `root`@`localhost` 119 GRANT drop table ON database * `root`@`localhost` 120 GRANT drop view ON database * `root`@`localhost` 121 GRANT alter table ON database * `root`@`localhost` 122 GRANT alter view ON database * `root`@`localhost` 123 GRANT database all ON database * `root`@`localhost` 124 GRANT database ownership ON database * `root`@`localhost` 125 GRANT select ON table *.* `root`@`localhost` 126 GRANT insert ON table *.* `root`@`localhost` 127 GRANT update ON table *.* `root`@`localhost` 128 GRANT truncate ON table *.* `root`@`localhost` 129 GRANT delete ON table *.* `root`@`localhost` 130 GRANT reference ON table *.* `root`@`localhost` 131 GRANT index ON table *.* `root`@`localhost` 132 GRANT table all ON table *.* `root`@`localhost` 133 GRANT table ownership ON table *.* `root`@`localhost` 134 GRANT values ON table *.* `root`@`localhost` 135 GRANT connect ON account `root`@`localhost` 136 show grants for 'test'@'localhost'; 137 Grants for test@localhost 138 create role role1; 139 grant all on table *.* to role1; 140 grant create table, drop table on database *.* to role1; 141 create user user1 identified by 'pass1'; 142 grant role1 to user1; 143 show grants for 'user1'@'localhost'; 144 Grants for user1@localhost 145 GRANT table all ON table *.* `user1`@`localhost` 146 GRANT create table ON database *.* `user1`@`localhost` 147 GRANT drop table ON database *.* `user1`@`localhost` 148 GRANT connect ON account `user1`@`localhost` 149 drop user user1; 150 drop role role1; 151 create database if not exists test03; 152 use test03; 153 drop view if exists v1; 154 drop table if exists t1; 155 create table t1(a int, b int); 156 insert into t1 values(1,1); 157 create view v1 as select * from t1; 158 show full tables; 159 Tables_in_test03 Table_type 160 t1 BASE TABLE 161 v1 VIEW 162 show full tables from test03; 163 Tables_in_test03 Table_type 164 t1 BASE TABLE 165 v1 VIEW 166 show full tables from `1;drop table t1;`; 167 invalid database 1;drop table t1; 168 show tables like `1;drop table t1;`; 169 invalid input: column 1;drop table t1; does not exist 170 show full tables from "1;drop table t1;"; 171 SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 40 near " "1;drop table t1;";"; 172 show create database `1;drop table t1;`; 173 invalid database 1;drop table t1; 174 show create table `1;drop table t1;`; 175 no such table test03.1;drop table t1; 176 show columns from `1;drop table t1;`; 177 no such table test03.1;drop table t1; 178 show table status from `1;drop table t1;`; 179 invalid database 1;drop table t1; 180 show index from `1;drop table t1;`; 181 no such table test03.1;drop table t1; 182 show variables like `1;drop table t1;`; 183 Variable_name Value 184 select * from t1; 185 a b 186 1 1 187 show collation like 'utf8mb4_general_ci'; 188 Collation Charset Id Default Compiled Sortlen Pad_attribute 189 utf8mb4_general_ci utf8mb4 45 Yes 1 PAD SPACE 190 show collation like 'utf8mb4_general_ci%'; 191 Collation Charset Id Default Compiled Sortlen Pad_attribute 192 utf8mb4_general_ci utf8mb4 45 Yes 1 PAD SPACE 193 show collation where Charset='utf8mb4'and Collation ='utf8mb4_general_ci'; 194 Collation Charset Id Default Compiled Sortlen Pad_attribute 195 utf8mb4_general_ci utf8mb4 45 Yes 1 PAD SPACE 196 show variables like 'sql_safe_updates'; 197 Variable_name Value 198 sql_safe_updates 0 199 set sql_safe_updates=1; 200 show variables like 'sql_safe_updates'; 201 Variable_name Value 202 sql_safe_updates 1 203 set autocommit = on; 204 show variables like 'autocommit'; 205 Variable_name Value 206 autocommit on 207 set autocommit = off; 208 show variables like 'autocommit'; 209 Variable_name Value 210 autocommit off 211 set autocommit = 1; 212 show variables like 'autocommit'; 213 Variable_name Value 214 autocommit on 215 drop table if exists t1; 216 create table t1(c1 int primary key auto_increment,c2 tinyint not null default 4,c3 smallint,c4 bigint,c5 tinyint unsigned,c6 smallint unsigned,c7 int unsigned,c8 bigint unsigned,c9 float,c10 double,c11 date,c12 datetime,c13 timestamp on update current_timestamp,c14 char,c15 varchar default 'q',c16 json,c17 decimal,c18 text,c19 blob,c20 uuid); 217 show create table t1; 218 Table Create Table 219 t1 CREATE TABLE `t1` (\n`c1` INT NOT NULL AUTO_INCREMENT,\n`c2` TINYINT DEFAULT 4,\n`c3` SMALLINT DEFAULT NULL,\n`c4` BIGINT DEFAULT NULL,\n`c5` TINYINT UNSIGNED DEFAULT NULL,\n`c6` SMALLINT UNSIGNED DEFAULT NULL,\n`c7` INT UNSIGNED DEFAULT NULL,\n`c8` BIGINT UNSIGNED DEFAULT NULL,\n`c9` FLOAT DEFAULT NULL,\n`c10` DOUBLE DEFAULT NULL,\n`c11` DATE DEFAULT NULL,\n`c12` DATETIME DEFAULT NULL,\n`c13` TIMESTAMP DEFAULT NULL ON UPDATE current_timestamp(),\n`c14` CHAR(1) DEFAULT NULL,\n`c15` VARCHAR(65535) DEFAULT 'q',\n`c16` JSON DEFAULT NULL,\n`c17` DECIMAL(38,0) DEFAULT NULL,\n`c18` TEXT DEFAULT NULL,\n`c19` BLOB DEFAULT NULL,\n`c20` UUID DEFAULT NULL,\nPRIMARY KEY (`c1`)\n) 220 SHOW TRIGGERS; 221 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 222 SHOW TRIGGERS like '*%'; 223 Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation 224 use mo_catalog; 225 show tables; 226 Tables_in_mo_catalog 227 mo_account 228 mo_cache 229 mo_columns 230 mo_configurations 231 mo_database 232 mo_foreign_keys 233 mo_indexes 234 mo_locks 235 mo_mysql_compatibility_mode 236 mo_pubs 237 mo_role 238 mo_role_grant 239 mo_role_privs 240 mo_sessions 241 mo_snapshots 242 mo_stages 243 mo_stored_procedure 244 mo_table_partitions 245 mo_tables 246 mo_transactions 247 mo_upgrade 248 mo_upgrade_tenant 249 mo_user 250 mo_user_defined_function 251 mo_user_grant 252 mo_variables 253 mo_version 254 show table_number from mo_catalog; 255 Number of tables in mo_catalog 256 27 257 show column_number from mo_database; 258 Number of columns in mo_database 259 9 260 show column_number from hdjshdj; 261 no such table mo_catalog.hdjshdj 262 drop database if exists test01; 263 create database test01; 264 use test01; 265 create table t(a int, b int); 266 insert into t values(1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6); 267 show table_values from t; 268 max(a) min(a) max(b) min(b) 269 6 1 6 1 270 drop table t; 271 show node list; 272 1 273 show locks; 274 1 275 create role role1; 276 grant all on table *.* to role1; 277 grant create table, drop table on database *.* to role1; 278 create user user1 identified by 'pass1'; 279 grant role1 to user1; 280 show grants for 'user1'@'localhost'; 281 Grants for user1@localhost 282 GRANT table all ON table *.* `user1`@`localhost` 283 GRANT create table ON database *.* `user1`@`localhost` 284 GRANT drop table ON database *.* `user1`@`localhost` 285 GRANT connect ON account `user1`@`localhost` 286 show grants for ROLE role1; 287 Grants for role1 288 GRANT table all ON table *.* `role1` 289 GRANT create table ON database *.* `role1` 290 GRANT drop table ON database *.* `role1` 291 drop user user1; 292 drop role role1; 293 drop database if exists test01; 294 create database test01; 295 use test01; 296 create table t1(a int unique key, b int, c int); 297 show table_number from test01; 298 Number of tables in test01 299 1 300 drop table t1; 301 drop database if exists test01; 302 create database test01; 303 use test01; 304 create table t(a int, b int, c json); 305 insert into t values(1, 1, '{"a":1,"b":2,"c":3}'), (2, 2, '{"a":1,"b":2,"c":3}'), (3, 3, '{"a":1,"b":2,"c":3}'), (4, 4, '{"a":1,"b":2,"c":3}'), (5, 5, '{"a":1,"b":2,"c":3}'), (6, 6, '{"a":1,"b":2,"c":3}'); 306 show table_values from t; 307 max(a) min(a) max(b) min(b) max(c) min(c) 308 6 1 6 1 null null 309 drop table t; 310 create database `.quote`; 311 show tables from `.quote`; 312 Tables_in_.quote 313 drop database if exists `.quote`; 314 drop database if exists showDB; 315 create database showDB; 316 use showDB; 317 create table a (a int,b int); 318 create view va as select a from a; 319 begin; 320 show create table a; 321 Table Create Table 322 a CREATE TABLE `a` (\n`a` INT DEFAULT NULL,\n`b` INT DEFAULT NULL\n) 323 show create table va; 324 View Create View character_set_client collation_connection 325 va create view va as select a from a; utf8mb4 utf8mb4_general_ci 326 show create view va; 327 View Create View character_set_client collation_connection 328 va create view va as select a from a; utf8mb4 utf8mb4_general_ci 329 show collation like 'utf8mb4_general_ci'; 330 Collation Charset Id Default Compiled Sortlen Pad_attribute 331 utf8mb4_general_ci utf8mb4 45 Yes 1 PAD SPACE 332 show collation like 'utf8mb4_general_ci%'; 333 Collation Charset Id Default Compiled Sortlen Pad_attribute 334 utf8mb4_general_ci utf8mb4 45 Yes 1 PAD SPACE 335 rollback; 336 drop database if exists showDb; 337 DROP DATABASE IF EXISTS test; 338 CREATE DATABASE test; 339 USE test; 340 DROP TABLE IF EXISTS show_01; 341 CREATE TABLE show_01(sname varchar(30),id int); 342 show INDEX FROM show_01; 343 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 344 DROP TABLE show_01; 345 DROP TABLE IF EXISTS show_02; 346 CREATE TABLE show_02 ( 347 h1 varchar(16) NOT NULL default '', 348 u1 varchar(16) NOT NULL default '', 349 PRIMARY KEY (h1,u1) 350 ); 351 show INDEX FROM show_02; 352 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 353 show_02 0 PRIMARY 1 h1 A 0 NULL NULL YES NULL 354 show_02 0 PRIMARY 2 u1 A 0 NULL NULL YES NULL 355 DROP TABLE show_02; 356 DROP TABLE IF EXISTS show_03; 357 CREATE TABLE show_03(a int, b int); 358 CREATE unique index x ON show_03(a) comment 'x'; 359 show CREATE table show_03; 360 Table Create Table 361 show_03 CREATE TABLE `show_03` (\n`a` INT DEFAULT NULL,\n`b` INT DEFAULT NULL,\nUNIQUE KEY `x` (`a`) COMMENT 'x'\n) 362 show INDEX FROM show_03; 363 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 364 show_03 0 x 1 a A 0 NULL NULL YES x YES NULL 365 DROP TABLE show_03; 366 CREATE TABLE show_04(a int, b int, unique key(a)); 367 show CREATE TABLE show_04; 368 Table Create Table 369 show_04 CREATE TABLE `show_04` (\n`a` INT DEFAULT NULL,\n`b` INT DEFAULT NULL,\nUNIQUE KEY `a` (`a`)\n) 370 CREATE INDEX b ON show_04(b); 371 show INDEX FROM show_04; 372 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 373 show_04 0 a 1 a A 0 NULL NULL YES YES NULL 374 show_04 1 b 1 b A 0 NULL NULL YES YES NULL 375 DROP TABLE show_04; 376 DROP DATABASE test; 377 create database test; 378 use test; 379 drop table if exists t1; 380 create table t1(a int, b int, c int, primary key(a)); 381 show columns from t1; 382 Field Type Null Key Default Extra Comment 383 a INT(32) NO PRI null 384 b INT(32) YES null 385 c INT(32) YES null 386 drop table t1; 387 drop table if exists t2; 388 create table t2(a int, b int, c int, primary key(a, b)); 389 show columns from t2; 390 Field Type Null Key Default Extra Comment 391 a INT(32) NO PRI null 392 b INT(32) NO PRI null 393 c INT(32) YES null 394 drop table t2; 395 drop table if exists t3; 396 create table t3(a int, b int, c int, primary key(a, b, c)); 397 show columns from t3; 398 Field Type Null Key Default Extra Comment 399 a INT(32) NO PRI null 400 b INT(32) NO PRI null 401 c INT(32) NO PRI null 402 drop table t3; 403 drop database test; 404 DROP DATABASE test; 405 Can't drop database 'test'; database doesn't exist 406 create database test; 407 use test; 408 drop table if exists t1; 409 CREATE TABLE t1 ( 410 col1 INT NOT NULL PRIMARY KEY, 411 col2 DATE NOT NULL, 412 col3 INT NOT NULL, 413 col4 INT NOT NULL, 414 INDEX (col2,col3) 415 ); 416 show index from t1; 417 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 418 t1 1 col2 1 col2 A 0 NULL NULL YES NULL 419 t1 1 col2 2 col3 A 0 NULL NULL YES NULL 420 t1 0 PRIMARY 1 col1 A 0 NULL NULL YES NULL 421 drop table t1; 422 drop table if exists t2; 423 CREATE TABLE t2 ( 424 col1 INT NOT NULL PRIMARY KEY, 425 col2 DATE NOT NULL UNIQUE KEY, 426 col3 INT NOT NULL, 427 col4 INT NOT NULL 428 ); 429 show index from t2; 430 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 431 t2 0 col2 1 col2 A 0 NULL NULL YES NULL 432 t2 0 PRIMARY 1 col1 A 0 NULL NULL YES NULL 433 drop table t2; 434 drop table if exists t3; 435 CREATE TABLE t3 ( 436 col1 INT NOT NULL PRIMARY KEY, 437 col2 DATE NOT NULL, 438 col3 INT NOT NULL, 439 col4 INT NOT NULL, 440 UNIQUE KEY (col1), 441 UNIQUE KEY (col1, col3) 442 ); 443 show index from t3; 444 Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Index_params Visible Expression 445 t3 0 col1 1 col1 A 0 NULL NULL YES NULL 446 t3 0 col1_2 1 col1 A 0 NULL NULL YES NULL 447 t3 0 col1_2 2 col3 A 0 NULL NULL YES NULL 448 t3 0 PRIMARY 1 col1 A 0 NULL NULL YES NULL 449 drop table t3; 450 drop database test; 451 drop database if exists test; 452 create database test; 453 use test; 454 SHOW CREATE TABLE information_schema.columns; 455 View Create View character_set_client collation_connection 456 columns CREATE VIEW information_schema.COLUMNS AS select 'def' as TABLE_CATALOG,att_database as TABLE_SCHEMA,att_relname AS TABLE_NAME,attname AS COLUMN_NAME,attnum AS ORDINAL_POSITION,mo_show_visible_bin(att_default,1) as COLUMN_DEFAULT,(case when attnotnull != 0 then 'NO' else 'YES' end) as IS_NULLABLE,mo_show_visible_bin(atttyp,2) as DATA_TYPE,internal_char_length(atttyp) AS CHARACTER_MAXIMUM_LENGTH,internal_char_size(atttyp) AS CHARACTER_OCTET_LENGTH,internal_numeric_precision(atttyp) AS NUMERIC_PRECISION,internal_numeric_scale(atttyp) AS NUMERIC_SCALE,internal_datetime_scale(atttyp) AS DATETIME_PRECISION,(case internal_column_character_set(atttyp) WHEN 0 then 'utf8' WHEN 1 then 'utf8' else NULL end) AS CHARACTER_SET_NAME,(case internal_column_character_set(atttyp) WHEN 0 then 'utf8_bin' WHEN 1 then 'utf8_bin' else NULL end) AS COLLATION_NAME,mo_show_visible_bin(atttyp,3) as COLUMN_TYPE,case when att_constraint_type = 'p' then 'PRI' else '' end as COLUMN_KEY,case when att_is_auto_increment = 1 then 'auto_increment' else '' end as EXTRA,'select,insert,update,references' as `PRIVILEGES`,att_comment as COLUMN_COMMENT,cast('' as varchar(500)) as GENERATION_EXPRESSION,if(true, NULL, 0) as SRS_ID from mo_catalog.mo_columns where account_id = current_account_id() and att_relname!='mo_increment_columns' and att_relname not like '__mo_cpkey_%' and attname != '__mo_rowid' and att_relname not like '\%!\%%\%!\%%' utf8mb4 utf8mb4_general_ci 457 drop database test;