Bug #2725 | KEY desc_idx (description(100)) being treated as UNIQUE KEY on Tru64 | ||
---|---|---|---|
Submitted: | 11 Feb 2004 23:55 | Modified: | 5 Mar 2004 0:31 |
Reporter: | [ name withheld ] | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 4.0.17 | OS: | Tru62 |
Assigned to: | Michael Widenius | CPU Architecture: | Any |
[11 Feb 2004 23:55]
[ name withheld ]
[5 Mar 2004 0:31]
Michael Widenius
I tested the following on our true64 box: > cd mysql-distrib/mysql-test I then created file t/skr.test with following context: #### drop table if exists t1; CREATE TABLE t1 ( nr_num varchar(20) NOT NULL default '', description text NOT NULL, PRIMARY KEY (nr_num), KEY desc_idx (description(100)) ) TYPE=MyISAM; insert into t1 values("","test"),("a","test"); select count(*) from t1; drop table t1; #### Executed: >./mysql-test-run --local --record --user=root t/skr.test > cat cat r/skr.result drop table if exists t1; CREATE TABLE t1 ( nr_num varchar(20) NOT NULL default '', description text NOT NULL, PRIMARY KEY (nr_num), KEY desc_idx (description(100)) ) TYPE=MyISAM; insert into t1 values("","test"),("a","test"); select count(*) from t1; count(*) 2 drop table t1; As you can see, things worked perfectly for me. If you want to help us find and fix the bug, please try to modify the above case so that you get an error / wrong result on your machine and attach the test to this bug report.