Bug report #21967
NULL value inserted as literal string instead of NULL object in Query Builder interface
|Affected QGIS version:||3.6.2||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||29782|
Tangentially related to #21805
Related also to #21966
Issue: The Query Builder interface inserts certain values as literal string representations instead of the actual object type.
STR: Double-click in the Query Builder GUI on a NULL entry will insert 'NULL', not NULL into the Query Builder.
If you have your NULL representation changed, it will insert the string representation of that NULL representation, not the NULL object or property. So, as in Ticket #21966 above, my custom NULL representation of <NULL> will not insert the object NULL, but instead the string '<NULL>'.