Changing the MySQL SQL Server mode to ONLY_FULL_GROUP_BY gives exception in the Storage Manager

To reproduce, execute the below query in a MySQL Server and then open up Storage Manager Database and Objects Tab

 

SET global sql_mode='ONLY_FULL_GROUP_BY'

go

 

select

        s.SCHEMA_NAME,

        s.DEFAULT_CHARACTER_SET_NAME,

        s.DEFAULT_COLLATION_NAME,

        IFNULL(SUM(t.data_length)+SUM(t.index_length),0.00) total_size 

from

        information_schema.schemata s 

                LEFT JOIN INFORMATION_SCHEMA.TABLES t 

                ON s.schema_name = t.table_schema 

GROUP BY

        s.schema_name

GO

 

//  'information_schema.s.DEFAULT_CHARACTER_SET_NAME' isn't in GROUP BY

 

select

        s.SCHEMA_NAME,

        s.DEFAULT_CHARACTER_SET_NAME,

        s.DEFAULT_COLLATION_NAME,

        IFNULL(SUM(t.data_length)+SUM(t.index_length),0.00) total_size 

from

        information_schema.schemata s 

                LEFT JOIN INFORMATION_SCHEMA.TABLES t 

                ON s.schema_name = t.table_schema 

GROUP BY

        s.schema_name,

        s.DEFAULT_CHARACTER_SET_NAME,

        s.DEFAULT_COLLATION_NAME

GO