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

Case insensitive attribute incorrect SQL generation results in missed matches

    XMLWordPrintable

Details

    Description

      If an attribute is not marked as "Case Sensitive" (case_sensitive) this is handled by adding a LOWER() clause to the SQL, but the input value is not likewise forced to lower case for the comparison.

      MatchService.php (line 489)

      // If the attribute is case insensitive, we insert LOWER clauses
              if(!$ruleattr->attribute->case_sensitive) {
                $colclause = "LOWER(" . $colclause . ")";
      + $val = strtolower($val);
              }

      Attachments

        Activity

          People

            benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
            ross.wilper@at.internet2.edu Ross Wilper (stanford.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: