~drizzle-trunk/drizzle/development

# Non-windows specific create tests.

--source include/not_windows.inc

#

# Bug#19479:mysqldump creates invalid dump

#

--disable_warnings

drop table if exists `about:text`;

--enable_warnings

create table `about:text` ( 

_id int not null auto_increment,

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

primary key (_id)

);

show create table `about:text`; 

drop table `about:text`;

# End of 5.0 tests

#

# Bug#16532:mysql server assert in debug if table det is removed

#

use test;

--disable_warnings

drop table if exists t1;

--enable_warnings

create table t1(a int) engine=myisam;

insert into t1 values(1);

--system rm -f $MYSQLTEST_VARDIR/master-data/test/t1.frm

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

--error ER_TABLE_EXISTS_ERROR

create table t1(a int, b int);

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

flush tables;

show open tables like "t%";

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

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

select count(a) from t1;

drop table t1;