New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Add index" Should not List JSON Columns #3288

Open
dohpaz42 opened this Issue Nov 9, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@dohpaz42

dohpaz42 commented Nov 9, 2018

Currently, the Add index interface will not allow TEXT columns to be added to an index. However, it does allow adding JSON columns, which results in the following error:

MySQL said: JSON column 'my_column' cannot be used in key specification.

I am using build 5423 (dee3201d) with MySQL 5.7.22 on macOS High Sierra 10.13.5 (17F77).

@dmoagx

This comment has been minimized.

Member

dmoagx commented Nov 10, 2018

Currently, the Add index interface will not allow TEXT columns to be added to an index.

Sequel Pro does allow adding TEXT columns to indexes, as long as the index is either a FULLTEXT index or the indexing length of the column is specified…

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment