26
26
test.t1 check status OK
27
27
show index from t1;
28
28
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
29
def data_dictionary show_indexes SHOW_INDEXES Table Table 8 256 2 N 1 0 45
29
def data_dictionary show_indexes SHOW_INDEXES Table Table 8 1024 2 N 1 0 45
30
30
def data_dictionary show_indexes SHOW_INDEXES Unique Unique 8 20 5 N 1 0 45
31
def data_dictionary show_indexes SHOW_INDEXES Key_name Key_name 8 256 7 N 1 0 45
31
def data_dictionary show_indexes SHOW_INDEXES Key_name Key_name 8 1024 7 N 1 0 45
32
32
def data_dictionary show_indexes SHOW_INDEXES Seq_in_index Seq_in_index 5 20 1 N 32769 0 63
33
def data_dictionary show_indexes SHOW_INDEXES Column_name Column_name 8 256 1 N 1 0 45
33
def data_dictionary show_indexes SHOW_INDEXES Column_name Column_name 8 1024 1 N 1 0 45
34
34
Table Unique Key_name Seq_in_index Column_name
35
35
t1 TRUE PRIMARY 1 a
48
48
-- after Bug#29394 is implemented.
49
49
show variables like "server_id%";
50
50
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
51
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_NAME Variable_name 8 256 9 N 1 0 45
51
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_NAME Variable_name 8 1024 9 N 1 0 45
52
52
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_VALUE Value 8 4096 1 N 1 0 45
53
53
Variable_name Value
55
55
show variables like "SERVER_id%";
56
56
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
57
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_NAME Variable_name 8 256 9 N 1 0 45
57
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_NAME Variable_name 8 1024 9 N 1 0 45
58
58
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_VALUE Value 8 4096 1 N 1 0 45
59
59
Variable_name Value
61
61
show variables like "this_doesn't_exists%";
62
62
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
63
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_NAME Variable_name 8 256 0 N 1 0 45
63
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_NAME Variable_name 8 1024 0 N 1 0 45
64
64
def data_dictionary session_variables SESSION_VARIABLES VARIABLE_VALUE Value 8 4096 0 N 1 0 45
65
65
Variable_name Value
66
66
show table status from test like "this_doesn't_exists%";
67
67
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
68
68
def data_dictionary show_table_status SHOW_TABLE_STATUS Session Session 5 20 0 N 32769 0 63
69
def data_dictionary show_table_status SHOW_TABLE_STATUS Schema Schema 8 256 0 N 1 0 45
70
def data_dictionary show_table_status SHOW_TABLE_STATUS Name Name 8 256 0 N 1 0 45
71
def data_dictionary show_table_status SHOW_TABLE_STATUS Type Type 8 256 0 N 1 0 45
72
def data_dictionary show_table_status SHOW_TABLE_STATUS Engine Engine 8 256 0 N 1 0 45
73
def data_dictionary show_table_status SHOW_TABLE_STATUS Version Version 8 256 0 N 1 0 45
74
def data_dictionary show_table_status SHOW_TABLE_STATUS Rows Rows 8 256 0 N 1 0 45
75
def data_dictionary show_table_status SHOW_TABLE_STATUS Avg_row_length Avg_row_length 8 256 0 N 1 0 45
76
def data_dictionary show_table_status SHOW_TABLE_STATUS Table_size Table_size 8 256 0 N 1 0 45
77
def data_dictionary show_table_status SHOW_TABLE_STATUS Auto_increment Auto_increment 8 256 0 N 1 0 45
69
def data_dictionary show_table_status SHOW_TABLE_STATUS Schema Schema 8 1024 0 N 1 0 45
70
def data_dictionary show_table_status SHOW_TABLE_STATUS Name Name 8 1024 0 N 1 0 45
71
def data_dictionary show_table_status SHOW_TABLE_STATUS Type Type 8 1024 0 N 1 0 45
72
def data_dictionary show_table_status SHOW_TABLE_STATUS Engine Engine 8 1024 0 N 1 0 45
73
def data_dictionary show_table_status SHOW_TABLE_STATUS Version Version 8 1024 0 N 1 0 45
74
def data_dictionary show_table_status SHOW_TABLE_STATUS Rows Rows 8 1024 0 N 1 0 45
75
def data_dictionary show_table_status SHOW_TABLE_STATUS Avg_row_length Avg_row_length 8 1024 0 N 1 0 45
76
def data_dictionary show_table_status SHOW_TABLE_STATUS Table_size Table_size 8 1024 0 N 1 0 45
77
def data_dictionary show_table_status SHOW_TABLE_STATUS Auto_increment Auto_increment 8 1024 0 N 1 0 45
78
78
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment
80
80
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
81
def data_dictionary show_schemas SHOW_SCHEMAS SCHEMA_NAME Database 8 256 18 N 1 0 45
81
def data_dictionary show_schemas SHOW_SCHEMAS SCHEMA_NAME Database 8 1024 18 N 1 0 45
87
87
show databases like "test%";
88
88
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
89
def data_dictionary show_schemas SHOW_SCHEMAS SCHEMA_NAME Database (test%) 8 256 4 N 1 0 45
89
def data_dictionary show_schemas SHOW_SCHEMAS SCHEMA_NAME Database (test%) 8 1024 4 N 1 0 45
92
92
create table t1 (f1 int not null, f2 int not null, f3 int not null, f4 int not null, primary key(f1,f2,f3,f4));
447
447
show index from t1;
448
448
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
449
def data_dictionary show_indexes SHOW_INDEXES Table Table 8 256 2 N 1 0 45
449
def data_dictionary show_indexes SHOW_INDEXES Table Table 8 1024 2 N 1 0 45
450
450
def data_dictionary show_indexes SHOW_INDEXES Unique Unique 8 20 4 N 1 0 45
451
def data_dictionary show_indexes SHOW_INDEXES Key_name Key_name 8 256 7 N 1 0 45
451
def data_dictionary show_indexes SHOW_INDEXES Key_name Key_name 8 1024 7 N 1 0 45
452
452
def data_dictionary show_indexes SHOW_INDEXES Seq_in_index Seq_in_index 5 20 1 N 32769 0 63
453
def data_dictionary show_indexes SHOW_INDEXES Column_name Column_name 8 256 6 N 1 0 45
453
def data_dictionary show_indexes SHOW_INDEXES Column_name Column_name 8 1024 6 N 1 0 45
454
454
Table Unique Key_name Seq_in_index Column_name
455
455
t1 TRUE PRIMARY 1 field1