diff options
| author | mskold/marty@linux.site <> | 2006-12-07 16:03:31 +0100 |
|---|---|---|
| committer | mskold/marty@linux.site <> | 2006-12-07 16:03:31 +0100 |
| commit | 8ca573857f600512d4b9c3b7887c1656134587e4 (patch) | |
| tree | 19321c02f14dfec49b401bc3339dce1444ef7364 /mysql-test/r/ndb_index_unique.result | |
| parent | 9d5fe95e567b9406b6bd12c12adf6bfdba044edc (diff) | |
| parent | 8fa5f366f7647dccb65177b28317296c17f8aded (diff) | |
| download | mariadb-git-8ca573857f600512d4b9c3b7887c1656134587e4.tar.gz | |
Merge mysql.com:/windows/Linux_space/MySQL/mysql-5.0
into mysql.com:/windows/Linux_space/MySQL/mysql-5.1
Diffstat (limited to 'mysql-test/r/ndb_index_unique.result')
| -rw-r--r-- | mysql-test/r/ndb_index_unique.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_unique.result b/mysql-test/r/ndb_index_unique.result index fbc3a2bb915..d83c60e6a8d 100644 --- a/mysql-test/r/ndb_index_unique.result +++ b/mysql-test/r/ndb_index_unique.result @@ -137,6 +137,21 @@ a b c 6 7 2 7 8 3 8 2 3 +create unique index bi using hash on t2(b); +insert into t2 values(9, 3, 1); +ERROR 23000: Duplicate entry '' for key 0 +alter table t2 drop index bi; +insert into t2 values(9, 3, 1); +select * from t2 order by a; +a b c +2 3 5 +3 4 6 +4 5 8 +5 6 2 +6 7 2 +7 8 3 +8 2 3 +9 3 1 drop table t2; CREATE TABLE t2 ( a int unsigned NOT NULL PRIMARY KEY, |