|
I'm not sure whether it's supposed to be supported, but now it isn't (works with InnoDB though):
mysql> create table t1 (pk int primary key, t text, key(t(256))) engine=leveldb;
|
ERROR 1073 (42000): BLOB column 't' can't be used in key specification with the used table type
|
|
mysql> create table t1 (pk int primary key, t text, key(t(256))) engine=innodb;
|
Query OK, 0 rows affected (0.33 sec)
|
|
mysql> create table t2 (pk int primary key, b blob, key(b(256))) engine=leveldb;
|
ERROR 1073 (42000): BLOB column 'b' can't be used in key specification with the used table type
|
|
mysql> create table t2 (pk int primary key, b blob, key(b(256))) engine=innodb;
|
Query OK, 0 rows affected (0.10 sec)
|
|
revision-id: psergey@askmonty.org-20130125200959-a7gq7phbaiajqs12
|
revno: 4519
|
branch-nick: mysql-5.6-leveldb
|
|
[MDEV-4097]