Details

    • Type: Task
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.3.0
    • Labels:
    • old issue number:
      383

      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.

        Attachments

          Activity

            People

            • Assignee:
              tdsilva Thomas D'Silva
              Reporter:
              jamestaylor James Taylor
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: