← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/show_check.result

Add in new show work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/show_check.result
95
95
Name    Engine  Version 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 Plugin_name
96
96
show databases;
97
97
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
98
 
def     information_schema      old_schemata    OLD_SCHEMATA    SCHEMA_NAME     Database        8       256     18      N       1       0       45
 
98
def     data_dictionary schema_names    SCHEMA_NAMES    SCHEMA_NAME     Database        8       256     18      N       1       0       45
99
99
Database
100
100
information_schema
101
101
mysql
102
102
test
103
103
show databases like "test%";
104
104
Catalog Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
105
 
def     information_schema      old_schemata    OLD_SCHEMATA    SCHEMA_NAME     Database (test%)        8       256     4       N       1       0       45
 
105
def     data_dictionary schema_names    SCHEMA_NAMES    SCHEMA_NAME     Database (test%)        8       256     4       N       1       0       45
106
106
Database (test%)
107
107
test
108
108
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));
486
486
create table `mysqlttest\1`.`a\b` (a int);
487
487
show tables from `mysqlttest\1`;
488
488
Tables_in_mysqlttest\1
489
 
a\b
490
489
show fields from `mysqlttest\1`.`a\b`;
491
490
Field   Type    Null    Key     Default Extra
492
491
a       int     YES             NULL