Bug report #4015
The rendering categorized using a spatialite don't work.
Status: | Closed | ||
---|---|---|---|
Priority: | Normal | ||
Assignee: | - | ||
Category: | Symbology | ||
Affected QGIS version: | master | Regression?: | No |
Operating System: | Easy fix?: | No | |
Pull Request or Patch supplied: | No | Resolution: | fixed |
Crashes QGIS or corrupts data: | No | Copied to github as #: | 14002 |
Description
Hi,
Using a spatialite db and try-ing to rendering using a categorized type seem don't work.
Qgis seem to be unable to classify correctly.
It classify always one only value even if there is more then one distinct value available.
I try qhis 1.7 and the trunk version 1.8.
The bug seem to be in both version.
History
#1 Updated by Paolo Cavallini over 13 years ago
Not confirmed here.
#2 Updated by aperi2007 - over 13 years ago
Hi tested more.
The categorized work correctly if the spatialite layer is without a filter.
But if I apply a filter to the layer the categorize don't work.
I try to apply a query like:
Field1 = '0101'
after this the category don't work
#3 Updated by Goyo D over 13 years ago
I can't replicate this using trunk in Ubuntu 11.04 natty even using a query.
#4 Updated by Goyo D over 13 years ago
Sorry I did not test properly. Indeed if I try to use the categorized in a spatialite layer with a query, the "Classify" button does nothing (no classes are created). Moreover if I try to apply changes in such a state qgis crashes with "Invalid pointer" error.
#5 Updated by Goyo D over 13 years ago
As a workaround the opposite way works: symbolize first, then query.
#6 Updated by aperi2007 - over 13 years ago
As a workaround the opposite way works: symbolize first, then query.
Unfortunately the query I need use reduce more the classification values.
So categorizing first will produce many values never used. :(
But perhaps another workaround could be to use the plugin RT_SQL_Layer and apply a spatialite layer a sql-layer having in it the same filter needed.
#7 Updated by aperi2007 - over 13 years ago
I forget...
Using the plugin rt_sql_layer as a workaround will produce a read-only layer.
So this classified layer is not editable.
#8 Updated by Giovanni Manghi almost 13 years ago
- Target version set to Version 1.7.4
#9 Updated by Paolo Cavallini almost 13 years ago
- Assignee deleted (
Paolo Cavallini) - Crashes QGIS or corrupts data set to No
- Affected QGIS version set to master
- Pull Request or Patch supplied set to No
#10 Updated by Paolo Cavallini over 12 years ago
- Target version changed from Version 1.7.4 to Version 1.8.0
#11 Updated by Paolo Cavallini over 12 years ago
- Target version changed from Version 1.8.0 to Version 2.0.0
#12 Updated by Daniel Vaz over 11 years ago
Is it still valid? Could you try the master version?
Thanks in advance
#13 Updated by Giovanni Manghi over 11 years ago
- Resolution set to fixed
- Status changed from Open to Closed
Daniel Vaz wrote:
Is it still valid? Could you try the master version?
Thanks in advance
it works fine on master, please reopen if necessary.