X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-1.9 required=5.0	tests=AWL,BAYES_00,SPF_HELO_PASS,T_RP_MATCHES_RCVD
X-Spam-Check-By: sourceware.org
To: cygwin AT cygwin DOT com
From: Achim Gratz <Stromeko AT nexgo DOT de>
Subject: [bug] Something fishy going on with sqlite3...
Date: Thu, 15 Mar 2012 20:59:14 +0100
Lines: 29
Message-ID: <87aa3hd4a5.fsf@Rainer.invalid>
Mime-Version: 1.0
Content-Type: text/plain
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.94 (gnu/linux)
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com


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.


Regards,
Achim.
-- 
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+

Samples for the Waldorf Blofeld:
http://Synth.Stromeko.net/Downloads.html#BlofeldSamplesExtra


--
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