4 ms·
Even in the absence of strict tables, you can also add a CHECK constraint whenever limits are needed on the value types. Here is one example from a recent discu
by paulclinger 4y ago
Even in the absence of strict tables, you can also add a CHECK constraint whenever limits are needed on the value types. Here is one example from a recent discussion in SQLite forum threads: `check(datetime(x, '+0 seconds') IS x)`.
- chasil 4y agoAn important proviso on the strict tables is that they will not be observed on older SQLite versions lacking this feature. SQLite has been rock-solid since attaining DO-178B, and commonly isn't ever upgraded in many installations. CentOS 7 is using 3.7.17. Since the v3 database format is standardized, the older version can utilize a STRICT database file, but will not have the capability to alter datatype behavior. For these cases, implementing both STRICT and the relevant CHECK constraints is advisable.