[PHOENIX-514] Support functional indexes

• Type: Task
• Status: Closed
• Resolution: Fixed
• Fix Version/s: 4.3.0
• Labels: enhancement
• old issue number: 383
• Assignee: Thomas D'Silva
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:47
• Updated: 21/Nov/15 02:15
• Resolved: 04/Feb/15 20:43

Description

Instead of only defining the set of columns from the data table that make up an index, you should be able to use expressions. For example:

CREATE INDEX upper_last_name_idx ON person (UPPER(last_name))

Then in queries that use UPPER(last_name), we can replace them with column references to the index table.