diff options
| author | unknown <mskold@mysql.com> | 2004-11-22 10:35:03 +0100 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-11-22 10:35:03 +0100 |
| commit | 5672598f0af4548f09959552eec9d766a792fe09 (patch) | |
| tree | 4b3d5b1082f5c6e2d15ba045d91240aa2e2225c7 /mysql-test/r/ndb_index_unique.result | |
| parent | 6d6b38c27fcac1da19a11fa07a5f02c2c22635fe (diff) | |
| download | mariadb-git-5672598f0af4548f09959552eec9d766a792fe09.tar.gz | |
Added checks for NOT NULL for all fields in UNIQUE INDEX (USING HASH)
Diffstat (limited to 'mysql-test/r/ndb_index_unique.result')
| -rw-r--r-- | mysql-test/r/ndb_index_unique.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_unique.result b/mysql-test/r/ndb_index_unique.result index af9b84022ed..9754be84b17 100644 --- a/mysql-test/r/ndb_index_unique.result +++ b/mysql-test/r/ndb_index_unique.result @@ -87,6 +87,13 @@ a b c 7 8 3 8 2 3 drop table t2; +CREATE TABLE t2 ( +a int unsigned NOT NULL PRIMARY KEY, +b int unsigned not null, +c int unsigned, +UNIQUE USING HASH (b, c) +) engine=ndbcluster; +ERROR 42000: Column 'c' is used with UNIQUE or INDEX but is not defined as NOT NULL CREATE TABLE t3 ( a int unsigned NOT NULL, b int unsigned not null, |