Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typos and poor wording in the about.wiki document. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
f30534fbb06981c98072244d344ba4c4 |
| User & Date: | drh 2008-11-30 13:09:27 |
Context
|
2008-11-30
| ||
| 20:42 | Fix the select1.proto test script so that avoids the use of NULL values. In about.wiki, warn user to not use NULL values together with ORDER BY. check-in: f84e0eed40 user: drh tags: trunk | |
| 13:09 | Fix typos and poor wording in the about.wiki document. check-in: f30534fbb0 user: drh tags: trunk | |
| 01:58 | Updates to the About document. check-in: 1e99bb8828 user: drh tags: trunk | |
Changes
Changes to about.wiki.
1
2
3
4
5
6
7
8
9
10
11
12
..
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
<h1>About Sqllogictest</h1> Sqllogictest is a program designed to verify that an SQL database engine computes correct results to queries by comparing the results to identical queries submitted to other SQL database engines. Sqllogictest was originally designed to test [http://www.sqlite.org/ | SQLite], but it is database engine neutral and can just as easily be used to test other database products. Sqllogictest is concerned only with correct results. No attention is paid to performance, optimal use of indices, disk and memory usage, transactional behavior, or concurrancy and locking issues. ................................................................................ Does the database engine compute the correct answer. </i></blockquote> Every SQL database engine has test vectors used to validate its operation. These manually generated test vectors are important. But generating test vectors is tedious, since the correct solutions must be computed and verifed by hand. The sqllogictest program is designed to sidestep this tedium by using independently developed database engines generate the reference test results automatically. This allows millions of test vectors to be producted by simple scripts, which in turn provides much more thorough and complete testing of the database engine. <h2>Operation</h2> The sqllogictest program is driven by test scripts containing SQL statements |
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
12
..
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
<h1>About Sqllogictest</h1> Sqllogictest is a program designed to verify that an SQL database engine computes correct results by comparing the results to identical queries from other SQL database engines. Sqllogictest was originally designed to test [http://www.sqlite.org/ | SQLite], but it is database engine neutral and can just as easily be used to test other database products. Sqllogictest is concerned only with correct results. No attention is paid to performance, optimal use of indices, disk and memory usage, transactional behavior, or concurrancy and locking issues. ................................................................................ Does the database engine compute the correct answer. </i></blockquote> Every SQL database engine has test vectors used to validate its operation. These manually generated test vectors are important. But generating test vectors is tedious, since the correct solutions must be computed and verifed by hand. The sqllogictest program is designed to sidestep this tedium by using independently developed database engines to generate the reference test results automatically. This allows millions of test vectors to be producted by simple scripts, which in turn provides much more thorough and complete testing of the database engine. <h2>Operation</h2> The sqllogictest program is driven by test scripts containing SQL statements |