<div dir="auto"><div>No objection from me!<div dir="auto"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Dec 13, 2022, 8:19 AM Even Rouault via gdal-dev <<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
<a href="https://github.com/qgis/QGIS/issues/51188" rel="noreferrer noreferrer" target="_blank">https://github.com/qgis/QGIS/issues/51188</a> has been brought to my <br>
attention. The issue is that the new background building of the RTree of <br>
GeoPackage files introduced in 3.6.0 didn't work well with committing <br>
transactions in between, which is easily triggered by ogr2ogr. All <br>
features were inserted but with default settings ~ 10% of them lacked an <br>
entry in the spatial index, which can be enough to break interactive <br>
display and workflows relying on spatial filtering. When using ogr2ogr, <br>
I believe the issue can only be seen when creating layers with more than <br>
100 000 features, since that's the default value for the interval at <br>
which transactions are committed.<br>
<br>
I've a fix ready in <a href="https://github.com/OSGeo/gdal/pull/6911" rel="noreferrer noreferrer" target="_blank">https://github.com/OSGeo/gdal/pull/6911</a>. The fix <br>
itself is a simple two-liner: <br>
<a href="https://github.com/OSGeo/gdal/pull/6911/commits/3f5f6225fe82e0c2e0241e4f66bfb861cdf4fe9d" rel="noreferrer noreferrer" target="_blank">https://github.com/OSGeo/gdal/pull/6911/commits/3f5f6225fe82e0c2e0241e4f66bfb861cdf4fe9d</a><br>
<br>
Given the status of GeoPackage being the default format for QGIS, I <br>
believe this is a severe enough issue to warrant an advanced 3.6.1 <br>
release, and an official retraction of 3.6.0.<br>
<br>
Thoughts ?<br>
<br>
Even<br>
<br>
-- <br>
<a href="http://www.spatialys.com" rel="noreferrer noreferrer" target="_blank">http://www.spatialys.com</a><br>
My software is free, but my time generally not.<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank" rel="noreferrer">gdal-dev@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/gdal-dev" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div></div></div>