[ https://issues.jboss.org/browse/TEIIDDES-1488?page=com.atlassian.jira.plu... ] Steven Hawkins commented on TEIIDDES-1488: ------------------------------------------ A function based index uses not just column references, but also deterministic expressions. For example: create view matx (col1 integer, col2 string, constraint idx index (upper(col2))) options (materialized true) as select * from x; Note that the index uses upper(col2). At least initially Teiid internally is still using the same KeyRecord logic with just using a Column with the name containing the expression. We then handle proper resolution of the index later in the engine. If you add support for this using index metadata we'll just have to ensure that the logic on both sides agrees upon how function based indexes are handled. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira