83   if( (p->flags & (MEM_Str|MEM_Blob))!=0 && p->n>sqlite3_max_blobsize ){  in updateMaxBlobsize()
230    if( ((P)->flags&MEM_Ephem)!=0 \
282   assert( pMem->flags==MEM_Undefined );  in allocateCursor()
283   assert( (pMem->flags & MEM_Dyn)==0 );  in allocateCursor()
345   assert( (pRec->flags & (MEM_Str|MEM_Int|MEM_Real|MEM_IntReal))==MEM_Str );  in applyNumericAffinity()
349     pRec->flags |= MEM_Int;  in applyNumericAffinity()
352     pRec->flags |= MEM_Real;  in applyNumericAffinity()
359   pRec->flags &= ~MEM_Str;  in applyNumericAffinity()
389     if( (pRec->flags & MEM_Int)==0 ){ /*OPTIMIZATION-IF-FALSE*/  in applyAffinity()
390       if( (pRec->flags & MEM_Real)==0 ){  in applyAffinity()
391         if( pRec->flags & MEM_Str ) applyNumericAffinity(pRec,1);  in applyAffinity()
402     if( 0==(pRec->flags&MEM_Str) ){ /*OPTIMIZATION-IF-FALSE*/  in applyAffinity()
403       if( (pRec->flags&(MEM_Real|MEM_Int|MEM_IntReal)) ){  in applyAffinity()
404         testcase( pRec->flags & MEM_Int );  in applyAffinity()
405         testcase( pRec->flags & MEM_Real );  in applyAffinity()
406         testcase( pRec->flags & MEM_IntReal );  in applyAffinity()
410     pRec->flags &= ~(MEM_Real|MEM_Int|MEM_IntReal);  in applyAffinity()
451   assert( (pMem->flags & (MEM_Int|MEM_Real|MEM_IntReal))==0 );  in computeNumericType()
452   assert( (pMem->flags & (MEM_Str|MEM_Blob))!=0 );  in computeNumericType()
480   assert( (pMem->flags & MEM_Null)==0  in numericType()
482   if( pMem->flags & (MEM_Int|MEM_Real|MEM_IntReal|MEM_Null) ){  in numericType()
483     testcase( pMem->flags & MEM_Int );  in numericType()
484     testcase( pMem->flags & MEM_Real );  in numericType()
485     testcase( pMem->flags & MEM_IntReal );  in numericType()
486     return pMem->flags & (MEM_Int|MEM_Real|MEM_IntReal|MEM_Null);  in numericType()
488   assert( pMem->flags & (MEM_Str|MEM_Blob) );  in numericType()
489   testcase( pMem->flags & MEM_Str );  in numericType()
490   testcase( pMem->flags & MEM_Blob );  in numericType()
501   int f = pMem->flags;  in sqlite3VdbeMemPrettyPrint()
561   if( p->flags & MEM_Undefined ){  in memTracePrint()
563   }else if( p->flags & MEM_Null ){  in memTracePrint()
564     printf(p->flags & MEM_Zero ? " NULL-nochng" : " NULL");  in memTracePrint()
565   }else if( (p->flags & (MEM_Int|MEM_Str))==(MEM_Int|MEM_Str) ){  in memTracePrint()
567   }else if( (p->flags & (MEM_IntReal))!=0 ){  in memTracePrint()
569   }else if( p->flags & MEM_Int ){  in memTracePrint()
572   }else if( p->flags & MEM_Real ){  in memTracePrint()
584   if( p->flags & MEM_Subtype ) printf(" subtype=0x%02x", p->eSubtype);  in memTracePrint()
615 #  define REGISTER_TRACE(R,M) if(db->flags&SQLITE_VdbeTrace)registerTrace(R,M)
657   pOut->flags = MEM_Int;  in out2PrereleaseWithClear()
669     pOut->flags = MEM_Int;  in out2Prerelease()
685     if( p->flags & (MEM_Int|MEM_IntReal) ){  in filterHash()
687     }else if( p->flags & MEM_Real ){  in filterHash()
689     }else if( p->flags & (MEM_Str|MEM_Blob) ){  in filterHash()
691       if( p->flags & MEM_Zero ) h += p->u.nZero;  in filterHash()
774    && (p->db->flags & (SQLITE_VdbeListing|SQLITE_VdbeEQP|SQLITE_VdbeTrace))!=0  in sqlite3VdbeExec()
779     if( p->db->flags & SQLITE_VdbeListing ){  in sqlite3VdbeExec()
785     if( p->db->flags & SQLITE_VdbeEQP ){  in sqlite3VdbeExec()
794     if( p->db->flags & SQLITE_VdbeTrace )  printf("VDBE Trace:\n");  in sqlite3VdbeExec()
815     if( db->flags & SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
985   pIn1->flags = MEM_Int;  in sqlite3VdbeExec()
1015   if( pIn1->flags & MEM_Int ){  in sqlite3VdbeExec()
1042   pOut->flags = MEM_Int;  in sqlite3VdbeExec()
1065   assert( pIn1->flags==MEM_Int );  in sqlite3VdbeExec()
1071   pIn1->flags = MEM_Undefined;  in sqlite3VdbeExec()
1092   pIn1->flags = MEM_Int;  in sqlite3VdbeExec()
1113   if( (pIn3->flags & MEM_Null)==0 ) break;  in sqlite3VdbeExec()
1241   pOut->flags = MEM_Real;  in sqlite3VdbeExec()
1270     pOut->flags |= MEM_Static;  in sqlite3VdbeExec()
1303   pOut->flags = MEM_Str|MEM_Static|MEM_Term;  in sqlite3VdbeExec()
1312     assert( pIn3->flags & MEM_Int );  in sqlite3VdbeExec()
1313     if( pIn3->u.i==pOp->p5 ) pOut->flags = MEM_Blob|MEM_Static|MEM_Term;  in sqlite3VdbeExec()
1360   pOut->flags = nullFlag = pOp->p1 ? (MEM_Null|MEM_Cleared) : MEM_Null;  in sqlite3VdbeExec()
1369     pOut->flags = nullFlag;  in sqlite3VdbeExec()
1387   pOut->flags = (pOut->flags&~(MEM_Undefined|MEM_AffMask))|MEM_Null;  in sqlite3VdbeExec()
1432   pOut->flags &= ~(MEM_Dyn|MEM_Ephem);  in sqlite3VdbeExec()
1433   pOut->flags |= MEM_Static|MEM_FromBind;  in sqlite3VdbeExec()
1508     if( (pOut->flags & MEM_Subtype)!=0 &&  (pOp->p5 & 0x0002)!=0 ){  in sqlite3VdbeExec()
1509       pOut->flags &= ~MEM_Subtype;  in sqlite3VdbeExec()
1542   pOut->mScopyFlags = pIn1->flags;  in sqlite3VdbeExec()
1557   assert( (pIn1->flags & MEM_Int)!=0 );  in sqlite3VdbeExec()
1645   flags1 = pIn1->flags;  in sqlite3VdbeExec()
1647   testcase( pIn2->flags & MEM_Null );  in sqlite3VdbeExec()
1648   if( (flags1 | pIn2->flags) & MEM_Null ){  in sqlite3VdbeExec()
1654     flags1 = pIn1->flags & ~MEM_Str;  in sqlite3VdbeExec()
1657     flags1 = pIn1->flags & ~MEM_Str;  in sqlite3VdbeExec()
1659   flags2 = pIn2->flags;  in sqlite3VdbeExec()
1662     flags2 = pIn2->flags & ~MEM_Str;  in sqlite3VdbeExec()
1665     flags2 = pIn2->flags & ~MEM_Str;  in sqlite3VdbeExec()
1677     assert( (pIn2->flags & MEM_Dyn) == (flags2 & MEM_Dyn) );  in sqlite3VdbeExec()
1678     pIn2->flags = flags2;  in sqlite3VdbeExec()
1681   assert( (pIn1->flags & MEM_Dyn) == (flags1 & MEM_Dyn) );  in sqlite3VdbeExec()
1682   pIn1->flags = flags1;  in sqlite3VdbeExec()
1686   pOut->flags |= MEM_Term;  in sqlite3VdbeExec()
1744   type1 = pIn1->flags;  in sqlite3VdbeExec()
1746   type2 = pIn2->flags;  in sqlite3VdbeExec()
1882   if( (pIn1->flags | pIn2->flags) & MEM_Null ){  in sqlite3VdbeExec()
1947   if( (pIn1->flags & MEM_Int)==0 ){  in sqlite3VdbeExec()
1949     if( (pIn1->flags & MEM_Int)==0 ){  in sqlite3VdbeExec()
1976   if( pIn1->flags & (MEM_Int|MEM_IntReal) ){  in sqlite3VdbeExec()
1977     testcase( pIn1->flags & MEM_Int );  in sqlite3VdbeExec()
1978     testcase( pIn1->flags & MEM_IntReal );  in sqlite3VdbeExec()
2126   flags1 = pIn1->flags;  in sqlite3VdbeExec()
2127   flags3 = pIn3->flags;  in sqlite3VdbeExec()
2190           testcase( flags3==pIn3->flags );  in sqlite3VdbeExec()
2191           flags3 = pIn3->flags;  in sqlite3VdbeExec()
2199         testcase( pIn1->flags & MEM_Int );  in sqlite3VdbeExec()
2200         testcase( pIn1->flags & MEM_Real );  in sqlite3VdbeExec()
2201         testcase( pIn1->flags & MEM_IntReal );  in sqlite3VdbeExec()
2203         testcase( (flags1&MEM_Dyn) != (pIn1->flags&MEM_Dyn) );  in sqlite3VdbeExec()
2204         flags1 = (pIn1->flags & ~MEM_TypeMask) | (flags1 & MEM_TypeMask);  in sqlite3VdbeExec()
2208         testcase( pIn3->flags & MEM_Int );  in sqlite3VdbeExec()
2209         testcase( pIn3->flags & MEM_Real );  in sqlite3VdbeExec()
2210         testcase( pIn3->flags & MEM_IntReal );  in sqlite3VdbeExec()
2212         testcase( (flags3&MEM_Dyn) != (pIn3->flags&MEM_Dyn) );  in sqlite3VdbeExec()
2213         flags3 = (pIn3->flags & ~MEM_TypeMask) | (flags3 & MEM_TypeMask);  in sqlite3VdbeExec()
2238   assert( (pIn3->flags & MEM_Dyn) == (flags3 & MEM_Dyn) );  in sqlite3VdbeExec()
2239   pIn3->flags = flags3;  in sqlite3VdbeExec()
2240   assert( (pIn1->flags & MEM_Dyn) == (flags1 & MEM_Dyn) );  in sqlite3VdbeExec()
2241   pIn1->flags = flags1;  in sqlite3VdbeExec()
2370        && ((aMem[p1+idx].flags & MEM_Null) || (aMem[p2+idx].flags & MEM_Null))  in sqlite3VdbeExec()
2485   if( (pIn1->flags & MEM_Null)==0 ){  in sqlite3VdbeExec()
2504   if( (pIn1->flags & MEM_Null)==0 ){  in sqlite3VdbeExec()
2505     pOut->flags = MEM_Int;  in sqlite3VdbeExec()
2584   VdbeBranchTaken( (pIn1->flags & MEM_Null)!=0, 2);  in sqlite3VdbeExec()
2585   if( (pIn1->flags & MEM_Null)!=0 ){  in sqlite3VdbeExec()
2686   if( (aMem[pOp->p1].flags & MEM_Null)!=0  in sqlite3VdbeExec()
2687    || (aMem[pOp->p3].flags & MEM_Null)!=0  in sqlite3VdbeExec()
2703   VdbeBranchTaken( (pIn1->flags & MEM_Null)==0, 2);  in sqlite3VdbeExec()
2704   if( (pIn1->flags & MEM_Null)==0 ){  in sqlite3VdbeExec()
2828         assert( pReg->flags & MEM_Blob );  in sqlite3VdbeExec()
3024         pDest->flags = MEM_Null;  in sqlite3VdbeExec()
3032       pDest->flags = aFlag[t&1];  in sqlite3VdbeExec()
3060       pDest->flags &= ~MEM_Ephem;  in sqlite3VdbeExec()
3123     if( (pIn1->flags & MEM_Null)==0 ){  in sqlite3VdbeExec()
3126           if( (pIn1->flags & MEM_Blob)==0 ) goto vdbe_type_error;  in sqlite3VdbeExec()
3131           if( (pIn1->flags & MEM_Int)==0 ) goto vdbe_type_error;  in sqlite3VdbeExec()
3135           if( (pIn1->flags & MEM_Str)==0 ) goto vdbe_type_error;  in sqlite3VdbeExec()
3139           testcase( (pIn1->flags & (MEM_Real|MEM_IntReal))==MEM_Real );  in sqlite3VdbeExec()
3140           testcase( (pIn1->flags & (MEM_Real|MEM_IntReal))==MEM_IntReal );  in sqlite3VdbeExec()
3141           if( pIn1->flags & MEM_Int ){  in sqlite3VdbeExec()
3151               pIn1->flags |= MEM_IntReal;  in sqlite3VdbeExec()
3152               pIn1->flags &= ~MEM_Int;  in sqlite3VdbeExec()
3155               pIn1->flags |= MEM_Real;  in sqlite3VdbeExec()
3156               pIn1->flags &= ~MEM_Int;  in sqlite3VdbeExec()
3158           }else if( (pIn1->flags & (MEM_Real|MEM_IntReal))==0 ){  in sqlite3VdbeExec()
3204     if( zAffinity[0]==SQLITE_AFF_REAL && (pIn1->flags & MEM_Int)!=0 ){  in sqlite3VdbeExec()
3214         pIn1->flags |= MEM_IntReal;  in sqlite3VdbeExec()
3215         pIn1->flags &= ~MEM_Int;  in sqlite3VdbeExec()
3218         pIn1->flags |= MEM_Real;  in sqlite3VdbeExec()
3219         pIn1->flags &= ~MEM_Int;  in sqlite3VdbeExec()
3310       if( zAffinity[0]==SQLITE_AFF_REAL && (pRec->flags & MEM_Int) ){  in sqlite3VdbeExec()
3311         pRec->flags |= MEM_IntReal;  in sqlite3VdbeExec()
3312         pRec->flags &= ~(MEM_Int);  in sqlite3VdbeExec()
3328     while( (pLast->flags & MEM_Null)!=0 && nField>pOp->p5 ){  in sqlite3VdbeExec()
3364     if( pRec->flags & MEM_Null ){  in sqlite3VdbeExec()
3365       if( pRec->flags & MEM_Zero ){  in sqlite3VdbeExec()
3380     }else if( pRec->flags & (MEM_Int|MEM_IntReal) ){  in sqlite3VdbeExec()
3384       testcase( pRec->flags & MEM_Int );  in sqlite3VdbeExec()
3385       testcase( pRec->flags & MEM_IntReal );  in sqlite3VdbeExec()
3418         if( pRec->flags & MEM_IntReal ){  in sqlite3VdbeExec()
3423           pRec->flags &= ~MEM_IntReal;  in sqlite3VdbeExec()
3424           pRec->flags |= MEM_Real;  in sqlite3VdbeExec()
3430     }else if( pRec->flags & MEM_Real ){  in sqlite3VdbeExec()
3435       assert( db->mallocFailed || pRec->flags&(MEM_Str|MEM_Blob) );  in sqlite3VdbeExec()
3438       serial_type = (len*2) + 12 + ((pRec->flags & MEM_Str)!=0);  in sqlite3VdbeExec()
3439       if( pRec->flags & MEM_Zero ){  in sqlite3VdbeExec()
3493   pOut->flags = MEM_Blob;  in sqlite3VdbeExec()
3496     pOut->flags |= MEM_Zero;  in sqlite3VdbeExec()
3891   if( pOp->p2 && (db->flags & (SQLITE_QueryOnly|SQLITE_CorruptRdOnly))!=0 ){  in sqlite3VdbeExec()
3892     if( db->flags & SQLITE_QueryOnly ){  in sqlite3VdbeExec()
4202     assert( (pIn2->flags & MEM_Int)!=0 );  in sqlite3VdbeExec()
4338     assert( aMem[pOp->p3].flags & MEM_Null );  in sqlite3VdbeExec()
4637     flags3 = pIn3->flags;  in sqlite3VdbeExec()
4642     newType = pIn3->flags; /* Record the type after applying numeric affinity */  in sqlite3VdbeExec()
4643     pIn3->flags = flags3;  /* But convert the type back to its original */  in sqlite3VdbeExec()
4900      if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
4929       if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
4940       if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
4950       if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
4995     if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
5002     if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
5125   if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
5165       assert( (r.aMem[ii].flags & MEM_Zero)==0 || r.aMem[ii].n==0 );  in sqlite3VdbeExec()
5172     assert( r.aMem->flags & MEM_Blob );  in sqlite3VdbeExec()
5204         if( r.aMem[ii].flags & MEM_Null ){  in sqlite3VdbeExec()
5272   testcase( pIn3->flags & MEM_Int );  in sqlite3VdbeExec()
5273   testcase( pIn3->flags & MEM_IntReal );  in sqlite3VdbeExec()
5274   testcase( pIn3->flags & MEM_Real );  in sqlite3VdbeExec()
5275   testcase( (pIn3->flags & (MEM_Str|MEM_Int))==MEM_Str );  in sqlite3VdbeExec()
5276   if( (pIn3->flags & (MEM_Int|MEM_IntReal))==0 ){  in sqlite3VdbeExec()
5284     if( (x.flags & MEM_Int)==0 ) goto jump_to_p2;  in sqlite3VdbeExec()
5292   assert( (pIn3->flags & MEM_Int)!=0 || pOp->opcode==OP_SeekRowid );  in sqlite3VdbeExec()
5441       assert( (pMem->flags & MEM_Int)!=0 );  /* mem(P3) holds an integer */  in sqlite3VdbeExec()
5541   assert( pKey->flags & MEM_Int );  in sqlite3VdbeExec()
5572   assert( (pData->flags & (MEM_Blob|MEM_Str))!=0 || pData->n==0 );  in sqlite3VdbeExec()
5576   if( pData->flags & MEM_Zero ){  in sqlite3VdbeExec()
5716          || (aMem[pOp->p3].flags & MEM_Int)   in sqlite3VdbeExec()
5828   assert( rc!=SQLITE_OK || (pOut->flags & MEM_Blob) );  in sqlite3VdbeExec()
5925     pOut->flags = MEM_Null;  in sqlite3VdbeExec()
5945       pOut->flags = MEM_Null;  in sqlite3VdbeExec()
6297   assert( (pIn2->flags & MEM_Blob) || (pOp->p5 & OPFLAG_PREFORMAT) );  in sqlite3VdbeExec()
6333   assert( pIn2->flags & MEM_Blob );  in sqlite3VdbeExec()
6647   pOut->flags = MEM_Null;  in sqlite3VdbeExec()
6657     pOut->flags = MEM_Int;  in sqlite3VdbeExec()
6804            || (CORRUPT_DB && (db->flags & SQLITE_NoSchemaError)!=0) );  in sqlite3VdbeExec()
6947   assert( (pnErr->flags & MEM_Int)!=0 );  in sqlite3VdbeExec()
6948   assert( (pnErr->flags & (MEM_Str|MEM_Blob))==0 );  in sqlite3VdbeExec()
6980   assert( (pIn2->flags & MEM_Int)!=0 );  in sqlite3VdbeExec()
6981   if( (pIn1->flags & MEM_Blob)==0 ){  in sqlite3VdbeExec()
7001   assert( (pIn1->flags & MEM_Blob)==0 || sqlite3VdbeMemIsRowSet(pIn1) );  in sqlite3VdbeExec()
7002   if( (pIn1->flags & MEM_Blob)==0   in sqlite3VdbeExec()
7047   assert( pIn3->flags&MEM_Int );  in sqlite3VdbeExec()
7052   if( (pIn1->flags & MEM_Blob)==0 ){  in sqlite3VdbeExec()
7128   if( (pRt->flags&MEM_Blob)==0 ){  in sqlite3VdbeExec()
7146     pRt->flags = MEM_Blob|MEM_Dyn;  in sqlite3VdbeExec()
7171       pMem->flags = MEM_Undefined;  in sqlite3VdbeExec()
7253   if( db->flags & SQLITE_DeferFKs ){  in sqlite3VdbeExec()
7330   assert( pIn1->flags&MEM_Int );  in sqlite3VdbeExec()
7362   assert( pIn1->flags & MEM_Int );  in sqlite3VdbeExec()
7363   assert( pIn3->flags & MEM_Int );  in sqlite3VdbeExec()
7390   assert( pIn1->flags&MEM_Int );  in sqlite3VdbeExec()
7407   assert( pIn1->flags&MEM_Int );  in sqlite3VdbeExec()
7524   assert( pCtx->pOut->flags==MEM_Null );  in sqlite3VdbeExec()
7546     pCtx->pOut->flags = MEM_Null;  in sqlite3VdbeExec()
7550   assert( pCtx->pOut->flags==MEM_Null );  in sqlite3VdbeExec()
7587   assert( (pMem->flags & ~(MEM_Null|MEM_Agg))==0 );  in sqlite3VdbeExec()
7742   pOut->flags = MEM_Str|MEM_Static|MEM_Term;  in sqlite3VdbeExec()
7870   if( isWriteLock || 0==(db->flags&SQLITE_ReadUncommit) ){  in sqlite3VdbeExec()
7922   assert( (aMem[pOp->p2].flags & MEM_Str)!=0 );  in sqlite3VdbeExec()
7923   assert( (aMem[pOp->p2].flags & MEM_Static)!=0 );  in sqlite3VdbeExec()
8017   pOut->flags = MEM_Null;  in sqlite3VdbeExec()
8069   assert( (pQuery->flags&MEM_Int)!=0 && pArgc->flags==MEM_Int );  in sqlite3VdbeExec()
8129     pDest->flags = MEM_Null|MEM_Zero;  in sqlite3VdbeExec()
8203   isLegacy = (db->flags & SQLITE_LegacyAlter);  in sqlite3VdbeExec()
8204   db->flags |= SQLITE_LegacyAlter;  in sqlite3VdbeExec()
8211   assert( pName->flags & MEM_Str );  in sqlite3VdbeExec()
8218   if( isLegacy==0 ) db->flags &= ~(u64)SQLITE_LegacyAlter;  in sqlite3VdbeExec()
8292       assert( nArg>1 && apArg[0] && (apArg[0]->flags&MEM_Null) );  in sqlite3VdbeExec()
8437   assert( (pOut->flags&MEM_Str)==0   in sqlite3VdbeExec()
8454   pIn1->flags &= ~MEM_Subtype;  in sqlite3VdbeExec()
8469   assert( pIn1->flags & MEM_Blob );  in sqlite3VdbeExec()
8473   if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
8505   assert( (pIn1->flags & MEM_Blob)!=0 );  in sqlite3VdbeExec()
8509   if( db->flags&SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
8606   if( (db->flags & SQLITE_SqlTrace)!=0  in sqlite3VdbeExec()
8756     if( db->flags & SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
8787   if( db->flags & SQLITE_VdbeTrace ){  in sqlite3VdbeExec()
8809     db->flags |= SQLITE_CorruptRdOnly;  in sqlite3VdbeExec()