From e2c869f2ff92b72917ecb4d16cf9408be174eb71 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 18 Jan 2005 17:45:49 +0300 Subject: 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". --- mysql-test/r/alter_table.result | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/r/alter_table.result') 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; -- cgit v1.2.1