Bug report #1789
PostGIS query: put '' around field values when appropriate
| 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
fix #1789
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@11105 c8812cc2-4d05-0410-92ff-de0c093fc19c
fix #1789
git-svn-id: http://svn.osgeo.org/qgis/trunk@11105 c8812cc2-4d05-0410-92ff-de0c093fc19c
fix #1789 (take 2)
git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@11106 c8812cc2-4d05-0410-92ff-de0c093fc19c
fix #1789 (take 2)
git-svn-id: http://svn.osgeo.org/qgis/trunk@11106 c8812cc2-4d05-0410-92ff-de0c093fc19c
History
#1
Updated by Jürgen Fischer almost 15 years ago
- Resolution set to fixed
- Status changed from Open to Closed
fixed in bcf09abb (SVN r11106)
#2
Updated by Paolo Cavallini almost 15 years ago
Fixed for boolean, not for date and time (possibily also other types)
#3
Updated by Paolo Cavallini almost 15 years ago
- Status changed from Closed to Feedback
- Resolution deleted (
fixed)
#4
Updated by Jürgen Fischer almost 15 years ago
- Resolution set to fixed
- Status changed from Feedback to Closed
fixed in 69841f7f (SVN r11107)