Hi. Although SQLite does not have any limits for filenames, there is a limit of 512 characters for the pathname, which seems like an arbitrary choice, as it does not match the limits of any of the filesystem listed in https://en.wikipedia.org/wiki/Comparison_of_file_systems#Limits. In addition to failing to open long absolute paths, attempts to open database files in very deep directories fail, even though at first glance, it looks like SQLite should just be opening the database file's name, which is short. Can it be changed to something larger, like 4096 (Linux PATH_MAX)?
Additionally, the documentation at https://www.sqlite.org/shortnames.html is a bit misleading since it does not mention the concatenation of filenames with their full paths when opening database files. Jason Lee _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
