db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4092) You should not be able to invoke a table function as a scalar function
Date Fri, 13 Mar 2009 10:27:50 GMT
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              
---------------
BadVTI@1ef69   

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