← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/r/show_table_status.result

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
Merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/r/show_table_status.result
 
1
FLUSH TABLES;
 
2
create schema schema_a;
 
3
use schema_a;
 
4
create table a (a int);
 
5
insert into a values (1), (2), (3);
 
6
create temporary table a (a int) engine=memory;
 
7
show table status;
 
8
Session Schema  Name    Type    Engine  Version Rows    Avg_row_length  Table_size      Auto_increment
 
9
#       schema_a        a       STANDARD        InnoDB  #       #       #       #       #
 
10
#       schema_a        a       TEMPORARY       MEMORY  #       #       #       #       #
 
11
create schema schema_b;
 
12
use schema_b;
 
13
create table a (a int);
 
14
create table b (a int);
 
15
insert into a select * from schema_a.a;
 
16
insert into b select * from schema_a.a;
 
17
select * from a;
 
18
a
 
19
select * from b;
 
20
a
 
21
show table status;
 
22
Session Schema  Name    Type    Engine  Version Rows    Avg_row_length  Table_size      Auto_increment
 
23
#       schema_b        a       STANDARD        InnoDB  #       #       #       #       #
 
24
#       schema_b        b       STANDARD        InnoDB  #       #       #       #       #
 
25
create temporary table a (a int);
 
26
insert into b select * from schema_a.a;
 
27
show table status;
 
28
Session Schema  Name    Type    Engine  Version Rows    Avg_row_length  Table_size      Auto_increment
 
29
#       schema_b        a       STANDARD        InnoDB  #       #       #       #       #
 
30
#       schema_b        a       TEMPORARY       InnoDB  #       #       #       #       #
 
31
#       schema_b        b       STANDARD        InnoDB  #       #       #       #       #
 
32
drop schema schema_a;
 
33
show table status;
 
34
Session Schema  Name    Type    Engine  Version Rows    Avg_row_length  Table_size      Auto_increment
 
35
#       schema_b        a       STANDARD        InnoDB  #       #       #       #       #
 
36
#       schema_b        a       TEMPORARY       InnoDB  #       #       #       #       #
 
37
#       schema_b        b       STANDARD        InnoDB  #       #       #       #       #
 
38
drop schema schema_b;
 
39
show table status;
 
40
Session Schema  Name    Type    Engine  Version Rows    Avg_row_length  Table_size      Auto_increment
 
41
#       data_dictionary show_table_status       FUNCTION        FunctionEngine  #       #       #       #       #