1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
|
--- /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/type_blob_indexes.result 2017-06-22 00:33:46.423995639 +0300
+++ /data/src/bb-10.2-mdev12528/mysql-test/suite/storage_engine/type_blob_indexes.reject 2017-06-22 14:09:07.227688145 +0300
@@ -71,53 +71,21 @@
l LONGBLOB <CUSTOM_COL_OPTIONS>,
UNIQUE INDEX l_t (l(256),t(64))
) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
-SHOW INDEX IN t1;
-Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
-t1 0 l_t 1 l # # 256 NULL # #
-t1 0 l_t 2 t # # 64 NULL # #
-INSERT INTO t1 (b,t,m,l) VALUES
-('','','',''),
-('a','b','c','d'),
-('b','d','c','b'),
-('test1','test2','test3','test4'),
-(REPEAT('a',128),REPEAT('b',128),REPEAT('c',128),REPEAT('d',128)),
-(HEX('abcd'),HEX('def'),HEX('a'),HEX('abc')),
-('abc','def','ghi','jkl'),
-('test2','test3','test4','test5'),
-('test3','test4','test5','test6'),
-(REPEAT('b',128),REPEAT('f',128),REPEAT('e',128),REPEAT('d',128)),
-(REPEAT('c',128),REPEAT('b',128),REPEAT('c',128),REPEAT('e',128));
-EXPLAIN SELECT SUBSTRING(t,64), SUBSTRING(l,256) FROM t1 WHERE t!=l AND l NOT IN ('test1') ORDER BY t, l DESC;
-id select_type table type possible_keys key key_len ref rows Extra
-# # # # l_t # # # # #
-SELECT SUBSTRING(t,64), SUBSTRING(l,256) FROM t1 WHERE t!=l AND l NOT IN ('test1') ORDER BY t, l DESC;
-SUBSTRING(t,64) SUBSTRING(l,256)
-
-
-bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
-bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
-
-
-fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
-
-
-
-EXPLAIN SELECT SUBSTRING(t,64), SUBSTRING(l,256) FROM t1 FORCE INDEX (l_t) WHERE t!=l AND l NOT IN ('test1') ORDER BY t, l DESC;
-id select_type table type possible_keys key key_len ref rows Extra
-# # # # l_t # # # # #
-SELECT SUBSTRING(t,64), SUBSTRING(l,256) FROM t1 FORCE INDEX (l_t) WHERE t!=l AND l NOT IN ('test1') ORDER BY t, l DESC;
-SUBSTRING(t,64) SUBSTRING(l,256)
-
-
-bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
-bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
-
-
-fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff
-
-
-
-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 (b BLOB /*!*/ /*Custom column options*/,
+t TINYBLOB /*!*/ /*Custom indexed column options*/,
+m MEDIUMBLOB /*!*/ /*Custom column options*/,
+l LONGBLOB /*!*/ /*Custom indexed column options*/,
+UNIQUE INDEX l_t (l(256),t(64))
+) ENGINE=RocksDB /*!*/ /*Custom table options*/ ]
+# The statement|command finished with ER_UNKNOWN_ERROR.
+# BLOB types or unique indexes or multi-part indexes 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 (b BLOB <CUSTOM_COL_OPTIONS>,
t TINYBLOB <CUSTOM_COL_OPTIONS>,
m MEDIUMBLOB <CUSTOM_COL_OPTIONS>,
|