How can we help you today? How can we help you today?

row_number() returns bigint, but SQL Prompt displays int

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
bstrautin
0

Comments

2 comments

Sort by
  • 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
    0
  • 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
    David Priddle
    0

Add comment

Please sign in to leave a comment.