diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/storage_engine/replace.rdiff')
-rw-r--r-- | storage/rocksdb/mysql-test/storage_engine/replace.rdiff | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/storage_engine/replace.rdiff b/storage/rocksdb/mysql-test/storage_engine/replace.rdiff new file mode 100644 index 00000000000..632c52f1504 --- /dev/null +++ b/storage/rocksdb/mysql-test/storage_engine/replace.rdiff @@ -0,0 +1,31 @@ +--- /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/replace.result 2017-06-22 00:33:46.423995639 +0300 ++++ /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/replace.reject 2017-06-22 14:03:14.971690359 +0300 +@@ -20,18 +20,16 @@ + 5 e + DROP TABLE t1; + CREATE TABLE t1 (a <INT_COLUMN>, b <CHAR_COLUMN>, UNIQUE INDEX (a)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +-REPLACE INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'); +-INSERT INTO t1 (a,b) VALUES (2,'d'); +-ERROR 23000: Duplicate entry '2' 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 +-REPLACE INTO t1 (a,b) VALUES (2,'d'); +-SELECT a,b FROM t1; +-a b +-1 a +-2 d +-3 c +-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 indexed 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>, PRIMARY KEY (b)) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; + REPLACE INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'); + INSERT INTO t1 (a,b) VALUES (4,'b'); |