You should not be able to invoke a table function as a scalar function
----------------------------------------------------------------------
Key: DERBY-4092
URL: https://issues.apache.org/jira/browse/DERBY-4092
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.4.2.1, 10.4.3.0, 10.5.0.0
Reporter: Rick Hillegas
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
---------------
bad...@1ef69
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.