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