-
Improvement
-
Resolution: Fixed
-
Major
-
4.4, 5.0
-
MOODLE_404_STABLE, MOODLE_500_STABLE
-
MOODLE_500_STABLE
-
- Covered by existing automated tests (Behat & PHPUnit)
-
Code verified against automated checks. 
Checked
MDL-80173using repository: https://github.com/paulholden/moodle.gitMore information about this report
Built on: Tue Feb 18 01:50:31 PM UTC 2025
-
main (0 errors / 0 warnings) [branch: Depending on decision(s) made in epic MDL-80166 we should evaluate and determine/remove support for Oracle in Report builder:
$ find . -type d -iname reportbuilder -exec git grep -i oracle {} \;
|
notes/classes/reportbuilder/local/entities/note.php: if ($DB->get_dbfamily() === 'oracle') {
|
admin/roles/classes/reportbuilder/local/entities/role.php: if ($DB->get_dbfamily() === 'oracle') {
|
tag/classes/reportbuilder/local/entities/tag.php: if ($DB->get_dbfamily() === 'oracle') {
|
comment/classes/reportbuilder/local/entities/comment.php: if ($DB->get_dbfamily() === 'oracle') {
|
cohort/classes/reportbuilder/local/entities/cohort.php: if ($DB->get_dbfamily() === 'oracle') {
|
course/classes/reportbuilder/local/entities/course_category.php: if ($DB->get_dbfamily() === 'oracle') {
|
group/classes/reportbuilder/local/entities/group.php: if ($DB->get_dbfamily() === 'oracle') {
|
group/classes/reportbuilder/local/entities/grouping.php: if ($DB->get_dbfamily() === 'oracle') {
|
reportbuilder/classes/local/aggregation/base.php: $sqlfieldrequirescast = in_array($DB->get_dbfamily(), ['mssql', 'oracle', 'postgres']);
|
reportbuilder/classes/local/aggregation/count.php: if ($columntype === column::TYPE_LONGTEXT && $DB->get_dbfamily() === 'oracle') {
|
reportbuilder/classes/local/aggregation/countdistinct.php: if ($columntype === column::TYPE_LONGTEXT && $DB->get_dbfamily() === 'oracle') {
|
reportbuilder/classes/local/aggregation/groupconcatdistinct.php: * This aggregation can be performed on all non-timestamp columns in MySQL, Postgres and Oracle only
|
reportbuilder/classes/local/aggregation/groupconcatdistinct.php: 'oracle',
|
reportbuilder/classes/local/entities/course.php: if ($columntype === column::TYPE_LONGTEXT && $DB->get_dbfamily() === 'oracle') {
|
reportbuilder/classes/local/entities/user.php: if ($columntype === column::TYPE_LONGTEXT && $DB->get_dbfamily() === 'oracle') {
|
reportbuilder/classes/local/helpers/custom_fields.php: // Long text fields should be cast for Oracle, for aggregation support.
|
reportbuilder/classes/local/helpers/custom_fields.php: if ($columntype === column::TYPE_LONGTEXT && $DB->get_dbfamily() === 'oracle') {
|
reportbuilder/classes/local/helpers/user_profile_fields.php: // Numeric (checkbox/time) fields should be cast, as should all fields for Oracle, for aggregation support.
|
reportbuilder/classes/local/helpers/user_profile_fields.php: } else if ($DB->get_dbfamily() === 'oracle') {
|
badges/classes/reportbuilder/local/entities/badge.php: if ($DB->get_dbfamily() === 'oracle') {
|
blog/classes/reportbuilder/local/entities/blog.php: if ($DB->get_dbfamily() === 'oracle') {
|
Other comparisons using get_dbfamily() should also be checked
- has a non-specific relationship to
-
MDL-76142 Cohort report stress tests fail on Oracle
-
- Closed
-
-
-
- Closed
-
-
MDL-75191 Create "Task logs" custom report source
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- is blocked by
-
-
- Closed
-
- will help resolve
-
MDL-84719 Report builder performance improvements
-
- Open
-
