Bug report #3541

New symbology duplicates categories of a spatialite layer

Added by Jean-Roc Morreale over 13 years ago. Updated over 13 years ago.

Status:Closed
Priority:Low
Assignee:nobody -
Category:Symbology
Affected QGIS version: Regression?:No
Operating System:All Easy fix?:No
Pull Request or Patch supplied: Resolution:invalid
Crashes QGIS or corrupts data: Copied to github as #:13601

Description

Hi,

When classifying a spatialite layer with the new symbology, some class are created twice.

If you show the feature count, one is at 0 while the other has the right number. The style of the "real" layer can't be modified, the empty one can be modified but not applied to the canva.

If you delete one of the layers, you can style the remaining one normally.

This behaviour doesn't occur with the old symbology or when using the new with a shp version of the layer.

test.zip - spatialite layer showing this behaviour (248 KB) Jean-Roc Morreale, 2011-03-03 07:33 AM

History

#1 Updated by Martin Dobias over 13 years ago

  • Resolution set to invalid
  • Status changed from Open to Closed

Something is wrong with the table. When you run in sqlite command line tool: 

SELECT DISTINCT type FROM test

you get duplicate entries, too. So they are not absolutely equal, that is what the database says.

Also available in: Atom PDF