Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Ensure C.I. is running SQL Server free-text tests #20128

Closed
ajcvickers opened this issue Mar 2, 2020 · 9 comments · Fixed by #23177
Closed

Ensure C.I. is running SQL Server free-text tests #20128

ajcvickers opened this issue Mar 2, 2020 · 9 comments · Fixed by #23177
Assignees
Labels
area-test closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-cleanup
Milestone

Comments

@ajcvickers
Copy link
Member

I installed FTS into my local Linux SQL Server installation and started seeing the failures below.

Running against localdb on my Windows machine (so no FTS) does not error. I wonder if we are not currently C.I. testing against a machine with FTS. @smitpatel?

Failed tests
0.7531128s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_literal
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__167_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 500
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 551
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 559
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 266
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 285
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 306
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Extensions/EntityFrameworkQueryableExtensions.cs:line 2039
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Extensions/EntityFrameworkQueryableExtensions.cs:line 2039
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_literal() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 284
--- End of stack trace from previous location where exception was thrown ---
0.0105695s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_language_term
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 404
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 236
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 173
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 159
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 185
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/QueryCompiler.cs:line 98
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/EntityQueryProvider.cs:line 79
   at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_language_term() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 301
0.9442682s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_logical_operator
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__167_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 500
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 551
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 559
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 266
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 285
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 306
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Extensions/EntityFrameworkQueryableExtensions.cs:line 2039
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Extensions/EntityFrameworkQueryableExtensions.cs:line 2039
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_logical_operator() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 316
--- End of stack trace from previous location where exception was thrown ---
0.6259562s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_prefix_term_and_language_term
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__167_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 500
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 551
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 559
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 266
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 285
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 306
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Query/ShapedQueryCompilingExpressionVisitor.cs:line 140
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Query/ShapedQueryCompilingExpressionVisitor.cs:line 152
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_prefix_term_and_language_term() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 334
--- End of stack trace from previous location where exception was thrown ---
0.9542727s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_proximity_term_and_language_term
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__167_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 500
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 551
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 559
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 266
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 285
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 306
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Query/ShapedQueryCompilingExpressionVisitor.cs:line 140
   at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleOrDefaultAsync[TSource](IAsyncEnumerable`1 asyncEnumerable, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Query/ShapedQueryCompilingExpressionVisitor.cs:line 152
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.Contains_with_proximity_term_and_language_term() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 350
--- End of stack trace from previous location where exception was thrown ---
0.5035988s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_literal
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__167_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.<>c.<.cctor>b__274_0(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 500
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 551
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 559
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 358
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 266
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementationAsync[TState,TResult](Func`4 operation, Func`4 verifySucceeded, TState state, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 285
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.AsyncEnumerator.MoveNextAsync() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 306
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Extensions/EntityFrameworkQueryableExtensions.cs:line 2039
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken) in /home/ajcvickers/efcore/src/EFCore/Extensions/EntityFrameworkQueryableExtensions.cs:line 2039
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_literal() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 61
--- End of stack trace from previous location where exception was thrown ---
0.0074405s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_multiple_predicates
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 404
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 236
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 173
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 159
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 185
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/QueryCompiler.cs:line 98
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/EntityQueryProvider.cs:line 79
   at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source)
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_multiple_predicates() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 134
0.008053s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_multiple_words
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 404
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 236
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 173
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 159
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 185
   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/QueryCompiler.cs:line 98
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/EntityQueryProvider.cs:line 79
   at System.Linq.Queryable.Count[TSource](IQueryable`1 source)
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_multiple_words() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 85
0.0322161s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_with_language_term
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 404
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 236
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 173
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 159
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 185
   at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/QueryCompiler.cs:line 98
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) in /home/ajcvickers/efcore/src/EFCore/Query/Internal/EntityQueryProvider.cs:line 79
   at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_with_language_term() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 102
0.0119656s✘ Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_with_multiple_words_and_language_term
Microsoft.Data.SqlClient.SqlException : Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Employees' because it is not full-text indexed.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
   at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean isAsync, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String method)
   at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) in /home/ajcvickers/efcore/src/EFCore.Relational/Storage/RelationalCommand.cs:line 404
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 236
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 173
   at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) in /home/ajcvickers/efcore/src/EFCore/Storage/ExecutionStrategy.cs:line 159
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext() in /home/ajcvickers/efcore/src/EFCore.Relational/Query/Internal/QueryingEnumerable.cs:line 185
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Microsoft.EntityFrameworkCore.Query.NorthwindDbFunctionsQuerySqlServerTest.FreeText_with_multiple_words_and_language_term() in /home/ajcvickers/efcore/test/EFCore.SqlServer.FunctionalTests/Query/NorthwindDbFunctionsQuerySqlServerTest.cs:line 117
@smitpatel
Copy link
Member

  1. CI is not running them at present since it uses localdb. My request for having machine or mechanism for us to run against actual SqlServer garnered no response here https://github.com/dotnet/core-eng/issues/9066
  2. Those errors are indicative of a possible invalid northwind database. Let me investigate into it.

@smitpatel smitpatel self-assigned this Mar 3, 2020
@ajcvickers
Copy link
Member Author

@smitpatel FYI, just did a clean build/test on release/3.1. Same tests fail.

@ajcvickers
Copy link
Member Author

@smitpatel Duplicate of #20084 (which is duplicate of #18299)?

@smitpatel
Copy link
Member

Not a duplicate of #20084. There are no owned entities or any other reason to cause a subquery in these tests.

@ajcvickers
Copy link
Member Author

@smitpatel Recreating my databases fixed this issue. However, one of the tests still fails--see #20232

We probably don't need to track anything more here since the underlying C.I. issue is about not using LocalDb, right?

@ajcvickers
Copy link
Member Author

@smitpatel Can you verify whether or not we are running free-text tests at some point in the C.I.?

@smitpatel
Copy link
Member

We are not running this in CI since they all use localdb.

@ajcvickers
Copy link
Member Author

Thanks. We'll discuss in triage.

@ajcvickers ajcvickers removed this from the 5.0.0 milestone Jul 30, 2020
@ajcvickers
Copy link
Member Author

We will do manual validation runs (on a dev box) for this in the 5.0 timeframe, and continue the process of trying to get not LocalDb SQL Server into the C.I. later.

@smitpatel smitpatel added closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. and removed blocked labels Dec 14, 2020
@smitpatel smitpatel modified the milestones: MQ, 6.0.0 Dec 14, 2020
smitpatel added a commit that referenced this issue Dec 14, 2020
smitpatel added a commit that referenced this issue Dec 14, 2020
@ghost ghost closed this as completed in #23177 Dec 15, 2020
ghost pushed a commit that referenced this issue Dec 15, 2020
@ajcvickers ajcvickers modified the milestones: 6.0.0, 6.0.0-preview1 Jan 27, 2021
@ajcvickers ajcvickers modified the milestones: 6.0.0-preview1, 6.0.0 Nov 8, 2021
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area-test closed-fixed The issue has been fixed and is/will be included in the release indicated by the issue milestone. type-cleanup
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants