[sqlite-dev] How Test Suite is Organized

4 views
Skip to first unread message

Octopus ZHANG

unread,
Dec 26, 2019, 3:23:49 AM12/26/19
to sqlit...@mailinglists.sqlite.org

Hi all,


I'm interested in the testing process of SQLite. I have read the documentation "How SQLite is Tested".

I downloaded the source code from https://www.sqlite.org/src/info/18db032d058f1436 which is with some test cases. I also tried to run the test suite with `make test`. The test finished within several minutes 

However, I still don't know how to run the three mentioned hardness test suite. I could only see the `xx.test` script under `test` folder and search to find the name (e.g. "thread"). In other words, I cannot map the test files to the testing items listed on the page.

Are there any other documentation/reports/notes/videos/presentations which talk about the testing process of SQLite?


Thanks,
Yushan

Kees Nuyt

unread,
Dec 26, 2019, 6:06:51 AM12/26/19
to sqlit...@mailinglists.sqlite.org

SQLite Test Harness #3 (TH3):
https://www.sqlite.org/th3.html

It is proprietary :
https://www.sqlite.org/support.html
https://www.sqlite.org/prosupport.html
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-dev mailing list
sqlit...@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev

Octopus ZHANG

unread,
Dec 26, 2019, 7:25:18 AM12/26/19
to sqlit...@mailinglists.sqlite.org

I want to learn the testing techniques, however, I didn't expect it to be proprietary.


Thank you all the same.


Kees Nuyt <k.n...@zonnet.nl> 于2019年12月26日周四 下午7:06写道:


--

--------------------------------------------------------------------------------
Apologize to any possible reply delay for time differences.
对于任何由于时差未能及时回复邮件的情况表示抱歉。

Octopus ZHANG

unread,
Dec 26, 2019, 7:31:30 AM12/26/19
to sqlit...@mailinglists.sqlite.org

I forgot to ask, are the other two Test Harness also proprietary?


Than you.

Kees Nuyt <k.n...@zonnet.nl> 于2019年12月26日周四 下午7:06写道:
On Thu, 26 Dec 2019 16:23:36 +0800, Yushan wrote:

Kees Nuyt

unread,
Dec 26, 2019, 6:57:13 PM12/26/19
to sqlit...@mailinglists.sqlite.org
On Thu, 26 Dec 2019 20:31:16 +0800, Yushan wrote:

> I forgot to ask, are the other two Test Harness also proprietary?

As https://www.sqlite.org/th3.html#history says:
"TH1 did not survive as a standard testing tool for SQLite, but it did find
continued service as a scripting language used to customize the Fossil version
control system."

Fossil is free to use.
http://www.fossil-scm.org/home/doc/trunk/COPYRIGHT-BSD2.txt

In Fossil, TH1 is a scripting language, not really a test harness anymore.
http://www.fossil-scm.org/home/doc/trunk/www/th1.md

As far as I can tell, TH2 did not survive.

Reply all
Reply to author
Forward
0 new messages