diff options
| author | unknown <ingo@mysql.com> | 2005-08-29 16:50:09 +0200 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2005-08-29 16:50:09 +0200 |
| commit | f876fae9c87b8330b3405a51ad886151ee300db4 (patch) | |
| tree | b102c0b329e6866dd9e872fdcbbee6a47dcd5619 /mysql-test/r/key.result | |
| parent | 56b8fc52cfe81b22031ece94475d9a6f3fa663c2 (diff) | |
| download | mariadb-git-f876fae9c87b8330b3405a51ad886151ee300db4.tar.gz | |
Bug#12565 - ERROR 1034 when running simple UPDATE or DELETE on large MyISAM table
Changed end-space comparison so that the key is not used past
its end. This is due to the new end-space behaviour in 4.1.
See also bug 6151 and 9188.
mysql-test/r/key.result:
Bug#12565 - ERROR 1034 when running simple UPDATE or DELETE on large MyISAM table
The test result.
mysql-test/t/key.test:
Bug#12565 - ERROR 1034 when running simple UPDATE or DELETE on large MyISAM table
The test case.
Diffstat (limited to 'mysql-test/r/key.result')
| -rw-r--r-- | mysql-test/r/key.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index cceaf393a60..f0a7afa239f 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -325,3 +325,19 @@ ERROR 42S21: Duplicate column name 'c1' alter table t1 add key (c1,c1,c2); ERROR 42S21: Duplicate column name 'c1' drop table t1; +create table t1 ( +c1 int, +c2 varchar(20) not null, +primary key (c1), +key (c2(10)) +) engine=myisam; +insert into t1 values (1,''); +insert into t1 values (2,' \t\tTest String'); +insert into t1 values (3,' \n\tTest String'); +update t1 set c2 = 'New Test String' where c1 = 1; +select * from t1; +c1 c2 +1 New Test String +2 Test String +3 + Test String |