Re: [sqlite] Specific sqlite_autoindex_* missing in recent SQLite versions

2019-11-18 Thread Vincas Dargis
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

Re: [sqlite] Specific sqlite_autoindex_* missing in recent SQLite versions

2019-11-14 Thread David Raymond
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

[sqlite] Specific sqlite_autoindex_* missing in recent SQLite versions

2019-11-14 Thread Vincas Dargis
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