|
When using col_name(length) syntax to specify an index prefix length, Connect engine ignores prefix and build whole index
create table t1 (
|
id int not null,
|
`name` varchar(150) NOT NULL,
|
b varbinary (50) NOT NULL,
|
c char (20) NOT NULL,
|
index (name(5)),
|
index (b(5)),
|
index (c(5))
|
)engine=CONNECT;
|
Query OK, 0 rows affected, 2 warnings (0.05 sec)
|
|
show create table t1;
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`id` int(11) NOT NULL,
|
`name` varchar(150) NOT NULL,
|
`b` varbinary(50) NOT NULL,
|
`c` char(20) NOT NULL,
|
KEY `name` (`name`),
|
KEY `b` (`b`),
|
KEY `c` (`c`)
|
) ENGINE=CONNECT DEFAULT CHARSET=latin1 |
|
|