diff options
| author | unknown <pem@mysql.com> | 2003-05-13 19:16:30 +0200 |
|---|---|---|
| committer | unknown <pem@mysql.com> | 2003-05-13 19:16:30 +0200 |
| commit | 563c32ccd1f5a212dfb270097c1dbd1cdc1be907 (patch) | |
| tree | 21315a755f5391934d3a15d07985511dd08bc06e /mysql-test/r/key.result | |
| parent | 4ccf66df87bfe9290d686e7abd585d3ffe1c1370 (diff) | |
| download | mariadb-git-563c32ccd1f5a212dfb270097c1dbd1cdc1be907.tar.gz | |
Fix of bug 390: primary key now implies (silently) NOT NULL for key fields.
Diffstat (limited to 'mysql-test/r/key.result')
| -rw-r--r-- | mysql-test/r/key.result | 1 |
1 files changed, 0 insertions, 1 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index 1cd9c9dfe79..31d35a681aa 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -42,7 +42,6 @@ price area type transityes shopsyes schoolsyes petsyes drop table t1; CREATE TABLE t1 (program enum('signup','unique','sliding') not null, type enum('basic','sliding','signup'), sites set('mt'), PRIMARY KEY (program)); ALTER TABLE t1 modify program enum('signup','unique','sliding'); -All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead drop table t1; CREATE TABLE t1 ( name varchar(50) DEFAULT '' NOT NULL, |