diff options
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index f60996ba31f..06e1872a1c0 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -469,9 +469,9 @@ b. c. update t1 set b='b ' where a=2; update t1 set b='b ' where a > 1; -ERROR 23000: Duplicate entry 'b ' for key 2 +ERROR 23000: Duplicate entry 'b ' for key 'b' insert into t1 (b) values ('b'); -ERROR 23000: Duplicate entry 'b' for key 2 +ERROR 23000: Duplicate entry 'b' for key 'b' select * from t1; a b 1 a @@ -867,7 +867,7 @@ explain select count(*) from t1 where v between 'a' and 'a ' and v between 'a ' id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref v v 13 const # Using where; Using index alter table t1 add unique(v); -ERROR 23000: Duplicate entry '{ ' for key 1 +ERROR 23000: Duplicate entry '{ ' for key 'v_2' alter table t1 add key(v); select concat('*',v,'*',c,'*',t,'*') as qq from t1 where v='a'; qq @@ -1227,16 +1227,16 @@ drop table t1; create table t1 (a char(10), unique (a)); insert into t1 values ('a '); insert into t1 values ('a '); -ERROR 23000: Duplicate entry 'a' for key 1 +ERROR 23000: Duplicate entry 'a' for key 'a' alter table t1 modify a varchar(10); insert into t1 values ('a '),('a '),('a '),('a '); -ERROR 23000: Duplicate entry 'a ' for key 1 +ERROR 23000: Duplicate entry 'a ' for key 'a' insert into t1 values ('a '); -ERROR 23000: Duplicate entry 'a ' for key 1 +ERROR 23000: Duplicate entry 'a ' for key 'a' insert into t1 values ('a '); -ERROR 23000: Duplicate entry 'a ' for key 1 +ERROR 23000: Duplicate entry 'a ' for key 'a' insert into t1 values ('a '); -ERROR 23000: Duplicate entry 'a ' for key 1 +ERROR 23000: Duplicate entry 'a ' for key 'a' update t1 set a='a ' where a like 'a%'; select concat(a,'.') from t1; concat(a,'.') |