Bug report #9320
Weird behavior when creating columns from a joined table
|Affected QGIS version:||2.0.1||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||17927|
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.