X-Recipient:	archive-cygwin AT delorie DOT com
DomainKey-Signature:	a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:message-id:date:from:mime-version:to:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	q=dns; s=default; b=BAH2Hrk6S/4veAVo//2Gnro2+SqeItIjGZ0Fcv0LQpf
	jBFBQqZoegNOsi1vDPrLVClTGEqYqy+nPYLgPtt6l2awXuZNKJHGxsX1UGDmU1eE
	ALp+4r/+x1DOkj/P0QZgXI11krA9FpMNFrG3I089E6yjjDXpBah0myuMZOZ1J8Hk
	=
DKIM-Signature:	v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:message-id:date:from:mime-version:to:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	s=default; bh=7qXC7esG9t2R7oszU/aHrtG5JTE=; b=yxsqMw9LqBtNheR5P
	X/9b//42ZH1WfpECqlpZNu1TmBi1/zwTTgV+5/eWfpj98EbAcRu7ccMkcoTRxsHO
	zF2bRasnd1YCNy1RrmWz0JpptUWfwz0D4Z5UfYcpehixJQZ9AE9HaWulQjllCzob
	m8KkAHvj9pkbWwxTo9eRfQR9G0=
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
X-Spam-SWARE-Status:	No, score=-2.8 required=5.0 tests=AWL,BAYES_00,KHOP_THREADED,RCVD_IN_DNSWL_NONE,RCVD_IN_HOSTKARMA_NO,RCVD_IN_HOSTKARMA_YE,SPF_PASS autolearn=ham version=3.3.1
Message-ID:	<51AD3BB4.2010601@acm.org>
Date:	Mon, 03 Jun 2013 17:58:28 -0700
From:	David Rothenberger <daveroth AT acm DOT org>
User-Agent:	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version:	1.0
To:	cygwin AT cygwin DOT com
Subject:	Re: [TEST] sqlite3-3.7.17-1 (Cygwin 1.7.19 locking feature)
References:	<51ACF886 DOT 10301 AT etr-usa DOT com>
In-Reply-To:	<51ACF886.10301@etr-usa.com>

On 6/3/2013 1:11 PM, Warren Young wrote:
> This is a big-push attempt at a version of Cygwin SQLite that will make
> everyone happy (ha!) whether they want POSIX advisory locking behavior
> or Windows mandatory locking behavior.  My part of the effort is being
> stubborn on this point and doing the basic testing and packaging.  The
> real magic was added by Corinna to yesterday's 1.7.19 cygwin1.dll snapshot.

Thank you (and thank you Corinna!) for all your hard work and
perseverance with this issue.

Unfortunately...

> - By default, it requests mandatory locking using the feature added in
> yesterday's Cygwin 1.7.19 snapshot.  This should make it cooperate with
> native Windows programs also using SQLite despite running in Unix mode.
> 
> - This mandatory-locks-by-default feature of this SQLite build can be
> disabled by setting the new CYGWIN_SQLITE_LOCKING environment variable
> to "posix".

... initial results with the Subversion test suite (for 1.8.0-rc2) show
that most tests fail with a "sqlite: database is locked (S5)" error
unless CYGWIN_SQLITE_LOCKING=posix.

The good news is that the test cases that relied on temporary tables are
now passing.

I'll try the 1.7.10 test suite shortly and report back on the results,
although I expect them to be the same.

-- 
David Rothenberger  ----  daveroth AT acm DOT org

Water, taken in moderation cannot hurt anybody.
                -- Mark Twain

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