Lines Matching defs:affinity

18 ** Return the 'affinity' of the expression pExpr if any.
22 ** affinity of that column is returned. Otherwise, 0x00 is returned,
23 ** indicating no affinity for the expression.
26 ** have an affinity:
53 return pExpr->pTab->aCol[j].affinity;
55 return pExpr->affinity;
128 ** type affinity of the other operand. This routine returns the
129 ** type affinity that should be used for the comparison operator.
135 ** affinity, use that. Otherwise use no affinity.
148 /* One side is a column, the other is not. Use the columns affinity. */
155 ** pExpr is a comparison operator. Return the type affinity that should
177 ** idx_affinity is the affinity of an indexed column. Return true
178 ** if the index with affinity idx_affinity may be used to implement
1282 ** unchanged by OP_Affinity with the affinity given in the second
1478 /* Check that the affinity that will be used to perform the
1479 ** comparison is the same as the affinity of the column. If
1483 int affinity_ok = (pTab->aCol[iCol].affinity==aff||aff==SQLITE_AFF_NONE);
1612 char affinity; /* Affinity of the LHS of the IN */
1621 affinity = sqlite3ExprAffinity(pLeft);
1629 ** statement returns a column value, then the affinity of that
1631 ** SELECT... statement are columns, then numeric affinity is used
1632 ** if either column has NUMERIC or INTEGER affinity. If neither
1633 ** 'x' nor the SELECT... statement are columns, then numeric affinity
1653 dest.affinity = (u8)affinity;
1669 ** that columns affinity when building index keys. If <expr> is not
1670 ** a column, use numeric affinity.
1677 if( !affinity ){
1678 affinity = SQLITE_AFF_NONE;
1710 sqlite3VdbeAddOp4(v, OP_MakeRecord, r3, 1, r2, &affinity, 1);
1800 char affinity; /* Comparison affinity to use */
1813 /* Figure out the affinity to use to create a key from the results
1817 affinity = comparisonAffinity(pExpr);
1847 sqlite3VdbeAddOp4(v, OP_Affinity, r1, 1, 0, &affinity, 1);
2194 ** Record the fact that an affinity change has occurred on iCount
2726 /* If the column has REAL affinity, it may currently be stored as an
2729 && pTab->aCol[pExpr->iColumn].affinity==SQLITE_AFF_REAL
2827 assert( pExpr->affinity==OE_Rollback
2828 || pExpr->affinity==OE_Abort
2829 || pExpr->affinity==OE_Fail
2830 || pExpr->affinity==OE_Ignore
2837 if( pExpr->affinity==OE_Abort ){
2841 if( pExpr->affinity==OE_Ignore ){
2845 sqlite3HaltConstraint(pParse, pExpr->affinity, pExpr->u.zToken, 0);