Bug #5761

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

Added by stefano nardone 11 months ago. Updated about 1 month ago.

Status:New Start Date:06/07/2012
Priority:Normal Due date:
Assigned to:Marco Hugentobler % Done:

0%

Category:-
Target version:Version 2.0.0
Platform:Ubuntu Patch supplied:Yes
Platform version:12.04 Affected version:master
Status info: Causes crash or corruption:No
Resolution:

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, 06/07/2012 10:15 am

06.png - classify with Natural Breaks mode (slooow) (349.4 kB) stefano nardone, 06/07/2012 10:15 am

testdata.zip (4.8 kB) Minoru Akagi, 11/28/2012 10:30 pm

joined_minmax.patch (1.5 kB) Minoru Akagi, 11/29/2012 03:46 pm

History

Updated by Giovanni Manghi 11 months ago

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

I can confirm this.

Updated by Paolo Cavallini 9 months ago

  • Target version set to Version 2.0.0

Updated by Minoru Akagi 6 months ago

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

Updated by Minoru Akagi 6 months ago

Added a patch

Updated by Giovanni Manghi 6 months ago

  • Assigned to set to Marco Hugentobler
  • Patch supplied changed from No to Yes

Updated by Minoru Akagi about 1 month ago

Working fine in master! (17d8007)
Tested with: PostGIS + PostGIS (no geometry), Spatialite + Spatialite (no geometry), Shapefile + XLS

Also available in: Atom PDF