Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.5, 10.6
-
None
Description
While working on 10.6 and 10.7 I've noticed that this test is permanently failing:
main.func_math w1 [ fail ]
|
Test ended at 2021-09-18 22:58:28
|
|
CURRENT_TEST: main.func_math
|
mysqltest: At line 425: query 'SELECT 9223372036854775807 + 9223372036854775807' succeeded - should have failed with error ER_DATA_OUT_OF_RANGE (1690)...
|
|
The result from queries just before the failure was:
|
< snip >
|
ERROR 22003: DOUBLE value is out of range in 'exp(750)'
|
SELECT POW(10, 309);
|
ERROR 22003: DOUBLE value is out of range in 'pow(10,309)'
|
SELECT COT(0);
|
ERROR 22003: DOUBLE value is out of range in 'cot(0)'
|
SELECT DEGREES(1e307);
|
ERROR 22003: DOUBLE value is out of range in 'degrees(1e307)'
|
SELECT 9223372036854775808 + 9223372036854775808;
|
ERROR 22003: BIGINT UNSIGNED value is out of range in '9223372036854775808 + 9223372036854775808'
|
SELECT 18446744073709551615 + 1;
|
ERROR 22003: BIGINT UNSIGNED value is out of range in '18446744073709551615 + 1'
|
SELECT 1 + 18446744073709551615;
|
ERROR 22003: BIGINT UNSIGNED value is out of range in '1 + 18446744073709551615'
|
SELECT -2 + CAST(1 AS UNSIGNED);
|
ERROR 22003: BIGINT UNSIGNED value is out of range in '-2 + cast(1 as unsigned)'
|
SELECT CAST(1 AS UNSIGNED) + -2;
|
ERROR 22003: BIGINT UNSIGNED value is out of range in 'cast(1 as unsigned) + -2'
|
SELECT -9223372036854775808 + -9223372036854775808;
|
ERROR 22003: BIGINT value is out of range in '-9223372036854775808 + -9223372036854775808'
|
SELECT 9223372036854775807 + 9223372036854775807;
|
Example of a full log at https://launchpadlibrarian.net/559043027/buildlog_ubuntu-hirsute-s390x.mariadb-10.7_1%3A10.7.0~ubuntu21.04.1~1631999241.a60c5e60c84+10.7.gitlab.ci.benchmark_BUILDING.txt.gz
Applies to platforms: s390x, ppc64
(of the Launchpad platforms it does not apply to armhf, arm64, amd64)
Attachments
Issue Links
- relates to
-
MDEV-21977 main.func_math fails due to undefined behaviour
- Closed
-
MDEV-20966 main.func_math fails in builbot on Debian unstable with wrong error code
- Stalled