Bug report #12356

DB Manager loads NUMERIC fields instead of DOUBLE when subquerying

Added by matteo ghetta about 9 years ago. Updated about 5 years ago.

Category:DB Manager
Affected QGIS version:2.8.1 Regression?:No
Operating System:debian Easy fix?:No
Pull Request or Patch supplied:No Resolution:end of life
Crashes QGIS or corrupts data:No Copied to github as #:20531


The original layer loaded in a SL database has many DOUBLE fields.
But trying to do a subquery and load the result in QGIS through DB Manager, the same fields are loaded as NUMERIC.

With NUMERIC fields one cannot use, for example, a graduated style.

Related issues

Related to QGIS Application - Bug report #12325: Integer fields converted to text when exported from Spati... Closed 2015-03-06


#1 Updated by Jukka Rahkonen about 9 years ago

May be related to #12325. The main reason is probably that SQLite does not have strict data types http://www.sqlite.org/datatype3.html.

#2 Updated by matteo ghetta about 9 years ago

Yes, may be related to the bug you cited.
So not a real QGIS bug rather a SQlite feature, right?

#3 Updated by Roy Roge about 9 years ago

SQlite does not enforce data type but i think this
should be up to the client interface using SQlite (or Spatialite)
otherwise we don't have control on our data and results

#4 Updated by Giovanni Manghi almost 7 years ago

  • Regression? set to No
  • Easy fix? set to No

#5 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to end of life
  • Status changed from Open to Closed

Also available in: Atom PDF