[OASIS Issue Tracker] (ODATA-1032) Define comparison for numeric value exceptions

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ https://issues.oasis-open.org/browse/ODATA-1032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Pizzo updated ODATA-1032:
---------------------------------


Note that, unlike NULL, NaN in particular (but also INF and -INF) are highly unlikely to be stored in the service. Rather they are likely to be the result of an interim calculation. Therefore, being able to filter out all records that have a value of NaN (or result in an expression evaluating to NaN) is probably not a relevant scenario.

> Define comparison for numeric value exceptions
> ----------------------------------------------
>
>                 Key: ODATA-1032
>                 URL: https://issues.oasis-open.org/browse/ODATA-1032
>             Project: OASIS Open Data Protocol (OData) TC
>          Issue Type: Bug
>          Components: OData URL Conventions
>    Affects Versions: V4.01_CSD01, V4.0_CSD03
>            Reporter: Michael Pizzo
>             Fix For: V4.01_CSD02
>
>
> We describe comparison operations with null, but not with NaN, -INF and INF.
> For NaN IEEE754, says that NaN is unordered and not equal to itself, meaning that NaN compared to anything, including NaN, is false except for != which is true.
> This makes sense mathematically; however, this makes it very hard to find all resources with a property value of NaN (we would have to add a separate IsNaN() operator, and comparisons would have to account for this in their expressions).  We could say that NaN==NaN, similar to how we say Null==Null to make it easier to search for Null values.
> For INF, -INF, IEEE754 appears to define INF==INF and -INF==-INF, so we would have:
> INF == INF: True
> INF != INF: False
> INF < INF: False
> INF <= INF: True
> INF > INF: False
> INF >= INF: True
> INF < <valid number>: False
> INF <= <valid number>: False
> INF > <valid number: True
> INF >= <valid number>: True
> INF > -INF: True
> -INF == -INF: True
> -INF != -INF: False
> -INF < -INF: False
> -INF <= -INF: True
> -INF > -INF: False
> -INF >= -INF: Tru
> -INF < <valid number>: True
> -INF <= <valid number>: True
> -INF > <valid number>: False
> -INF >= <valid number>: False
> -INF > INF: False



--
This message was sent by Atlassian JIRA
(v6.2.2#6258)