findAll() and findAndCountAll() inconsistency: schema not applied in findAll()

[vigalo]

Hello :

What are you doing?

When I do :

Model.findAll({ schema: {'4cfdc1df-a993-4029-8009-d9c2e5b46db3'}}).then(result => console.log(result))

the data is fetched from the public schema in the database, but when I do :

Model.findAndCountAll({ schema: {'4cfdc1df-a993-4029-8009-d9c2e5b46db3'}}).then(result => console.log(result))

the data is fetched from the intended schema as expected.

What do you expect to happen?

Two commands must return the same data from the right schema

What is actually happening?

findAll() is returning allways data from the public schema. findAndCountAll() is working as expected

__Dialect: postgres
__Sequelize version: 4.42.0
__Tested with latest release: No

[sushantdhiman]

I don't think we support passing schema option in both findAll and findAndCountAll, model can have a schema, which worked properly for me.

Please submit SSCCE to I can reproduce this issue

---

( What is SSCCE ? You can find template for Sequelize here )

A few good example of SSCCE

1. ResourceRequest timed out - connection not reestablished after db restarted #8014 (comment)
2. removeAttribute('id') results in undefined: null data value #7318 (comment)
3. toJSON converting booleans to "t" (true) or "f" (false) #8749 (comment)