~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
drop table if exists t0,t1,t2,t3,t4;
2
drop table if exists t0,t5,t6,t7,t8,t9,t1_1,t1_2,t9_1,t9_2;
3
create table t0 SELECT 1,"table 1";
4
create table t2 SELECT 2,"table 2";
5
create table t3 SELECT 3,"table 3";
6
rename table t0 to t1;
7
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
8
select * from t1;
9
3	table 3
10
3	table 3
11
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
12
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
13
select * from t1;
14
1	table 1
15
1	table 1
16
rename table t1 to t2;
17
Got one of the listed errors
18
rename table t1 to t1;
19
Got one of the listed errors
20
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t2;
21
Got one of the listed errors
22
show tables like "t_";
23
Tables_in_test (t_)
24
t1
25
t2
26
t3
27
rename table t3 to t1, t2 to t3, t1 to t2, t4 to t1;
28
Got one of the listed errors
29
rename table t3 to t4, t5 to t3, t1 to t2, t4 to t1;
673.3.12 by Stewart Smith
fix RENAME TABLE
30
ERROR 42S02: Table 'test.t5' doesn't exist
1 by brian
clean slate
31
select * from t1;
32
1	table 1
33
1	table 1
34
select * from t2;
35
2	table 2
36
2	table 2
37
select * from t3;
38
3	table 3
39
3	table 3
40
drop table if exists t1,t2,t3,t4;
41
Warnings:
42
Note	1051	Unknown table 't4'