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!! :)