Artifact
6fb11fefa67712fe7f92e06c86d76e073c3e3eb8:
Ticket change
[6fb11fef]
- Ticket
[ce7c133e] Foreign key constraint fails when it should succeed. status still Open with 4 other changes
by
drh
2010-07-29 01:55:02.
D 2010-07-29T01:55:02
J +comment \n\n<hr><i>drh\sadded\son\s2010-07-29\s01:55:02:</i><br>\nThe\sissue\swas\sin\sthe\shandling\sof\smulti-column\sforeign\skey\sconstraints\r\nwhere\sone\sof\sthe\scolumns\swas\san\sinteger\sprimary\skey.\s\sThe\serror\shas\r\nalways\sbeen\sin\sthe\scode.\s\sIt\swas\ssimply\smasked\sby\sthe\sprior\serror\s\r\nof\sticket\s[dd08e5a988d00decc4a543daa8dbbfab9c577ad8].\s\sThe\sfix\sin\r\ncheck-in\s[636f86095eb1f4bdcfb0c9ed846c4c6b3589c10b]\sis\scorrect.\s\sThat\r\nfix\sdid\snot\sintroduce\sa\snew\sproblem;\sit\smerely\sbrought\san\sexisting\r\nproblem\sinto\sview.\r\n\r\nThe\sSeverity\sof\sthis\sticket\sis\sdowngraded\sto\sImportant\ssince\sone\r\ncan\seasily\sargue\sthat\sany\sschema\sthat\shas\sa\smulti-column\r\nforeign\skey\sconstraint\swhere\sone\sof\sthe\scolumns\sis\sa\sprimary\skey\r\nis\sa\sbroken\sschema.\s\sEven\sso,\swe\sought\sto\shandle\seven\sbroken\r\nschemas\scorrectly,\swhich\sshould\sbe\sthe\scase\safter\scheck-in\r\n[53902f7d4a46aa70ecc5bf180a01ff888d52686a].
J priority Immediate
J resolution Open
J severity Important
K ce7c133ea6cc9ccdc1a60d80441f80b6180f5eba
U drh
Z 0190864f18fadecc0feaeb75d2ac17eb