Lines Matching defs:affinity
4481 ** numeric affinity to the value. This means that an attempt is
10015 char affinity; /* One of the SQLITE_AFF_... values */
10057 ** Column affinity types.
10064 ** when multiple affinity types are concatenated into a string and
10080 ** affinity value.
10085 ** Additional bit values that can be ORed with an affinity without
10086 ** changing the affinity.
10187 char *zColAff; /* String defining the affinity of each column */
10376 char *zColAff; /* String defining the affinity of each column */
10548 char affinity; /* The affinity of the column or 0 if not a column */
10946 char affinity; /* MakeRecord with this affinity for SRT_Set */
11003 u8 affinity; /* Affinity used when eDest==SRT_Set */
22547 /* 30 */ "Affinity",
59370 u8 affinity, /* Affinity to use */
59417 if( (op==TK_INTEGER || op==TK_FLOAT ) && affinity==SQLITE_AFF_NONE ){
59420 sqlite3ValueApplyAffinity(pVal, affinity, SQLITE_UTF8);
59428 if( SQLITE_OK==sqlite3ValueFromExpr(db,pExpr->pLeft,enc,affinity,&pVal) ){
59438 sqlite3ValueApplyAffinity(pVal, affinity, enc);
62712 ** 0 instead. Unless it is NULL, apply affinity aff (one of the SQLITE_AFF_*
64603 ** Processing is determine by the affinity parameter:
64611 ** always preferred, even if the affinity is REAL, because
64621 Mem *pRec, /* The value to apply affinity to */
64622 char affinity, /* The affinity to be applied */
64625 if( affinity==SQLITE_AFF_TEXT ){
64634 }else if( affinity!=SQLITE_AFF_NONE ){
64635 assert( affinity==SQLITE_AFF_INTEGER || affinity==SQLITE_AFF_REAL
64636 || affinity==SQLITE_AFF_NUMERIC );
64665 u8 affinity,
64668 applyAffinity((Mem *)pVal, affinity, enc);
65049 char affinity; /* Affinity to use for comparison */
65096 const char *zAffinity; /* The affinity to be applied */
65097 char cAff; /* A single character of affinity */
65111 char *zAffinity; /* The affinity string for the record */
66460 ** has REAL affinity. Such column values may still be stored as
66583 ** The SQLITE_AFF_MASK portion of P5 must be an affinity character -
66585 ** to coerce both inputs according to this affinity before the
66587 ** affinity is used. Note that the affinity conversions are stored
66654 char affinity; /* Affinity to use for comparison */
66688 u.aj.affinity = pOp->p5 & SQLITE_AFF_MASK;
66689 if( u.aj.affinity ){
66690 applyAffinity(pIn1, u.aj.affinity, encoding);
66691 applyAffinity(pIn3, u.aj.affinity, encoding);
67296 /* Opcode: Affinity P1 P2 * P4 *
67301 ** string indicates the column affinity that should be used for the nth
67306 const char *zAffinity; /* The affinity to be applied */
67307 char cAff; /* A single character of affinity */
67331 ** string indicates the column affinity that should be used for the nth
67334 ** The mapping from character to affinity is given by the SQLITE_AFF_
67337 ** If P4 is NULL then all index fields have the affinity NONE.
67352 char *zAffinity; /* The affinity string for the record */
73432 pExpr->affinity = SQLITE_AFF_INTEGER;
73456 pExpr->affinity = SQLITE_AFF_INTEGER;
73646 pExpr->affinity = SQLITE_AFF_INTEGER;
73744 /* FIX ME: Compute pExpr->affinity based on the expected return
74409 ** Return the 'affinity' of the expression pExpr if any.
74413 ** affinity of that column is returned. Otherwise, 0x00 is returned,
74414 ** indicating no affinity for the expression.
74417 ** have an affinity:
74444 return pExpr->pTab->aCol[j].affinity;
74446 return pExpr->affinity;
74519 ** type affinity of the other operand. This routine returns the
74520 ** type affinity that should be used for the comparison operator.
74526 ** affinity, use that. Otherwise use no affinity.
74539 /* One side is a column, the other is not. Use the columns affinity. */
74546 ** pExpr is a comparison operator. Return the type affinity that should
74568 ** idx_affinity is the affinity of an indexed column. Return true
74569 ** if the index with affinity idx_affinity may be used to implement
75680 ** unchanged by OP_Affinity with the affinity given in the second
75891 /* Check that the affinity that will be used to perform the
75892 ** comparison is the same as the affinity of the column. If
75896 int affinity_ok = (pTab->aCol[iCol].affinity==aff||aff==SQLITE_AFF_NONE);
76022 char affinity; /* Affinity of the LHS of the IN */
76031 affinity = sqlite3ExprAffinity(pLeft);
76039 ** statement returns a column value, then the affinity of that
76041 ** SELECT... statement are columns, then numeric affinity is used
76042 ** if either column has NUMERIC or INTEGER affinity. If neither
76043 ** 'x' nor the SELECT... statement are columns, then numeric affinity
76063 dest.affinity = (u8)affinity;
76079 ** that columns affinity when building index keys. If <expr> is not
76080 ** a column, use numeric affinity.
76087 if( !affinity ){
76088 affinity = SQLITE_AFF_NONE;
76120 sqlite3VdbeAddOp4(v, OP_MakeRecord, r3, 1, r2, &affinity, 1);
76210 char affinity; /* Comparison affinity to use */
76223 /* Figure out the affinity to use to create a key from the results
76227 affinity = comparisonAffinity(pExpr);
76257 sqlite3VdbeAddOp4(v, OP_Affinity, r1, 1, 0, &affinity, 1);
76604 ** Record the fact that an affinity change has occurred on iCount
77138 /* If the column has REAL affinity, it may currently be stored as an
77141 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
77239 assert( pExpr->affinity==OE_Rollback
77240 || pExpr->affinity==OE_Abort
77241 || pExpr->affinity==OE_Fail
77242 || pExpr->affinity==OE_Ignore
77249 if( pExpr->affinity==OE_Abort ){
77253 if( pExpr->affinity==OE_Ignore ){
77257 sqlite3HaltConstraint(pParse, pExpr->affinity, pExpr->u.zToken, 0);
77551 switch( pExpr->affinity ){
82175 /* If there is no type specified, columns have the default affinity
82177 ** be called next to set pCol->affinity correctly.
82179 pCol->affinity = SQLITE_AFF_NONE;
82198 ** associated affinity type.
82202 ** found, the corresponding affinity is returned. If zType contains
82207 ** Substring | Affinity
82275 pCol->affinity = sqlite3AffinityType(pCol->zType);
82611 assert( pCol->affinity-SQLITE_AFF_TEXT >= 0 );
82612 assert( pCol->affinity-SQLITE_AFF_TEXT < ArraySize(azType) );
82613 testcase( pCol->affinity==SQLITE_AFF_TEXT );
82614 testcase( pCol->affinity==SQLITE_AFF_NONE );
82615 testcase( pCol->affinity==SQLITE_AFF_NUMERIC );
82616 testcase( pCol->affinity==SQLITE_AFF_INTEGER );
82617 testcase( pCol->affinity==SQLITE_AFF_REAL );
82619 zType = azType[pCol->affinity - SQLITE_AFF_TEXT];
82621 assert( pCol->affinity==SQLITE_AFF_NONE
82622 || pCol->affinity==sqlite3AffinityType(zType) );
88094 ** apply the affinity of the parent key). If this fails, then there
88097 ** will have INTEGER affinity applied to it, which may not be correct. */
88239 ** the parent key columns. The affinity of the parent key column should
88251 /* Set the collation sequence and affinity of the LHS of each TK_EQ
88259 pLeft->affinity = pCol->affinity;
88263 pLeft->affinity = SQLITE_AFF_INTEGER;
88286 pLeft->affinity = SQLITE_AFF_INTEGER;
88758 ** that the affinity and collation sequence associated with the
88822 pRaise->affinity = OE_Abort;
89000 ** Return a pointer to the column affinity string associated with index
89001 ** pIdx. A column affinity string has one character for each column in
89002 ** the table, according to the affinity of the column:
89004 ** Character Column affinity
89015 ** Memory for the buffer containing the column index affinity string
89021 /* The first time a column affinity string for a particular index is
89025 ** The column affinity string will eventually be deleted by
89038 pIdx->zColAff[n] = pTab->aCol[pIdx->aiColumn[n]].affinity;
89048 ** Set P4 of the most recently inserted opcode to a column affinity
89049 ** string for table pTab. A column affinity string has one character
89050 ** for each column indexed by the index, according to the affinity of the
89053 ** Character Column affinity
89062 /* The first time a column affinity string for a particular table
89066 ** The column affinity string will eventually be deleted by
89081 zColAff[i] = pTab->aCol[i].affinity;
90667 if( pDest->aCol[i].affinity!=pSrc->aCol[i].affinity ){
90668 return 0; /* Affinity must be the same on all columns */
94541 pDest->affinity = 0;
95159 p->affinity = sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affinity);
95168 sqlite3VdbeAddOp4(v, OP_MakeRecord, regResult, 1, r1, &p->affinity, 1);
95435 sqlite3VdbeAddOp4(v, OP_MakeRecord, regRow, 1, regRowid, &p->affinity, 1);
95865 pCol->affinity = sqlite3ExprAffinity(p);
95866 if( pCol->affinity==0 ) pCol->affinity = SQLITE_AFF_NONE;
96496 p->affinity =
96497 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affinity);
96499 sqlite3VdbeAddOp4(v, OP_MakeRecord, pIn->iMem, 1, r1, &p->affinity, 1);
98220 ** Apply the affinity pDest->affinity before storing
100510 pCol->affinity, &pValue);
100515 if( iReg>=0 && pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
103146 idxaff = pIdx->pTable->aCol[iColumn].affinity;
103223 ** be the name of an indexed column with TEXT affinity. */
104441 aff = pSrc->pTab->aCol[pTerm->u.leftColumn].affinity;
105145 ** an sqlite3_value structure containing the same value, with affinity
105153 ** affinity aff applied to it, instead.
105234 u8 aff = p->pTable->aCol[p->aiColumn[0]].affinity;
105308 u8 aff; /* Column affinity */
105314 aff = p->pTable->aCol[p->aiColumn[0]].affinity;
105956 ** Code an OP_Affinity opcode to apply the column affinity string zAff
105975 ** and end of the affinity string.
106075 ** compute the affinity string.
106085 ** copy of the column affinity string of the index allocated using
106087 ** with equality constraints that use NONE affinity are set to
106093 ** In the example above, the index on t1(a) has TEXT affinity. But since
106094 ** the right hand side of the equality constraint (t2.b) has NONE affinity,
106096 ** a key to search the index. Hence the first byte in the returned affinity
106105 char **pzAff /* OUT: Set to point to affinity string */
106115 char *zAff; /* Affinity string to return */
106590 char *zStartAff; /* Affinity for start of range constraint */
106591 char *zEndAff; /* Affinity for end of range constraint */
106666 ** applied to the operands, set the affinity to apply to pRight to
106707 ** applied to the operands, set the affinity to apply to pRight to
110881 yygotominor.yy342.pExpr->affinity = OE_Ignore;
110891 yygotominor.yy342.pExpr->affinity = (char)yymsp[-3].minor.yy392;
