Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <385503320.346331266449007927.JavaMail.jira@brutus.apache.org>
Date: Wed, 17 Feb 2010 23:23:27 +0000 (UTC)
From: "Sylvain Leroux (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-4553) In ij GETCURRENTROWNUMBER directly
 writeits result  to output
In-Reply-To: <860303680.343931266442167914.JavaMail.jira@brutus.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Sylvain Leroux updated DERBY-4553:
----------------------------------

    Attachment: DERBY-4553_repro.patch

Attaching a repro for this issue.

The repro just create a cursor and add a call to GETCURRENTROWNUMBER at the end of ij7.sql. Running the ToolScripts test suite produce the following result:
  sh$ ant all && java junit.textui.TestRunner org.apache.derbyTesting.functionTests.tests.tools.ToolScripts 
  [snip]
  .0
  F....0
  F...
  Time: 130.112
  There were 2 failures:
  [snip]

The '0's in the output are the result of GETCURRENTROWNUMBER. And are not caught by the test tool. That leads to a failure of the corresponding test.

----

By looking at the source of ij, it seems there is currently no class implementing ijResult suitable to return only one value. An option would be to create a new class derived of ijResultVector to implement scalar results as 1-dimension vector.

> In ij GETCURRENTROWNUMBER directly writeits result  to output
> -------------------------------------------------------------
>
>                 Key: DERBY-4553
>                 URL: https://issues.apache.org/jira/browse/DERBY-4553
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>            Reporter: Sylvain Leroux
>            Priority: Trivial
>         Attachments: DERBY-4553_repro.patch
>
>
> In ij, the statement GETCURRENTROWNUMBER directly write its result to output instead of returning it:
> Here are the faulty lines in ij.ij, method GetCurrentRowNumber():
> 	...
> 	LocalizedResource.OutputWriter().println(utilInstance.getCurrentRowNumber(rs));
> 	return null;
> This interferes with testing - and possibly with any external tool using the ij.ij parser.

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