• Gleb Shchepa's avatar
    Bug #45360: wrong results · 79d8de67
    Gleb Shchepa authored
    Propagation of a large unsigned numeric constant
    in the WHERE expression led to wrong result.
    
    For example,
    "WHERE a = CAST(0xFFFFFFFFFFFFFFFF AS USIGNED) AND FOO(a)",
    where a is an UNSIGNED BIGINT, and FOO() accepts strings,
    was transformed to "... AND FOO('-1')".
    
    That has been fixed.
    
    Also EXPLAIN EXTENDED printed incorrect numeric constants in
    transformed WHERE expressions like above. That has been
    fixed too.
    79d8de67
bigint.test 11.9 KB