Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-14679 META: DB layer 2.0
  3. MDL-23888

new sql_like() should accept parameters and treat case/accent sensitiveness properly

    XMLWordPrintable

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0
    • None
    • Database SQL/XMLDB
    • None
    • MOODLE_20_STABLE

    Description

      1/ at present we do not have case sensitive like support - mostly MySQL is to be blamed
      2/ sql_ilike() does not support parameters - we need fieldname and parameter
      3/ it would be nice to have support for escape characters
      4/ we need more unit tests

      Attachments

        Issue Links

          has a non-specific relationship to

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-23927 use new sql_ilike() and sql_binary_equal() where necessary

          • Major - Major loss of function, incorrect output
          • Closed
          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-23925 make get_records() and friends use case and accent insensitive comparison consistently for all DB engines

          • Major - Major loss of function, incorrect output
          • Closed

          Activity

            People

              skodak Petr Skoda
              skodak Petr Skoda
              Nobody Nobody
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: