... Testing Services The Test Harness #3 (TH3) is a suite of test cases for SQLite that provide 100% branch test coverage (and 100% modified condition/decision coverage) for the core SQLite in an as-deployed configuration using only published and ... 

 ... An SQL test script was developed and run by volunteers on various SQL RDBMSes and the results of those tests were used to deduce how each engine processed NULL values. The original tests were run in May of 2002. A ... 

4.1. Compiling And Testing on Android  ... adb push kvtest-android /data/local/tmp Finally use "adb shell" to get a shell prompt on the Android device, cd into the /data/local/tmp directory, and begin running the tests as with any other unix host. This page ... 

 ... The Test Harness #3 (TH3) is an alternative set of test vectors for SQLite that verify the operation of SQLite in an as-deployed configuration on embedded platforms with 100% branch test coverage.

 ... These error reporting paths are all carefully tested to ensure they will always work. SQLite is resilient in the face of corrupt inputs, including maliciously designed database files and SQL strings. Extensive fuzz-testing ensures that corrupt inputs will not ... 

 ... Aviation-grade testing → Every machine-code branch instruction is tested in both directions. Multiple times. On multiple platforms and with multiple compilers. This helps make the code robust for future migrations. The intense testing also means that new developers ... 

 ... The claim of the previous paragraph is extensively checked in the SQLite regression test suite using a special test harness that simulates the effects on a database file of operating system crashes and power failures. Additional information

 ... SQLite is often used as a surrogate for an enterprise RDBMS for demonstration purposes or for testing. SQLite is fast and requires no setup, which takes a lot of the hassle out of testing and which makes demos perky and ... 

 ... The SQLite developers will set up customized regression tests to fully and completely test SQLite as configured by consortium members. Normally, only the standard SQLite configuration is fully tested at each release. Consortium members that use a non-standard configuration ... 

SQLITE_PREPARE_PERSISTENT, SQLITE_PREPARE_NORMALIZE, SQLITE_PREPARE_NO_VTAB, SQLITE_PREPARE_DONT_LOG

 ... This can be used, for example, to do test compiles to see if some SQL syntax is well-formed, without generating messages on the global error log when it is not. If the test compile fails, the sqlite3_prepare_v3() call returns ...