Remove parentheses after ON in JOIN specification

XMLWordPrintable

    • Type: Improvement
    • Resolution: Fixed
    • Priority: Minor
    • None
    • Affects Version/s: None
    • Component/s: Domain Model
    • None
    • Hide

      Use:
      <join specification> ::= ON ( <column reference> "=" <column reference> )

      no parens

      Show
      Use: <join specification> ::= ON ( <column reference> "=" <column reference> ) no parens

      The BNF for queries has:

      <join specification> ::= ON "(" <column reference> "=" <column reference> ")"

      I see no reason to have the parentheses mandatory; for consistency with the syntax of many databases I'd rather have:

      <join specification> ::= ON ( <column reference> "=" <column reference> | "(" <column reference> "=" <column reference> ")" )

      (And if people want to completely ditch the redundant parentheses I'm all for it as well.)

            Assignee:
            Ethan Gur-esh (Inactive)
            Reporter:
            Florent Guillaume (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: