Feature request #6450
Allow QGIS to 'guess' field types for calculated fields in spatialite views
|Pull Request or Patch supplied:||No
||Copied to github as #:||15690
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.
- Target version changed from Version 1.8.0 to Version 2.0.0
- Target version changed from Version 2.0.0 to Future Release - Nice to have
- 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
- Priority changed from High to Normal
- Category set to Data Provider/SpatiaLite
- 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 ?
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 !
- Status changed from Feedback to Open
Can someone estimate how much time it would take to solve this problem? Maybe we can look for a solution....
Also available in: Atom