Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1676

support better runtime error message when a SQL function meet fital error

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.1-incubating
    • Component/s: sql-exe
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              ovis_poly liu ming
              Reporter:
              ovis_poly liu ming
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: