strange paging behavior #80

Closed
Antares007 opened this Issue Oct 28, 2011 · 3 comments

2 participants

@Antares007

Sql Store:

SELECT COUNT(*)
FROM [Commits]
WHERE CommitStamp>'2011-10-20'
RESULT IS: 10930

EventStore 3.0.11293.43:
var store = Wireup.Init()
.UsingSqlPersistence("Sql")
.InitializeStorageEngine()
.UsingJsonSerialization()
.Build();

        var enumerable = store.Advanced.GetFrom(new DateTime(2011, 10, 20)).ToList();
        Console.WriteLine(enumerable.Count);

RESULT IS: 614

Problem Is 614 != 10930

@joliver

Can you run the following select and email me the list (I'll send you my email separately):

SELECT StreamId, StreamRevision, Items,
CommitId, CommitSequence, CommitStamp,
Dispatched,
0x AS Headers, 0x AS Payload
FROM Commits;

@Antares007

shure, here is my commits https://docs.google.com/leaf?id=0B7JuZ-ZQhNLgNTM3MjlkMzMtNTI0MC00MjlkLTlhODctNjY5ODU4M2E5OTgz&hl=en_US.

since previous post i'll added more commits to the store

@joliver joliver pushed a commit that referenced this issue Nov 1, 2011
Oliver, Jonathan All dialects which support paging now properly page over GetFrom(Date…
…Time) as well as GetUndispatchedCommits() calls--closes issue #80;
7bd4b38
@joliver

Issue resolved.

@joliver joliver closed this Nov 1, 2011
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment