SQLite
Check-in [b3f53668]
Not logged in
Overview
SHA1 Hash:b3f53668115f0a12a01167c2a75eecc735416024
Date: 2012-12-08 14:16:47
User: drh
Comment:Make sure WHERE clause constraints A=B and B=A work the same even with COLLATE clauses.
Tags And Properties
Context
2012-12-08
21:36
[cdbfa664] Closed-Leaf: Adjustments to the collating-sequence refactoring to facilitate full-coverage testing and to fix some minor issues found by TH3. (user: drh, tags: ticket-71e333e7)
14:16
[b3f53668] Make sure WHERE clause constraints A=B and B=A work the same even with COLLATE clauses. (user: drh, tags: ticket-71e333e7)
13:26
[2722f407] Fix the header comment on the OP_Compare operator. (user: drh, tags: ticket-71e333e7)
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/where.c.

1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
        pTerm->nChild = 1;
        pTerm->wtFlags |= TERM_COPIED;
      }else{
        pDup = pExpr;
        pNew = pTerm;
      }
      exprCommute(pParse, pDup);
      pLeft = pDup->pLeft;
      pNew->leftCursor = pLeft->iTable;
      pNew->u.leftColumn = pLeft->iColumn;
      testcase( (prereqLeft | extraRight) != prereqLeft );
      pNew->prereqRight = prereqLeft | extraRight;
      pNew->prereqAll = prereqAll;
      pNew->eOperator = operatorMask(pDup->op);
    }







|







1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
        pTerm->nChild = 1;
        pTerm->wtFlags |= TERM_COPIED;
      }else{
        pDup = pExpr;
        pNew = pTerm;
      }
      exprCommute(pParse, pDup);
      pLeft = sqlite3ExprSkipCollate(pDup->pLeft);
      pNew->leftCursor = pLeft->iTable;
      pNew->u.leftColumn = pLeft->iColumn;
      testcase( (prereqLeft | extraRight) != prereqLeft );
      pNew->prereqRight = prereqLeft | extraRight;
      pNew->prereqAll = prereqAll;
      pNew->eOperator = operatorMask(pDup->op);
    }