Thank you for taking the time to report this bug and helping to make
Ubuntu better. The version of Ubuntu you're reporting this issue on is
in End of Life status, and newer versions have fixed this issue. You can
learn more about this at https://wiki.ubuntu.com/Releases
** Changed in:
Seems to be directly related to:
http://bugs.mysql.com/bug.php?id=21476
** Bug watch added: MySQL Bug System #21476
http://bugs.mysql.com/bug.php?id=21476
--
MySQL 5.0.22 Crash on Ubuntu 6.06.2 LTS
https://bugs.launchpad.net/bugs/392236
You received this bug notification because you are a
Both hardy (5.0.51a) and karmic (5.0.75) don't allow the use of such a
query:
mysql SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user
FROM mysql.user mu ORDER BY mu.User) a;
ERROR 1054 (42S22): Unknown column 'mu.User' in 'order clause'
which seems to be right behavior.
A backport of 5.0.38 doesn't produce a mysqld crash:
math...@t-mysqld-d:~$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.0.38-Ubuntu_0ubuntu1-log Ubuntu 7.04 distribution
Type 'help;' or '\h' for help. Type '\c' to clear
The latter query caused the initial crash, The first is a simplified
query which is using the mysql user database and also crashes
So please use this query on a MySQL 5.0.22 Server on Ubuntu 6.06.2 LTS
SELECT * FROM (SELECT mu.User FROM mysql.user mu UNION SELECT mu.user FROM
mysql.user mu ORDER