]
Steven Hawkins commented on TEIID-3174:
---------------------------------------
Can you clarify the intent of issue? The error message is saying that a -1 count is
invalid, which means that your locate is not finding a comma.
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
Labels: left, stringfunction
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.