Bug #10230 The Server Crash
Submitted: 28 Apr 2005 8:31 Modified: 28 May 2005 9:38
Reporter: AJIT DIXIT Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[28 Apr 2005 8:31] AJIT DIXIT 
Description:
If I run Following query , the server crashes 

select ROUND(sum(stk_curr_val /100000) , 0) as retval from stkdate
                          inner join depots on locn = depotid
                           where  stkdate.trdate = '2005-04-13'
                           and depots.sbu = 'AMADEUS'
                           and stkdate.bin = 'GOOD'  ;

However foilllowing query runs OK

select ROUND(sum(stk_curr_val) /100000 , 0) as retval from stkdate
                          inner join depots on locn = depotid
                           where  stkdate.trdate = '2005-04-13'
                           and depots.sbu = 'AMADEUS'
                           and stkdate.bin = 'GOOD'  ;

Earlier in 4.1.11 I have never noticed any server crash in running the same query

What is behaviorial differance between above two SQLs

How to repeat:
I can send data if requested
[28 Apr 2005 9:38] Hartmut Holzgraefe 
yes, please send data, or at least the backtrace info found in the servers error log

and please fill out the Version and OS info fields, too
[28 May 2005 23:00] Bugs System 
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".