commit 04e9eeadc63bb651a658150e0529cd3463914690
author drh <drh@noemail.net> Wed Jun 01 19:16:06 2011 +0000
committer drh <drh@noemail.net> Wed Jun 01 19:16:06 2011 +0000
tree f076df8e0addbb0377e0bac9e00352e9a67a6752
parent 124c0b49a19ce24302c6594e60c80c7ba4df6c98

Avoid unnecessary duplication of SQL parameter names.

FossilOrigin-Name: e704e8690ae35decc9769a45cf8d519ccad8b79d

src/expr.c

diff --git a/src/expr.c b/src/expr.c
index 4cd2f24..be2f4d7 100644
--- a/src/expr.c
+++ b/src/expr.c
@@ -2345,7 +2345,9 @@
       assert( pExpr->u.zToken[0]!=0 );
       sqlite3VdbeAddOp2(v, OP_Variable, pExpr->iColumn, target);
       if( pExpr->u.zToken[1]!=0 ){
-        sqlite3VdbeChangeP4(v, -1, pExpr->u.zToken, P4_TRANSIENT);
+        assert( pExpr->u.zToken[0]=='?' 
+             || strcmp(pExpr->u.zToken, pParse->azVar[pExpr->iColumn-1])==0 );
+        sqlite3VdbeChangeP4(v, -1, pParse->azVar[pExpr->iColumn-1], P4_STATIC);
       }
       break;
     }