~drizzle-trunk/drizzle/development

connect (con1,localhost,root,,);

connect (con2,localhost,root,,);

connection con1;

--disable_warnings

drop table if exists t1,t2;

--enable_warnings

# Add a lot of keys to slow down check

create table t1(n int not null, key(n), key(n), key(n), key(n));

let $1=10000;

disable_query_log;

while ($1)

{

 eval insert into t1 values ($1);

 dec $1;

}

enable_query_log;

send check table t1 extended;

connection con2;

insert into t1 values (200000);

connection con1;

reap;

drop table t1;

# End of 4.1 tests

#

# Bug #9897  Views: 'Check Table' crashes MySQL, with a view and a table 

# in the statement

#

connection default;

Create table t1(f1 int);

Create table t2(f1 int);

Check Table v1,t2;

drop table t1, t2;

#

# BUG#26325 - TEMPORARY TABLE "corrupt" after first read, according to CHECK

#             TABLE

#

CREATE TEMPORARY TABLE t1(a INT);

CHECK TABLE t1;

REPAIR TABLE t1;

DROP TABLE t1;