You might take a look at this [recent clarification of the documentation](https://sqlite.org/src/info/80498b69ea489e88), which should soon make its way into the published docs.
You might take a look at this [recent clarification of the documentation](https://sqlite.org/src/info/80498b69ea489e88), which should soon make its way into the published docs.