SQLite

Check-in [b4a10c39e7]
Login

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

Overview
Comment:When ALTER TABLE RENAME TO is used to change the name of a table that is the parent table of a foreign key constraint, modify that foreign key constraint to use the new table name.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b4a10c39e726dc190e9597e382baddc034294114
User & Date: dan 2009-09-26 17:51:48.000
References
2014-04-14
19:46 New ticket [264b970c43] Crash when calling sqlite_rename_parent() with NULL parameters.. (artifact: 9c40070dd4 user: drh)
Context
2009-09-28
11:54
Fix some foreign key constraint related problems that occur when a row refers to itself. (check-in: 9e503e2d04 user: dan tags: trunk)
2009-09-26
17:51
When ALTER TABLE RENAME TO is used to change the name of a table that is the parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. (check-in: b4a10c39e7 user: dan tags: trunk)
2009-09-25
17:03
Avoid checking if an insert or delete has "fixed" an outstanding FK constraint violation if the constraint counter indicates that the database contains no such violations. (check-in: 519144ac43 user: dan tags: trunk)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/alter.c.
Changes to src/fkey.c.
Changes to src/sqliteInt.h.
Changes to test/fkey2.test.