Bug report #6710

QGIS appears to support editing joined tables, but it really does not

Added by Alister Hood about 7 years ago. Updated about 5 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Vectors
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:fixed/implemented
Crashes QGIS or corrupts data:No Copied to github as #:15875

Description

- Join any table A to any table B.
- Open the attribute table for table B and enable editing. You will be able to edit the joined fields and even click "save" without any error/warning messages. But if you close and then reopen the table you will find that the edits were not saved, because QGIS only supports read-only joins (I think there is a ticket for read-write joins).
Also:
- The delete column dialog lists the read-only columns
- The field calculator lists the read-only columns under "update existing field"
- The joined columns are included in the new "Column Preview" list (in QGIS 2 - see description below). But if you select one of them, you get an error message.

History

#1 Updated by Alister Hood about 7 years ago

Also tested in 1.8
The only difference is that in 1.8 the table updates when you "save" - you don't need to close and reopen it to see that the changes were not saved.

#2 Updated by Giovanni Manghi about 7 years ago

  • Status changed from Open to Feedback

Alister Hood wrote:

Also tested in 1.8
The only difference is that in 1.8 the table updates when you "save" - you don't need to close and reopen it to see that the changes were not saved.

so, seems a regression, right?

#3 Updated by Alister Hood about 7 years ago

No. The important bug is this part:

You will be able to edit the joined fields and even click "save" without any error/warning messages.

Not this part:

need to close and reopen it to see that the changes were not saved.

#4 Updated by Alister Hood almost 7 years ago

[Added two more symptoms to the description]

#5 Updated by Alister Hood over 6 years ago

This has improved somewhat in master. If you try to delete a joined column or edit a joined field it fails silently, but now at least you can still see that nothing has actually changed.

There is another new issue: if you click the left button in the bottom right of the attribute table (BTW, what is it called? These buttons need tooltips), then click the drop-down thing at the top left, the joined columns will be included in the "Column Preview" list. But if you select one of them, you get an error message:

Could not set column 'Column_name' as preview column.
Parser error:
syntax error, unexpected COLUMN_REF, expecting $end

#6 Updated by Giovanni Manghi about 5 years ago

  • Resolution set to fixed/implemented
  • Status changed from Feedback to Closed

all issues seems solved to me in master: joined columns are clearly marked in several dialogs (like the delete column one) and the error described in the last comment does not show anymore.

Also available in: Atom PDF