[MDEV-14498] PS: Wrong value for CAST(? AS DOUBLE) when using 9223372036854775808 as a parameter - Jira

XML

Word

Printable

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:

relates to

MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler

MDEV-14476 Integer overflow when using 9223372036854775808 as a LIMIT parameter