To: cygwin@cygwin.com
From: =?ISO-8859-1?Q?Ren=E9_Berber?= <r.berber@computer.org>
Subject: Re: [bug] Something fishy going on with sqlite3...
Date: Thu, 15 Mar 2012 14:06:54 -0600
Lines: 28
Message-ID: <jjti4r$2t7$1@dough.gmane.org>
References: <87aa3hd4a5.fsf@Rainer.invalid>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.19) Gecko/20081209 Lightning/0.9 Thunderbird/2.0.0.19 Mnenhy/0.7.6.0
In-Reply-To: <87aa3hd4a5.fsf@Rainer.invalid>
Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm
Precedence: bulk
Sender: cygwin-owner@cygwin.com
Mail-Followup-To: cygwin@cygwin.com

On 3/15/2012 1:59 PM, Achim Gratz wrote:
> 
> I've been trying to troubleshoot an SQLite failure that boils down to
> this: SQLite catches an access denied error when trying to create a
> _temporary_ table and only when sqlite3 is run from mintty.  If I do the
> same thing in a console, all is well (as I found out when trying to
> strace the sqlite3 process in another window).
> 
> :> sqlite3
> :sqlite> CREATE TEMP TABLE two (
> :   ...>     id INTEGER NOT NULL,
> :   ...>     name CHAR (64) NOT NULL
> :   ...> );
> 
> I'm already at the 2012-03-14 snapshot.  I currently work around by
> compiling SQLite to use only memory and nver a file for temporary
> tables, but it seems that there may be a larger problem lurking here.
> 
> The same thing happens with the packaged sqlite3, a freshly compiled one
> from the source package and the version that is delivered with the
> DBD::SQLite package from CPAN.

The obvious question: what is your $TMP ?

You may remember a recent thread about temporary directories, then they
where changed in base-files.
-- 
René Berber


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple