Take(0) returns the entire result set

[yuenm18]

We are having an issue where Take(0) is returning the entire result set instead of an empty list. We are using Marten 4.0 but I ran this test against master and it's also failing there.

        [Fact]
        public void take_0_error()
        {
            var targets = Target.GenerateRandomData(1000).ToArray();

            theStore.BulkInsert(targets);

            using (var query = theStore.QuerySession())
            {
                var take1 = query.Query<Target>().Skip(0).Take(1).ToList();
                var take0 = query.Query<Target>().Skip(0).Take(0).ToList();

                take1.Count().ShouldBe(1); // correct
                take0.Count().ShouldBe(0); // fails (should be 0 but was 1000)
            }
        }

[jeremydmiller]

@yuenm18 That's purposeful behavior. Is this from some kind of dynamic paging maybe?

[yuenm18]

Yep, it's from dynamic paging

[jeremydmiller]

Try this thing? https://martendb.io/documents/querying/linq/paging.html

[yuenm18]

Thanks, that gives me a nice error message.