Bug report #10912

joined attributes are not (correctly) propagated in nested joins

Added by Denis Rouzaud about 6 years ago. Updated about 6 years ago.

Status:Closed
Priority:Normal
Assignee:Martin Dobias
Category:Vectors
Affected QGIS version:2.4.0 Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:19275

Description

It seems there is a problem with nested joins.
By nested joins, I mean layer A is joined to B which itself is joined to c, then D etc.

What I expected when I open the attribute table of layer A is to get all the attributes.
They would named in QGIS:
A_attrs | A_B_attrs | A_B_C_attrs | A_B_C_D_attrs

I set up a small project to test this.
In my setup, only the attributes of the first join layer are shown (B in A, C in B, D in C).

But, when trying this with Andreas yesterday, all attributes column where shown, but some were filled with NULL values.

test_join.sql - SQL code to create the schema 'test_join' (1.58 KB) Denis Rouzaud, 2014-07-18 05:46 AM

project.qgs - small QGIS project to test it. You would have to change param connection. (31.1 KB) Denis Rouzaud, 2014-07-18 05:46 AM

Associated revisions

Revision 071a5ec0
Added by Martin Dobias about 6 years ago

Fix #10912 (joined attributes are not correctly propagated in nested joins)

This commit makes QgsVectorLayerJoinBuffer listen to changes in fields
of joined vector layers in order to update the cache and inform parent layer

History

#1 Updated by Giovanni Manghi about 6 years ago

  • Subject changed from joined attributes are not (coorectly) propagated in nested joins to joined attributes are not (correctly) propagated in nested joins

#2 Updated by Denis Rouzaud about 6 years ago

  • Assignee set to Martin Dobias

#3 Updated by Martin Dobias about 6 years ago

  • Status changed from Open to Closed

Also available in: Atom PDF