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

Details

    • 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

    Description

      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.

      Attachments

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

        Issue Links

          Activity

            People

              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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

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

                  Clockify

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