[jira] [Reopened] (TRAFODION-1676) support better runtime error message when a SQL function meet fital error

["liu ming (JIRA)" <ji...@apache.org>]

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

liu ming reopened TRAFODION-1676:
---------------------------------

Bad code cause SQL regression issues from time to time, need to fix it.

> support better runtime error message when a SQL function meet fital error
> -------------------------------------------------------------------------
>
>                 Key: TRAFODION-1676
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1676
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-exe
>            Reporter: liu ming
>            Assignee: liu ming
>            Priority: Minor
>             Fix For: 2.1-incubating
>
>
> A sql contains some SQL function, for example UPPER(), when the input data of UPPER() contains invalid data, UPPER() will fail. In this case, the whole query abort, and the error message cannot tell which row has invalid data, so it is very hard to fix the problem.
> It will be good to have row id or the real value of the error row in the error message to help trouble shooting.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)