1
by brian
clean slate |
1 |
drop table if exists `about:text`; |
2 |
create table `about:text` ( |
|
3 |
_id int not null auto_increment, |
|
4 |
`about:text` varchar(255) not null default '', |
|
5 |
primary key (_id) |
|
6 |
);
|
|
7 |
show create table `about:text`; |
|
8 |
Table Create Table |
|
9 |
about:text CREATE TABLE "about:text" ( |
|
10 |
"_id" int(11) NOT NULL AUTO_INCREMENT, |
|
11 |
"about:text" varchar(255) NOT NULL, |
|
12 |
PRIMARY KEY ("_id") |
|
13 |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
|
14 |
drop table `about:text`; |
|
15 |
use test; |
|
16 |
drop table if exists t1; |
|
17 |
create table t1(a int) engine=myisam; |
|
18 |
insert into t1 values(1); |
|
19 |
"We get an error because the table is in the definition cache"
|
|
20 |
create table t1(a int, b int); |
|
21 |
ERROR 42S01: Table 't1' already exists |
|
22 |
"Flush the cache and recreate the table anew to be able to drop it"
|
|
23 |
flush tables; |
|
24 |
show open tables like "t%"; |
|
25 |
Database Table In_use Name_locked |
|
26 |
create table t1(a int, b int, c int); |
|
27 |
"Try to select from the table. This should not crash the server"
|
|
28 |
select count(a) from t1; |
|
29 |
count(a) |
|
30 |
0
|
|
31 |
drop table t1; |