diff options
| author | msvensson@pilot.blaudden <> | 2007-03-01 18:12:56 +0100 |
|---|---|---|
| committer | msvensson@pilot.blaudden <> | 2007-03-01 18:12:56 +0100 |
| commit | f5778fc73e4e676f38c4734bca3a96f4d08dc2d7 (patch) | |
| tree | dd839a6db9e2985054d2bc99faaafdc4440866fc /mysql-test/t/blackhole.test | |
| parent | ab61d07a30b73e3446b6eab9536ba464a0d55f74 (diff) | |
| parent | 2f5a2b2476a0ca43d0a5bdfb979b427ff806839f (diff) | |
| download | mariadb-git-f5778fc73e4e676f38c4734bca3a96f4d08dc2d7.tar.gz | |
Merge pilot.blaudden:/home/msvensson/mysql/mysql-5.0
into pilot.blaudden:/home/msvensson/mysql/mysql-5.0-maint
Diffstat (limited to 'mysql-test/t/blackhole.test')
| -rw-r--r-- | mysql-test/t/blackhole.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/blackhole.test b/mysql-test/t/blackhole.test index e40b84eb5cd..4bafad2d777 100644 --- a/mysql-test/t/blackhole.test +++ b/mysql-test/t/blackhole.test @@ -127,4 +127,19 @@ show binlog events; drop table t1,t2,t3; +# +#Bug#19717: DELETE Query Error on BLACKHOLE when using WHERE on column with UNIQUE INDEX +# +CREATE TABLE t1(a INT, b INT) ENGINE=BLACKHOLE; +DELETE FROM t1 WHERE a=10; +ALTER TABLE t1 ADD INDEX(a); +DELETE FROM t1 WHERE a=10; +ALTER TABLE t1 DROP INDEX a; +ALTER TABLE t1 ADD UNIQUE INDEX(a); +DELETE FROM t1 WHERE a=10; +ALTER TABLE t1 DROP INDEX a; +ALTER TABLE t1 ADD PRIMARY KEY(a); +DELETE FROM t1 WHERE a=10; +DROP TABLE t1; + # End of 4.1 tests |