mirror of
https://github.com/doctrine/orm.git
synced 2026-03-23 22:42:18 +01:00
Fulltext index on unique column ignored #4961
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @csasarak on GitHub (Jan 6, 2016).
I was asked to link to an issue I filed with dbal: Fulltext index on unique column ignored.
@CienappsDAG commented on GitHub (Jun 7, 2023):
Bumping.
What solution is being propose as an alternative here 7 years later?
Remove my unique constraint? Eh
I can't make use of migrations because of this.
I currently have a custom schema:update command which will add the index manually and it ain't pretty.
@greg0ire commented on GitHub (Jun 7, 2023):
@CienappsDAG you're suffering from the bug. What do you propose?
@csasarak commented on GitHub (Jun 7, 2023):
There is a small workaround where you add an always true conditional to the index and that's enough to stop the it from getting pruned while not changing the index's meaning. I talk about it more in the linked issue above. It's ugly but it worked.
@morphles commented on GitHub (Jul 16, 2025):
So now 9 years, still present. Workaround seems... not fully working, it makes migration create index (though there again, can't figure out how to make it generate "WITH PARSER ngram", so have to manually edit migration, it is ether not possible or docs are lacking), in any case it at least generates index creation, even if missing parser clause, but schema validation then says schema is wrong, and shows both drop and create for index.... So CI does not like such things.