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=nNcPDGFoJh5pZl/9Ukiv3S+0s6Kj3MI4NMQ57dNQGGK
	6I2chHQv0dSLk2x2giOg4mB9kfNvSXp1EG7YPRWnDnznNYTbesYLGJE23pMKi69n
	CUKNeutF+i6CrtjLvupaVjf03I+5/IMrqVyZxjzkd7HPXInIujWKZZ1swgZduDjQ
	=
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=sQXyezSrZqfu5jMNpJM0d4o+aTA=; b=cOLtdwugjifnpk96x
	NQ603kice2RI7SdurxbkccpY5DX8miDqb8KMAy7gg/rwe478tnjrxd9CwqOY4yTa
	l8un3R4q7RCyn6wtsucR2D+czRXnPElqCxBbk+XIQOcJkH20kfREx3J+6kzbUVl8
	e9X8j07wkkuLHJZlzzMEtgyYDs=
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=-3.8 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,KHOP_THREADED,RCVD_IN_DNSWL_LOW,RCVD_IN_HOSTKARMA_YE,SPF_PASS autolearn=ham version=3.3.1
X-Received: by 10.182.87.42 with SMTP id u10mr6685566obz.73.1370034658800;        Fri, 31 May 2013 14:10:58 -0700 (PDT)
Message-ID: <51A911E3.8060605@users.sourceforge.net>
Date: Fri, 31 May 2013 16:10:59 -0500
From: "Yaakov (Cygwin/X)" <yselkowitz AT users DOT sourceforge DOT net>
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: sqlite3: bug with monotone
References: <51A6B6EB DOT 6050309 AT users DOT sourceforge DOT net> <loom DOT 20130530T122354-144 AT post DOT gmane DOT org> <51A825D0 DOT 8040304 AT users DOT sourceforge DOT net> <51A8EFAF DOT 4030104 AT etr-usa DOT com>
In-Reply-To: <51A8EFAF.4030104@etr-usa.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 2013-05-31 13:45, Warren Young wrote:
> On 5/30/2013 22:23, Yaakov (Cygwin/X) wrote:
>> I can confirm that -DSQLITE_TEMP_STORE=2 is enough to fix
>> monotone on its own.
>>
>> I have updated my build accordingly, plus added two more configuration
>> options, and a patch for the manpage, from Fedora.  Can *this* get into
>> the distro package?
>
> I don't see any serious problems from changing that build option.  It
> doubtless would prevent 32-bit Cygwin SQLite from accessing gigabyte+
> DBs, but those needing to do such things can a) set the pragma to
> restore previous behavior; b) switch to Cygwin 64; or c) switch to
> native SQLite.

Shouldn't this only limit the size of temp tables?  How often would 
those be that large?

> As for the rest of it, are you proposing that I adopt your Ports version
> of SQLite, replacing what I have?  Does yours include the Unix mode /tmp
> patch I mentioned?

You may if you wish; the /tmp patch is there now, alongside the 
aforementioned manpage patch and other enabled options.


Yaakov


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