[ https://issues.jboss.org/browse/TEIID-4893?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4893: ---------------------------------- Component/s: JDBC Connector (was: Query Engine) Priority: Critical (was: Blocker) The core problem is with using a non-positive index. Since substring and the associated source functions aren't standard, there isn't consistent handling. We do though assume that the Teiid behavior is the defacto correct behavior and translator logic when possible should compensate. In this case the postgres translator is not accounting for 0/negative indexes and should be updated to account for that. In general use 1 based indexing in string functions when possible. -- This message was sent by Atlassian JIRA (v7.2.3#72005)