]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(merge: 005c9d8 c9ef12f)
Enhance the "PRAGMA integrity_check" statement so that it verifies datatype
authordrh <>
Mon, 10 Oct 2022 23:54:17 +0000 (23:54 +0000)
committerdrh <>
Mon, 10 Oct 2022 23:54:17 +0000 (23:54 +0000)
commit7747ffba476e2f050d5c72238bd5ffe3d57d5f2d
tree71bb09777b15611db9f0cc1762d65f90f42f43a5tree
parent005c9d829593365b734d2885ddfe04ab85ffbc4fcommit | diff
parentc9ef12f62bfbf808e606dd69d578ef9df3cc9e5acommit | diff
Enhance the "PRAGMA integrity_check" statement so that it verifies datatype
constraints on non-STRICT tables:  (1) Columns with TEXT affinity should not
contain numeric values, and (2) columns with NUMERIC affinity should not
contain TEXT values that could be converted into numbers.

FossilOrigin-Name: aa6e9086196248675b9e33dbfaad9ef67097432535896790f80d2470002978b1
manifest diff1 | diff2 | blob | history
manifest.uuid diff1 | diff2 | blob | history
Mirror of https://github.com/sqlite/sqlite.git