[MDEV-8514] Storing '1e-1000000000000' into an INT column produces a wrong result - Jira

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.4(EOL)
Component/s: OTHER
Labels:
None

SET sql_mode='';

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a INT);

INSERT INTO t1 VALUES ('1e-1000000000000');

SHOW WARNINGS;

SELECT * FROM t1;

returns

+---------+------+--------------------------------------------+

| Level   | Code | Message                                    |

+---------+------+--------------------------------------------+

| Warning | 1264 | Out of range value for column 'a' at row 1 |

+---------+------+--------------------------------------------+

1 row in set (0.00 sec)

+------------+

| a          |

+------------+

| 2147483647 |

+------------+

1 row in set (0.00 sec)

This is wrong. The expected result is 0.
The warning also does not look correct.

relates to

MDEV-8515 Explicit and implicit CAST from string to integer work differently

No workflow transitions have been executed yet.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server