Dear Maintainer,

in version 3.36 a new flag was introduced to enable rowids in views. This was
the default behaviour before.

Currently this breaks tests for GeoDjango when used with spatialite.
The Django bug is tracked here:

https://code.djangoproject.com/ticket/32935

Adding -DSQLITE_ALLOW_ROWID_IN_VIEW to CFLAGS should restore compatibility with
spatialite.

Regards,
Michael


- -- System Information:
Debian Release: bookworm/sid
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: arm64 (aarch64)

Kernel: Linux 5.15.35-rockchip64 (SMP w/6 CPU threads; PREEMPT)
Kernel taint flags: TAINT_CRAP
Locale: LANG=en_DK.UTF-8, LC_CTYPE=en_DK.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_DK.UTF-8), LANGUAGE=en_DK.UTF-8
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages libsqlite3-0:arm64 depends on:
ii  libc6  2.33-7

libsqlite3-0:arm64 recommends no packages.

libsqlite3-0:arm64 suggests no packages.

- -- no debconf information
-----BEGIN PGP SIGNATURE-----

iQFFBAEBCgAvFiEEqVSlRXW87UkkCnJc/9PIi5l90WoFAmLF/2URHGZsYWRpQGRl
Ymlhbi5vcmcACgkQ/9PIi5l90Wo01Qf+NVpDRZ0fqOQcsHTH31v9r7Bf566mTJdl
deW/xnDOmege3AG0bt15F9ItXyVztBldQvmwguIQDdxqayImAPEytlWzd9Seiemz
Jo+PaHGR59pjXTBhkyUB9S6nhM+PB5wPoD3UZPrcLt1zw2NL9B0HVMH3+idgWwNC
s5jqc5iPq1I4ZzuqYsjEBM1MOEeLITdkc6ny7b+/EVdeFdKx7B+I/u6Hy19iaZsv
bXSt5l4xYPEd1asUJsBOhyXR7YrSK0ZwnzvOyqiTs9diCJaV+XtH1fma3ugdXkcS
30wgeNUoQUfk+QpHgLYJ3fNycNSnpFJB/XVKQ7E36kxM5FFVxaf+Nw==
=SWju
-----END PGP SIGNATURE-----

We believe that the bug you reported is fixed in the latest version of
sqlite3, which is due to be installed in the Debian FTP archive.

A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to 1014495@bugs.debian.org,
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Laszlo Boszormenyi (GCS) <gcs@debian.org> (supplier of updated sqlite3 package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing ftpmaster@ftp-master.debian.org)
Format: 1.8
Date: Thu, 07 Jul 2022 00:04:47 +0200
Source: sqlite3
Architecture: source
Version: 3.39.0-2
Distribution: unstable
Urgency: medium
Maintainer: Laszlo Boszormenyi (GCS) <gcs@debian.org>
Changed-By: Laszlo Boszormenyi (GCS) <gcs@debian.org>
Closes: 1014495
Changes:
 sqlite3 (3.39.0-2) unstable; urgency=medium
 .
   * Compile with -DSQLITE_ALLOW_ROWID_IN_VIEW to re-enable rowid for views
     (closes: #1014495).
Checksums-Sha1:
 59df8152781fe4c6f21941e5ca10845fae87b28e 2487 sqlite3_3.39.0-2.dsc
 e2043031dbf56f5b9e41d99155fc3f54f272563a 29452 sqlite3_3.39.0-2.debian.tar.xz
Checksums-Sha256:
 4b4af780290181fe37ae3368eda704bbd6da5781ad1df8dde8bc95a7c4b09164 2487 sqlite3_3.39.0-2.dsc
 3d9b5b3ecde02ca03704c3f5fdc685ac0fdb698218a3583360b14baffb5658c9 29452 sqlite3_3.39.0-2.debian.tar.xz
Files:
 75b9e534141387ec7c524db2253f74e0 2487 devel optional sqlite3_3.39.0-2.dsc
 dc0ee600dba33e85aafce1cffdb7bc7d 29452 devel optional sqlite3_3.39.0-2.debian.tar.xz
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEfYh9yLp7u6e4NeO63OMQ54ZMyL8FAmLGZz8ACgkQ3OMQ54ZM
yL8u+g/9FiBEJ/6ZEXr0DKkhHhE2gXdkVHTBt7VK86H7C2NV/jKhgqq+JaYAx38n
kVOCFmEx8rZzsSMEdnq3kCAsuB3Y6ID80xGPgOBp10FSqzOcQPVp36r3mMU4Wm5k
XFCt09XfgXankLfwwZHcI7+3k3W0kmFD0W22NBXSxFNxS3aH0m1xd3N9Z0VDjdbf
Tl3j4WdUwF35WzU7Q/Yec3QvZ+Jh2pD/xbnmLjWJlPULatf8ycnjio3WqJj9jS7w
z9NmtBnjCeSvIfu2AeqaBcvV/fgKcaUXga6yL9ENOTwy+kPgFu4D67693poEj071
dOFS0QIpYMXletk2g4bcwHbX1ofrNeT1rR5LQtAakFB8169ctsJYFr8C4QyG6qvG
W3fOOlMgkgfk4eD3NSd0VXY/ZAx1ZxcbmgHLGRm1gLgr447RX6poMhzWyC3OoMhV
X7aijAb3gmNDfjP7NJcBFG3CDHbe3B+ZV1YBmvGGRsRyoJj0jejKMeZLf4buIfSj
fvbsURAdG6mXYom3yOytaIXeD0JQpzjitPE7QQ4692gpueRB6DRdIPAs3mKW/Vhi
DhCsIxT30EtZUmM1gWYGtREEqT/+hmgUVf4ZCEkJG2RW4W13xMfBIMNhindY7Kk0
dUaV09+mz9G7/foIFZqTZxvm6xyLrEmSSx+903hPq8CyUPlpX9g=
=A9vy
-----END PGP SIGNATURE-----