#---- Bug 214 ----
SET STORAGE_ENGINE='Falcon';
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(
Month date NOT NULL,
Type tinyint(3) unsigned NOT NULL auto_increment,
UNIQUE KEY Month (Month,Type)
) ;
INSERT INTO t1 VALUES
('2003-09-01', 1),
('2003-09-01', 1),
('2003-09-01', 2),
('2003-09-01', 2),
('2003-09-01', 3);
ERROR 23000: Duplicate entry '2003-09-01-1' for key 'Month'
DROP TABLE t1;
