filter_formats() causes a filesort [#625942]

EXPLAIN SELECT ff.* FROM filter_format ff ORDER BY weight ASC;
+----+-------------+-------+------+---------------+------+---------+------+------+----------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra          |
+----+-------------+-------+------+---------------+------+---------+------+------+----------------+
|  1 | SIMPLE      | ff    | ALL  | NULL          | NULL | NULL    | NULL |    3 | Using filesort | 
+----+-------------+-------+------+---------------+------+---------+------+------+----------------+
1 row in set (0.00 sec)

This query is currently run whenever displaying a formatted textarea, but has no index at all.

Comment	File	Size	Author
#3	filter.patch	900 bytes	catch

Comments

Comment #1

catch

he/him

English

commented 7 November 2009 at 04:40

Component:

base system

» filter.module

Comment #2

sun

German

Karlsruhe

commented 7 November 2009 at 04:41

subscribing

Comment #3

catch

he/him

English

commented 7 November 2009 at 06:00

Status:

Active

» Needs review

Status	File	Size
new	filter.patch	900 bytes

mysql> EXPLAIN SELECT ff.* FROM filter_format ff ORDER BY weight ASC;
+----+-------------+-------+-------+---------------+--------+---------+------+------+-------+
| id | select_type | table | type  | possible_keys | key    | key_len | ref  | rows | Extra |
+----+-------------+-------+-------+---------------+--------+---------+------+------+-------+
|  1 | SIMPLE      | ff    | index | NULL          | weight | 1       | NULL |    3 |       | 
+----+-------------+-------+-------+---------------+--------+---------+------+------+-------+