OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Trouble in calculations

From: Xavier CAMIER (xavier.camierbatinor.fr)
Date: Wed Aug 23 2006 - 04:58:53 CDT


MaxDB 7.6.00.12

Hello,

When executing
SELECT -(100+50) FROM DBA.MYTABLE
I get 50 as result.

When executing
SELECT -(100+50+1) FROM DBA.MYTABLE
I get 149 as result.

Is there something wrong with the way I use parentheses or is this a bug
? Has it been corrected in MaxDB further versions ?

Kind regards,
Xavier CAMIER

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb