diff options
| author | unknown <tomas@poseidon.ndb.mysql.com> | 2005-01-26 11:31:46 +0100 |
|---|---|---|
| committer | unknown <tomas@poseidon.ndb.mysql.com> | 2005-01-26 11:31:46 +0100 |
| commit | d041ed2d8cddc67fe9dacbf2060927b84139f3f4 (patch) | |
| tree | 4e04933cc990354077d53b898f92e4a29019b6f6 /mysql-test/r/ndb_index_unique.result | |
| parent | 9d1701898bb98dc59d121cfc5b485fbf86b30f4b (diff) | |
| download | mariadb-git-d041ed2d8cddc67fe9dacbf2060927b84139f3f4.tar.gz | |
Bug#8101 unique indexes which attribute are _not_ specified in the order of the table does not work
Diffstat (limited to 'mysql-test/r/ndb_index_unique.result')
| -rw-r--r-- | mysql-test/r/ndb_index_unique.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_unique.result b/mysql-test/r/ndb_index_unique.result index f9cc89ee4cc..598b9dcccf7 100644 --- a/mysql-test/r/ndb_index_unique.result +++ b/mysql-test/r/ndb_index_unique.result @@ -612,3 +612,17 @@ a b c 3 NULL NULL 4 4 NULL drop table t1, t8; +create table t1( +id integer not null auto_increment, +month integer not null, +year integer not null, +code varchar( 2) not null, +primary key ( id), +unique idx_t1( month, code, year) +) engine=ndb; +INSERT INTO t1 (month, year, code) VALUES (4,2004,'12'); +INSERT INTO t1 (month, year, code) VALUES (5,2004,'12'); +select * from t1 where code = '12' and month = 4 and year = 2004 ; +id month year code +1 4 2004 12 +drop table t1; |