diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-07-16 10:56:42 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-07-16 10:56:42 +0400 |
| commit | 47c1b0407971408eefaabee79a1097fd5c6ea90f (patch) | |
| tree | 0284fa386bd664c60860033f1b8e56f9ccae6424 /mysql-test/r/mrr_icp_extra.result | |
| parent | 9651a6f5745c330111b5281e69a7d52fc8261d0d (diff) | |
| download | mariadb-git-47c1b0407971408eefaabee79a1097fd5c6ea90f.tar.gz | |
MDEV-4778: Incorrect results from Aria/MyISAM SELECT using index with prefix length on TEXT column
Backport the fix olav.sandstaa@sun.com-20101102184747-qfuntqwj021imy9r:
"Fix for Bug#52660 Perf. regr. using ICP for MyISAM on range queries on an index containing TEXT"
(together with further fixes in that code) into MyISAM and Aria.
Diffstat (limited to 'mysql-test/r/mrr_icp_extra.result')
| -rw-r--r-- | mysql-test/r/mrr_icp_extra.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/mrr_icp_extra.result b/mysql-test/r/mrr_icp_extra.result index 5e49fb6e956..f7adcfb19fd 100644 --- a/mysql-test/r/mrr_icp_extra.result +++ b/mysql-test/r/mrr_icp_extra.result @@ -105,7 +105,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range FieldKey FieldKey 38 NULL 4 Using index condition; Rowid-ordered scan; Using filesort EXPLAIN SELECT * FROM t1 IGNORE INDEX (FieldKey, LongField) WHERE FieldKey > '2' ORDER BY LongVal; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range StringField StringField 38 NULL 4 Using index condition; Using filesort +1 SIMPLE t1 range StringField StringField 38 NULL 4 Using where; Using filesort SELECT * FROM t1 WHERE FieldKey > '2' ORDER BY LongVal; FieldKey LongVal StringVal 3 1 2 |