diff options
| author | dlenev@brandersnatch.localdomain <> | 2005-01-18 17:45:49 +0300 |
|---|---|---|
| committer | dlenev@brandersnatch.localdomain <> | 2005-01-18 17:45:49 +0300 |
| commit | 0787a97b1c38685cc16798faddc10892c581efcb (patch) | |
| tree | b09d56eaf7f2505f10962f7a4b9f1d4e0bda8f8b /mysql-test/r/alter_table.result | |
| parent | 3d4eb575a212060492d2b6d0cceb313b359b1659 (diff) | |
| download | mariadb-git-0787a97b1c38685cc16798faddc10892c581efcb.tar.gz | |
Added test for bug #7884 "Able to add invalid unique index on TIMESTAMP
prefix", which roots were fixed in 4.0 tree.
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; |