Wrong Result in MySQL 5

hs · Post by hs » Wed 26 Apr 2006 04:32

Hi,

I upgraded to MySQL 5 and have wrong result in my query. Details bellow :

Delphi 5 OR Delphi 6, MyDAC 5.55.0.26, MySQL 5.0.18

Table test
Kode varchar(11)
Qty decimal(9,2)
Price decimal(15,4)
Disc decimal(6,4)
Tax decimal(6,4)
Kurs decimal(10,4)

My Query like this :
Select Kode,Qty,Price,Disc,Tax,Kurs,Qty*Price*Kurs*(1-(Disc/100))*(1+(Tax/100)) Total from test

IF I direct run this query with SQLYog, i have the correct result. But if i use mydac in my apps the result is wrong. Any idea?

Thanks.
hs

Antaeus · Post by **Antaeus** » Thu 27 Apr 2006 07:39

Thank you for information. We have reproduced this problem. The investigation of the problem is in progress. Unfortunately now we cannot give you any information. As soon as we solve the problem we'll let you know.
As temporary solution you can set MyQuery.Options.FieldsAsString to True.

ben · Post by **ben** » Thu 27 Apr 2006 20:17

this bug also applies to the 4.x version of MyDAC?

Antaeus · Post by **Antaeus** » Fri 28 Apr 2006 08:01

Yes. We have reproduced this bug using the latest build of MyDAC.

Antaeus · Post by **Antaeus** » Sat 06 May 2006 15:14

We have fixed this problem. This fix will be included in the next MyDAC build.