Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (nike.apache.org: domain of m.v.lunteren@gmail.com
 designates 209.85.146.182 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=NWxleghSmSFd78gTQXD4nS7U1WGoOlrJ5hK1rsdYNLzltQFSTgf3tUR2VTl0DonZXE
         XKmZxuglDj6e+e66NcXjbQBXTPe8kxuWGuN5QEqjAhRDt4RiqnU3zW8kIpLXCFmLAllm
         Vv90gcs/+3oaOhb5uMmOo7aLnJbOj9bP7I/ag=
MIME-Version: 1.0
In-Reply-To: <bf7f828e0903221453h10097362s3773a0bf795b41a1@mail.gmail.com>
References: <bf7f828e0903221453h10097362s3773a0bf795b41a1@mail.gmail.com>
Date: Sun, 22 Mar 2009 15:18:04 -0700
Message-ID: <c25576af0903221518g240213c2peb589f54476796db@mail.gmail.com>
Subject: Re: Tests missing on holdCursorExternalSortJDBC30.sql ?
From: Myrna van Lunteren <m.v.lunteren@gmail.com>
To: derby-dev@db.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Sun, Mar 22, 2009 at 2:53 PM, Tiago Espinha <tiago@espinhas.net> wrote:
> Hey guys,
> I am working on DERBY-4090 and I started with the
> holdCursorExternalSortJDBC30.sql . The thing is that on the file's overvi=
ew,
> 10 tests are reported as follows:
> -- overview:
> -- =A0 =A0TEST =A00: test hold cursor with external sort (order by).
> -- =A0 =A0TEST =A01: basic heap =A0scan tests (multiple rows)
> -- =A0 =A0TEST =A02: basic btree scan tests (zero rows/update nonkey fiel=
d)
> -- =A0 =A0TEST =A03: basic btree scan tests (multiple rows/update nonkey =
field)
> -- =A0 =A0TEST =A04: basic btree scan tests (zero rows/read only/no group=
 fetch)
> -- =A0 =A0TEST =A05: basic btree scan tests (multiple rows/read only/no g=
roup
> fetch)
> -- =A0 =A0TEST =A06: basic tests for cursors with order by
> -- =A0 =A0TEST =A07: test of hold cursor code in
> DistinctScalarAggregateResultSet.java
> -- =A0 =A0TEST =A08: test of hold cursor code in GroupedAggregateResultSe=
t.java
> -- =A0 =A0TEST =A09: test scan positioned on a row which has been purged.
> -- =A0 =A0TEST 10: test scan positioned on a page which has been purged
> However, only two actual tests exist in that file. Is this normal or am I
> missing something? Why would the remaining tests have been removed?
> Tiago

Hi Tiago,

Converting this test is actually DERBY-3842 - currently owned by
Junjie, but I think you can just assign yourself and link it to
DERBY-4090. Junjie made a patch but there were some comments that
never got addressed.

But to get to the point you were asking - looks to me like the top of
comments at the top of the test are somewhat bogus - looks like
someone might have done a cut-and-paste from holdCursorJDBC30.sql and
never adjusted the comments.

HTH.
Myrna