• Tor Didriksen's avatar
    Bug#13463415 63502: INCORRECT RESULTS OF BIGINT AND DECIMAL COMPARISON · 07fd88d5
    Tor Didriksen authored
    Bug#11758543 50756: BIGINT '100' MATCHES 1.001E2
    
    Expressions of the form
          BIGINT_COL <compare> <non-integer constant>
    
          should be done either as decimal, or float.
    
          Currently however, such comparisons are done as int,
          which means that the constant may be truncated,
          and yield false positives/negatives for all queries
          where compare is '>' '<' '>=' '<=' '=' '!='.
    
          BIGINT_COL IN <list of contstants>
          and
          BIGINT_COL BETWEEN <constant> AND <constant>
          are also affected.
    07fd88d5
bigint.test 13.3 KB