Skip to content

Full text indexes not supported in SQL Server #4485

Open
@jackbentley

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

  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/

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions