X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-1.8 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: =?UTF-8?B?UmVuw6kgQmVyYmVy?= <r DOT berber AT computer DOT org>
Subject: Re: [bug] Something fishy going on with sqlite3...
Date: Thu, 15 Mar 2012 14:50:34 -0600
Lines: 43
Message-ID: <jjtkmo$po1$1@dough.gmane.org>
References: <87aa3hd4a5 DOT fsf AT Rainer DOT invalid> <jjti4r$2t7$1 AT dough DOT gmane DOT org> <8762e5d3le DOT fsf AT Rainer DOT invalid>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
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: <8762e5d3le.fsf@Rainer.invalid>
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
List-Id: <cygwin.cygwin.com>
List-Unsubscribe: <mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT 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

On 3/15/2012 2:14 PM, Achim Gratz wrote:

> René Berber <r DOT berber AT computer DOT org> writes:
>> The obvious question: what is your $TMP ?
> 
> Obvious maybe — but TMP doesn't get invoked.  :-)
> 
> SQLite tries to create the file in the current working directory.
> Again, if I do that from a windows console window, all is well, if I do
> it from mintty I get an access denied error.

Right.  Problem is I can't reproduce the error.

I'm not using a snapshot, I'm at "1.7.11(0.260/5/3) 2012-02-24", and the
operation you show, using mintty:

$ sqlite3 test
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq  name             file
---  ---------------  --------------------------------------
0    main             C:\Cygwin\home\rberber\test
sqlite> create TEMP TABLE two (
   ...> id INTEGER NOT NULL,
   ...> name CHAR (64) NOT NULL
   ...> );
sqlite> .databases
seq  name             file
---  ---------------  ---------------------------------------
0    main             C:\Cygwin\home\rberber\test
1    temp
sqlite> .schema two
CREATE TABLE two (
id INTEGER NOT NULL,
name CHAR (64) NOT NULL
);

No access denied.  The file test is created in the same directory, also
.sqlite_history .
-- 
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