From derby-dev-return-71721-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Sun Aug 02 12:42:36 2009
Return-Path: <derby-dev-return-71721-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 50745 invoked from network); 2 Aug 2009 12:42:36 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 2 Aug 2009 12:42:36 -0000
Received: (qmail 82038 invoked by uid 500); 2 Aug 2009 12:42:39 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 81973 invoked by uid 500); 2 Aug 2009 12:42:38 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 81956 invoked by uid 99); 2 Aug 2009 12:42:38 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Aug 2009 12:42:38 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Aug 2009 12:42:35 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id DB6AE234C04C
	for <derby-dev@db.apache.org>; Sun,  2 Aug 2009 05:42:14 -0700 (PDT)
Message-ID: <1512502074.1249216934897.JavaMail.jira@brutus>
Date: Sun, 2 Aug 2009 05:42:14 -0700 (PDT)
From: "Eranda Sooriyabandara (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-4318) convert inbetween.sql to JUNIT
In-Reply-To: <1816866528.1248107834849.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/DERBY-4318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eranda Sooriyabandara updated DERBY-4318:
-----------------------------------------

    Attachment: InbetweenTest.diff

Hi Bryan,If the previous replacement correct we can use it in several
places. And after replacing I saw three parts which still gives the errors.

In row 687,

if(usingEmbedded()){
            rs = st.executeQuery(
                "values ConsistencyChecker()");

            expColNames = new String [] {"1"};
            JDBC.assertColumnNames(rs, expColNames);

            expRS = new String [][]
            {
                {"No open scans, etc"},
                {"30 dependencies found"}
            };

            JDBC.assertFullResultSet(rs, expRS, true);
        }

In the row 2891,
rs = st.executeQuery("values (3, cast (null as int))");

In row 4620,
st.executeUpdate(
            " create view v1(c1)"
            + "as"
            + "select c1 from t1"
            + "union all"
            + "select c2 from t2 ");

I am attaching the patch file here.
Thanks


> convert inbetween.sql to JUNIT
> ------------------------------
>
>                 Key: DERBY-4318
>                 URL: https://issues.apache.org/jira/browse/DERBY-4318
>             Project: Derby
>          Issue Type: Improvement
>          Components: Test
>            Reporter: Eranda Sooriyabandara
>            Assignee: Eranda Sooriyabandara
>            Priority: Minor
>         Attachments: inbetween.junit, InbetweenTest.diff, InbetweenTest.diff, InbetweenTest.diff
>
>
> conversion of inbetween.sql to JUNIT

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.