Unable to create fulltext index type with mariaDB and InnoDB
Open
Nobody has claimed this yet.
enhancement
- Dominant language
- PHP
- Stars
- 4.5k
- Forks
- 884
- PR merge metrics
- No merged PRs in 30d
Description
$this->table("user_informations")
->addIndex('name', ['type' => 'fulltext'])
->addIndex('hei_id', ['type' => 'fulltext'])
->update();
This will only create an index with index type. I use MariaDB 10.1.10 with InnoDB.
Fulltext indexes are supported with InnoDB from MariaDB 10.0.5 https://mariadb.com/kb/en/mariadb/fulltext-index-overview/
Thanks
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start at the table()->addIndex() handling used by the reported migration and trace how MariaDB/InnoDB index types are generated. Reproduce the example on MariaDB 10.1.10 and verify that the resulting indexes are created as FULLTEXT rather than only receiving an index type; the payload names no source file or test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, php
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100