/ Check-in [ecb1f2fd]
Login

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

Overview
Comment:Additional tests to give full coverage testing to ticket #2211. (CVS 3630)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ecb1f2fd7b96797459287eaab95693ae17ec2079
User & Date: drh 2007-02-06 23:41:34
Context
2007-02-07
01:01
http://www.sqlite.org/cvstrac/tktview?tn=2219

When creating fts tables in an attached database, the backing tables are created in database 'main'. This change propagates the appropriate database name to the routines which build sql statements.

Note that I propagate the database name and table name separately. I briefly considered just making the table name be "db.table", but it didn't fit so well in the model used to store the table name and other information, and having the db name passed separately seemed a bit more transparent. (CVS 3631) check-in: 283385d2 user: shess tags: trunk

2007-02-06
23:41
Additional tests to give full coverage testing to ticket #2211. (CVS 3630) check-in: ecb1f2fd user: drh tags: trunk
13:26
When optimizing out an ORDER BY clause due to uniqueness constraints, make sure unused terms to the right in the ORDER BY clause to not reference other tables in a join. Ticket #2211. Additional test cases needed before closing this ticket. (CVS 3629) check-in: 912faf18 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/where.test.

     7      7   #    May you find forgiveness for yourself and forgive others.
     8      8   #    May you share freely, never taking more than you give.
     9      9   #
    10     10   #***********************************************************************
    11     11   # This file implements regression tests for SQLite library.  The
    12     12   # focus of this file is testing the use of indices in WHERE clases.
    13     13   #
    14         -# $Id: where.test,v 1.40 2007/02/06 13:26:34 drh Exp $
           14  +# $Id: where.test,v 1.41 2007/02/06 23:41:34 drh Exp $
    15     15   
    16     16   set testdir [file dirname $argv0]
    17     17   source $testdir/tester.tcl
    18     18   
    19     19   # Build some test data
    20     20   #
    21     21   do_test where-1.0 {
................................................................................
  1079   1079     } 
  1080   1080   } {4/1 4/4 1/1 1/4 nosort}
  1081   1081   do_test where-14.7 {
  1082   1082     cksort {
  1083   1083       SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b
  1084   1084     } 
  1085   1085   } {4/1 4/4 1/1 1/4 sort}
         1086  +do_test where-14.7.1 {
         1087  +  cksort {
         1088  +    SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, y.a||y.b
         1089  +  } 
         1090  +} {4/1 4/4 1/1 1/4 sort}
         1091  +do_test where-14.7.2 {
         1092  +  cksort {
         1093  +    SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, x.a, x.a||x.b
         1094  +  } 
         1095  +} {4/1 4/4 1/1 1/4 nosort}
  1086   1096   do_test where-14.8 {
  1087   1097     cksort {
  1088   1098       SELECT x.a || '/' || y.a FROM t8 x, t8 y ORDER BY x.b, y.a||y.b DESC
  1089   1099     } 
  1090   1100   } {4/4 4/1 1/4 1/1 sort}
  1091   1101   do_test where-14.9 {
  1092   1102     cksort {