Open
Description
Bug Report
Q | A |
---|---|
BC Break | no |
Version | x.y.z |
Summary
Unable to use FULLTEXT
indexes when using SQL Server despite it supporting them.
Current behaviour
Currently, Doctrine only supports theses types of indexes in MySQL.
How to reproduce
- Create a connection to an SQL Server.
- Create a table using Doctrine
- Add an index to the table via Doctrine with the
fulltext
flag
Expected behaviour
The index should be created using the SQL CREATE FULLTEXT INDEX
.
Currently, it only uses the SQL CREATE INDEX
.
More info
Documentation:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-fulltext-index-transact-sql?view=sql-server-ver15
I can't find information on microsoft.com about supported versions, but looks to be supported back to 2005 according to this site and others:
https://codingsight.com/implementing-full-text-search-in-sql-server-2016-for-beginners/