diff options
| author | unknown <dlenev@brandersnatch.localdomain> | 2005-01-18 17:45:49 +0300 |
|---|---|---|
| committer | unknown <dlenev@brandersnatch.localdomain> | 2005-01-18 17:45:49 +0300 |
| commit | e2c869f2ff92b72917ecb4d16cf9408be174eb71 (patch) | |
| tree | b09d56eaf7f2505f10962f7a4b9f1d4e0bda8f8b /mysql-test/r/alter_table.result | |
| parent | 9474fed704746c18d3422cf16ecd6a4747392cb1 (diff) | |
| download | mariadb-git-e2c869f2ff92b72917ecb4d16cf9408be174eb71.tar.gz | |
Added test for bug #7884 "Able to add invalid unique index on TIMESTAMP
prefix", which roots were fixed in 4.0 tree.
mysql-test/r/alter_table.result:
Added test for bug #7884 "Able to add invalid unique index on TIMESTAMP
prefix".
mysql-test/t/alter_table.test:
Added test for bug #7884 "Able to add invalid unique index on TIMESTAMP
prefix".
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index a7ae8bc310c..7d2b3f01ae6 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -493,3 +493,7 @@ select hex(a) from t1; hex(a) F2E5F1F2 drop table t1; +create table t1 ( a timestamp ); +alter table t1 add unique ( a(1) ); +ERROR HY000: Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys +drop table t1; |