diff options
| author | dan <dan@noemail.net> | 2019-08-20 11:43:44 +0000 |
|---|---|---|
| committer | dan <dan@noemail.net> | 2019-08-20 11:43:44 +0000 |
| commit | b6ce71bd265314f65ad95ecdb2735af54121a4dd (patch) | |
| tree | 35668a8bb863766d78c5473a89dfe42e04bab132 /src | |
| parent | 3722b3abf1da4e9bde859df68e679e00c6829f41 (diff) | |
| download | sqlite-b6ce71bd265314f65ad95ecdb2735af54121a4dd.tar.gz sqlite-b6ce71bd265314f65ad95ecdb2735af54121a4dd.zip | |
Retain the affinity of an expression in a WHERE clause when it is transformed to a reference to an index column on the same expression. Fix for [f043b113].
FossilOrigin-Name: 511da0815673ca4a176aa61dc23a8231b2ab77e8363fc184a78b6e17dba64d49
Diffstat (limited to 'src')
| -rw-r--r-- | src/wherecode.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/wherecode.c b/src/wherecode.c index c781b06c1..934e3e2e8 100644 --- a/src/wherecode.c +++ b/src/wherecode.c @@ -1117,6 +1117,7 @@ typedef struct IdxExprTrans { static int whereIndexExprTransNode(Walker *p, Expr *pExpr){ IdxExprTrans *pX = p->u.pIdxTrans; if( sqlite3ExprCompare(0, pExpr, pX->pIdxExpr, pX->iTabCur)==0 ){ + pExpr->affExpr = sqlite3ExprAffinity(pExpr); pExpr->op = TK_COLUMN; pExpr->iTable = pX->iIdxCur; pExpr->iColumn = pX->iIdxCol; |