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

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

[sqlite] Specific sqlite_autoindex_* missing in recent SQLite versions

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

[sqlite] Creating operators for custom functions

Hello, It is very nice to have sqlite3_create_function() interface, so I can implement regexp() with Qt libraries that I use already. Snippet from documentation says: >The REGEXP operator is a special syntax for the regexp() user function. So REGEXP is also an operator which works out of the