MariaDB [test]> select * from seq_1_to_2;

+-----+

| seq |

+-----+

|   1 |

|   2 |

+-----+

2 rows in set (0.01 sec)

MariaDB [test]> set binlog_format=statement;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> lock table seq_1_to_2 write;

ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.

MariaDB [test]> set binlog_format=row;

Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> lock table seq_1_to_2 write;

ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.