diff options
Diffstat (limited to 'mysql-test/main/keyread.result')
-rw-r--r-- | mysql-test/main/keyread.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/keyread.result b/mysql-test/main/keyread.result index d8e9659d4bb..19a22eedbdf 100644 --- a/mysql-test/main/keyread.result +++ b/mysql-test/main/keyread.result @@ -4,3 +4,13 @@ select distinct f1 from v1; f1 drop view v1; drop table t1; +CREATE TABLE t1 (a INT NOT NULL, UNIQUE(a)) ENGINE=InnoDB; +INSERT INTO t1 VALUES (1),(2); +DELETE FROM t1 ORDER BY a LIMIT 1; +SELECT * FROM t1; +a +2 +DROP TABLE t1; +CREATE TABLE t1 (a CHAR KEY,b BLOB) ENGINE=InnoDB; +DELETE FROM t1 ORDER BY a LIMIT 1; +DROP TABLE t1; |