Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2867 JSON support
  3. CALCITE-2868

Support for JSON key uniqueness constraint

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Syntax of JSON key uniqueness constraint:

      <JSON key uniqueness constraint> ::= WITH UNIQUE [ KEYS ] | WITHOUT UNIQUE [ KEYS ]
      

      From ISO/IEC 9075-6[1]:

      If <JSON key uniqueness constraint> is not specified, then WITHOUT UNIQUE KEYS is implicit.

      [1] http://standards.iso.org/ittf/PubliclyAvailableStandards/c065143_ISO_IEC_TR_19075-5_2016.zip

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zhztheplayer Hongze Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: