2019-11-14 17:56, David Raymond wrote:
Apparently it got smarter about "primary key unique" in 3.20.0 and stopped
making the extra index when it's a without rowid table. Don't see anything about it in
the release notes though.
Even on the current release "primary key unique" will still make an
ndex
for the unique if it's a rowid table.
-Original Message-
From: sqlite-users On Behalf Of
Vincas Dargis
Sent: Thursday, November 14, 2019 4:28 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Specific sqlite_autoindex_* missing in recent SQLite versions
Hi list,
A
Hi list,
Accidentally, when performing VACUUM using rather old SQLite 3.16.2
(from Debian 8 stretch) binary on some database file created with more
recent SQLite (like 3.29.0 available in Qt 5.13.2 or a bit older),
I've discovered that database now has a few more `sqlite_autodinex_*`
entries in `s
3 matches
Mail list logo