[ 
https://issues.apache.org/jira/browse/DERBY-6151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rick Hillegas updated DERBY-6151:
---------------------------------

    Attachment: derby-6151-01-aa-passBackWarnings.diff

Attaching derby-6151-01-aa-passBackWarnings.diff. This patch percolates 
SQLWarnings from table functions back to the user. I will run tests.

Touches the following files:

-------------------

M       java/engine/org/apache/derby/impl/sql/execute/VTIResultSet.java

For each row, get the SQLWarnings from the table function and add them to the 
list for the ResultSet.

-------------------

M       java/engine/org/apache/derby/vti/VTITemplateBase.java

Now getWarnings() returns null rather than raising an unimplemented feature 
exception. This prevents its subclasses from choking VTIResultSet.

-------------------

M       
java/testing/org/apache/derbyTesting/functionTests/tests/lang/TableFunctionTest.java

Adds a regression test for this functionality.

                
> Derby does not report warnings raised by table functions
> --------------------------------------------------------
>
>                 Key: DERBY-6151
>                 URL: https://issues.apache.org/jira/browse/DERBY-6151
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.11.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-6151-01-aa-passBackWarnings.diff
>
>
> If a table function raises warnings as the user loops through 
> ResultSet.next(), those warnings are silently thrown away by Derby. Derby 
> should return those warnings when the user calls ResultSet.getWarnings().

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to