MariaDB

  1. Bug #611382
  2. Comment #5

Comment 5 for bug 611382

Revision history for this message
Timour Katchaounov (timour) wrote :

The query plan in 5.3-mwl89 equivalent to the 5.3 plan above is:
+----+-------------+-------+--------+---------------+------+---------+------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
 +----+-------------+-------+--------+---------------+------+---------+------+------+-------------+
| 1 | PRIMARY | t1 | system | NULL | NULL | NULL | NULL | 1 | |
| 1 | PRIMARY | t3 | system | NULL | NULL | NULL | NULL | 1 | |
| 1 | PRIMARY | t2 | ALL | NULL | NULL | NULL | NULL | 2 | Using where |
| 2 | SUBQUERY | t2 | ALL | NULL | NULL | NULL | NULL | 2 | |
 +----+-------------+-------+--------+---------------+------+---------+------+------+-------------+