Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-622

Allow comparison of geo types, binary to null.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: V4.0_OS
    • Fix Version/s: V4.0_ERRATA01
    • Component/s: Protocol, URL Conventions
    • Labels:
      None
    • Environment:

      [Proposed][Applied]

    • Proposal:
      Hide

      Explicitly state that binary, stream and geo values can only be compared to null using "eq null" and "ne null".

      Show
      Explicitly state that binary, stream and geo values can only be compared to null using "eq null" and "ne null".

      Description

      We currently state that operators can be used with types other than geo, stream, and binary, as these values are typically not comparable, but we don't say what can be used with these types..

      It is valid to compare these values to null. This is handled in database systems, for example, by having "is null" and "is not null" operators, but since in OData we decided (after long debate) to use "eq null" and "ne null" to compare to null values (with appropriate null propagation rules). However, the current verbiage could be misinterpreted to mean that the common and useful case of comparing binary, stream and geo values to null is not supported.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mikep Michael Pizzo
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: