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

Oracle support for distinct group concatenation SQL

    XMLWordPrintable

Details

    • Oracle
    • MOODLE_400_STABLE
    • MOODLE_401_STABLE
    • Hide

      Covered by automated testing, specifically test the following now pass without any skipped tests on Oracle:

      $ bin/moodle-docker-compose exec --user www-data webserver php admin/tool/behat/cli/run.php --name="Aggregate a text column"
      $ bin/moodle-docker-compose exec webserver vendor/bin/phpunit reportbuilder/tests/local/aggregation/groupconcatdistinct_test.php
      

      Show
      Covered by automated testing, specifically test the following now pass without any skipped tests on Oracle: $ bin/moodle-docker-compose exec --user www-data webserver php admin/tool/behat/cli/run.php --name="Aggregate a text column" $ bin/moodle-docker-compose exec webserver vendor/bin/phpunit reportbuilder/tests/local/aggregation/groupconcatdistinct_test.php

    Description

      We added sql_group_concat support to the DML drivers in MDL-52817 (docs)

      This issue is to investigate support for the same, but with DISTINCT. The current implementation of the same aggregation method in Report builder (MDL-72663) is only supported in MySQL & Postgres

      Edit see MDL-71747, the bump to minimum version requirements should allow us to support this in Oracle fully (still no native support in SQL Server)

      Determine whether similar support could exist in other supported DB's, and the minimum version required in each to do so, then move the aggregation code from Report builder to the DML drivers

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              pholden Paul Holden
              David Carrillo David Carrillo
              Victor Déniz Falcón Victor Déniz Falcón
              CiBoT CiBoT
              Votes:
              0 Vote for this issue
              Watchers:
              5 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 - 4 hours, 41 minutes
                  4h 41m

                  Clockify

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