~drizzle-trunk/drizzle/development

drop table if exists `about:text`;

create table `about:text` ( 

_id int not null auto_increment,

`about:text` varchar(255) not null default '',

primary key (_id)

) ENGINE=MyISAM;

show create table `about:text`;

Table	Create Table

about:text	CREATE TABLE `about:text` (

  `_id` int NOT NULL AUTO_INCREMENT,

  `about:text` varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (`_id`)

) ENGINE=MyISAM

drop table `about:text`;

use test;

drop table if exists t1;

create table break_frm(a int) engine=myisam;

insert into break_frm values(1);

"We get an error because the table is in the definition cache"

create table break_frm(a int, b int);

ERROR 42S01: Table 'break_frm' already exists

"Flush the cache and recreate the table anew to be able to drop it"

flush tables;

show open tables like "break_frm%";

Database	Table	In_use	Name_locked

create table break_frm(a int, b int, c int);

"Try to select from the table. This should not crash the server"

select count(a) from break_frm;

count(a)

0

drop table break_frm;

create table break_frm(a int) engine=myisam;

drop table if exists break_frm;