diff options
| author | unknown <igor@olga.mysql.com> | 2007-02-14 22:06:41 -0800 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-02-14 22:06:41 -0800 |
| commit | 6ae94723ca07c0938d25105d6180c96bc6abeaae (patch) | |
| tree | d44a33ab601b96a951e6b65aec5bb1a6981f3a6a /mysql-test/r/endspace.result | |
| parent | c039eed82cb21d75965fd9b2e936396e0282e0cb (diff) | |
| download | mariadb-git-6ae94723ca07c0938d25105d6180c96bc6abeaae.tar.gz | |
Fixed bug #25971: indexes on text columns were ignored when ref accesses
were evaluated.
According to the new rules for string comparison partial indexes on text
columns can be used in the same cases when partial indexes on varchar
columns can be used.
mysql-test/r/endspace.result:
Adjusted results after the fix for bug #25971.
mysql-test/r/innodb.result:
Adjusted results after the fix for bug #25971.
mysql-test/r/myisam.result:
Adjusted results after the fix for bug #25971.
mysql-test/r/select.result:
Added a test case for bug #25971.
mysql-test/r/type_blob.result:
Adjusted results after the fix for bug #25971.
mysql-test/t/select.test:
Added a test case for bug #25971.
Diffstat (limited to 'mysql-test/r/endspace.result')
| -rw-r--r-- | mysql-test/r/endspace.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/endspace.result b/mysql-test/r/endspace.result index 0e68418a80f..003ee7ffd5e 100644 --- a/mysql-test/r/endspace.result +++ b/mysql-test/r/endspace.result @@ -98,7 +98,7 @@ concat('|', text1, '|') |teststring | explain select concat('|', text1, '|') from t1 where text1='teststring '; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range key1 key1 22 NULL 2 Using where +1 SIMPLE t1 ref key1 key1 22 const 2 Using where select concat('|', text1, '|') from t1 where text1 like 'teststring_%'; concat('|', text1, '|') |teststring | |