DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:message-id:date:from:mime-version:to:subject
	:references:in-reply-to:content-type; q=dns; s=default; b=I4+Y7d
	jbUyseoTEr40zf95128OxdbdqPQ5UnU0oCcrPyOXa17/Z3qSTI58n/WtxeWlravA
	HMDt7efQoZ8+kdPhD3rFFkrs4htBQO46tGagMG7t04pYTGuLq19fch0tWadNu34z
	lSP8qdUwA620vxHeAkOl8A3/NeFYzyWDKMhhk=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Message-ID: <51B63566.3000307@dancol.org>
Date: Mon, 10 Jun 2013 13:21:58 -0700
From: Daniel Colascione <dancol AT dancol DOT org>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version: 1.0
To: cygwin AT cygwin DOT com
Subject: Re: SQLite temporary path creation broken in latest stable release
References: <51B52B51 DOT 50203 AT dancol DOT org> <51B6272F DOT 8010001 AT etr-usa DOT com>
In-Reply-To: <51B6272F.8010001@etr-usa.com>
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="----enig2PKURAVSQFQWFPPXIBAEF"

------enig2PKURAVSQFQWFPPXIBAEF
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On 6/10/2013 12:21 PM, Warren Young wrote:
> On 6/9/2013 19:26, Daniel Colascione wrote:
>> which I haven't been able to test
>=20
> You should.  One of the changes is to prefer creating temporary tables in=
 memory
> instead of on disk, which should bypass the problem.

This change makes me nervous. What if the temporary tables are large?

>=20
>> "/var/tmp/etilqs_z28HceqmzVr3ZO1\\etilqs_rnPCuceSOgjfeTd".
>=20
> This bug is already under discussion on the SQLite mailing list:
>=20
>     http://comments.gmane.org/gmane.comp.db.sqlite.general/81718
>=20
> None of the SQLite core developers have responded to my charge that this =
looks
> like a bug in SQLite.  It shouldn't be generating temporary file names wi=
th
> backslashes in them for Cygwin builds, since it knows such paths go throu=
gh the
> Cygwin DLL, which sometimes has trouble doing the right thing with backsl=
ashes.

It seems easy enough to patch out the backslash addition.

>=20
> There is a chance the bug exists in the "Unix" path as well, since backsl=
ashes
> are legal in POSIX paths but not on Cygwin, but since the in-memory chang=
e will
> avoid this, my motivation to fix this bug twice is low.  Once should be e=
nough.


------enig2PKURAVSQFQWFPPXIBAEF
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.13 (Cygwin)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlG2NWgACgkQ17c2LVA10VuzNACbBUJTjAXnwFnnVyB0HBowTRPv
D0QAoOjhBCnC32KUakRODLMfcmj0bivr
=PzhH
-----END PGP SIGNATURE-----

------enig2PKURAVSQFQWFPPXIBAEF--