Note that the vast majority of the sqlite tests are functional tests written in TCL and are not "real" unit tests. His test test stuff like "does select (this,

Note that the vast majority of the sqlite tests are functional tests written in TCL and are not "real" unit tests. His test test stuff like "does select (this, this, this) return that under these circumstances. There's some test setup stuff written in C and maybe C-level interface tests, but I think the functional tests are what lets him modify his optimizer, rather than some unit tests which are tightly bound to a specific implementation.