Related to

http://10.168.1.17:8081/do/home/project/aquadatastudio/issue/3518

MySQL 6 on 10.168.1.38

demo database

created a table with the below syntax

CREATE TABLE a_index_length_test  (
    a    bigint(20) NOT NULL,
    b    tinyblob NOT NULL,
    c    longblob NOT NULL,
    d    mediumblob NOT NULL,
    e    mediumtext NOT NULL,
    f    longtext NOT NULL,
    g    tinytext NOT NULL
    )
GO

Tried to create indexes on all the columns but the length is not enabled for the above data types(not on bigint) - so I cant create indexes

ADS displays BLOB/TEXT xolumn used in key specification without a key length

See pic

---------

I created an index manually by putting the length and it is displayed in index properties

CREATE INDEX `ind_1`
    ON a_index_length_test(`b`(5), `c`(5), `d`(5), `e`(5), `f`(5), `g`(5))