[Qgis-user] bug in 3.10.2 (after upgrading from 3.10.1) with NULL being lost in PostGIS

[Alessandro Pasotti]

On Tue, Feb 4, 2020 at 5:02 PM Jason Carlson <jason at starlandcounty.com>
wrote:

> Can anyone else confirm this before I submit it?
>


Can you please check latest master builds first? I've done a couple of
fixes in the past few days that might have an impact on this issue.

If the issue is still there, please file a ticket and attach a small SQL
dump and a QGS project to reproduce the issue.





> After I upgraded from 3.10.1 to 3.10.2 I noticed an issue that it no
> longer handles null values correctly when updating records in PostGIS.
>
> I rolled back to version 3.10.1 and the issue goes away.
>
> Here is more detail:
> I have some PostgreSQL tables that have fields that can be NULL or text
> but I have check constraint in place saying it has to be NULL or one of a
> list of specific strings.
>
> In 3.10.1 if I go to edit a record that has some fields set as NULL, when
> the QGIS attribute form loads for editing, it shows those fields as NULL
> inside the text field (they can be text or null). I can make changes to any
> fields and save and the NULL fields remain as NULL.
>
> In 3.10.2 if I go to edit the same record, the QGIS attribute form when
> displayed for editing the record does not show those fields as being NULL
> but an empty string. When I submit changes, any fields that should still be
> NULL are not being submitted as NULL as I get a check constraint error
> saying it doesn't fit the criteria. I've tried entering into those fields
> manually as NULL or 'NULL' or "NULL" and a dozen or so other guesses and it
> still fails.
>
> Again, if I roll back to version 3.10.1 it works as it has on many
> previous versions all the way back to 2.8
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



-- 
Alessandro Pasotti
w3:   www.itopen.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200204/cc137cb6/attachment.html>