On 5/8/15, Sairam Gaddam <gaddamsairam at gmail.com> wrote: > I have custom SQLite and in order to test it I downl > oaded sqlite-src-3081000.zip > (7.29 MiB) as advised, which contains some test files but most of them are > .test files and how to execute them? should I use sqllogictest program? If > it should be used where is it available?
The main public SQLite test suite makes extensive use of TCL. (http://tcl.tk/). On unix or Windows workstations, you simply install TCL then unpack the SQLite archive, then type "./configure; make test" on unix or Windows with MinGW/Msys or "nmake /f Makefile.msc test" under Windows with MSVC. If you are on an embedded system that does not have the infrastructure to support TCL, then you could (as you observe) try to run sqllogictest, which is written in C. But that test suite is really only designed to show that SQLite generates the same results as other database engines for given SQL statements. So it does not test things like file I/O or transactions or non-universal features such as partial indexes, common table expression, virtual tables, etc. The TH3 test suite is plain C code that provides 100% MC/DC is designed to run on embedded systems with minimal support infrastructure. But TH3 is proprietary and is used under license only. See https://sqlite.org/th3.html for additional information. > > And regarding .c test files some of them require tcl.h file which i could > not find ! I followed the steps given at the starting of each file but i > dont find them useful. > can anyone help me regarding this? > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp drh at sqlite.org