Bug report #21967

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

Added by Brett Carlock almost 5 years ago. Updated almost 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Processing/GUI
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

Description

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 almost 5 years ago

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

History

#1 Updated by Jürgen Fischer almost 5 years ago

  • Description updated (diff)

#2 Updated by Jürgen Fischer almost 5 years ago

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

Also available in: Atom PDF