[Gambas-user] Bug when executing SQL..

Stephen Bungay sbungay at ...981...
Tue Aug 22 19:50:41 CEST 2006


The reason I say this is because I am getting some rather unexpected results. 
For example the select statement;

SELECT COALESCE(SUM(rec_payment), SUM(rec_Payment),0) AS Payment
FROM tbl_salespayments 
WHERE rec_create > 1158921569;

  When executed from within the database manager  (or my gambas application) 
returns the sum of the column rec_payment, but when executed in MySQL it 
returnes zero (0) (which is what it should return in this case given the data 
I have in the table). 
 Are there known issues with whatever engine is being used? 

Steve.




More information about the User mailing list