iN() not working properly. It is returning all records in that documentType.
Describe the bug Issue with iN() query in flutter CouchBase. in() works fine in iOS as I am iOS developer I have used it before too. But in flutter it returns all the records under that documentType.
To Reproduce Steps to reproduce the behavior:
- Use iN() and pass expressions list to it.
- I have only 3 documents in couchbase_db having ids as
1, 2, 3in int format. I have just passed1in below expression it returns all 3 documents. I thought issue with my query but just replaced iN() withequalTo(expressions[0])it works fine.
List<Expression> expressions = [idsArray.map((id)](url) => Expression.string(id)).toList();
Query query = QueryBuilder.select([SelectResult.all()]) .from("couch_db") .where(Expression.property("documentType") .equalTo(Expression.string("student")) .and(Expression.property("id").iN(expressions)));
Expected behavior It should return only documents that are related to List<Expressions> passed in where query.
Screenshots

Desktop:
- macOS for development and iOS device / Android device(In android emulator it shows only 2 documents
1, 3tried by passing any id)
I will take a quick look and see if anything obvious jumps out at me. Please let me know if you figure out anything.