| Bug #28052 | Falcon Crash with insert while unique key for date and tinyint | ||
|---|---|---|---|
| Submitted: | 23 Apr 2007 22:51 | ||
| Reporter: | Hakan Küçükyılmaz | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
| Version: | 6.0.0-alpha | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[23 Apr 2007 22:51]
Hakan Küçükyılmaz
Test case is falcon_bug_28052.test.
Description: I create a table with a DATE column and a TINYINT AUTO_INCREMENT column. I use both these columns in a UNIQUE constraint.. I insert a few rows. Crash. How to repeat: /* This test is inspired by insert_select.test. */ 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);