aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2012-12-08 14:16:47 +0000
committerdrh <drh@noemail.net>2012-12-08 14:16:47 +0000
commitfb76f5a00c07b97d715816587e685dd0bd39c6f3 (patch)
tree4dcfdbc54b2aa26b146597cbe96958623d0d8c06 /src
parent0ca10dfbed25fd2dd3af1820b6d298724064b55b (diff)
downloadsqlite-fb76f5a00c07b97d715816587e685dd0bd39c6f3.tar.gz
sqlite-fb76f5a00c07b97d715816587e685dd0bd39c6f3.zip
Make sure WHERE clause constraints A=B and B=A work the same even with
COLLATE clauses. FossilOrigin-Name: b3f53668115f0a12a01167c2a75eecc735416024
Diffstat (limited to 'src')
-rw-r--r--src/where.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/where.c b/src/where.c
index 9d5cfbe4f..49c3ab95c 100644
--- a/src/where.c
+++ b/src/where.c
@@ -1244,7 +1244,7 @@ static void exprAnalyze(
pNew = pTerm;
}
exprCommute(pParse, pDup);
- pLeft = pDup->pLeft;
+ pLeft = sqlite3ExprSkipCollate(pDup->pLeft);
pNew->leftCursor = pLeft->iTable;
pNew->u.leftColumn = pLeft->iColumn;
testcase( (prereqLeft | extraRight) != prereqLeft );