Bug report #4015

The rendering categorized using a spatialite don't work.

Added by aperi2007 - about 8 years ago. Updated about 6 years ago.

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 about 8 years ago

Not confirmed here.

#2 Updated by aperi2007 - about 8 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 about 8 years ago

I can't replicate this using trunk in Ubuntu 11.04 natty even using a query.

#4 Updated by Goyo D about 8 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 about 8 years ago

As a workaround the opposite way works: symbolize first, then query.

#6 Updated by aperi2007 - about 8 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 - about 8 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 8 years ago

  • Target version set to Version 1.7.4

#9 Updated by Paolo Cavallini over 7 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 7 years ago

  • Target version changed from Version 1.7.4 to Version 1.8.0

#11 Updated by Paolo Cavallini about 7 years ago

  • Target version changed from Version 1.8.0 to Version 2.0.0

#12 Updated by Daniel Vaz about 6 years ago

Is it still valid? Could you try the master version?

Thanks in advance

#13 Updated by Giovanni Manghi about 6 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.

Also available in: Atom PDF