Bug report #5761

"equal intervals" and "pretty breaks" do not work for joined fields

Added by stefano nardone over 7 years ago. Updated over 5 years ago.

Status:Closed
Priority:Normal
Assignee:Marco Hugentobler
Category:-
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:Yes Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:15265

Description

When making joins between a layer with geometries, to a table without geometry columns (all residing in PostGIS), if I choose to make a graduate classify with equal intervals on a numeric data field the classes are all filled with zeros. 'Preatty breaks' mode also do nothing of useful to classify, as shows no results. If I chose other classify modes it works well (Natural breaks). Happens with 1.7.4 in Windows (XP) and 1.8 master with Ubuntu 12.04 64

18.png - classify window with equal intervals (343 KB) stefano nardone, 2012-06-07 10:15 AM

06.png - classify with Natural Breaks mode (slooow) (349 KB) stefano nardone, 2012-06-07 10:15 AM

testdata.zip (4.82 KB) Minoru Akagi, 2012-11-28 10:30 PM

joined_minmax.patch Magnifier (1.48 KB) Minoru Akagi, 2012-11-29 03:46 PM

History

#1 Updated by Giovanni Manghi over 7 years ago

  • Subject changed from Graduated classify for joins to "equal intervals" and "pretty breaks" do not work for joined fields

I can confirm this.

#2 Updated by Paolo Cavallini about 7 years ago

  • Target version set to Version 2.0.0

#3 Updated by Minoru Akagi almost 7 years ago

Added a simple test dataset (shp+xls). Minimum/Maximum values of each columns of joined table seem to be incorrect.

#4 Updated by Minoru Akagi almost 7 years ago

Added a patch

#5 Updated by Giovanni Manghi almost 7 years ago

  • Pull Request or Patch supplied changed from No to Yes
  • Assignee set to Marco Hugentobler

#6 Updated by Minoru Akagi over 6 years ago

Works fine on master (17d8007)
Tested with: PostGIS + PostGIS (no geometry), Spatialite + Spatialite (no geometry), Shapefile + XLS

#7 Updated by Alexander Bruy over 5 years ago

  • OS version deleted (12.04)
  • Status changed from Open to Closed
  • Operating System deleted (Ubuntu)
  • Resolution set to fixed/implemented

Seems fixed in master.

Also available in: Atom PDF