• bar@mysql.com/bar.intranet.mysql.r18.ru's avatar
    Bug#24158 SET PASSWORD in binary log fails under ANSI_QUOTES · dcde1be1
    Problem: ``SET PASSWORD FOR foo@localhost'' was written into
    binary log using double quites: ``SET PASSWORD FOR "foo"@"localhost"...''.
    If sql_mode was set to ANSI_QUOTES, parser on slave considered
    "foo" and "localhost" as identifiers instead of strigns constants,
    so it failed to parse, generated syntax error and slave then stopped.
    Fix: changing binary log entries to use single quotes:
    ``SET PASSWORD FOR 'foo'@'localhost'...'' not to depend on ANSI_QUOTES.
    dcde1be1
rpl_do_grant.result 1.32 KB