Bug report #14796
DB Manager: query builder always places double quotes around column values
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | DB Manager | ||
| Affected QGIS version: | master | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 22753 |
Description
Subject says it all, this means that queries created with this tool will always fail.
ex:
SELECT "planet_osm_roads"."osm_id"
FROM "public"."planet_osm_roads"
WHERE "ref"="EN 335"
or
SELECT "planet_osm_roads"."ref"
FROM "public"."planet_osm_roads"
WHERE "osm_id"="00001"
Text values should be around single quotes, number as they are.
Associated revisions
[db_manager] Fix #14796 - Quote values depending on data type in query builder
History
#1
Updated by Arnaud Morvan about 8 years ago
- Status changed from Open to Closed
Fixed in changeset 8e5b28f3bb5d7fb46b54c69176ec4143268ea977.