[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.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.4.1.3
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 22/Jan/08 23:50
• Updated: 21/Jan/11 17:51
• Resolved: 10/Jun/08 21:01

Description

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.

Issue Links

• is part of: DERBY-2034 Tracking of bugs that lead to incorrect results being stored or returned to the client
• is related to: DERBY-3512 Using functions, you can create a LONG VARCHAR value which is longer than the maximum length of a Derby LONG VARCHAR