maria-developers team mailing list archive

[Alexander Barkov <bar@xxxxxxxxxxx>]

Hello Ian,


A fix for MDEV-6170 fixed another problem as a side effect:
"SELECT ... LIMIT 0" is now deterministic for statement based
binary log.
Queries with "LIMIT 0" do not return ER_BINLOG_UNSAFE_STATEMENT
any more.

Can you please mention this in the manual?

Some discussion is here:
https://mariadb.atlassian.net/browse/MDEV-6170


Related articles in the MySQL manual:
https://dev.mysql.com/doc/refman/5.6/en/replication-rbr-safe-unsafe.html
https://dev.mysql.com/doc/refman/5.6/en/replication-features-limit.html

Thanks.