Skip to content

Instantly share code, notes, and snippets.

@pvivera
Created November 21, 2014 22:40
Show Gist options
  • Save pvivera/1bf8c6ba00b4421dd82a to your computer and use it in GitHub Desktop.
Save pvivera/1bf8c6ba00b4421dd82a to your computer and use it in GitHub Desktop.
RavenDB workaround for query with filter on long fails 2
using System.Linq;
using Raven.Abstractions.Indexing;
using Raven.Client.Indexes;
using Raven.Tests.Helpers;
using Xunit;
namespace TestRaven
{
public class RavenDbTests : RavenTestBase
{
[Fact]
public void Hi()
{
var store = NewDocumentStore();
store.ExecuteIndex(new SomeIndex());
using (var session = store.OpenSession())
{
session.Store(new Result {Number = 1});
session.SaveChanges();
}
WaitForIndexing(store);
using (var session = store.OpenSession())
{
var results1 = session.Query<Result, SomeIndex>()
.ToList();
var results2 = session.Query<Result, SomeIndex>()
.Where(x => x.Number > 0)
.ToList();
var results3 = session.Advanced.LuceneQuery<Result>("SomeIndex")
.WhereGreaterThanOrEqual(x => x.Number, 0)
.ToList();
Assert.Equal(1, results1.Count); // success
Assert.Equal(1, results2.Count); // success
Assert.Equal(1, results3.Count); // success
}
}
public class SomeIndex : AbstractIndexCreationTask<Result>
{
public SomeIndex()
{
Map = results => from result in results
select new
{
result.Number
};
Sort(r=>r.Number, SortOptions.Long);
}
}
public class Result
{
public long Number { get; set; }
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment