Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-79565

An error occurs because the query uses the SQL command LENGTH() instead of sql_length()

XMLWordPrintable

    • MOODLE_403_STABLE
    • MOODLE_403_STABLE
    • Hide
      1. Ensure testing with SQL Server
      2. Checkout version prior to MDL-67390:

        $ git checkout 07af783b9a9cff38d54192ea0b91175c9679d35e~1
        

      3. Install site
      4. Checkout fixed branch (this one)
      5. Run upgrade
      6. Confirm upgrade completes successfully
      Show
      Ensure testing with SQL Server Checkout version prior to MDL-67390 : $ git checkout 07af783b9a9cff38d54192ea0b91175c9679d35e~1 Install site Checkout fixed branch (this one) Run upgrade Confirm upgrade completes successfully
    • 1
    • Team Hedgehog 2023 Sprint 3.3

      Since not all database engines use LENGTH to get the number of characters in a given string, we need to change the query to use sql_length(), not LENGTH().

      Regression from MDL-67390.

        1. image.png
          image.png
          215 kB
        2. MDL-79565.png
          MDL-79565.png
          930 kB

            pholden Paul Holden
            meirza.arson@moodle.com Meirza
            Meirza Meirza
            Sara Arjona (@sarjona) Sara Arjona (@sarjona)
            Ron Carl Alfon Yu Ron Carl Alfon Yu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 26 minutes
                1h 26m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.