A modern programming language that makes developers happier.

kotlinlang

hello everyone,
i'm stuck with .sum() aggregate function.
I have a column of type ushort
and i have a query which should retrieve a sum of the column values. Even though the values are ushort (SMALLINT UNSIGNED) resulted sum might be out of the ushort range.
And for plain MariaDB query in console it's absolutely legit query. But `MyTable.uShortCol.sum()` truncates result to ushort, obviously.
Any adwise?
I've found an issue on the GitGub <https://github.com/JetBrains/Exposed/issues/1035> which seems relevant to me but there's no solution

i've managed to get a correct sum with
```MyTable.uShortCol.sum().castTo&lt;Int&gt;(IntegerColumnType())```
And it's fine to me. But
```MyTable.uShortCol.sum().castTo&lt;UInt&gt;(UIntegerColumnType())```
didn't work because generated SQL query was incorrect

```CAST(SUM(MyTable.uShortCol) AS INT UNSIGNED) b FROM```


because of `UNSIGNED` inside the `CAST` . It throws mysql error in my case (MariaDB 10.10)