Bug report #14796

DB Manager: query builder always places double quotes around column values

Added by Giovanni Manghi about 4 years ago. Updated about 4 years ago.

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

Revision 8e5b28f3
Added by Arnaud Morvan about 4 years ago

[db_manager] Fix #14796 - Quote values depending on data type in query builder

History

#1 Updated by Arnaud Morvan about 4 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF