storage/innodb_plugin/mysql-test/innodb_bug41904.test


1
2
3
4
5
6
7
8
9
10
11
12
13
14

#
# Make sure http://bugs.mysql.com/41904 remains fixed.
#

-- source include/not_embedded.inc
-- source include/have_innodb.inc

CREATE TABLE bug41904 (id INT PRIMARY KEY, uniquecol CHAR(15)) ENGINE=InnoDB;

INSERT INTO bug41904 VALUES (1,NULL), (2,NULL);

CREATE UNIQUE INDEX ui ON bug41904 (uniquecol);

DROP TABLE bug41904;