MySQL, Avoid DOUBLE value is out of range in POW(2, 1024) -

MySQL, Avoid DOUBLE value is out of range in POW(2, 1024) -

i've noted mysql returns error pow(2, 1024), error 1690 (22003): double value out of range in pow(2, 1024). how avoid error?

i thinking in ugly solution:

if (@expoent > 1023) @expoent = 1023; pow(2, @expoent);

this relates mysql convert hex double.

you can simplify using least() function:

pow(2, least(@expoent, 1023))

mysql