I just updated to the latest Nuget of the client and I'm getting a strange error on a query that has never caused me any problems. The query looks like this:
public static PostTopic<CharacterOverview> GetPostsForCharacter(this IDocumentSession session, ICharacterRepository characterRepository, string characterId, int? limit, int? offset) {
var posts = session.Query<Post>()
.Where(x => x.Sections.Any(y => y.ReferenceId == characterId))
.OrderByDescending(x => x.CreatedAt)
.ToLazyPage(limit, offset, "CreatedAt", false);
var character = characterRepository.GetOverview(characterId);
return new PostTopic<CharacterOverview> {
Topic = character.Value,
Posts = posts.Value
};
}
There error details are as follows:
{"Got an error from server, status code: 500\r\n{\r\n \"Url\": \"/indexes/dynamic/Posts\",\r\n \"Error\": \"System.InvalidOperationException: Could not understand query: \\r\\n-- line 2 col 9: \\\"in\\\" expected\\r\\n\\r\\n at Raven.Database.Linq.QueryParsingUtils.GetVariableDeclarationForLinqQuery(String query, Boolean requiresSelectNewAnonymousType) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Linq\\\\QueryParsingUtils.cs:line 84\\r\\n at Raven.Database.Linq.DynamicViewCompiler.TransformMapDefinitionFromLinqQuerySyntax(String query, String& entityName) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Linq\\\\DynamicViewCompiler.cs:line 442\\r\\n at Raven.Database.Linq.DynamicViewCompiler.HandleMapFunction(ConstructorDeclaration ctor, String map) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Linq\\\\DynamicViewCompiler.cs:line 132\\r\\n at Raven.Database.Linq.DynamicViewCompiler.TransformQueryToClass() in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Linq\\\\DynamicViewCompiler.cs:line 97\\r\\n at Raven.Database.Linq.DynamicViewCompiler.GenerateInstance() in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Linq\\\\DynamicViewCompiler.cs:line 489\\r\\n at Raven.Database.Storage.IndexDefinitionStorage.AddAndCompileIndex(IndexDefinition indexDefinition) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Storage\\\\IndexDefinitionStorage.cs:line 150\\r\\n at Raven.Database.Storage.IndexDefinitionStorage.CreateAndPersistIndex(IndexDefinition indexDefinition) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Storage\\\\IndexDefinitionStorage.cs:line 135\\r\\n at Raven.Database.DocumentDatabase.PutIndex(String name, IndexDefinition definition) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\DocumentDatabase.cs:line 731\\r\\n at Raven.Database.Queries.DynamicQueryRunner.TouchTemporaryIndex(String temporaryIndexName, String permanentIndexName, Func`1 createDefinition) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Queries\\\\DynamicQueryRunner.cs:line 161\\r\\n at Raven.Database.Queries.DynamicQueryRunner.GetAppropriateIndexToQuery(String entityName, IndexQuery query, DynamicQueryMapping map) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Queries\\\\DynamicQueryRunner.cs:line 118\\r\\n at Raven.Database.Queries.DynamicQueryRunner.ExecuteDynamicQuery(String entityName, IndexQuery query) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Queries\\\\DynamicQueryRunner.cs:line 37\\r\\n at Raven.Database.Queries.DynamicQueryExtensions.ExecuteDynamicQuery(DocumentDatabase self, String entityName, IndexQuery indexQuery) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Queries\\\\DynamicQueryExtensions.cs:line 17\\r\\n at Raven.Database.Server.Responders.Index.PerformQueryAgainstDynamicIndex(IHttpContext context, String index, IndexQuery indexQuery, Guid& indexEtag) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\Responders\\\\Index.cs:line 224\\r\\n at Raven.Database.Server.Responders.Index.ExecuteQuery(IHttpContext context, String index, Guid& indexEtag) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\Responders\\\\Index.cs:line 169\\r\\n at Raven.Database.Server.Responders.Index.GetIndexQueryRessult(IHttpContext context, String index) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\Responders\\\\Index.cs:line 118\\r\\n at Raven.Database.Server.Responders.Index.OnGet(IHttpContext context, String index) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\Responders\\\\Index.cs:line 90\\r\\n at Raven.Database.Server.Responders.Index.Respond(IHttpContext context) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\Responders\\\\Index.cs:line 45\\r\\n at Raven.Database.Server.HttpServer.DispatchRequest(IHttpContext ctx) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\HttpServer.cs:line 548\\r\\n at Raven.Database.Server.HttpServer.HandleActualRequest(IHttpContext ctx) in c:\\\\Builds\\\\RavenDB-Stable\\\\Raven.Database\\\\Server\\\\HttpServer.cs:line 315\"\r\n}"}
Any help would be much appreciated. I'm releasing in about two weeks...and I can easily delay this particular feature if I have to, but I'd rather not ;)