Bug #78010 Unable to set index length
Submitted: 10 Aug 2015 13:26 Modified: 10 Aug 2015 14:29
Reporter: Andy Beverley Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:6.3.4 OS:Ubuntu
Assigned to: CPU Architecture:Any

[10 Aug 2015 13:26] Andy Beverley
Description:
It is not possible to set an index length when editing a table. Any values submitted just change to a zero.

I have tried this on both VARCHAR and TEXT fields, but it possibly affects others too.

In the console the following error is displayed:

(mysql-workbench-bin:6906): GLib-GObject-CRITICAL **: g_value_get_long: assertion 'G_VALUE_HOLDS_LONG (value)' failed

How to repeat:
- Create a new table
- Using the model, add a new TEXT column to the table
- Click the "Indexes" tab
- Create a new index
- Edit the new index, select the TEXT column, and set an index length of 50
- The index length will be reset to 0

I cannot find any other way of specifying an index length. A workaround would be appreciated.

Thanks.
[10 Aug 2015 14:29] MySQL Verification Team
Thank you for the bug report. Duplicate of http://bugs.mysql.com/bug.php?id=75039 .