SQLite User Forum

sqlite3rbu_vacuum() fails on Windows if zState == NULL
Login

sqlite3rbu_vacuum() fails on Windows if zState == NULL

(1) By Ralf on 2022-11-08 13:31:02 [source]

sqlite3rbu_vacuum("test.db", NULL); fails with an "invalid uri authority" error for local files on Windows because

https://www.sqlite.org/src/file?ci=trunk&name=ext/rbu/sqlite3rbu.c&ln=2786

always generates a zState URI with just 2 slashes like

  • file://C:\dir\file.db

According to https://en.wikipedia.org/wiki/File_URI_scheme#Windows_2 URIs for local files should omit the hostname "localhost" but not the slash, like this:

  • file:///C:\dir\file.db ^

The latter is then again accepted by sqlite3ParseUri().

(2) By Dan Kennedy (dan) on 2022-11-08 20:07:30 in reply to 1 [link] [source]

Thanks for analyzing and reporting this. Now fixed here:

https://sqlite.org/src/info/77ccc8ea8a901df6

Dan.