[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