diff options
author | unknown <hf@deer.(none)> | 2003-12-02 19:06:24 +0400 |
---|---|---|
committer | unknown <hf@deer.(none)> | 2003-12-02 19:06:24 +0400 |
commit | 6990f6cf7e0397487e4b1934fa1255f93ea8665c (patch) | |
tree | e42d6f69d6d5e61fe9558a68a021327bebf6c221 /mysql-test/t/constraints.test | |
parent | 40d2de8eaaaacc91784a901d04724ff9197d981e (diff) | |
download | mariadb-git-6990f6cf7e0397487e4b1934fa1255f93ea8665c.tar.gz |
Fix for #1189 (Mess with names about CONSTRAINT)
Second edition: error message was deleted as Segey suggested
Now name of the constraint will be used as the name of the key
if the last not specified
mysql-test/r/constraints.result:
appropriate test result
mysql-test/t/constraints.test:
test case for 1189
sql/sql_yacc.yy:
language definitions changed so that we can obtaint constraint's name
and send it as the name of the key if it's not specified
Diffstat (limited to 'mysql-test/t/constraints.test')
-rw-r--r-- | mysql-test/t/constraints.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/constraints.test b/mysql-test/t/constraints.test index cc796e0abd2..dbc34a0dff1 100644 --- a/mysql-test/t/constraints.test +++ b/mysql-test/t/constraints.test @@ -21,3 +21,9 @@ drop table t1; create table t1 (a int null); insert into t1 values (1),(NULL); drop table t1; +create table t1 (a int null); +alter table t1 add constraint constraint_1 unique (a); +alter table t1 add constraint unique key_1(a); +alter table t1 add constraint constraint_2 unique key_2(a); +show create table t1; +drop table t1; |