Bug report #1789

PostGIS query: put '' around field values when appropriate

Added by Paolo Cavallini about 10 years ago. Updated about 10 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Data Provider
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:fixed
Crashes QGIS or corrupts data: Copied to github as #:11849

Description

When using the query builder from PostGIS provider, if the user selects a boolean, date, time etc. field that requires to be surrounded by _, they are written without them, so the query fails, eg:

fieldname=t

(where fieldname is a boolean, true/false) instead of

fieldname='t'

Associated revisions

Revision 5274c8f1
Added by Jürgen Fischer about 10 years ago

fix #1789

git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision bcf09abb
Added by Jürgen Fischer about 10 years ago

fix #1789

git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision b7c2b63c
Added by Jürgen Fischer about 10 years ago

fix #1789 (take 2)

git-svn-id: http://svn.osgeo.org/qgis/trunk/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

Revision 69841f7f
Added by Jürgen Fischer about 10 years ago

fix #1789 (take 2)

git-svn-id: http://svn.osgeo.org/qgis/[email protected] c8812cc2-4d05-0410-92ff-de0c093fc19c

History

#1 Updated by Jürgen Fischer about 10 years ago

  • Resolution set to fixed
  • Status changed from Open to Closed

fixed in bcf09abb (SVN r11106)

#2 Updated by Paolo Cavallini about 10 years ago

Fixed for boolean, not for date and time (possibily also other types)

#3 Updated by Paolo Cavallini about 10 years ago

  • Status changed from Closed to Feedback
  • Resolution deleted (fixed)

#4 Updated by Jürgen Fischer about 10 years ago

  • Resolution set to fixed
  • Status changed from Feedback to Closed

fixed in 69841f7f (SVN r11107)

Also available in: Atom PDF