row_number() returns bigint, but SQL Prompt displays int

bstrautin

The summary popup for the row_number() function reports that it returns int, but it actually returns bigint.

select row_number() over (order by o.object_id)
from sys.objects o

David Priddle

Hi bstrautin,

Thanks for pointing this out!

We'll have a review of all of the function return types and their parameter types to make sure we don't have any more inaccuracies.

Best regards,

David

David Priddle

Hi bstrautin,

This should be fixed in the latest version of the software.

Please let us know if it works for you.

Best regards,

David