Bug report #18086

QGIS 2.18: Joins do not work reliable

Added by Thomas Nogatz 6 months ago. Updated 6 months ago.

Status:Open
Priority:Normal
Assignee:-
Category:Unknown
Affected QGIS version:2.18.16 Regression?:No
Operating System:Windows 10 Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No

Description

QGIS 2.18.16 on Windows 10

Steps (see attached project):
- Working with a shapefile
- Join the shapefile to a table
- Join to a second table in relation to the first joined table
- Layer style based on values of both tables

The result: sometimes the join works, sometimes it does not. If it does work: It's possible to make it not working by changing a layer style label description (in the given project for instance: "Fließgewässer" to "running waters").

The same project works properly on QGIS 2.14 - here the described problem does not appear.

See bug reports #17697 and #17840

project1.zip (1.22 MB) Thomas Nogatz, 2018-02-13 09:08 AM

History

#1 Updated by Thomas Nogatz 6 months ago

"The join does not work" means: QGIS does not recognize corresponding ident values, and all values of the joined table are NULL.

Also available in: Atom PDF