I have 100000 documents in my bucket which is having different types of documents.
Now my problem is that when I am using joins with Limit and Offset then I think it is considering only leading document type for Limit.
eg. LIMIT 10 OFFSET 0 then it is giving only 8 records.
LIMIT 10 OFFSET 10 then it is giving next 7 records.
Is this the behavior or bug ?
My requirement is that it should apply the OFFSET and LIMIT clauses after joining.And should return 10 docs for
LIMIT 10 OFFSET 0
Can any one please help me on this.