]
Steven Hawkins updated TEIID-3315:
----------------------------------
Affects Version/s: 7.7
(was: 8.7)
problem with function TRIM
--------------------------
Key: TEIID-3315
URL:
https://issues.jboss.org/browse/TEIID-3315
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.7
Reporter: Bram Gadeyne
Assignee: Steven Hawkins
Labels: stringfunction
I have a database that contains some columns with multiple values separated with comma .
So I'm trying to use a combination of case, substring and trim to split these values
into multiple colums.
The following statement part does not work:
case when pos2 = 0 then trim(substring(Description, pos1+1))
end as bed
TEIID31100 Parsing error: Encountered "+1)[*])[*] end as" at line 3, column
68.
If I add ' ' FROM to the trim statement it does work and returns a correct
result.
working statement:
case when pos2 = 0 then trim(' ' FROM substring(Description, pos1+1))
end as bed