KEMBAR78
Support binary columns with SQL Server FREETEXT/CONTAINS by roji · Pull Request #24033 · dotnet/efcore · GitHub
Skip to content

Conversation

@roji
Copy link
Member

@roji roji commented Jan 31, 2021

Closes #23921

@roji roji requested review from maumar and smitpatel January 31, 2021 22:13
@roji
Copy link
Member Author

roji commented Feb 1, 2021

I know adding stuff to Northwind would end badly. @maumar @smitpatel suggestions on where this test should live? GearsOfWar?

@smitpatel
Copy link
Contributor

@roji
Copy link
Member Author

roji commented Feb 1, 2021

@smitpatel next task!

CREATE FULLTEXT CATALOG GearsOfWar_FTC AS DEFAULT;
CREATE FULLTEXT INDEX ON Missions (BriefingDocument TYPE COLUMN BriefingDocumentFileExtension) KEY INDEX PK_Missions;
WAITFOR DELAY '00:00:03';
Copy link
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Yes. Unfortunately there is some asynchronous process here, so if we run the tests too quickly after creating the full text catalog/index, we get back empty resullts (not an error, which is what you get when the catalog/index aren't created at all). 😡 😡 😡

Copy link
Contributor

@smitpatel smitpatel left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM. @maumar to sign-off for test changes.

@roji roji merged commit bb28f69 into main Feb 9, 2021
@roji roji deleted the FreeTheText branch February 9, 2021 08:39
Ali-YousefiTelori pushed a commit to Ali-YousefiTelori/EntityFrameworkCore that referenced this pull request Feb 10, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

SqlServer: Allow FreeText and Contains function to take non-string parameters

3 participants