aboutsummaryrefslogtreecommitdiff
path: root/src/pragma.c
diff options
context:
space:
mode:
authordan <Dan Kennedy>2025-02-13 14:47:25 +0000
committerdan <Dan Kennedy>2025-02-13 14:47:25 +0000
commit5087eacb18b6e89291abc15c2818832ae99fd3cc (patch)
tree43c694901701b601ac54e30f183636d77ba42413 /src/pragma.c
parent25367c1eb04aa55b47d1e253e5e85cf9e6d7228b (diff)
downloadsqlite-5087eacb18b6e89291abc15c2818832ae99fd3cc.tar.gz
sqlite-5087eacb18b6e89291abc15c2818832ae99fd3cc.zip
Ensure the counts of "deferred FK violations" and "deferred immediate FK violations" are kept separate when "PRAGMA defer_foreign_keys" is used.
FossilOrigin-Name: c5190b0fd9bd76653fb7bb08e931699e42c88cef8a00352360d091948cda93a2
Diffstat (limited to 'src/pragma.c')
-rw-r--r--src/pragma.c5
1 files changed, 4 insertions, 1 deletions
diff --git a/src/pragma.c b/src/pragma.c
index 291ccf7af..f1a922d1a 100644
--- a/src/pragma.c
+++ b/src/pragma.c
@@ -1153,7 +1153,10 @@ void sqlite3Pragma(
}
}else{
db->flags &= ~mask;
- if( mask==SQLITE_DeferFKs ) db->nDeferredImmCons = 0;
+ if( mask==SQLITE_DeferFKs ){
+ db->nDeferredImmCons = 0;
+ db->nDeferredCons = 0;
+ }
if( (mask & SQLITE_WriteSchema)!=0
&& sqlite3_stricmp(zRight, "reset")==0
){