Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2211

Case Insensitive Indexes

    XMLWordPrintable

Details

    Description

      Matchgrids should be constructed with lower case indexes on case insensitive attributes. eg:

      CREATE INDEX foo ON mg_testgrid ((lower(firstname)));

      Note this will increase the cost of index construction on new records. Possibly drop the case sensitive index if it's not used anywhere.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CO-1006 Create Case Insensitive Search Indices

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CO-2217 Update DBAL to Handle Indexes Based on SQL Expressions

          • Major - Major loss of function.
          • Open

          Activity

            People

              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: