ER_DATA_OUT_OF_RANGE (1690): BIGINT value is out of range in '9223372036854775807 + 9223372036854775807'

[11405s] main.func_math                           w5 [ retry-fail ]

[11405s]         Test ended at 2024-05-11 20:04:16

[11405s] 

[11405s] CURRENT_TEST: main.func_math

[11405s] mysqltest: At line 432: query 'SELECT 9223372036854775807 + 9223372036854775807' failed: ER_DATA_OUT_OF_RANGE (1690): BIGINT value is out of range in '9223372036854775807 + 9223372036854775807'

[11405s] 

[11405s] The result from queries just before the failure was:

[11405s] < snip >

[11405s] ERROR 22003: DOUBLE value is out of range in 'exp(750)'

[11405s] SELECT POW(10, 309);

[11405s] ERROR 22003: DOUBLE value is out of range in 'pow(10,309)'

[11405s] SELECT COT(0);

[11405s] ERROR 22003: DOUBLE value is out of range in 'cot(0)'

[11405s] SELECT DEGREES(1e307);

[11405s] ERROR 22003: DOUBLE value is out of range in 'degrees(1e307)'

[11405s] SELECT 9223372036854775808 + 9223372036854775808;

[11405s] ERROR 22003: BIGINT UNSIGNED value is out of range in '9223372036854775808 + 9223372036854775808'

[11405s] SELECT 18446744073709551615 + 1;

[11405s] ERROR 22003: BIGINT UNSIGNED value is out of range in '18446744073709551615 + 1'

[11405s] SELECT 1 + 18446744073709551615;

[11405s] ERROR 22003: BIGINT UNSIGNED value is out of range in '1 + 18446744073709551615'

[11405s] SELECT -2 + CAST(1 AS UNSIGNED);

[11405s] ERROR 22003: BIGINT UNSIGNED value is out of range in '-2 + cast(1 as unsigned)'

[11405s] SELECT CAST(1 AS UNSIGNED) + -2;

[11405s] ERROR 22003: BIGINT UNSIGNED value is out of range in 'cast(1 as unsigned) + -2'

[11405s] SELECT -9223372036854775808 + -9223372036854775808;

[11405s] ERROR 22003: BIGINT value is out of range in '-9223372036854775808 + -9223372036854775808'

[11405s] SELECT 9223372036854775807 + 9223372036854775807;