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,TW_LQ,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: Re: [bug] Something fishy going on with sqlite3...
Date: Thu, 15 Mar 2012 22:13:32 +0100
Lines: 56
Message-ID: <871uotd0ub.fsf@Rainer.invalid>
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>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
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

René Berber <r DOT berber AT computer DOT org> writes:
> Right.  Problem is I can't reproduce the error.

I don't have any better information at the moment.

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

I've switched to snapshots due to other problems (no Ctrl-C in console)
and have just been updating them whenever a new one came out.  I can't
say for sure it has to do with the snapshot, but since you can't
reproduce it I might have to revert the installation to the release
version and try again.

> $ sqlite3 test

I doubt it makes any difference, but I didn't give any file name when
invoking SQLite.

[...]> SQLite version 3.7.3
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite>
> seq  name             file
> ---  ---------------  ---------------------------------------
> 0    main             C:\Cygwin\home\rberber\test
> 1    temp

If the temp table is really not associated with a file, then this test
didn't trigger the bug most likely.  In my test case the temporary file
supposedly should be named etilqs-<something random>.

> 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.  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.  I didn't see anything that jumped out on me in the
strace.


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

SD adaptation for Waldorf microQ V2.22R2:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada


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