Most databases implement analytical ranks/row_number as returning bigint - regardless of what type count returns. MS SQL introduced COUNT_BIG, and Postgresql switched everything to bigint in 7.2.