Details
-
Type:
Technical task
-
Status: Closed
-
Priority:
Minor
-
Resolution: Won't Fix
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Reproducible on
revision-id: psergey@askmonty.org-20130201180328-ocmbh9uvcoedmihp
revno: 4591
branch-nick: mysql-5.6-leveldb
SQL layer doesn't let the table to be created, because LevelDB SE doesn't return HA_CAN_INDEX_BLOBS from table_flags().
I think this needs to be fixed, but this is low priority.