new "too many digits" bug in SP-4

this issue is new for SP-4 ..i have been using this syntax for a long time
and never encountered this problem until the upgrade :(


> dbGetQuery( db , "select ( sum( ( bene_sex_ident_cd = 1 ) ) ) / ( count(
* ) ) as pct_male from x11" )
  pct_male
1        0
> dbGetQuery( db , "select ( sum( ( bene_sex_ident_cd = 1 ) )*1.000 ) / (
count( * )*1.000 ) as pct_male from x11" )
Error in .local(conn, statement, ...) :
  Unable to execute statement 'select ( sum( ( bene_sex_ident_cd = 1 )
)*1.000 ) / ( count( * )*1.000 ) as pct_male from x11'.
Server says 'too many digits (19 > 18)' [#22003].
>


what diagnostics can i run for you to troubleshoot this?  thanks!!  :)