Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-32262

MYSQL 5.7.5+ only_full_group_by setting causing some issues with some queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: OPEN
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 12.0
    • Fix Version/s: None
    • Component/s: Global
    • Labels:
    • Environment:
      MySQL 5.7.5+
    • Previous Issue Keys:
      SAM-3169

      Description

      Those that have begun running on MySQL 5.7.5 may notice some errors in the logs that look like:

      caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
          at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
      caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
          at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sakai_master.eventstati0_.EVENT_ID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
      

      MySQL change
      http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by for the
      Stack overflow for reference:
      http://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ern Earle R Nietzel
                Reporter:
                ern Earle R Nietzel
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Git Source Code