[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

AW: Long Pathes on Windows and SQLite

From: Markus Schaber <m.schaber_at_codesys.com>
Date: Fri, 23 Aug 2013 14:24:52 +0000

Hi, All,

Von: Branko Čibej [mailto:brane_at_wandisco.com]
> On 22.08.2013 14:26, Markus Schaber wrote:
> > Some days ago, I stumbled across a problem, and could analyze it a little
> > bit those days.
> >
> > Windows has a general limit on the path length of 260 characters on some
> > APIs, while others allow a length of about 32k characters (with some
> > restrictions).
> >
> > Most (if not all) of the SVN codebase seems to work fine with those long
> > pathes.
>
> Yes, APR takes care to use the Unicode APIs and use \\?.
>
> > However, it seems that SQLite is not (yet) long path clean:
>
> Sigh...
> [...snip...]
>
> > I already mentioned this problem on IRC, where Bert meant that it is an
> > issue in SQLite itself which has its own windows abstracton layer.
> >
> > Now, some questions arise:
> > 1) Is this issue worth to file a bug report in the SVN database? (Up
> > to now, none of our customers has been bitten by that issue, but it is
> > very likely that one will show up sooner or later...)
>
> IMO it's a good idea to track this, but I propose you also file the report to
> SQLite (and put a link to that report in our report).
> [snip]

I did file http://subversion.tigris.org/issues/show_bug.cgi?id=4417.

I did also contact the SQLite developers about this issue, and in http://www.mail-archive.com/sqlite-users@sqlite.org/msg78853.html, Richard Hipp saids:

| SQLite version 3.8.0 allows for longer windows pathnames up to
| 3*MAX_PATH bytes, which is 3x more space that was allowed before. This is
| still not 32K but might be sufficient for your needs. The limit can be
| extended at compile-time.

This could help us to solve the problem.

Best regards

Markus Schaber

CODESYS® a trademark of 3S-Smart Software Solutions GmbH

Inspiring Automation Solutions

3S-Smart Software Solutions GmbH
Dipl.-Inf. Markus Schaber | Product Development Core Technology
Memminger Str. 151 | 87439 Kempten | Germany
Tel. +49-831-54031-979 | Fax +49-831-54031-50

E-Mail: m.schaber@codesys.com | Web: http://www.codesys.com | CODESYS store: http://store.codesys.com
CODESYS forum: http://forum.codesys.com

Managing Directors: Dipl.Inf. Dieter Hess, Dipl.Inf. Manfred Werner | Trade register: Kempten HRB 6186 | Tax ID No.: DE 167014915
Received on 2013-08-23 16:25:33 CEST

This is an archived mail posted to the Subversion Dev mailing list.