A query such as:

Select TimestampAdd(SQL_TSI_FRAC_SECOND, 999999999 + 1, Cast(CurDate() as timestamp));

Returns a result with the incorrect amount of factional seconds.