Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 52084 invoked from network); 16 Nov 2005 01:57:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 16 Nov 2005 01:57:45 -0000 Received: (qmail 76923 invoked by uid 500); 16 Nov 2005 01:57:44 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 76895 invoked by uid 500); 16 Nov 2005 01:57:44 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 76885 invoked by uid 99); 16 Nov 2005 01:57:43 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Nov 2005 17:57:43 -0800 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=RCVD_IN_SORBS_WEB,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of suresh.thalamati@gmail.com designates 64.233.184.196 as permitted sender) Received: from [64.233.184.196] (HELO wproxy.gmail.com) (64.233.184.196) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Nov 2005 17:57:35 -0800 Received: by wproxy.gmail.com with SMTP id 67so2012411wri for ; Tue, 15 Nov 2005 17:57:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=fxRn1NYg34is/nWk7WgvRS1DZv6VRG1PvVWPHyboRPtXDUDsANfy99xIEglkrw9eKvuciTHVAPLenxHEKld0PKW+u57Crrr6jalUj9d2bstQMphhjae7kHkeIfIIKYaz9XehPoUcix/uwhBpqOclch2buaXmlCRuFYxU5PNgwH4= Received: by 10.64.193.9 with SMTP id q9mr5091996qbf; Tue, 15 Nov 2005 17:57:22 -0800 (PST) Received: from ?9.30.40.126? ( [129.42.184.35]) by mx.gmail.com with ESMTP id e19sm4153009qba.2005.11.15.17.57.21; Tue, 15 Nov 2005 17:57:22 -0800 (PST) Message-ID: <437A91FE.4000407@gmail.com> Date: Tue, 15 Nov 2005 17:57:18 -0800 From: Suresh Thalamati User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: derby-dev@db.apache.org Subject: Re: RowLocation lifetime References: <43729B2D.9070502@sun.com> <43729E46.4020105@sbcglobal.net> <4378B489.1030104@sun.com> <4378BE7D.6050004@sbcglobal.net> <4378FBB1.6050606@sbcglobal.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N �ystein Gr�vlen wrote: >>>>>>"MM" == Mike Matrigali writes: > > > MM> It is only stable while some sort of stable table intent lock is held. > MM> Rows can move during a compress table operation. > > I understand, when a record is moved to another page, its RecordId > will change. Is this the only case where a RecordId will change? It seems like that for the heap tables. By quick scan at the code I find only btrees set derby.storage.reusableRecordId=true, and this property is not supposed to be set by the users. If a invalid handle is passed to store, in one fecth case I noticed it throws the exception SQLState.RAWSTORE_RECORD_VANISHED , Thanks -suresht