[sqlite] Regarding testing

[Niall O'Reilly]

On Mon, 27 Apr 2015 17:51:43 +0100,
Drago, William @ CSG - NARDA-MITEQ wrote:
> 
> Never saw this before. LMAO. Will put it too good use...

  +1
  Ossum!

[sqlite] Regarding testing

[Sairam Gaddam]

Yeah I read that link previously but how do i get all those test cases?

On Mon, Apr 27, 2015 at 5:27 PM, Simon Slavin  wrote:

>
> On 27 Apr 2015, at 12:54pm, Sairam Gaddam  wrote:
>
> > How SQLite is tested and can I get those test cases?
>
> <
> http://lmgtfy.com/?q=How+SQLite+is+tested+and+can+I+get+those+test+cases%3F
> >
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Regarding testing

[Sairam Gaddam]

How SQLite is tested and can I get those test cases?

[sqlite] Regarding testing

[Drago, William @ CSG - NARDA-MITEQ]

Never saw this before. LMAO. Will put it too good use...

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com



> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin
> Sent: Monday, April 27, 2015 7:58 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Regarding testing
>
>
> On 27 Apr 2015, at 12:54pm, Sairam Gaddam 
> wrote:
>
> > How SQLite is tested and can I get those test cases?
>
> <http://lmgtfy.com/?q=How+SQLite+is+tested+and+can+I+get+those+test+cas
> es%3F>
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] Regarding testing

[Eduardo Morras]

On Mon, 27 Apr 2015 18:06:31 +0530
Sairam Gaddam  wrote:

> Yeah I read that link previously but how do i get all those test
> cases?

You can buy the professional tests at 
http://www.hwaci.com/sw/sqlite/prosupport.html , Mr. Hipps company behind 
Sqlite.

Or you can trust them or create the tests you need for your use case.

---   ---
Eduardo Morras 

[sqlite] Regarding testing

[Simon Slavin]

On 27 Apr 2015, at 1:36pm, Sairam Gaddam  wrote:

> Yeah I read that link previously but how do i get all those test cases?

Following the links from that page, some of the tests are included in the full 
download of the SQLite source code, which can be found near the end of the 
Download page (the big download which is longer than 5 Meg).

TH3 is described here:



where it lists TH3 License requirements in section 5.0

Simon.

[sqlite] Regarding testing

[Rob Willett]

You didn?t read the link properly. I?ll highlight the relevant sections 
The TCL Tests are the oldest set of tests for SQLite. They are contained in the 
same source tree as the SQLite core and like the SQLite core are in the public 
domain. The TCL tests are the primary tests used during development. The TCL 
tests are written using the TCL scripting language . The 
TCL test harness itself consists of 23.1 KSLOC of C code used to create the TCL 
interface. The test scripts are contained in 825 files totaling 10.9MB in size. 
There are 33402 distinct test cases, but many of the test cases are 
parameterized and run multiple times (with different parameters) so that on a 
full test run millions of separate tests are performed.

The TH3  test harness is a set of proprietary 
tests, written in C that provide 100% branch test coverage (and 100% MC/DC test 
coverage) to the core SQLite library. The TH3 tests are designed to run on 
embedded and specialized platforms that would not easily support TCL or other 
workstation services. TH3 tests use only the published SQLite interfaces. TH3 
is free to SQLite Consortium  members 
and is available by license to others. TH3 consists of about 53.1 MB or 718.2 
KSLOC of C code implementing 36618 distinct test cases. TH3 tests are heavily 
parameterized, though, so a full-coverage test runs about 1.5 million different 
test instances. The cases that provide 100% branch test coverage constitute a 
subset of the total TH3 test suite. A soak test prior to release does hundreds 
of millions of tests. Additional information on TH3 is available separately 
.


Does that help?

Rob


> On 27 Apr 2015, at 13:36, Sairam Gaddam  wrote:
> 
> Yeah I read that link previously but how do i get all those test cases?
> 
> On Mon, Apr 27, 2015 at 5:27 PM, Simon Slavin  wrote:
> 
>> 
>> On 27 Apr 2015, at 12:54pm, Sairam Gaddam  wrote:
>> 
>>> How SQLite is tested and can I get those test cases?
>> 
>> <
>> http://lmgtfy.com/?q=How+SQLite+is+tested+and+can+I+get+those+test+cases%3F
>>> 
>> 
>> Simon.
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>> 
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Regarding testing

[Simon Davies]

On 27 April 2015 at 12:54, Sairam Gaddam  wrote:
> How SQLite is tested and can I get those test cases?

4th entry under "Overview Documents" on http://www.sqlite.org/docs.html

[sqlite] Regarding testing

[Simon Slavin]

On 27 Apr 2015, at 12:54pm, Sairam Gaddam  wrote:

> How SQLite is tested and can I get those test cases?



Simon.