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
	=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
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>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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