Documentation Source Text

Check-in [3562d60bc7]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a bug in the foreign-key-clause syntax diagram: the ON DELETE clause and its friends are all optional.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3562d60bc75d116feb21bf2f17dfa133edebfe02
User & Date: drh 2009-05-10 15:57:35.000
Context
2009-05-11
14:24
Initial error list checkin. (check-in: 7276f4a4a3 user: shaneh tags: trunk)
2009-05-10
15:57
Fix a bug in the foreign-key-clause syntax diagram: the ON DELETE clause and its friends are all optional. (check-in: 3562d60bc7 user: drh tags: trunk)
2009-05-06
23:57
Fix a typo in the release 3.6.14 news blurb. (check-in: a431922439 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to art/syntax/bubble-generator.tcl.
︙︙
145
146
147
148
149
150
151

152
153
154
155
156
157
158
159
160
161
162

163
164
165
166
167
168
169
170

          {line CHECK ( expr )}
          {line FOREIGN KEY ( {loop /column-name ,} ) foreign-key-clause }
       }
  }
  foreign-key-clause {
      stack 
        {line REFERENCES /foreign-table {optx ( {loop /column-name ,} )}}

          {loop
             {or
                {line ON {or DELETE UPDATE INSERT}
                         {or {line SET NULL} {line SET DEFAULT}
                             CASCADE RESTRICT
                         }
                }
                {line MATCH /name}
             }
             {}
          }

        {or
          {line {optx NOT} DEFERRABLE 
             {or 
                {line INITIALLY DEFERRED}
                {line INITIALLY IMMEDIATE}
                {}
             }
          }








>

|









>
|








145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172

          {line CHECK ( expr )}
          {line FOREIGN KEY ( {loop /column-name ,} ) foreign-key-clause }
       }
  }
  foreign-key-clause {
      stack 
        {line REFERENCES /foreign-table {optx ( {loop /column-name ,} )}}
        {optx 
          {loop
             {or 
                {line ON {or DELETE UPDATE INSERT}
                         {or {line SET NULL} {line SET DEFAULT}
                             CASCADE RESTRICT
                         }
                }
                {line MATCH /name}
             }
             {}
          }
        }
        {optx
          {line {optx NOT} DEFERRABLE 
             {or 
                {line INITIALLY DEFERRED}
                {line INITIALLY IMMEDIATE}
                {}
             }
          }
︙︙
Changes to art/syntax/foreign-key-clause.gif.

cannot compute difference between binary files