Bug #10258 ERROR AND ERATIC BEHAVIOR IN TYPE CONVERSION
Submitted: 29 Apr 2005 8:31 Modified: 1 Jun 2005 3:11
Reporter: AJIT DIXIT Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version:5.0.4 OS:Linux (Linux RH9)
Assigned to: CPU Architecture:Any

[29 Apr 2005 8:31] AJIT DIXIT 
Description:
Following Query 

INSERT INTO stkdate3  (   locn ,  item ,  bin ,  stk_curr , stk_curr_val  , trdate)  
SELECT     a.locn ,  a.item ,  a.bin ,   sum(a.stk_curr- a.stk_date) as stk_net , 
           sum(a.stk_curr_val - a.stk_date_val ) as stk_net_val , b.trdate
              FROM stkdate a , stkdate b
              where a.locn = b.locn
              and a.item = b.item
              and a.bin = b.bin 
              and a.trdate > b.trdate 
              group by a.locn ,  a.item ,  a.bin , b.trdate ;

a) If column stk_curr_val of stkdate3 table and stk_curr_val and stk_date_val of stkdate table are of type int it generates correct results

b) If column stk_curr_val of stkdate3 table is int  and stk_curr_val and stk_date_val of stkdate table are of type Decimal 15,2  it generates very eratic results

There is problem in query whenever mysql is required to to type conversion

This Problem was not noticed in Version 4.1.11

How to repeat:
I can provide data id required
[1 May 2005 3:11] Jorge del Conde 
Hi!

Can you please upload the schema for table: stkdate3 so that we can try and reproduce this bug ?

Thanks!
[1 Jun 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".