Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix a typo in the FOREIGN KEY documentation. |
|---|---|
| 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 |
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 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
|