[Qgis-psc] QGIS grant report: Fix handling of provider default value clauses/Autogenerate/nextval(...) handling

[Anita Graser]

Thank you for your work and report, Nyall. Great to see GeoPackage support
improve further.


Anita


On Monday, 24. October 2022 04:42:59 (+02:00), Nyall Dawson wrote:


HI PSC,



I'd like to report the current status of the grant project: "QGIS grant
report: Fix handling of provider default value
clauses/Autogenerate/nextval(...) handling" (see
https://github.com/qgis/QGIS-Enhancement-Proposals/issues/247)


The bulk of these changes landed in the QGIS 3.28 release, and we should
start seeing a decrease in the number of related issues.


A quick way to demonstrate on of the issues fixed is:


- open a geopackage file
- start editing the layer, add some features to it, but don't save the
edits
- right click the edited layer and try to save it to a different file


On older qgis releases you'll be spammed with a number of error messages
because we tried to write a string value of "Autogenerate" into a number
field for all the newly created features. On QGIS 3.28 this all just works
as expected, with no errors encountered.


While the bulk of this work is now complete, I've allowed for some of the
grant funding to cover all required follow up work as the new approach gets
wider testing in a stable release. Accordingly I'll be monitoring any
related incoming bug reports and addressing them as part of the grant
funds.


Thanks again for the opportunity to undertake this work!



Nyall



--
--
Anita Graser
Home: http://anitagraser.com
Twitter: @underdarkgis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-psc/attachments/20221024/73e24d40/attachment.htm>