diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/update.test')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/update.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/update.test b/storage/rocksdb/mysql-test/rocksdb/t/update.test index 51e2c5be0a6..6220c4f55a3 100644 --- a/storage/rocksdb/mysql-test/rocksdb/t/update.test +++ b/storage/rocksdb/mysql-test/rocksdb/t/update.test @@ -70,3 +70,13 @@ SELECT * FROM t1 ORDER BY pk; DROP TABLE t1; + +# +# Issue #830 UPDATE with unique constraint does not work +# + +CREATE TABLE t1 (a INT, b CHAR(8), UNIQUE INDEX(a)) ENGINE=RocksDB; +INSERT INTO t1 (a,b) VALUES (1,'foo'),(2,'bar'); +UPDATE t1 SET a=a+100; +SELECT * FROM t1; +DROP TABLE t1; |