[QGIS-trac] [Quantum GIS] #1372: Crash when using postgis layers with symbology "continous colors"

[Quantum GIS]

#1372: Crash when using postgis layers with symbology "continous colors"
---------------------------------------------------------+------------------
   Reporter:  sitondorf                                  |              Owner:  nobody       
       Type:  bug                                        |             Status:  new          
   Priority:  critical: causes crash or data corruption  |          Milestone:  Version 1.0.0
  Component:  Build/Install                              |            Version:  HEAD         
   Keywords:  crash postgis symbology                    |   Platform_version:               
   Platform:  Windows                                    |           Must_fix:  No           
Status_info:  0                                          |  
---------------------------------------------------------+------------------
 POSTGis-Layer: View in Postgis-Database v_mdat_gem_k_efh

 When displaying the data everything works fine.
 "Save Project" and "Open Project" work as expected.

 Layer-Properties->Symbology:
 Legend type: change to "Continuous Color"
 Classification Field: wert
 ... (default values)

 [OK]: Map is displayed with continous colors.
 Saved Project to a new file
 Closed QGIS
 Start QGIS
 Open saved project -> application crash

 No difference between 0.11.0-Metis and 1.0.0-Kore-preview1

 Postgis-Data:
 CREATE OR REPLACE VIEW v_mdat_gem_k_efh AS
  SELECT g.gid, g.rs, g.ags, g.si_subkey, g.gen, g.des, g.ewz, g.bld_gen,
 f.wert, f.wert_quelle, d."BEZ" AS wert_quelle_str, f.wert_fix,
 f.randgebiet, g.the_geom
    FROM basis_bkg_gem g, marktdaten_gem_k_efh f
    JOIN datenquelle d ON d."ID" = f.wert_quelle
   WHERE g.rs = f.rs AND g.si_subkey = f.si_subkey;
 CREATE TABLE basis_bkg_gem
 (
   gid serial NOT NULL,
   bld_rs character(12),
   krs_rs character(12),
   rs character(12),
   ags character(8),
   si_subkey character(2),
   gen character varying(50),
   des character varying(50),
   ewz bigint,
   bld_gen character varying(25),
   krs_gen character varying(50),
   the_geom geometry,
   CONSTRAINT basis_bkg_gem_gem_pkey PRIMARY KEY (gid),
   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
 'MULTIPOLYGON'::text OR the_geom IS NULL),
   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326)
 )
 WITH (OIDS=FALSE);
 CREATE TABLE marktdaten_gem_k_efh
 (
   rs character(12) NOT NULL,
   si_subkey character(2) NOT NULL,
   wert double precision,
   wert_quelle integer,
   wert_fix boolean,
   randgebiet boolean,
   CONSTRAINT marktdaten_gem_k_efh_pkey PRIMARY KEY (rs, si_subkey)
 )
 WITH (OIDS=FALSE);
 CREATE TABLE datenquelle
 (
   "ID" integer NOT NULL,
   "BEZ" character varying(50) NOT NULL,
   CONSTRAINT pk_datenquelle PRIMARY KEY ("ID")
 )
 WITH (OIDS=FALSE);

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1372>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats