Jan Martiska created TEIID-5278: ----------------------------------- Summary: 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 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. -- This message was sent by Atlassian JIRA (v7.5.0#75005)