dbal icon indicating copy to clipboard operation
dbal copied to clipboard

Full text indexes not supported in SQL Server

Open jackbentley opened this issue 4 years ago • 0 comments

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

  1. Create a connection to an SQL Server.
  2. Create a table using Doctrine
  3. 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/

jackbentley avatar Jan 22 '21 14:01 jackbentley