Going back to v17.0 the docs state this:
Using the # operator (support for Null values)
Queries by attribute using the “#” operator can have different results depending on whether or not the Map NULL values to blank values property is checked for the object field:
Map NULL values to blank values property checked (default option, recommended in most cases).
However in the database structure window, when looking at the Inspector of an Object field, the “Map NULL values to blank values” checkbox is not present. Is there no option to turn it on or off for Object fields? What is its new permanent setting?
Using v17.232154 64-bit & macOS 10.14.2