Unable to have computation in GROUP BY statement

[saklanipankaj]

SELECT c, SUM(b/a)
FROM t1
GROUP BY c;

ERROR 13180 (HY000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'testdb.t1.b.ElGamal.Enc' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

unable to do group by when doing computation inside a SUM function

[cheziyi]

What is the schema of the table?

[saklanipankaj]

+-------+--------------+------+------+-------------------+-------+------------------------------------------------+
| Field | Type | Null | Key | Default | Extra | Encryption |
+-------+--------------+------+------+-------------------+-------+------------------------------------------------+
| a | int | NO | | NULL | | Store, Addition, Multiplication, Search, Range |
| b | tinyint | NO | | NULL | | Store, Addition, Multiplication, Search, Range |
| c | varchar(100) | YES | | NULL | | None |
| d | datetime | NO | | CURRENT_TIMESTAMP | | None |
+-------+--------------+------+------+-------------------+-------+------------------------------------------------+
4 rows in set (0.00 sec)

[cheziyi]

Encrypted aggregation functions are currently does not support the GROUP BY clause, but will be supported in the future.