[
https://issues.apache.org/jira/browse/TRAFODION-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-2896 started by Hans Zeller.
----------------------------------------------
> Internal error in stored procedures when a warning is generated in SQL
> ----------------------------------------------------------------------
>
> Key: TRAFODION-2896
> URL: https://issues.apache.org/jira/browse/TRAFODION-2896
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 2.0-incubating
> Environment: Any, however this problem is not always reproducible
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.3
>
>
> Anu and Selva have seen cases of this and we suspect that the problem has to
> do with the way the UDR server handles return codes from CLI calls it makes.
> Stored procedures can contain SQL and produce result sets. As part of this,
> the UDR server makes CLI calls. Right now, it maps any non-zero return codes
> to internal errors. That is not quite right, warnings should either be
> returned to the user or ignored, whichever is more appropriate.
> Selva also found that in some cases we do sequences of CLI calls, and if we
> encounter a warning in an earlier CLI calls, the later ones may return that
> warning code if the diagnostics aren't cleared in-between. The UDR server
> often does not clear the diags area, so it may see this issue.
> The fix for these symptoms is to raise an internal error only for true errors
> in CLI calls, not for warnings. This applies to code in the UDR server, files
> in core/sql/udrserv.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
