Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2.6
-
None
-
Ubuntu 16.04
Description
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 | |