mysql 不正确的数据名_MySQL返回不正确的数据？

Django社区最近出现了一个关于MySQL测试的问题(使用MyISAM)。

这是django票证：http://code.djangoproject.com/ticket/14661

Django的一位核心开发人员提出了这个测试，我们很多人都能够复制它。任何人都有猜测我们在这里遇到什么？它仅仅是MySQL中的一个错误还是我错过了一些东西？

以下是测试代码和查询：

DROP TABLE IF EXISTS `testapp_tag`;

CREATE TABLE `testapp_tag` (

`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,

`name` varchar(10) NOT NULL,

`parent_id` integer

);

INSERT INTO `testapp_tag` (`name`, `parent_id`) VALUES ("t1", NULL);

INSERT INTO `testapp_tag` (`name`, `parent_id`) VALUES ("t2", 1);

INSERT INTO `testapp_tag` (`name`, `parent_id`) VALUES ("t3", 1);

INSERT INTO `testapp_tag` (`name`, `parent_id`) VALUES ("t4", 3);

INSERT INTO `testapp_tag` (`name`, `parent_id`) VALUES ("t5", 3);

SELECT `testapp_tag`.`id`, `testapp_tag`.`name`, `testapp_tag`.`parent_id` FROM `testapp_tag` WHERE NOT ((`testapp_tag`.`id` IN (SELECT U0.`id` FROM `testapp_tag` U0 LEFT OUTER JOIN `testapp_tag` U1 ON (U0.`id` = U1.`parent_id`) WHERE U1.`id` IS NULL) AND `testapp_tag`.`id` IS NOT NULL)) ORDER BY `testapp_tag`.`name` ASC;

SELECT `testapp_tag`.`id`, `testapp_tag`.`name`, `testapp_tag`.`parent_id` FROM `testapp_tag` WHERE NOT ((`testapp_tag`.`id` IN (SELECT U0.`id` FROM `testapp_tag` U0 LEFT OUTER JOIN `testapp_tag` U1 ON (U0.`id` = U1.`parent_id`) WHERE U1.`id` IS NULL) AND `testapp_tag`.`id` IS NOT NULL)) ORDER BY `testapp_tag`.`name` ASC;这是输出：

mysql> SELECT `testapp_tag`.`id`, `testapp_tag`.`name`, `testapp_tag`.`parent_id` FROM `testapp_tag` WHERE NOT ((`testapp_tag` .`id` IN (SELECT U0.`id` FROM `testapp_tag` U0 LEFT OUTER JOIN `testapp_tag` U1 ON (U0.`id` = U1.`parent_id`) WHERE U1.`id` IS NULL) AND `testapp_tag`.`id` IS NOT NULL)) ORDER BY `testapp_tag`.`name` ASC;

+----+------+-----------+

| id | name | parent_id |

+----+------+-----------+

| 1 | t1 | NULL |

| 3 | t3 | 1 |

| 5 | t5 | 3 |

+----+------+-----------+

3 rows in set (0.00 sec)

mysql> SELECT `testapp_tag`.`id`, `testapp_tag`.`name`, `testapp_tag`.`parent_id` FROM `testapp_tag` WHERE NOT ((`testapp_tag` .`id` IN (SELECT U0.`id` FROM `testapp_tag` U0 LEFT OUTER JOIN `testapp_tag` U1 ON (U0.`id` = U1.`parent_id`) WHERE U1.`id` IS NULL) AND `testapp_tag`.`id` IS NOT NULL)) ORDER BY `testapp_tag`.`name` ASC;

+----+------+-----------+

| id | name | parent_id |

+----+------+-----------+

| 1 | t1 | NULL |

| 3 | t3 | 1 |

+----+------+-----------+

2 rows in set (0.01 sec)