You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2013/04/04 21:40:15 UTC
[jira] [Updated] (DERBY-6151) Derby does not report warnings raised
by table functions
[ 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