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

support MySQL 5.7 sql_mode=only_full_group_by

          Details

          • Documentation Required?:
            None
          • Sprint:
            4.7.10 Performance
          • Funding Source:
            Core Team Contract
          • Payment Status:
            Paid

            Description

            MySQL 5.7 introduces sql_mode=only_full_group_by (enabled by default), which strictly limits what can be included in the select part of a query when using group by, to avoid non-deterministic values. We should review queries and fix accordingly in order meet these requirements.

            Refer to: NYSS #10020

              Attachments

                Issue Links

                is supplemented by

                Bug - A problem which impairs or prevents the functions of the product. CRM-19662 Send test mailing failing because of "only_full_group_by" setting

                • Important - Important to the CiviCRM product's future & reputation
                • Done/Fixed

                Improvement - An improvement or enhancement to an existing feature or task. CRM-19128 (possibly partial 4.7.10 regression) Confusing double presentation of contributions in contribution detail report

                • Trivial - Cosmetic problem like misspelt words or misaligned text.
                • Done/Fixed
                links to

                Web Link PR: civicrm-core#8511: CRM-18439 - support MySQL 5.7 sql_mode=only_full_group_by

                Web Link PR: civicrm-core#8511: CRM-18439 - support MySQL 5.7 sql_mode=only_full_group_by

                  Activity

                    People

                    • Assignee:
                      monish.deb Monish Deb
                      Reporter:
                      lcdweb Brian Shaughnessy
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      11 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 1 week, 2 days
                        1w 2d