ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT

This page is part of MariaDB's SkySQL Documentation.

The parent of this page is: Error Codes

Topics on this page:

Overview
CHANGE HISTORY
EXTERNAL REFERENCES

Overview

Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1 as error number 1722
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1 as error number 1722
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1 as error number 1722

EXTERNAL REFERENCES

This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the ER_BINLOG_UNSAFE_WRITE_AUTOINC_SELECT page in the MariaDB Enterprise Documentation.