Bug report #5284
MS SQL features disappear if SQL errors on insert
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||fixed|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||15004|
If you are saving a feature and the database fails to insert due to a SQL error the feature will disappear with no error to tell the user what has happened.
The PostGIS provider throws a error and blocks the save operation until the user has fixed the mistake, letting the user try to save again after the changes have been made.