summaryrefslogtreecommitdiff
path: root/storage/rocksdb/mysql-test/rocksdb/t/mariadb_misc_binlog.test
blob: fb150f7a7918656b8dfc7bb1b5f4c518d45daf81 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
--source include/have_rocksdb.inc

create table t1 (a int) engine=rocksdb;

--echo # Should have binlog ON
select @@log_bin;

set binlog_format='row';

--echo # Should succeed
optimize table t1;

--echo #
--echo # MDEV-13602: rocksdb.index_merge_rocksdb2 failed in buildbot
--echo #

lock tables t1 write;
insert into t1 values(1);
unlock tables;

set @tmp_bf= @@binlog_format;
set binlog_format='STATEMENT';
lock tables t1 write;
--error ER_REQUIRE_ROW_BINLOG_FORMAT
insert into t1 values(1);
unlock tables;
set @@binlog_format=@tmp_bf;

drop table t1;