-
-
Notifications
You must be signed in to change notification settings - Fork 539
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
Description
Steps to reproduce this issue
- Step 1; create a new table with a
BLOBtype column; - Step 2; add a
KEYto it; - Step 3; save;
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 BLOB type requires a key length.
For VARCHAR type we can modify the Length at Indexes tab.
But for BLOB types we can't:
I could check that all VARCHAR similar types will works, and all BLOB similar types will not.
Workaround
Currently workaround is modify the Datatype to VARCHAR, modify the Length then back to BLOB.
Possible solution
Seems related to this piece of code. Maybe just do Allowed for dtcBinary, except if exists some reason to it.
Environment
- HeidiSQL version: 10.3.0.5885
- Database system and version: MariaDB 10.3
- Operating system: Windows 10 x64
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

