nest select over 3 levels does't work well with union

[epee]

The version is Community 2.2.4-1.

mysql> show create table t;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------+
| t | CREATE TABLE `t` (
  `a` int(11) DEFAULT NULL
) ENGINE=InfiniDB DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> select * from t;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.01 sec)

mysql> select a from ( select a from (select a from t union all select a from t) as t1) as t2;
+---------+
| a |
+---------+
| 1 |
| 2359296 |
| 0 |
| 1 |
| 2359296 |
| 0 |
+---------+
6 rows in set (0.02 sec)

[Robert Adams (radams-calpont)]

Fix packaged in the 2.2.5 release.