Hi all,

i have accidently discover a bug on mysql, i have crash my web server, it
paralysed all services until we kill the process... after a request mysql jump and stay to 100% cpu.

it seems that mysqld crash when he receive a request that contain a simple
jointure (from table1 t1, table2 t2) and a right outer join just after.

for example this request works correctly :

select u.username from whosonline w, users u where u.user_id = w.user_id

and this crash the server :

select u.username from whosonline w, users u right outer join users u2 on u2.user_id = w.user_id where u.user_id = w.user_id

username varchar(50) all user_id int

it "works" on linux 4.0.12, mysql-4.0.13-win and mysql-3.23.38-win, i think all
versions are affected :/

i hope it's help you *

friendly