Datastore query offsets are not working as it supposed to

[ibrahim-abuelalaa]

This is a weird behaviour when setting the offset parameter so I have 9825 entities and

len(list(client.query(kind="Foo").fetch()))

Will yield 9825, but

len(list(client.query(kind="Foo").fetch(offset=1)))

will yield 9808

[chemelnucfin]

Hello, I wasn't able to reproduce the behavior, but I only tested it with a smaller test case.

Do you have more information you can give me? Does it happen with other queries?

[ibrahim-abuelalaa]

hello, thanks for your response. Yes it is like that with others queries the only thing that I could add is that the number of returned entities increase when I use

query.keys_only()

or use projection queries, so it is 9815 instead of 9808

[ibrahim-abuelalaa]

it works fine for small test case. But not for large one

[bmclean]

googleapis/google-cloud-ruby#1922

[blowmage]

I have a fix for the Ruby library here: googleapis/google-cloud-ruby#1930

[tseaver]

@mcdonc Reference this bug in your PR.