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",
59398 u8 affinity, /* Affinity to use */
59445 if( (op==TK_INTEGER || op==TK_FLOAT ) && affinity==SQLITE_AFF_NONE ){
59448 sqlite3ValueApplyAffinity(pVal, affinity, SQLITE_UTF8);
59456 if( SQLITE_OK==sqlite3ValueFromExpr(db,pExpr->pLeft,enc,affinity,&pVal) ){
59466 sqlite3ValueApplyAffinity(pVal, affinity, enc);
62740 ** 0 instead. Unless it is NULL, apply affinity aff (one of the SQLITE_AFF_*
64631 ** Processing is determine by the affinity parameter:
64639 ** always preferred, even if the affinity is REAL, because
64649 Mem *pRec, /* The value to apply affinity to */
64650 char affinity, /* The affinity to be applied */
64653 if( affinity==SQLITE_AFF_TEXT ){
64662 }else if( affinity!=SQLITE_AFF_NONE ){
64663 assert( affinity==SQLITE_AFF_INTEGER || affinity==SQLITE_AFF_REAL
64664 || affinity==SQLITE_AFF_NUMERIC );
64693 u8 affinity,
64696 applyAffinity((Mem *)pVal, affinity, enc);
65077 char affinity; /* Affinity to use for comparison */
65124 const char *zAffinity; /* The affinity to be applied */
65125 char cAff; /* A single character of affinity */
65139 char *zAffinity; /* The affinity string for the record */
66488 ** has REAL affinity. Such column values may still be stored as
66611 ** The SQLITE_AFF_MASK portion of P5 must be an affinity character -
66613 ** to coerce both inputs according to this affinity before the
66615 ** affinity is used. Note that the affinity conversions are stored
66682 char affinity; /* Affinity to use for comparison */
66716 u.aj.affinity = pOp->p5 & SQLITE_AFF_MASK;
66717 if( u.aj.affinity ){
66718 applyAffinity(pIn1, u.aj.affinity, encoding);
66719 applyAffinity(pIn3, u.aj.affinity, encoding);
67324 /* Opcode: Affinity P1 P2 * P4 *
67329 ** string indicates the column affinity that should be used for the nth
67334 const char *zAffinity; /* The affinity to be applied */
67335 char cAff; /* A single character of affinity */
67359 ** string indicates the column affinity that should be used for the nth
67362 ** The mapping from character to affinity is given by the SQLITE_AFF_
67365 ** If P4 is NULL then all index fields have the affinity NONE.
67380 char *zAffinity; /* The affinity string for the record */
73468 pExpr->affinity = SQLITE_AFF_INTEGER;
73492 pExpr->affinity = SQLITE_AFF_INTEGER;
73682 pExpr->affinity = SQLITE_AFF_INTEGER;
73780 /* FIX ME: Compute pExpr->affinity based on the expected return
74445 ** Return the 'affinity' of the expression pExpr if any.
74449 ** affinity of that column is returned. Otherwise, 0x00 is returned,
74450 ** indicating no affinity for the expression.
74453 ** have an affinity:
74480 return pExpr->pTab->aCol[j].affinity;
74482 return pExpr->affinity;
74555 ** type affinity of the other operand. This routine returns the
74556 ** type affinity that should be used for the comparison operator.
74562 ** affinity, use that. Otherwise use no affinity.
74575 /* One side is a column, the other is not. Use the columns affinity. */
74582 ** pExpr is a comparison operator. Return the type affinity that should
74604 ** idx_affinity is the affinity of an indexed column. Return true
74605 ** if the index with affinity idx_affinity may be used to implement
75716 ** unchanged by OP_Affinity with the affinity given in the second
75927 /* Check that the affinity that will be used to perform the
75928 ** comparison is the same as the affinity of the column. If
75932 int affinity_ok = (pTab->aCol[iCol].affinity==aff||aff==SQLITE_AFF_NONE);
76058 char affinity; /* Affinity of the LHS of the IN */
76067 affinity = sqlite3ExprAffinity(pLeft);
76075 ** statement returns a column value, then the affinity of that
76077 ** SELECT... statement are columns, then numeric affinity is used
76078 ** if either column has NUMERIC or INTEGER affinity. If neither
76079 ** 'x' nor the SELECT... statement are columns, then numeric affinity
76099 dest.affinity = (u8)affinity;
76115 ** that columns affinity when building index keys. If <expr> is not
76116 ** a column, use numeric affinity.
76123 if( !affinity ){
76124 affinity = SQLITE_AFF_NONE;
76156 sqlite3VdbeAddOp4(v, OP_MakeRecord, r3, 1, r2, &affinity, 1);
76246 char affinity; /* Comparison affinity to use */
76259 /* Figure out the affinity to use to create a key from the results
76263 affinity = comparisonAffinity(pExpr);
76293 sqlite3VdbeAddOp4(v, OP_Affinity, r1, 1, 0, &affinity, 1);
76640 ** Record the fact that an affinity change has occurred on iCount
77174 /* If the column has REAL affinity, it may currently be stored as an
77177 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
77275 assert( pExpr->affinity==OE_Rollback
77276 || pExpr->affinity==OE_Abort
77277 || pExpr->affinity==OE_Fail
77278 || pExpr->affinity==OE_Ignore
77285 if( pExpr->affinity==OE_Abort ){
77289 if( pExpr->affinity==OE_Ignore ){
77293 sqlite3HaltConstraint(pParse, pExpr->affinity, pExpr->u.zToken, 0);
77587 switch( pExpr->affinity ){
82211 /* If there is no type specified, columns have the default affinity
82213 ** be called next to set pCol->affinity correctly.
82215 pCol->affinity = SQLITE_AFF_NONE;
82234 ** associated affinity type.
82238 ** found, the corresponding affinity is returned. If zType contains
82243 ** Substring | Affinity
82311 pCol->affinity = sqlite3AffinityType(pCol->zType);
82647 assert( pCol->affinity-SQLITE_AFF_TEXT >= 0 );
82648 assert( pCol->affinity-SQLITE_AFF_TEXT < ArraySize(azType) );
82649 testcase( pCol->affinity==SQLITE_AFF_TEXT );
82650 testcase( pCol->affinity==SQLITE_AFF_NONE );
82651 testcase( pCol->affinity==SQLITE_AFF_NUMERIC );
82652 testcase( pCol->affinity==SQLITE_AFF_INTEGER );
82653 testcase( pCol->affinity==SQLITE_AFF_REAL );
82655 zType = azType[pCol->affinity - SQLITE_AFF_TEXT];
82657 assert( pCol->affinity==SQLITE_AFF_NONE
82658 || pCol->affinity==sqlite3AffinityType(zType) );
88130 ** apply the affinity of the parent key). If this fails, then there
88133 ** will have INTEGER affinity applied to it, which may not be correct. */
88275 ** the parent key columns. The affinity of the parent key column should
88287 /* Set the collation sequence and affinity of the LHS of each TK_EQ
88295 pLeft->affinity = pCol->affinity;
88299 pLeft->affinity = SQLITE_AFF_INTEGER;
88322 pLeft->affinity = SQLITE_AFF_INTEGER;
88794 ** that the affinity and collation sequence associated with the
88858 pRaise->affinity = OE_Abort;
89036 ** Return a pointer to the column affinity string associated with index
89037 ** pIdx. A column affinity string has one character for each column in
89038 ** the table, according to the affinity of the column:
89040 ** Character Column affinity
89051 ** Memory for the buffer containing the column index affinity string
89057 /* The first time a column affinity string for a particular index is
89061 ** The column affinity string will eventually be deleted by
89074 pIdx->zColAff[n] = pTab->aCol[pIdx->aiColumn[n]].affinity;
89084 ** Set P4 of the most recently inserted opcode to a column affinity
89085 ** string for table pTab. A column affinity string has one character
89086 ** for each column indexed by the index, according to the affinity of the
89089 ** Character Column affinity
89098 /* The first time a column affinity string for a particular table
89102 ** The column affinity string will eventually be deleted by
89117 zColAff[i] = pTab->aCol[i].affinity;
90703 if( pDest->aCol[i].affinity!=pSrc->aCol[i].affinity ){
90704 return 0; /* Affinity must be the same on all columns */
94577 pDest->affinity = 0;
95195 p->affinity = sqlite3CompareAffinity(pEList->a[0].pExpr, pDest->affinity);
95204 sqlite3VdbeAddOp4(v, OP_MakeRecord, regResult, 1, r1, &p->affinity, 1);
95471 sqlite3VdbeAddOp4(v, OP_MakeRecord, regRow, 1, regRowid, &p->affinity, 1);
95901 pCol->affinity = sqlite3ExprAffinity(p);
95902 if( pCol->affinity==0 ) pCol->affinity = SQLITE_AFF_NONE;
96532 p->affinity =
96533 sqlite3CompareAffinity(p->pEList->a[0].pExpr, pDest->affinity);
96535 sqlite3VdbeAddOp4(v, OP_MakeRecord, pIn->iMem, 1, r1, &p->affinity, 1);
98256 ** Apply the affinity pDest->affinity before storing
100546 pCol->affinity, &pValue);
100551 if( iReg>=0 && pTab->aCol[i].affinity==SQLITE_AFF_REAL ){
103182 idxaff = pIdx->pTable->aCol[iColumn].affinity;
103259 ** be the name of an indexed column with TEXT affinity. */
104477 aff = pSrc->pTab->aCol[pTerm->u.leftColumn].affinity;
105181 ** an sqlite3_value structure containing the same value, with affinity
105189 ** affinity aff applied to it, instead.
105270 u8 aff = p->pTable->aCol[p->aiColumn[0]].affinity;
105344 u8 aff; /* Column affinity */
105350 aff = p->pTable->aCol[p->aiColumn[0]].affinity;
105992 ** Code an OP_Affinity opcode to apply the column affinity string zAff
106011 ** and end of the affinity string.
106111 ** compute the affinity string.
106121 ** copy of the column affinity string of the index allocated using
106123 ** with equality constraints that use NONE affinity are set to
106129 ** In the example above, the index on t1(a) has TEXT affinity. But since
106130 ** the right hand side of the equality constraint (t2.b) has NONE affinity,
106132 ** a key to search the index. Hence the first byte in the returned affinity
106141 char **pzAff /* OUT: Set to point to affinity string */
106151 char *zAff; /* Affinity string to return */
106626 char *zStartAff; /* Affinity for start of range constraint */
106627 char *zEndAff; /* Affinity for end of range constraint */
106702 ** applied to the operands, set the affinity to apply to pRight to
106743 ** applied to the operands, set the affinity to apply to pRight to
110917 yygotominor.yy342.pExpr->affinity = OE_Ignore;
110927 yygotominor.yy342.pExpr->affinity = (char)yymsp[-3].minor.yy392;
