A formula field with a result of NULL causes SOQL retrieval to fail
Last updated 2020-11-23 ·Reference W-3607654 ·Reported By 39 users
When creating a Formula Field with a formula of the value NULL, SOQL queries fail with "ORA-00920: invalid relational operator".
1. Create a custom formula field with Checkbox type.
2. Enter a formula value text of NULL
3. Execute SOQL from the Dev Console:
SELECT MyCustomFormulaField__c FROM MyCustomObject__c LIMIT 1
4. Observe error:
System.UnexpectedException: common.exception.SfdcSqlException: ORA-00920: invalid relational operator
Ensure the formula result is TRUE or FALSE.
Reported By (39)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.