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
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue relates to |
Affects Version/s | 10.5 [ 23123 ] | |
Affects Version/s | 10.6 [ 24028 ] |
Assignee | Oleksandr Byelkin [ sanja ] |
Component/s | Tests [ 10800 ] |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Attachment | func_math_tests_MDEV-26645.diff [ 60111 ] |
Workflow | MariaDB v3 [ 125164 ] | MariaDB v4 [ 144410 ] |
Attachment | mariadb-gcc12-x86_64.log [ 61856 ] |
issue.field.resolutiondate | 2022-02-18 15:04:11.0 | 2022-02-18 15:04:11.316 |
Component/s | Data types [ 13906 ] | |
Component/s | Tests [ 10800 ] | |
Fix Version/s | 10.5.16 [ 27508 ] | |
Fix Version/s | 10.6.8 [ 27506 ] | |
Fix Version/s | 10.7.4 [ 27504 ] | |
Fix Version/s | 10.8.3 [ 27502 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Fix Version/s | 10.6 [ 24028 ] | |
Assignee | Oleksandr Byelkin [ sanja ] | Marko Mäkelä [ marko ] |
Resolution | Fixed [ 1 ] | |
Status | Confirmed [ 10101 ] | Closed [ 6 ] |
Link |
This issue relates to |