Wrong indexing with SUBSTRING function and OData4 translator ------------------------------------------------------------ Key: TEIID-5278 URL: https://issues.jboss.org/browse/TEIID-5278 Project: Teiid Issue Type: Bug Components: OData Affects Versions: 8.12.11.6_4 Reporter: Jan Martiska Assignee: Steven Hawkins Fix For: 10.0.4, 10.2, 10.1.2 SQL {{SUBSTRING}} function indexes strings from 1, but OData {{substring}} filtering function indexes from zero. This needs to be taken into account. Currently a query containing {{WHERE SUBSTRING(stringkey, 1, 1) = 'x'}} will return items where the second character is x, but it should return rows where the first character is x.