title: Force MySQL 4.1 return to Decimal type
body: <p>I'm using JDBC to access a MySQL 4.1 database and have problems with queries of Decimal type.  When I do a query on a single Decimal column (i.e., <code>SELECT amount AS v FROM Customer</code>) I get a <code>BigDecimal</code> through the JDBC driver, but when I do an an operation of Decimal columns (i.e., <code>SELECT amount + tax AS v FROM Customer</code>) I get a <code>Double</code> even all columns involved in the operation are Decimal.  Is there ay way in which I can Convert or Cast the result to a Decimal.  I've tried <code>CAST</code> and <code>CONVERT</code> unsuccessfully.</p>