Richard Deeming

My feedback

  1. 7 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Richard Deeming commented  · 

    Same problem with parsing infinity:

    DECLARE @R REAL = TRY_PARSE(N'∞' as REAL);
    SELECT @R;
    GO

    DECLARE @R REAL = TRY_PARSE(N'-∞' as REAL);
    SELECT @R;
    GO

    The value is parsed and assigned to the variable, but attempting to select the variable produces an arithmetic overflow error.

    I suspect SQL Server is using the CLR's System.Double type to parse the value, and is then unable to cope with these specific IEEE 754 return values.

    NB: Using the FORMAT function, you can see the value of the variable:

    DECLARE @R REAL = TRY_PARSE(N'∞' as REAL);
    SELECT FORMAT(@R, 'r');
    GO

    Richard Deeming supported this idea  · 
  2. 889 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  153 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
    Richard Deeming supported this idea  · 
  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    Richard Deeming shared this idea  · 

Feedback and Knowledge Base