FindAndCount all generates wrong query #5445
Description
When upgrading Sequelize from 3.3.0 to 3.19.0 FindAndCountAll retrieves inconsistent results with COUNT:5 and 0 rows.
We have identified the issue as being a miss generated query. Attached are the DIFF between the queries generated in 3.3.0 and 3.19.0 for our production system.
A failing test has been added via Pull Request: #5446
We were able to reproduce this issue since Sequelize 3.5.0.
For the moment we have rolled back our production system to Sequelize 3.3.0, till we can find a solution for this issue.
DIALECT: POSTGRES
Sequelize VERSION: 3.19.0
Node: 0.10.39
incorrectly generated query 3.19.txt
correctly generated query 3.3.0.txt