Ubuntu
mysql-dfsg-5.0 package

  1. Bug #392236
  2. Comment #2

Comment 2 for bug 392236

Revision history for this message
Daniël van Eeden (dveeden) wrote :

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 BY mu.User) a;

The ORDER BY is causing the crash. I don't think the ORDER BY is syntactically allowed there.