Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3174

integer operation within LEFT command

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • None
    • 8.7
    • None

      When executing a command of the following form

      LEFT(Description,((LOCATE(',',Description))-1))

      I get an Exception like this:

      14:31:00,038 WARN [org.teiid.PROCESSOR] (Worker3295_QueryProcessorQueue53347) 5tz38FpQ/WJw TEIID30020 Processing exception for request 5tz38FpQ/WJw.50 'TEIID30328 Unable to evaluate LEFT(sometable.Description, (LOCATE(',', sometable.Description) - 1)): TEIID30384 Error while evaluating function left'. Originally ExpressionEvaluationException 'TEIID30396 Left/Right count -1 is invalid. It must be >= 0.' FunctionMethods.java:758. Enable more detailed logging to see the entire stacktrace.

            rhn-engineering-shawkins Steven Hawkins
            gadeynebram Bram Gadeyne (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: