Documentation Source Text

Check-in [58cb4dd691]
Login

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

Overview
Comment:Fix a typo in the FOREIGN KEY documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | branch-3.19
Files: files | file ages | folders
SHA3-256: 58cb4dd691fdcedda448774930164e5135ffb7b2fa51447f049c6085a437ffec
User & Date: drh 2017-07-03 11:01:34.260
Context
2017-07-09
18:49
Fix typo in the appfileformat.html document. (check-in: 67789bcd04 user: drh tags: branch-3.19)
2017-07-03
11:01
Fix a typo in the FOREIGN KEY documentation. (check-in: 58cb4dd691 user: drh tags: branch-3.19)
2017-07-01
23:24
Attempt to improve the INSERT documentation. (check-in: 6b1a2005d8 user: drh tags: branch-3.19)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/foreignkeys.in.
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
    Errors reported when content is changed are "DML errors" and errors
    reported when the schema is changed are "DDL errors".
    So, in other words, misconfigured foreign key constraints that require
    looking at both the child and parent are DML errors.
    ^The English language error message for foreign key DML errors is usually
    "foreign key mismatch" but can also be "no such table" if the parent
    table does not exist.
    ^(Foreign key DML errors are may be reported if:

  <ul>
    <li> The parent table does not exist, or
    <li> The parent key columns named in the foreign key constraint do
         not exist, or
    <li> The parent key columns named in the foreign key constraint are not
         the primary key of the parent table and are not subject to a unique







|







320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
    Errors reported when content is changed are "DML errors" and errors
    reported when the schema is changed are "DDL errors".
    So, in other words, misconfigured foreign key constraints that require
    looking at both the child and parent are DML errors.
    ^The English language error message for foreign key DML errors is usually
    "foreign key mismatch" but can also be "no such table" if the parent
    table does not exist.
    ^(Foreign key DML errors are reported if:

  <ul>
    <li> The parent table does not exist, or
    <li> The parent key columns named in the foreign key constraint do
         not exist, or
    <li> The parent key columns named in the foreign key constraint are not
         the primary key of the parent table and are not subject to a unique