Debian Codegraph @

mysql-test/suite/maria/maria-connect.test

raw
1 #
2 # Test that can't be run with --extern
3 #
4
5 -- source include/have_maria.inc
6 -- source include/have_log_bin.inc
7 -- source include/binlog_start_pos.inc
8
9 let $start_pos= `select @binlog_start_pos`;
10
11 let $default=`select @@global.default_storage_engine`;
12 set global default_storage_engine=aria;
13 set session default_storage_engine=aria;
14
15 # Initialise
16 --disable_warnings
17 drop table if exists t1;
18 --enable_warnings
19 SET SQL_WARNINGS=1;
20
21 #
22 # UNIQUE key test
23 #
24 # as long as aria cannot rollback, binlog should contain both inserts
25 #
26 RESET MASTER;
27 set binlog_format=statement;
28 CREATE TABLE t1 (a int primary key);
29 insert t1 values (1),(2),(3);
30 --error ER_DUP_ENTRY
31 insert t1 values (4),(2),(5);
32 show warnings;
33 select * from t1;
34 --replace_result $start_pos <start_pos>
35 --replace_column 2 # 5 #
36 eval SHOW BINLOG EVENTS FROM $start_pos;
37 drop table t1;
38 set binlog_format=default;
39
40 # End of 5.2 tests
41
42 --disable_result_log
43 --disable_query_log
44 eval set global default_storage_engine=$default;
45 set global aria_log_file_size=default;
46 --enable_result_log
47 --enable_query_log