Bug report #17505

Relation reference widget doesn't update to NULL value when deleting a reference

Added by Regis Haubourg over 2 years ago. Updated over 1 year ago.

Status:Closed
Priority:High
Assignee:Paul Blottiere
Category:Edit widget
Affected QGIS version:2.18.14 Regression?:Yes
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:25402

Description

When checking "allow null" values in relation reference widget, and use the red cross to suppress a referenced foreign key, no "UPDATE mytable set my_fk = NULL ;" is forwarded to the database.

So this looks like a tough regression.

History

#1 Updated by Regis Haubourg over 2 years ago

  • Assignee set to Hugo Mercier

#2 Updated by Regis Haubourg over 2 years ago

  • Assignee deleted (Hugo Mercier)

#3 Updated by Paul Blottiere over 2 years ago

  • Assignee set to Paul Blottiere

#4 Updated by Jürgen Fischer over 1 year ago

  • Status changed from Open to Feedback

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#5 Updated by Regis Haubourg over 1 year ago

  • Status changed from Feedback to Closed

This is solved in 3.4. Closing

Also available in: Atom PDF