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

Oracle support for distinct group concatenation SQL

XMLWordPrintable

    • 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

      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

            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

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours, 41 minutes
                4h 41m

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