diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/storage_engine/update_with_keys.rdiff')
| -rw-r--r-- | storage/rocksdb/mysql-test/storage_engine/update_with_keys.rdiff | 77 |
1 files changed, 0 insertions, 77 deletions
diff --git a/storage/rocksdb/mysql-test/storage_engine/update_with_keys.rdiff b/storage/rocksdb/mysql-test/storage_engine/update_with_keys.rdiff deleted file mode 100644 index a59da32a10a..00000000000 --- a/storage/rocksdb/mysql-test/storage_engine/update_with_keys.rdiff +++ /dev/null @@ -1,77 +0,0 @@ ---- /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/update_with_keys.result 2017-06-22 00:33:46.423995639 +0300 -+++ /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/update_with_keys.reject 2017-06-22 15:21:52.275660708 +0300 -@@ -17,54 +17,27 @@ - 8 - DROP TABLE t1; - CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, UNIQUE INDEX(a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; --INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(0,'f'),(100,'a'); --UPDATE t1 SET a=a+200; --UPDATE t1 SET a=0 WHERE a > 250; --UPDATE t1 SET a=205 WHERE a=200; --ERROR 23000: Duplicate entry '205' for key 'a' --# Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY). --# If you got a difference in error message, just add it to rdiff file --UPDATE t1 SET a=12345 ORDER BY a, b LIMIT 1; --SELECT a,b FROM t1; --a b --12345 a --200 f --201 a --202 b --203 c --204 d --205 e --UPDATE t1 SET a=80 WHERE a IN (202,203); --ERROR 23000: Duplicate entry '80' for key 'a' --# Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY). --# If you got a difference in error message, just add it to rdiff file --DROP TABLE t1; -+ERROR HY000: Unique index support is disabled when the table has no primary key. -+# ERROR: Statement ended with errno 1105, errname ER_UNKNOWN_ERROR (expected to succeed) -+# ------------ UNEXPECTED RESULT ------------ -+# [ CREATE TABLE t1 (a INT(11) /*!*/ /*Custom column options*/, b CHAR(8) /*!*/ /*Custom column options*/, UNIQUE INDEX(a)) ENGINE=RocksDB /*!*/ /*Custom table options*/ ] -+# The statement|command finished with ER_UNKNOWN_ERROR. -+# Unique keys or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. -+# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. -+# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. -+# Also, this problem may cause a chain effect (more errors of different kinds in the test). -+# ------------------------------------------- - CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, UNIQUE INDEX(a,b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; --INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(100,'a'),(6,'f'); --UPDATE t1 SET a=6 WHERE a=3; --UPDATE t1 SET a=100 WHERE a=1; --ERROR 23000: Duplicate entry '100-a' for key 'a' --# Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY). --# If you got a difference in error message, just add it to rdiff file --UPDATE t1 SET a=4, b='d' WHERE b='f'; --ERROR 23000: Duplicate entry '4-d' for key 'a' --# Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY). --# If you got a difference in error message, just add it to rdiff file --UPDATE t1 SET a=a+1; --SELECT a,b FROM t1; --a b --101 a --2 a --3 b --5 d --6 e --7 c --7 f --UPDATE t1 SET b='z'; --ERROR 23000: Duplicate entry '7-z' for key 'a' --# Statement ended with one of expected results (ER_DUP_ENTRY,ER_DUP_KEY). --# If you got a difference in error message, just add it to rdiff file --DROP TABLE t1; -+ERROR HY000: Unique index support is disabled when the table has no primary key. -+# ERROR: Statement ended with errno 1105, errname ER_UNKNOWN_ERROR (expected to succeed) -+# ------------ UNEXPECTED RESULT ------------ -+# [ CREATE TABLE t1 (a INT(11) /*!*/ /*Custom column options*/, b CHAR(8) /*!*/ /*Custom column options*/, UNIQUE INDEX(a,b)) ENGINE=RocksDB /*!*/ /*Custom table options*/ ] -+# The statement|command finished with ER_UNKNOWN_ERROR. -+# Unique keys or multi-part keys or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. -+# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. -+# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. -+# Also, this problem may cause a chain effect (more errors of different kinds in the test). -+# ------------------------------------------- - CREATE TABLE t1 (a <INT_COLUMN> PRIMARY KEY, b <CHAR_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; - INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(0,'f'),(100,'a'); - UPDATE t1 SET a=a+200; |