/ View Ticket
Ticket UUID: c060923a5422590b3734eb92eae0c94934895b68
Title: VFS filename truncation issues
Status: Closed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: VFS Resolution: Wont_Fix
Last Modified: 2014-03-11 13:06:54
Version Found In: 3.6.2

In essence the Unix VFS uses a hard-coded limit of 512 bytes for a fully qualified filename, truncates anything longer than that, and then gives can't open error on having stuffed the situation up. In practise current Unix systems have maxiumum pathname lengths of 4096 bytes which means there are files that SQLite can't open. Note the truncation happens even if a fully qualified pathname is passed in. This has also affected mozilla.

The Windows VFS has the same problem but it's default max length is the same as Window's. However Windows does allow pathnames to be prefixed by "\\?\" which then uses an alternate path parser with a 32kb limit.

rogerb added on 2009-10-19 05:17:39:
More details on how truncation also affects Windows is at http://www.sqlite.org/cvstrac/tktview?tn=2996