It makes sense for the maxLength < desiredPrecision to be an error, but with scale, does the sql spec say this is an error? I'd think you could just use the scale and those decimal places would be zero, no?