← Back to branch summary

~jaypipes/drizzle/replication-to-transaction

« back to all changes in this revision

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

  • Committer: Brian Aker
  • Date: 2010-03-09 22:58:27 UTC
  • mfrom: (1320.1.18 build)
  • Revision ID: brian@gaz-20100309225827-7igxztca4lrj3fx3
Merge in show status work.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/r/show_temporary_tables.result
 
1
FLUSH STATUS;
 
2
create schema a;
 
3
use a;
 
4
create temporary table a (a int) engine=memory;
 
5
insert into a values (1), (2), (3);
 
6
select * from data_dictionary.show_temporary_tables;
 
7
TABLE_SCHEMA    TABLE_NAME      RECORDS RECORD_LENGTH   ENGINE
 
8
a       a       0       5       MEMORY
 
9
create schema b;
 
10
use b;
 
11
create temporary table a (a int);
 
12
create temporary table b (a int);
 
13
insert into a select * from a.a;
 
14
insert into b select * from a.a;
 
15
select * from a;
 
16
a
 
17
1
 
18
2
 
19
3
 
20
select * from b;
 
21
a
 
22
1
 
23
2
 
24
3
 
25
select * from data_dictionary.show_temporary_tables;
 
26
TABLE_SCHEMA    TABLE_NAME      RECORDS RECORD_LENGTH   ENGINE
 
27
b       b       3       5       InnoDB
 
28
b       a       3       5       InnoDB
 
29
a       a       3       5       MEMORY
 
30
drop schema a;
 
31
select * from data_dictionary.show_temporary_tables;
 
32
TABLE_SCHEMA    TABLE_NAME      RECORDS RECORD_LENGTH   ENGINE
 
33
b       b       3       5       InnoDB
 
34
b       a       3       5       InnoDB
 
35
drop schema b;
 
36
select * from data_dictionary.show_temporary_tables;
 
37
TABLE_SCHEMA    TABLE_NAME      RECORDS RECORD_LENGTH   ENGINE