[jira] [Resolved] (TRAFODION-2896) Internal error in stored procedures when a warning is generated in SQL

["Hans Zeller (JIRA)" <ji...@apache.org>]

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

Hans Zeller resolved TRAFODION-2896.
------------------------------------
    Resolution: Fixed

Fix checked into Trafodion master on 1/11/2018 with https://github.com/apache/trafodion/pull/1384.

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