contrib/sqlite3/sqlite3.c

103870   char *zAff = 0;       /* Affinity string for comparisons */
103886   zAff = exprINAffinity(pParse, pExpr);
103978         sqlite3VdbeChangeP5(v, zAff[0]);
103986         sqlite3VdbeChangeP5(v, zAff[0] | SQLITE_JUMPIFNULL);
104028     sqlite3VdbeAddOp4(v, OP_Affinity, rLhs, nVector, 0, zAff, nVector);
104101   sqlite3DbFree(pParse->db, zAff);
104545           static const char zAff[] = "B\000C\000D\000E";
104549                             &zAff[(aff-'B')*2], P4_STATIC);
144225 ** Code an OP_Affinity opcode to apply the column affinity string zAff
144229 ** are no-ops) at the beginning and end of zAff are ignored.  If all entries
144230 ** in zAff are SQLITE_AFF_BLOB or SQLITE_AFF_NONE, then no code gets generated.
144232 ** This routine makes its own copy of zAff so that the caller is free
144233 ** to modify zAff after this routine returns.
144235 static void codeApplyAffinity(Parse *pParse, int base, int n, char *zAff){
144237   if( zAff==0 ){
144247   while( n>0 && zAff[0]<=SQLITE_AFF_BLOB ){
144250     zAff++;
144252   while( n>1 && zAff[n-1]<=SQLITE_AFF_BLOB ){
144258     sqlite3VdbeAddOp4(v, OP_Affinity, base, n, 0, zAff, n);
144265 ** Before the comparison operation, affinity zAff is to be applied
144270 **   * the affinity change in zAff is guaranteed not to change the value.
144275   char *zAff                      /* Affinity string to modify */
144280     if( sqlite3CompareAffinity(p, zAff[i])==SQLITE_AFF_BLOB
144281      || sqlite3ExprNeedsNoAffinityChange(p, zAff[i])
144283       zAff[i] = SQLITE_AFF_BLOB;
144597   char *zAff;                   /* Affinity string to return */
144613   zAff = sqlite3DbStrDup(pParse->db,sqlite3IndexAffinityStr(pParse->db,pIdx));
144614   assert( zAff!=0 || pParse->db->mallocFailed );
144637   assert( zAff==0 || (int)strlen(zAff)>=nEq );
144661         if( zAff ) zAff[j] = SQLITE_AFF_BLOB;
144669       if( zAff ){
144670         if( sqlite3CompareAffinity(pRight, zAff[j])==SQLITE_AFF_BLOB ){
144671           zAff[j] = SQLITE_AFF_BLOB;
144673         if( sqlite3ExprNeedsNoAffinityChange(pRight, zAff[j]) ){
144674           zAff[j] = SQLITE_AFF_BLOB;
144679   *pzAff = zAff;