Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <296012518.1204926946346.JavaMail.jira@brutus>
Date: Fri, 7 Mar 2008 13:55:46 -0800 (PST)
From: "Daniel John Debrunner (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3341) TABLE FUNCTION returning CHAR values
 does not return a correct value if the Java ResultSet class returns a value
 less than the length of the defined CHAR.
In-Reply-To: <4221390.1201045834725.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-3341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12576393#action_12576393 ] 

Daniel John Debrunner commented on DERBY-3341:
----------------------------------------------

> For the record, my first attempt to fix this problem was to insert CASTs into the bound tree. That did not work.

It would be interesting to see the details on this to either allow others not to waste their time trying a similar solution or to allow others to get the solution working.
The benefit of an open source community is to throw code out there and ask opinions on why it doesn't work, usually the whole community benefits through the exposure.


> TABLE FUNCTION returning CHAR values does not return a correct value if the Java ResultSet class returns a value less than the length of the defined CHAR.
> ----------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3341
>                 URL: https://issues.apache.org/jira/browse/DERBY-3341
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Daniel John Debrunner
>             Fix For: 10.4.0.0
>
>         Attachments: derby-3341-01-coerce.diff, derby-3341-01-da-coerceWithTests.diff, derby-3341-02-aa-refGuide.diff, derby_3341_test.txt, rrefcreatefunctionstatement.html
>
>
> Defining a column in the returned type as CHAR(10) requires that the returned value be of length 10 characters.
> Defining a table function with a return type of:
>    returns TABLE  column0 char( 10 ), column1 char( 10 ))
> seems to just return whatever the Java ResultSet implementation handed it.
> My guess this is true for all variable length types, no casting of the value occurs when it is returned to the SQL domain.
> Java single value functions and procedure out parameters do perform any required casting to ensure the value is of the declared type.

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