[teiid-issues] [JBoss JIRA] (TEIID-3174) integer operation within LEFT command

[Bram Gadeyne (JIRA)]

Bram Gadeyne created TEIID-3174:
-----------------------------------

             Summary: integer operation within LEFT command
                 Key: TEIID-3174
                 URL: https://issues.jboss.org/browse/TEIID-3174
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.7
            Reporter: Bram Gadeyne
            Assignee: Steven Hawkins


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.



--
This message was sent by Atlassian JIRA
(v6.3.1#6329)