Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.2, 10.3
-
Component/s: Data types
-
Labels:None
Description
This query:
EXECUTE IMMEDIATE 'SELECT CAST(? AS DOUBLE),CAST(? AS DECIMAL(20,0))' USING 9223372036854775808, 9223372036854775808; |
returns:
+-----------------------+--------------------------+
|
| CAST(? AS DOUBLE) | CAST(? AS DECIMAL(20,0)) |
|
+-----------------------+--------------------------+
|
| -9.223372036854776e18 | 9223372036854775808 |
|
+-----------------------+--------------------------+
|
Notice:
- the result for DOUBLE cast is wrong
- the result for DECIMAL cast is OK
Attachments
Issue Links
- relates to
-
MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler
-
- Closed
-
-
MDEV-14476 Integer overflow when using 9223372036854775808 as a LIMIT parameter
-
- Open
-