• unknown's avatar
    Bug #26199 Replication Failure on Slave when using stored procs with bit-type parameters. · 6cfd9a4f
    unknown authored
    The value of the actual argument of BIT-type-arg stored procedure was binlogged as non-escaped
    sequence of bytes corresponding to internal representation of the bit value.
    
    The patch enforces binlogging of the bit-argument as a valid literal: prefixing the quoted bytes
    sequence with _binary.
    Note, that behaviour of Item_field::var_str for field_type() of MYSQL_TYPE_BIT is exceptional
    in that the returned string contains the binary representation even though result_type() of
    the item is INT_RESULT.
    
    
    mysql-test/r/rpl_sp_effects.result:
      testing stored function and procedure called with BIT-arg.
    mysql-test/t/rpl_sp_effects.test:
      results changed
    sql/sp_head.cc:
      Treating BIT field type specially to for its value to be prefixed and quoted.
    6cfd9a4f
rpl_sp_effects.test 4.18 KB