Options
row_number() returns bigint, but SQL Prompt displays int
bstrautin
Posts: 8 Bronze 2
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
Comments
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
This should be fixed in the latest version of the software.
Please let us know if it works for you.
Best regards,
David