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: |
58cb4dd691fdcedda448774930164e51 |
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
Changes to pages/foreignkeys.in.
︙ | ︙ | |||
320 321 322 323 324 325 326 | 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. | | | 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 |
︙ | ︙ |