/ Check-in [f255ea6d]
Login

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

Overview
Comment:bug fix (CVS 142)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: f255ea6d4bb085a869485c14b4c96af13ca826fa
User & Date: drh 2000-08-22 18:29:34
Context
2000-08-22
18:30
Version 1.0.3 (CVS 497) check-in: d35a1f8b user: drh tags: trunk
18:29
bug fix (CVS 142) check-in: f255ea6d user: drh tags: trunk
13:47
:-) (CVS 141) check-in: 7ecc9c44 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to VERSION.

     1         -1.0.2
            1  +1.0.3

Changes to src/where.c.

    21     21   **   http://www.hwaci.com/drh/
    22     22   **
    23     23   *************************************************************************
    24     24   ** This module contains C code that generates VDBE code used to process
    25     25   ** the WHERE clause of SQL statements.  Also found here are subroutines
    26     26   ** to generate VDBE code to evaluate expressions.
    27     27   **
    28         -** $Id: where.c,v 1.8 2000/06/21 13:59:13 drh Exp $
           28  +** $Id: where.c,v 1.9 2000/08/22 18:29:34 drh Exp $
    29     29   */
    30     30   #include "sqliteInt.h"
    31     31   
    32     32   /*
    33     33   ** The query generator uses an array of instances of this structure to
    34     34   ** help it analyze the subexpressions of the WHERE clause.  Each WHERE
    35     35   ** clause subexpression is separated from the others by an AND operator.
................................................................................
   320    320         }
   321    321         sqliteVdbeAddOp(v, OP_MakeKey, pIdx->nColumn, 0, 0, 0);
   322    322         sqliteVdbeAddOp(v, OP_Fetch, base+pTabList->nId+i, 0, 0, 0);
   323    323         sqliteVdbeAddOp(v, OP_NextIdx, base+pTabList->nId+i, brk, 0, cont);
   324    324         if( i==pTabList->nId-1 && pushKey ){
   325    325           haveKey = 1;
   326    326         }else{
   327         -        sqliteVdbeAddOp(v, OP_Fetch, idx, 0, 0, 0);
          327  +        sqliteVdbeAddOp(v, OP_Fetch, base+idx, 0, 0, 0);
   328    328           haveKey = 0;
   329    329         }
   330    330       }
   331    331       loopMask |= 1<<idx;
   332    332   
   333    333       /* Insert code to test every subexpression that can be completely
   334    334       ** computed using the current set of tables.

Changes to www/changes.tcl.

    13     13   
    14     14   
    15     15   proc chng {date desc} {
    16     16     puts "<DT><B>$date</B></DT>"
    17     17     puts "<DD><P><UL>$desc</UL></P></DD>"
    18     18   }
    19     19   
    20         -chng {2000 Aug 22 (Version 1.0.2)} {
           20  +chng {2000 Aug 22 (Version 1.0.3)} {
    21     21   <li>In the sqlite shell, print the "Database opened READ ONLY" message
    22     22       to stderr instead of stdout.</li>
    23     23   <li>In the sqlite shell, now print the version number on initial startup.</li>
    24     24   <li>Add the <b>sqlite_version[]</b> string constant to the library</li>
           25  +<li>Makefile updates</li>
           26  +<li>Bug fix: incorrect VDBE code was being generated for the following
           27  +    circumstance: a query on an indexed table containing a WHERE clause with
           28  +    an IN operator that had a subquery on its right-hand side.</li>
    25     29   }
    26     30   
    27     31   chng {2000 Aug 18 (Version 1.0.1)} {
    28     32   <li>Fix a bug in the configure script.</li>
    29     33   <li>Minor revisions to the website.</li>
    30     34   }
    31     35