Weird behavior when creating columns from a joined table

[qgib]

Author Name: Guillaume Larocque (@glaroc)
Original Redmine Issue: 9320
Affected QGIS version: 2.0.1
Redmine category:vectors
Assignee: Jürgen Fischer

---

Steps to reproduce:

1- Join the layer named 'Joined_Table.csv' to the layer named 'BBS_Routes' using the shared routes column.
2- Enter edit mode in the attribute table and try to create a new column (Integer, width 10) simply copying values from column year1980. This gives a column containing only NULLs while it should give NULLs only in rows that contain NULLS in the year1980 column. If you update the column using 'update existing field', while keeping the same formula, the NULLs disappear. Now create a new column that copies values of column year1994. This works as expected.

I can confirm that this was working properly in pre 2.0 versions of QGIS. I have tried various combinations of column names, column sums, etc. and I can't explain what's going on. I have seen this behavior on Windows 7 and Ubuntu, and on various other machines.

---

• Joined_Table_Bug_Report.zip (Guillaume Larocque)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

tagging this as a regression at least until I will have time to test if is still an issue on QGIS master.

---

• fixed_version_id was configured as Future Release - High Priority
• category_id was configured as Vectors
• priority_id was changed from Normal to Severe/Regression

[qgib]

Author Name: Alexander Bruy (@alexbruy)

---

Confirmed on Linux with QGIS master 48afac3

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

• subject was changed from Weird behavior when creating columns from a joined table. to Weird behavior when creating columns from a joined table

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• assigned_to_id was configured as Jürgen Fischer
• fixed_version_id was changed from Future Release - High Priority to Version 2.2

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "9d7ef65a2dd4d5a4b07e37af01cff04146bca34e".

---

• status_id was changed from Open to Closed