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

Review SQL CEIL() uses across code. MSSQL uses CEILING()

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 1.9.2, 2.0
    • 1.9.1, 2.0
    • Database SQL/XMLDB
    • None
    • Any
    • MOODLE_19_STABLE, MOODLE_20_STABLE
    • MOODLE_19_STABLE, MOODLE_20_STABLE

      While fixing and testing MDL-13861, it seems that the statistics generations has some CEIL() SQL uses.

      But MSSQL isn't using that function but CEILING() instead.

      To fix this:

      1) Create one sql_ceil() function.
      2) Replace all uses of CEIL() with that function.

      Ciao

            stronk7 Eloy Lafuente (stronk7)
            stronk7 Eloy Lafuente (stronk7)
            Petr Skoda Petr Skoda
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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