|
1
by brian
clean slate |
1 |
DROP TABLE IF EXISTS t1, `t``1`, `t 1`; |
2 |
drop view if exists v1; |
|
3 |
drop database if exists client_test_db; |
|
4 |
mysql.columns_priv OK |
|
5 |
mysql.db OK |
|
6 |
mysql.event OK |
|
7 |
mysql.func OK |
|
8 |
mysql.general_log |
|
9 |
note : The storage engine for the table doesn't support optimize |
|
10 |
mysql.help_category OK
|
|
11 |
mysql.help_keyword OK
|
|
12 |
mysql.help_relation OK
|
|
13 |
mysql.help_topic OK
|
|
14 |
mysql.host OK
|
|
15 |
mysql.ndb_binlog_index OK
|
|
16 |
mysql.online_backup OK
|
|
17 |
mysql.online_backup_progress OK
|
|
18 |
mysql.plugin OK
|
|
19 |
mysql.proc OK
|
|
20 |
mysql.procs_priv OK
|
|
21 |
mysql.servers OK
|
|
22 |
mysql.slow_log
|
|
23 |
note : The storage engine for the table doesn't support optimize |
|
24 |
mysql.tables_priv OK |
|
25 |
mysql.time_zone OK |
|
26 |
mysql.time_zone_leap_second OK |
|
27 |
mysql.time_zone_name OK |
|
28 |
mysql.time_zone_transition OK |
|
29 |
mysql.time_zone_transition_type OK |
|
30 |
mysql.user OK |
|
31 |
mysql.columns_priv OK |
|
32 |
mysql.db OK |
|
33 |
mysql.event OK |
|
34 |
mysql.func OK |
|
35 |
mysql.general_log |
|
36 |
note : The storage engine for the table doesn't support optimize |
|
37 |
mysql.help_category OK
|
|
38 |
mysql.help_keyword OK
|
|
39 |
mysql.help_relation OK
|
|
40 |
mysql.help_topic OK
|
|
41 |
mysql.host OK
|
|
42 |
mysql.ndb_binlog_index OK
|
|
43 |
mysql.online_backup OK
|
|
44 |
mysql.online_backup_progress OK
|
|
45 |
mysql.plugin OK
|
|
46 |
mysql.proc OK
|
|
47 |
mysql.procs_priv OK
|
|
48 |
mysql.servers OK
|
|
49 |
mysql.slow_log
|
|
50 |
note : The storage engine for the table doesn't support optimize |
|
51 |
mysql.tables_priv OK |
|
52 |
mysql.time_zone OK |
|
53 |
mysql.time_zone_leap_second OK |
|
54 |
mysql.time_zone_name OK |
|
55 |
mysql.time_zone_transition OK |
|
56 |
mysql.time_zone_transition_type OK |
|
57 |
mysql.user OK |
|
58 |
create table t1 (a int); |
|
59 |
create view v1 as select * from t1; |
|
60 |
test.t1 OK |
|
61 |
test.t1 OK |
|
62 |
drop view v1; |
|
63 |
drop table t1; |
|
64 |
create table `t``1`(a int); |
|
65 |
create table `t 1`(a int); |
|
66 |
test.t 1 OK |
|
67 |
test.t`1 OK |
|
68 |
drop table `t``1`, `t 1`; |
|
69 |
create database d_bug25347;
|
|
70 |
use d_bug25347;
|
|
71 |
create table t_bug25347 (a int);
|
|
72 |
create view v_bug25347 as select * from t_bug25347;
|
|
73 |
insert into t_bug25347 values (1),(2),(3);
|
|
74 |
flush tables;
|
|
75 |
removing and creating
|
|
76 |
d_bug25347.t_bug25347
|
|
77 |
Error : Incorrect file format 't_bug25347'
|
|
78 |
error : Corrupt
|
|
79 |
insert into t_bug25347 values (4),(5),(6);
|
|
80 |
ERROR HY000: Incorrect file format 't_bug25347'
|
|
81 |
d_bug25347.t_bug25347
|
|
82 |
warning : Number of rows changed from 0 to 3
|
|
83 |
status : OK
|
|
84 |
insert into t_bug25347 values (7),(8),(9);
|
|
85 |
select * from t_bug25347;
|
|
86 |
a
|
|
87 |
1
|
|
88 |
2
|
|
89 |
3
|
|
90 |
7
|
|
91 |
8
|
|
92 |
9
|
|
93 |
select * from v_bug25347;
|
|
94 |
a
|
|
95 |
1
|
|
96 |
2
|
|
97 |
3
|
|
98 |
7
|
|
99 |
8
|
|
100 |
9
|
|
101 |
drop view v_bug25347;
|
|
102 |
drop table t_bug25347;
|
|
103 |
drop database d_bug25347;
|
|
104 |
use test;
|
|
105 |
End of 5.0 tests
|
|
106 |
create table t1(a int);
|
|
107 |
create view v1 as select * from t1;
|
|
108 |
show tables;
|
|
109 |
Tables_in_test
|
|
110 |
t1
|
|
111 |
v1
|
|
112 |
show tables;
|
|
113 |
Tables_in_test
|
|
114 |
t1
|
|
115 |
#mysql50#v-1
|
|
116 |
v1
|
|
117 |
show tables;
|
|
118 |
Tables_in_test
|
|
119 |
t1
|
|
120 |
v1
|
|
121 |
v-1
|
|
122 |
drop view v1, `v-1`; |
|
123 |
drop table t1;
|