Feature request #6450

Allow QGIS to 'guess' field types for calculated fields in spatialite views

Added by Marie Silvestre almost 5 years ago. Updated 5 months ago.

Status:Open
Priority:Normal
Assignee:-
Category:Data Provider/SpatiaLite
Pull Request or Patch supplied:No Resolution:
Easy fix?:No

Description

When creating a view (spatial or not) within a sqlite database, calculated fields have no definite type because of the affinity typing rules of SQLite.
Those fields cannot be used by QGIS for symbology purposes thereafter.

Unless there is a way to by-pass this issue, I think it's realy a shame to populate the database with tables instead of views.

History

#1 Updated by Pirmin Kalberer almost 5 years ago

  • Target version changed from Version 1.8.0 to Version 2.0.0

#2 Updated by Pirmin Kalberer almost 5 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

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

  • Subject changed from Allow QGIS to 'guess' field types for calcutlated fields in spatialite views to Allow QGIS to 'guess' field types for calculated fields in spatialite views

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

  • Priority changed from High to Normal

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

  • Category set to Data Provider/SpatiaLite

#6 Updated by Médéric RIBREUX almost 2 years ago

  • Status changed from Open to Feedback

Hello, bug triage...

in QGIS 2.13 master (and probably in 2.12.1), when I make a SQLite view, QGIS find attribute type without any problem...
Can you confirm ?

#7 Updated by Médéric RIBREUX almost 2 years ago

Oops, sorry for the noise: I've made tests with calculated fields and QGIS don't recognise them (even with a CAST function)...
Furthermore, in DBManager, the calculated field type is also empty.

So this feature request is still valid !

#8 Updated by Médéric RIBREUX over 1 year ago

  • Status changed from Feedback to Open

#9 Updated by Pieter Brusselman 12 months ago

Can someone estimate how much time it would take to solve this problem? Maybe we can look for a solution....

#10 Updated by Giovanni Manghi 5 months ago

  • Easy fix? set to No

Also available in: Atom PDF