Can't create fulltext index on multiple columns

[OlafvdSpek]

The FullText icon is missing..

[made2591]

@OlafvdSpek can you explain the problem? Maybe I can handle this but I'm not sure I correctly understood!

[OlafvdSpek]

What part do you not understand?

[made2591]

What is FullText icon? XD I know it sounds stupid but I mean: where are you in the screen? what do you expect? Are you talking about a ui-only bug or something else?

[OlafvdSpek]

On the Structure tab, you can select multiple columns and then create an index on them by clicking the Primary Key, Unique Key or Index buttons. The FullText button isn't in the line after "With selected:" though.

[made2591]

thank you! I will try to solve the problem in the day, but I am a newbiew XD as you should have already understood

[made2591]

Ok, I loaded the stack and understood the problem. FullText is missing, lol. I'll go throught it.

[whispertante]

Hi @made2591,
are you still working on this issue? If no, I would take it.

[made2591]

I worked on it a little bit, but I'm far from finding a sol...I think it is more difficult than you expected. If you want to re-assign, please go ahead! I will go in States tomorrow, and for 2 weeks I will not work of any open projects. Sorry for delay in feedback!

[whispertante]

Hi @OlafvdSpek
I think @made2591 is right by saying, this is a bigger issue.
FullText Indices can only be created within a table configured with the storage engine MyISAM. InnoDB does not support this feature, thus the icon is not displayed. If you change the engine, the icon will be displayed.

I think, there is a bug that the FullText feature is being displayed within the columns (see screen) also if the storage engine does not support it, e.g. InnoDB.

Do you agree?

[OlafvdSpek]

https://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html

[whispertante]

Okay, my source was obviously outdated.
I will have a look

[ankitjain28may]

@nijel I would like to work on this issue if anyone isn't active on this, can you please assign this to me ?

[nijel]

Fixed by #13716