XMLWordPrintable

Details

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

    Description

      sql_ilike() is the only remaining function that returns one string (the ilike operator) instead of one SQL fragment. We have already changed some old helper sql functions to return SQL fragments and I think it would be great to do the same with this function. In fact we are going to need it because to implement support for ilike() in Oracle, I need to call some Oracle functions, so I propose to do:

      function sql_ilike($fieldname)

      where fieldname can be one fieldname or one placeholder, np with that.

      Requires:

      • implement the new function.
      • change all old uses
      • modify tests

      Thoughts?

      Attachments

        1. olike.txt
          2 kB
          Amanda Doughty

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:
                24/Nov/10