Hi I wonder if someone could help me out with an issue.
For some reason I am finding running identical queries on the same collection with different limits returns completely different documents, even when total document count is well below the limit.
Environment:
- Appwrite version: 1.7.4
- Next.js API routes
- Single collection with ~8 documents
Code:
// Query 1 - returns 2 documents that were previously deleted from my database
const docs1 = await databases.listDocuments(DB_ID, COLLECTION_ID, [Query.limit(100)]);
console.log('Total:', docs1.total, 'Returned:', docs1.documents.length);
// Output: Total: 4, Returned: 2, Shows: parks 1,1
// Query 2 - returns 8 documents
const docs2 = await databases.listDocuments(DB_ID, COLLECTION_ID, [Query.limit(1000)]);
console.log('Total:', docs2.total, 'Returned:', docs2.documents.length);
// Output: Total: ?, Returned: 8, Shows: parks 3,278,315,316,25,12,25,25
Expected: Both queries should return the same documents since limit(100) should be sufficient for a collection with <100 docs.
Actual: Different queries return completely different document sets, as if accessing different collections or indexes.
Has anyone seen similar inconsistent query results? Is this a known issue with document visibility/indexing or am I doing something silly?
