On Tue, 16 Aug 2022 12:14:46 -0700 (PDT), Konrad J Hambrick wrote:
> I failed one test ( check_drop_rename -- see below )
>
this happens because you are using a too much recent version of
libsqlite3
here is the full history: SpatiaLite had a bug that none noticed
(a malformed SQL statement used for automatically creating a
Trigger). Unhappily older versions of libsqlite3 too had a bug
that didn't reported the SQL error, so apparently all was going
well.
at some point a new version of libsqlite3 appeared that finally
detected the SQL error, so now we are left with a (rightfully)
failing test. of course the current development version in
the Fossil repository already contains the fix for this issue.
> One question I have: is libspatialite compatible with proj 9.0.1 ?
>
if I correctly remember there is any recent change releated to proj.
a more comprehensive answer: I'm not really sure if starting a
fresh porting by using the slightly outdated 5.0.1 (released 18
months ago) is the best possible option.
the current development version in the Fossil repository
surely contains several interesting bug fixes applied in
the meanwhile and is surelly well aligned with the more
recent versions of GEOS, PROJ and alike.
if you are possibly interested and do not know Fossil
just try this from the shell:
fossil clone
https://www.gaia-gis.it/fossil/libspatialite \
./libspatialite.fossil
mkdir libspatialite
cd libspatialite
fossil open ../libspatialite.fossil
./configure
bye Sandro