← Back to branch summary

~jaypipes/drizzle/replication-to-transaction

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/t/show_temporary_tables.test

  • 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/t/show_temporary_tables.test
 
1
FLUSH STATUS;
 
2
 
 
3
create schema a;
 
4
use a;
 
5
create temporary table a (a int) engine=memory;
 
6
insert into a values (1), (2), (3);
 
7
select * from data_dictionary.show_temporary_tables;
 
8
 
 
9
create schema b;
 
10
use b;
 
11
create temporary table a (a int);
 
12
create temporary table b (a int);
 
13
 
 
14
insert into a select * from a.a;
 
15
insert into b select * from a.a;
 
16
 
 
17
select * from a;
 
18
select * from b;
 
19
 
 
20
select * from data_dictionary.show_temporary_tables;
 
21
 
 
22
drop schema a;
 
23
select * from data_dictionary.show_temporary_tables;
 
24
 
 
25
drop schema b;
 
26
select * from data_dictionary.show_temporary_tables;