Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-21455

Intra-rc regression supportsFullGroupBy: MariaDB 10.2 does not support ANY_VALUE

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Blocker
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.28
    • Fix Version/s: 4.7.28
    • Component/s: None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Core Team Funds
    • Verified?:
      No

      Description

      Follow-up issue to CRM-21363, which causes a regression in 4.7.28-RC:

      • Using MariaDB 10.2
      • Enable CiviCase
      • Create a case
      • then go to "Manage Case" (i.e. open/view the case)

      Result: fatal error because "ANY_VALUE" does not exist on MariaDB 10.2.

      https://jira.mariadb.org/browse/MDEV-10426

      Seems to be caused by:

      https://github.com/civicrm/civicrm-core/blob/4.7.28-rc/CRM/Activity/BAO/Activity.php#L920

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mlutfy Mathieu Lutfy
            • Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: