/ Check-in [7cb697f8]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add tests for the change on this branch.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | covering-or
Files: files | file ages | folders
SHA1: 7cb697f82932a2581af69350117a29c9c8a2544f
User & Date: dan 2016-01-29 21:16:13
Context
2016-01-30
00:45
Change the P4_INTARRAY so that always begins with a length integer. Print the content of the INTARRAY on EXPLAIN output. Closed-Leaf check-in: 6c520d57 user: drh tags: covering-or
2016-01-29
21:16
Add tests for the change on this branch. check-in: 7cb697f8 user: dan tags: covering-or
20:58
Different comment on the alternative cursor fields of VdbeCursor. check-in: 6e3dcb6d user: drh tags: covering-or
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/whereD.test.

   296    296   } {A C search 6}
   297    297   do_searchcount_test 6.3.2 {
   298    298     SELECT c FROM x1 WHERE a=1 OR b=10;
   299    299   } {3 11 search 5}
   300    300   do_searchcount_test 6.3.3 {
   301    301     SELECT rowid FROM x1 WHERE a=1 OR b=10;
   302    302   } {1 3 search 4}
          303  +
          304  +do_searchcount_test 6.4.1 {
          305  +  SELECT a FROM x1 WHERE b BETWEEN 1 AND 4 OR c BETWEEN 8 AND 12
          306  +} {1 9 search 6}
          307  +do_searchcount_test 6.4.2 {
          308  +  SELECT b, c FROM x1 WHERE b BETWEEN 1 AND 4 OR c BETWEEN 8 AND 12
          309  +} {2 3 10 11 search 5}
          310  +do_searchcount_test 6.4.3 {
          311  +  SELECT rowid, c FROM x1 WHERE b BETWEEN 1 AND 4 OR c BETWEEN 8 AND 12
          312  +} {1 3 3 11 search 4}
          313  +
          314  +do_searchcount_test 6.5.1 {
          315  +  SELECT a FROM x1 WHERE rowid = 2 OR c=11
          316  +} {5 9 search 3}
          317  +do_searchcount_test 6.5.2 {
          318  +  SELECT d FROM x1 WHERE rowid = 2 OR c=11
          319  +} {8 12 search 2}
          320  +do_searchcount_test 6.5.3 {
          321  +  SELECT d FROM x1 WHERE c=11 OR rowid = 2
          322  +} {12 8 search 2}
          323  +do_searchcount_test 6.5.4 {
          324  +  SELECT a FROM x1 WHERE c=11 OR rowid = 2 
          325  +} {9 5 search 3}
          326  +
          327  +do_searchcount_test 6.6.1 {
          328  +  SELECT rowid FROM x1 WHERE a=1 OR b=6 OR c=11
          329  +} {1 2 3 search 6}
          330  +do_searchcount_test 6.6.2 {
          331  +  SELECT c FROM x1 WHERE a=1 OR b=6 OR c=11
          332  +} {3 7 11 search 7}
          333  +do_searchcount_test 6.6.3 {
          334  +  SELECT c FROM x1 WHERE c=11 OR a=1 OR b=6 
          335  +} {11 3 7 search 7}
          336  +do_searchcount_test 6.6.4 {
          337  +  SELECT c FROM x1 WHERE b=6 OR c=11 OR a=1
          338  +} {7 11 3 search 7}
   303    339   
   304    340   finish_test