[DERBY-4092] You should not be able to invoke a table function as a scalar function

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.3.1, 10.6.1.0
• Component/s: SQL
• Urgency: Normal
• Issue & fix info: Newcomer, Patch Available
• Bug behavior facts: Deviation from standard, Wrong query result
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 13/Mar/09 10:25
• Updated: 05/Jul/10 16:39
• Resolved: 18/Aug/09 15:16

Description

If you invoke a table function as a scalar function, Derby instantiates the ResultSet returned by the table function and returns that ResultSet. This behavior looks wrong. Derby should raise an error if you invoke a table function as a scalar function. Here is an example of the problem:

ij> values ( badVTI( 'foo' ) );
1
---------------
BadVTI@1ef69