MySQL Bugs: #1457: crash MySQL server after query

Bug #1457	crash MySQL server after query
Submitted:	1 Oct 2003 9:00	Modified:	2 Nov 2003 22:02
Reporter:	Alex Ivanov	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1 alpha	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
After next query MySQL server down with error:

Error by addres 0x0044855d. 
And Server crashed.

This query give error

(SELECT 
dabitspeztable_0.id, 
didentificationtable_0.Fam,
didentificationtable_0.Name,
didentificationtable_0.SecName,
dabitspeztable_0.Prior, 
dmedtable_0.medtype, 
dcurrentexem_0.SpezID,
dballtable_0.Currentexem, 
dballtable_0.BALL,
dballtable_1.Currentexem, 
dballtable_1.BALL,
dballtable_2.Currentexem, 
dballtable_2.BALL,-1,-1,-1,-1,-1,-1,
dballtable_0.BALL+dballtable_1.BALL+dballtable_2.BALL summball

FROM 
dabitspeztable dabitspeztable_0, 
dmedtable dmedtable_0, 
drangelist drangelist_0,
dballtable dballtable_0,
dballtable dballtable_1,
dballtable dballtable_2,
dcurrentexem dcurrentexem_0, 
didentificationtable didentificationtable_0

order by dabitspeztable_0.prior desc,summball desc,dballtable_0.BALL desc)

union all

(SELECT 
dabitspeztable_0.id, 
didentificationtable_0.Fam,
didentificationtable_0.Name,
didentificationtable_0.SecName,
dabitspeztable_0.Prior, 
dmedtable_0.medtype, 
dcurrentexem_0.SpezID,
dballtable_0.Currentexem, 
dballtable_0.BALL,
dballtable_1.Currentexem, 
dballtable_1.BALL,
dballtable_2.Currentexem, 
dballtable_2.BALL,-1,-1,-1,-1,-1,-1,
dballtable_0.BALL+dballtable_1.BALL+dballtable_2.BALL summball

FROM 
dabitspeztable dabitspeztable_0, 
dmedtable dmedtable_0, 
drangelist drangelist_0,
dballtable dballtable_0,
dballtable dballtable_1,
dballtable dballtable_2,
dcurrentexem dcurrentexem_0, 
didentificationtable didentificationtable_0

order by summball desc,dballtable_0.BALL desc)

union all

(SELECT 
dabitspeztable_0.id, 
didentificationtable_0.Fam,
didentificationtable_0.Name,
didentificationtable_0.SecName,
dabitspeztable_0.Prior, 
dmedtable_0.medtype, 
dcurrentexem_0.SpezID,
dballtable_0.Currentexem, 
dballtable_0.BALL,
dballtable_1.Currentexem, 
dballtable_1.BALL,
dballtable_2.Currentexem, 
dballtable_2.BALL,-1,-1,-1,-1,-1,-1,
dballtable_0.BALL+dballtable_1.BALL+dballtable_2.BALL summball

FROM 
dabitspeztable dabitspeztable_0, 
dmedtable dmedtable_0, 
drangelist drangelist_0,
dballtable dballtable_0,
dballtable dballtable_1,
dballtable dballtable_2,
dcurrentexem dcurrentexem_0, 
didentificationtable didentificationtable_0

order by summball desc,dballtable_0.BALL desc,fam)

I deleted a WHERE section of Query but if you want i will send full query to you.

If take this query WITH OUT an ORDER declaration all will be work normal.

Thanks and
Sorry for my English. =)

How to repeat:
Give this query again. that`s all

Just now I begin to build an 4.1.1 Windows server from our last BK tree.
A lot of fixes were added since 4.1.0 release, then I need to test if
this crash still happens.
If you can help me saving my time, please send me a complete test case
with tables structure filled with few records and the queries you had
mentioned.
The zip test case file can be uploaded at:
ftp://supprt.mysql.com/pub/mysql/secret

if you agree please use a name which identified this bug report.

Thanks in advance.

I can`t connect to FTP directory.
Please send password and login to my mail!

For to dowlonad for the FTP before mentioned you don't need password
and login. Please verifiy if any firewall or browser set don't permits
the login.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".