• Alfranio Correia's avatar
    BUG#41166 stored function requires "deterministic" if binlog_format is "statement" · 90f8eb48
    Alfranio Correia authored
    If the log_bin_trust_function_creators option is not defined, creating a stored
    function requires either one of the modifiers DETERMINISTIC, NO SQL, or READS
    SQL DATA. Executing a stored function should also follows the same rules if in
    STATEMENT mode. However, this was not happening and a wrong error was being
    printed out: ER_BINLOG_ROW_RBR_TO_SBR.
    
    The patch makes the creation and execution compatible and prints out the correct
    error ER_BINLOG_UNSAFE_ROUTINE when a stored function without one of the modifiers
    above is executed in STATEMENT mode.
    90f8eb48
item_func.cc 154 KB