diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-30 22:19:28 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-30 22:19:28 +0300 |
| commit | 0707f4658aee46727b11e4cc00f09b0a2d7826a0 (patch) | |
| tree | 223956917d3d7183d23137ef26ba48e92a0e40cc /mysql-test/t | |
| parent | db951c2fa25cc2e2b272f2d6f138bc88a20923bb (diff) | |
| parent | e7026604e9d8eea8573d0ee84ae2ec3359e4cad0 (diff) | |
| download | mariadb-git-0707f4658aee46727b11e4cc00f09b0a2d7826a0.tar.gz | |
Merge sinisa@work.mysql.com:/home/bk/mysql-4.0
into sinisa.nasamreza.org:/mnt/work/mysql-4.0
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/delete.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test index 953e22cdd55..cd56d14921e 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -35,3 +35,11 @@ create table t1 (a bigint not null, primary key (a,a,a,a,a,a,a,a,a,a)); insert into t1 values (2),(4),(6),(8),(10),(12),(14),(16),(18),(20),(22),(24),(26),(23),(27); delete from t1 where a=27; drop table t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1), (2), (3); +LOCK TABLES t1 WRITE; +DELETE FROM t1; +OPTIMIZE TABLE t1; +SELECT * FROM t1; +CHECK TABLE t1; +drop table if exists t1; |