When performing a query with a filter that is not using the IN operator (e.g.
name IS NOT NULL) the query is expected to succeed.
The query is failing because the SQL produced or the query is invalid (
name IS NOT (NULL)), it surrounds the value with parentheses. Postgresql doesn’t consider this syntax valid.
"name":"ForestLiana","message":"Records Index Count error: PG::SyntaxError: ERROR: syntax error at or near \"(\" LINE 1: ...\".\"order_id\" WHERE ((\"order\".\"id\" IS NOT (NULL)))
Please provide any relevant information about your setup.
- Package Version: 7.0.0
- Rails Version: 6.1.4
- Database Dialect: Postgresql
- Database Version: 13.3
- Project Name: Back Office
I’ve created a PR with a suggested solution for the problem.