summaryrefslogtreecommitdiff
path: root/mysql-test/r/delete.result
diff options
context:
space:
mode:
authorunknown <ram@gw.mysql.r18.ru>2004-06-21 15:17:07 +0500
committerunknown <ram@gw.mysql.r18.ru>2004-06-21 15:17:07 +0500
commit7b1626edd429b7815509f1586e01c3bc810b6daf (patch)
tree9c1133d00b2617ead44ce0898b87b6c9088f1a9b /mysql-test/r/delete.result
parent60cb0e5f6d6626a2d2a574e58b6a1abf7a4a9449 (diff)
downloadmariadb-git-7b1626edd429b7815509f1586e01c3bc810b6daf.tar.gz
a fix (bug #4198: Incorrect key file for table).
Diffstat (limited to 'mysql-test/r/delete.result')
-rw-r--r--mysql-test/r/delete.result10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/delete.result b/mysql-test/r/delete.result
index f1acc5d2dfa..c6b7a40214d 100644
--- a/mysql-test/r/delete.result
+++ b/mysql-test/r/delete.result
@@ -120,3 +120,13 @@ a b
0 10
1 11
drop table t11, t12, t2;
+create table t1 (a int, b int, unique key (a), key (b));
+insert into t1 values (3, 3), (7, 7);
+delete t1 from t1 where a = 3;
+check table t1;
+Table Op Msg_type Msg_text
+test.t1 check status OK
+select * from t1;
+a b
+7 7
+drop table t1;