Bug report #6994
Can't update NULL numerical MS SQL
|Affected QGIS version:||master||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||16098|
Seems that you can't add or update a numerical field that allows nulls using the attribute table or form. If you try the attribute form doesn't allow you to enter a value into the null field.
Create the following table:
CREATE TABLE [dbo].[test](
[id] [int] IDENTITY(1,1) NOT NULL,
[value] [decimal](10, 3) NULL,
[valuef] [float] NULL,
[valuer] [real] NULL)
- Open the layer in QGIS. It doesn't need a geometry column
- Open the attribute table
- Make the table editable
- Click the add button
- Try entering a value into any of the fields. The form will stop you.
I'm not 100% sure where the issue is here. I have tried to reproduce it on PostGIS and Spatialite but at the moment it seems to only happen with MS SQL layers.