db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Created: (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.
Date Tue, 22 Jan 2008 23:50:34 GMT
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


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.


Mime
View raw message