-
-
Notifications
You must be signed in to change notification settings - Fork 570
Allow modify length of index #900
Copy link
Copy link
Closed
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-mysqlMySQL and/or MariaDB specific issueMySQL and/or MariaDB specific issue
Milestone
Metadata
Metadata
Assignees
Labels
bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLconfirmedIssue verified by project memberIssue verified by project membernettype-mysqlMySQL and/or MariaDB specific issueMySQL and/or MariaDB specific issue
Type
Fields
Give feedbackNo fields configured for issues without a type.
Steps to reproduce this issue
BLOBtype column;KEYto it;You will receive the error "SQL Error (1170): BLOB/TEXT column 'column1' used in key specification without a key length", which is right, due to
BLOBtype requires a key length.For
VARCHARtype we can modify the Length at Indexes tab.But for
BLOBtypes we can't:I could check that all
VARCHARsimilar types will works, and allBLOBsimilar types will not.Workaround
Currently workaround is modify the Datatype to
VARCHAR, modify the Length then back toBLOB.Possible solution
Seems related to this piece of code. Maybe just do
AllowedfordtcBinary, except if exists some reason to it.Environment