Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.21, 11.8.1, 10.2(EOL), 10.3(EOL), 10.6
-
None
Description
DELIMITER $$
|
BEGIN NOT ATOMIC |
DECLARE a DECIMAL(30,0) DEFAULT 9223372036854775808; |
EXECUTE IMMEDIATE 'EXPLAIN EXTENDED SELECT 1 LIMIT ?' USING a; |
END; |
$$
|
DELIMITER ;
|
SHOW WARNINGS;
|
+---------+------+----------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------------------------------------------+
|
| Warning | 1916 | Got overflow when converting '9223372036854775808' to INT. Value truncated |
|
| Note | 1003 | select 1 AS `1` limit 9223372036854775807 |
|
+---------+------+----------------------------------------------------------------------------+
|
Notice, the value was truncated to the maximum signed integer. This looks wrong.
It should treat 9223372036854775808 as an unsigned value and preserve it in the LIMIT clause.
Attachments
Issue Links
- relates to
-
MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler
-
- Closed
-
-
MDEV-14498 PS: Wrong value for CAST(? AS DOUBLE) when using 9223372036854775808 as a parameter
-
- Open
-
Activity
Field | Original Value | New Value |
---|---|---|
Link |
This issue relates to |
Link | This issue relates to MDEV-14498 [ MDEV-14498 ] |
Component/s | Data types [ 13906 ] |
Fix Version/s | 10.4 [ 22408 ] |
Workflow | MariaDB v3 [ 83944 ] | MariaDB v4 [ 140539 ] |
Fix Version/s | 10.3 [ 22126 ] |
Affects Version/s | 10.6.21 [ 29953 ] |
Fix Version/s | 10.6 [ 24028 ] |
Fix Version/s | 11.8 [ 29921 ] |
Affects Version/s | 11.8.1 [ 29961 ] | |
Affects Version/s | 10.6 [ 24028 ] |
Fix Version/s | 10.4(EOL) [ 22408 ] |