BINLOG_ UNSAFE_ INSERT_ SELECT_ UPDATE
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Error Codes for MariaDB Enterprise Server
Topics on this page:
INSERT... SELECT... ON DUPLICATE KEY UPDATE is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are updated. This order cannot be predicted and may differ on master and the slave
See also: Error Codes for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
See also: Error Codes for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES