/ Check-in [eae6dfbe]
Login

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

Overview
Comment:One possible fix for the [e39d032577d] problem it to replace the failing assert() with a testcase() as shown here.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | tkt-e39d0325
Files: files | file ages | folders
SHA1: eae6dfbe5535f4818b73806b13308b99dedb9f22
User & Date: drh 2014-03-20 12:36:39
Context
2014-03-20
12:36
One possible fix for the [e39d032577d] problem it to replace the failing assert() with a testcase() as shown here. Closed-Leaf check-in: eae6dfbe user: drh tags: tkt-e39d0325
12:17
Fix an unnecessarily obtuse use of a bitmask flag. check-in: ca314081 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Show Whitespace Changes Patch

Changes to src/where.c.

  4015   4015       }else if( pTerm->eOperator & (WO_EQ) ){
  4016   4016         assert(
  4017   4017           (pNew->wsFlags & (WHERE_COLUMN_NULL|WHERE_COLUMN_IN|WHERE_SKIPSCAN))!=0
  4018   4018           || nInMul==0
  4019   4019         );
  4020   4020         pNew->wsFlags |= WHERE_COLUMN_EQ;
  4021   4021         if( iCol<0 || (nInMul==0 && pNew->u.btree.nEq==pProbe->nKeyCol-1)){
  4022         -        assert( (pNew->wsFlags & WHERE_COLUMN_IN)==0 || iCol<0 );
         4022  +        /* Ticket [e39d032577df]: WHERE a=? AND b IN (?) -- a, b indexed */
         4023  +        testcase( (pNew->wsFlags & WHERE_COLUMN_IN)!=0 && iCol>=0 );
  4023   4024           if( iCol>=0 && pProbe->onError==OE_None ){
  4024   4025             pNew->wsFlags |= WHERE_UNQ_WANTED;
  4025   4026           }else{
  4026   4027             pNew->wsFlags |= WHERE_ONEROW;
  4027   4028           }
  4028   4029         }
  4029   4030         pNew->u.btree.nEq++;