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 16:33:00 -0600
Lines:	58
Message-ID:	<jjtqmt$93i$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> <jjtkmo$po1$1 AT dough DOT gmane DOT org> <871uotd0ub DOT fsf AT Rainer DOT invalid>
Mime-Version:	1.0
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:	<871uotd0ub.fsf@Rainer.invalid>
X-IsSubscribed:	yes
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
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 3:13 PM, Achim Gratz wrote:

>> 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 .
> 
> In case it wasn't clear in my first posting, I can create a new table
> (not marked TEMPORARY) just fine.

You quoted the output of command .schema, not the table creation which
used 'create TEMP TABLE ...'

Let's try again, no file this time:

$ sqlite3
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create TEMP TABLE two (
   ...> id INTEGER NOT NULL,
   ...> name CHAR (64) NOT NULL
   ...> );
sqlite>
sqlite> .databases
seq  name             file

---  ---------------
----------------------------------------------------------
0    main

1    temp

sqlite>
sqlite> .schema two
CREATE TABLE two (
id INTEGER NOT NULL,
name CHAR (64) NOT NULL
);

The command .schema was just for showing that the operation not only
succeeded, but didn't cause any error.

> Before or after getting the "access
> denied" error I can create "real" tables as much as I want, it is only
> the temporary ones that give trouble and only when they are set to go to
> files, not memory.

How do you set them to go into files?

Are you using '.backup temp <file name>' and 'dump ..." after creating
those tables?
-- 
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

- Raw text -