Bug with UNION and constant columns

"Amir Abiri" <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <001301c4440c$85e01cd0$1500640a@amir>
mysql> ( SELECT '' ) UNION ( SELECT 'aaaaaaaaaaaa' );
+--+
|  |
+--+
|  |
+--+
1 row in set (0.00 sec)

mysql> ( SELECT '******' ) UNION ( SELECT '|||||||||||');
+--------+
| ****** |
+--------+
| ****** |
| |||||| |
+--------+
2 rows in set (0.00 sec)

(there are more '|' then '*')

Bug exists in 4.0.20.

Does not occur in 4.1.1.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.