opengisch / OSGeo4A

OSGeo4A is a build environment to cross-compile opensource GIS software for android devices
MIT License
30 stars 22 forks source link

Downgrade sqlite3 to 3.35.5 to fix spatialite regression #127

Closed nirvn closed 2 years ago

nirvn commented 2 years ago

Alright, for QField 1.10, we have two choices: upgrade GDAL from 3.3.2 to 3.4.0, or downgrade sqlite3 from 3.36.0 to 3.35.5 -- I guess the latter is safer, so going ahead with that.

Long story short, sqlite has change the way it handles views and ROWID, which caused a regression in GDAL (a fix was pushed into 3.4.0 https://github.com/OSGeo/gdal/pull/4017).

nirvn commented 2 years ago

@m-kuhn , I thought https://github.com/opengisch/OSGeo4A/pull/126 would work, but unless the latest rounds of APKs tell otherwise, we have to move to this plan B :)

For the record, vcpkg also has sqlite 3.36.0 so there we'll need to make sure we run on gdal >= 3.4.