diff options
author | unknown <mskold/marty@mysql.com/linux.site> | 2006-12-07 15:51:16 +0100 |
---|---|---|
committer | unknown <mskold/marty@mysql.com/linux.site> | 2006-12-07 15:51:16 +0100 |
commit | d8ff6cdfc8185e167db1ec6eac4f9bd486439ca4 (patch) | |
tree | 2eaf3a9cdbd39d389ad73150b6a272ca19c61605 /mysql-test/r | |
parent | ece3c40b31349fee7231059209cbbeecbf9d57ae (diff) | |
parent | 6e47c11c7abac4cd66806b48e07c9b179e2662e4 (diff) | |
download | mariadb-git-d8ff6cdfc8185e167db1ec6eac4f9bd486439ca4.tar.gz |
Merge mysql.com:/windows/Linux_space/MySQL/mysql-4.1
into mysql.com:/windows/Linux_space/MySQL/mysql-5.0
mysql-test/r/ndb_index_unique.result:
Auto merged
mysql-test/t/ndb_index_unique.test:
Auto merged
Diffstat (limited to 'mysql-test/r')
-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 12ffc8437db..670fbe5b4e0 100644 --- a/mysql-test/r/ndb_index_unique.result +++ b/mysql-test/r/ndb_index_unique.result @@ -133,6 +133,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, |