summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/maria/maria-connect.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/maria/maria-connect.test')
-rw-r--r--mysql-test/suite/maria/maria-connect.test47
1 files changed, 47 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-connect.test b/mysql-test/suite/maria/maria-connect.test
new file mode 100644
index 00000000..ac7e9589
--- /dev/null
+++ b/mysql-test/suite/maria/maria-connect.test
@@ -0,0 +1,47 @@
+#
+# Test that can't be run with --extern
+#
+
+-- source include/have_maria.inc
+-- source include/have_log_bin.inc
+-- source include/binlog_start_pos.inc
+
+let $start_pos= `select @binlog_start_pos`;
+
+let $default=`select @@global.default_storage_engine`;
+set global default_storage_engine=aria;
+set session default_storage_engine=aria;
+
+# Initialise
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
+SET SQL_WARNINGS=1;
+
+#
+# UNIQUE key test
+#
+# as long as aria cannot rollback, binlog should contain both inserts
+#
+RESET MASTER;
+set binlog_format=statement;
+CREATE TABLE t1 (a int primary key);
+insert t1 values (1),(2),(3);
+--error ER_DUP_ENTRY
+insert t1 values (4),(2),(5);
+show warnings;
+select * from t1;
+--replace_result $start_pos <start_pos>
+--replace_column 2 # 5 #
+eval SHOW BINLOG EVENTS FROM $start_pos;
+drop table t1;
+set binlog_format=default;
+
+# End of 5.2 tests
+
+--disable_result_log
+--disable_query_log
+eval set global default_storage_engine=$default;
+set global aria_log_file_size=default;
+--enable_result_log
+--enable_query_log