Bug report #21967

NULL value inserted as literal string instead of NULL object in Query Builder interface

Added by Brett Carlock over 4 years ago. Updated over 4 years ago.

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>'.

Associated revisions

Revision 4ee40991
Added by Jürgen Fischer over 4 years ago

query builder: fix #21805 & #21966 & #21967


#1 Updated by Jürgen Fischer over 4 years ago

  • Description updated (diff)

#2 Updated by Jürgen Fischer over 4 years ago

  • % Done changed from 0 to 100
  • Status changed from Open to Closed

Also available in: Atom PDF