For the past couple of weeks our Continuous Integration (CI) build that uses SFDX and scratch orgs has had most of its queries failing for the Platform Encryption org with this error:
common.exception.SfdcSqlException: ORA-00932: inconsistent datatypes: expected CHAR got DATE
The code appears to work fine once packaged and then deployed.
This had been working fine and our build configuration has not changed in this area. Any ideas on where to look or how to fix this?
There is this known issue Internal Server Error when doing SOQL query of formula field using an encrypted Date/Time field that looks like the same thing, but unclear why our production environments aren't affected too. Any ideas on that?
Now thinking it is code change that has made this start to happen. The queries are wildcarded (via describe calls) and more fields have been added.