diff options
| author | unknown <tomas@poseidon.ndb.mysql.com> | 2005-01-26 16:09:58 +0100 |
|---|---|---|
| committer | unknown <tomas@poseidon.ndb.mysql.com> | 2005-01-26 16:09:58 +0100 |
| commit | a51993cfc6ceb2d7bd70ec7c737eb212316fd2a5 (patch) | |
| tree | 24ae954e02692855c115338fca928b3df2f91121 /mysql-test/r/ndb_index_unique.result | |
| parent | e8aaac93ed1ecfe59d29a013f47cf62650cdd58d (diff) | |
| parent | 43de408bbf6eb82558223a7e804ecc0ce4284557 (diff) | |
| download | mariadb-git-a51993cfc6ceb2d7bd70ec7c737eb212316fd2a5.tar.gz | |
Merge tulin@bk-internal.mysql.com:/home/bk/mysql-5.0-ndb
into poseidon.ndb.mysql.com:/home/tomas/mysql-5.0-ndb
mysql-test/r/ndb_index_unique.result:
Auto merged
mysql-test/t/ndb_index_unique.test:
Auto merged
sql/sql_insert.cc:
Auto merged
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 d9397ad42e1..517d09ddf29 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; |