1#
2# Tests for innodb that requires not default character sets
3#
4
5--source include/have_innodb.inc
6let collation=utf8_unicode_ci;
7--source include/have_collation.inc
8
9# Setup
10--disable_warnings
11drop table if exists t1;
12--enable_warnings
13
14#
15# Bug #26835: table corruption after delete+insert
16#
17
18CREATE TABLE t1 (a VARCHAR(5) COLLATE utf8_unicode_ci PRIMARY KEY)
19ENGINE=InnoDB;
20INSERT INTO t1 VALUES (0xEFBCA4EFBCA4EFBCA4);
21DELETE FROM t1;
22INSERT INTO t1 VALUES ('DDD');
23SELECT * FROM t1;
24DROP TABLE t1;
25