Home
last modified time | relevance | path

Searched refs:affinity (Results 1 – 25 of 52) sorted by relevance

123

/sqlite-3.40.0/test/
H A DwhereB.test13 # subtle affinity issues.
21 # * t1.y holds an integer value with affinity NONE
22 # * t2.b holds a text value with affinity TEXT
73 # * t1.y holds a text value with affinity TEXT
74 # * t2.b holds an integer value with affinity NONE
128 # * t1.y holds a text value with affinity NONE
184 # * t1.y holds a text value with affinity NONE
245 # * t1.y holds a text value with affinity NONE
305 # * t1.y holds a text value with affinity NONE
366 # * t2.b holds a text value with affinity NONE
[all …]
H A Din3.test176 # This next block of tests - in3-3.* - verify that column affinity is
189 CREATE UNIQUE INDEX t1_i1 ON t1(a); /* no affinity */
190 CREATE UNIQUE INDEX t1_i2 ON t1(b); /* numeric affinity */
191 CREATE UNIQUE INDEX t1_i3 ON t1(c); /* text affinity */
194 CREATE UNIQUE INDEX t2_i1 ON t2(x); /* no affinity */
196 CREATE UNIQUE INDEX t2_i3 ON t2(z); /* text affinity */
204 # No affinity is applied before comparing "x" and "a". Therefore
209 # Logically, numeric affinity is applied to both sides before
214 # No affinity is applied before the comparison takes place. Making
225 # Numeric affinity is applied to both sides before
[all …]
H A Dtypes2.test71 # Compare literals against a column with TEXT affinity
81 # Compare literals against a column with NUMERIC affinity
91 # Compare literals against a column with affinity NONE
163 # Change (by ticket #805): No affinity in comparisons
169 # Compare literals against a column with TEXT affinity
179 # Compare literals against a column with NUMERIC affinity
189 # Compare literals against a column with affinity NONE
202 # Compare literals against literals (no affinity applied)
209 # Compare literals against a column with TEXT affinity
223 # Compare literals against a column with affinity NONE
[all …]
H A De_select2.test205 proc te_apply_affinity {affinity typevar valvar} {
209 switch -- $affinity {
223 default { error "invalid affinity: $affinity" }
236 set affinity none
244 -affinity {
245 set affinity [string tolower [lindex $args [incr i]]]
261 te_apply_affinity $affinity t1 v1
262 te_apply_affinity $affinity t2 v2
539 {t5 %ss% -using y -on {te_equals -affinity text 0 0}}
542 {%ss% t5 -using y -on {te_equals -affinity text 0 0}}
[all …]
H A Dbloom1.test42 SELECT 'affinity!' FROM t1 CROSS JOIN t2 WHERE t2.c = '14';
43 } {affinity!}
H A Dreturning1.test350 # Incorrect affinity for REAL values that can be represented as integers.
356 INSERT INTO t1(x) VALUES(5.0) RETURNING x, affinity(x);
359 UPDATE t1 SET x=x+1 RETURNING x, affinity(x);
362 DELETE FROM t1 RETURNING x, affinity(x);
H A Dsubquery.test225 # has text affinity and the LHS has integer affinity. The rule is
236 # because the constraint has integer affinity but t4i has text affinity.
H A Din.test340 # Type affinity applied to the right-hand side of an IN operator.
363 # No coercion because column a as affinity NONE
374 # No coercion because column a as affinity NONE
764 # For the IN_INDEX_NOOP optimization, apply REAL affinity to the LHS
765 # values prior to comparison if the RHS has REAL affinity.
H A Danalyze3.test81 # Create a table with two columns. Populate the first column (affinity
191 # that the indexed column has TEXT affinity in this case. In the tests
192 # above the affinity is INTEGER.
242 # Same tests a third time. This time, column x has INTEGER affinity and
H A Dtypes.test45 # Create a table with one column for each type of affinity
56 # literal were inserted into a column with affinity INTEGER, NUMERIC, TEXT
H A Dwhere2.test375 -- The + operator removes affinity from the rhs. No conversions
427 # In this case, the +b disables the affinity conflict and allows
435 # In this case, the +b disables the affinity conflict and allows
443 # In this case, the +b disables the affinity conflict and allows
H A Daffinity3.test91 # Incorrect affinity when using automatic indexes
H A Daffinity2.test12 # focus of this file is type affinity in comparison operations.
H A Dfunc3.test156 # Unlikely() does not preserve the affinity of X.
H A DwhereL.test125 # Incorrect join result due to mishandling of affinity in constant
H A DtriggerC.test368 # This next block of tests, triggerC-4.*, checks that affinity
399 # in a column with REAL affinity, it is actually stored as an integer.
403 # triggerC-4.1.*: Check that affinity transformations are made before
/sqlite-3.40.0/src/
H A Dvdbemem.c1558 u8 affinity, /* Affinity to use */ in valueFromExpr() argument
1587 sqlite3ValueApplyAffinity(*ppVal, affinity, enc); in valueFromExpr()
1616 sqlite3ValueApplyAffinity(pVal, affinity, SQLITE_UTF8); in valueFromExpr()
1645 sqlite3ValueApplyAffinity(pVal, affinity, enc); in valueFromExpr()
1669 rc = valueFromFunction(db, pExpr, enc, affinity, &pVal, pCtx); in valueFromExpr()
1713 u8 affinity, /* Affinity to use */ in sqlite3ValueFromExpr() argument
1741 u8 affinity, /* Affinity to use */ in stat4ValueFromExpr() argument
1766 sqlite3ValueApplyAffinity(pVal, affinity, ENC(db)); in stat4ValueFromExpr()
1771 rc = valueFromExpr(db, pExpr, ENC(db), affinity, &pVal, pAlloc); in stat4ValueFromExpr()
1861 u8 affinity, /* Affinity to use */ in sqlite3Stat4ValueFromExpr() argument
[all …]
H A Dbuild.c1505 char affinity = SQLITE_AFF_BLOB; in sqlite3AddColumn() local
1542 affinity = sqlite3StdTypeAffinity[i]; in sqlite3AddColumn()
1543 if( affinity<=SQLITE_AFF_TEXT ) szEst = 5; in sqlite3AddColumn()
1578 pCol->affinity = affinity; in sqlite3AddColumn()
1582 if( affinity==SQLITE_AFF_BLOB ){ in sqlite3AddColumn()
2152 assert( pCol->affinity-SQLITE_AFF_BLOB >= 0 ); in createTableStmt()
2154 testcase( pCol->affinity==SQLITE_AFF_BLOB ); in createTableStmt()
2155 testcase( pCol->affinity==SQLITE_AFF_TEXT ); in createTableStmt()
2158 testcase( pCol->affinity==SQLITE_AFF_REAL ); in createTableStmt()
2162 assert( pCol->affinity==SQLITE_AFF_BLOB in createTableStmt()
[all …]
H A Dexpr.c26 return pTab->aCol[iCol].affinity; in sqlite3TableColumnAffinity()
3176 char affinity; /* Affinity of the LHS of the IN */ in sqlite3CodeRhsOfIN() local
3181 affinity = sqlite3ExprAffinity(pLeft); in sqlite3CodeRhsOfIN()
3182 if( affinity<=SQLITE_AFF_NONE ){ in sqlite3CodeRhsOfIN()
3183 affinity = SQLITE_AFF_BLOB; in sqlite3CodeRhsOfIN()
3184 }else if( affinity==SQLITE_AFF_REAL ){ in sqlite3CodeRhsOfIN()
3185 affinity = SQLITE_AFF_NUMERIC; in sqlite3CodeRhsOfIN()
3212 sqlite3VdbeAddOp4(v, OP_MakeRecord, r1, 1, r2, &affinity, 1); in sqlite3CodeRhsOfIN()
3770 if( pCol->affinity>=SQLITE_AFF_TEXT ){ in sqlite3ExprCodeGeneratedColumn()
4213 if( pCol->affinity==SQLITE_AFF_REAL ){ in sqlite3ExprCodeTarget()
[all …]
H A Dvdbe.c383 char affinity, /* The affinity to be applied */ in applyAffinity() argument
386 if( affinity>=SQLITE_AFF_NUMERIC ){ in applyAffinity()
387 assert( affinity==SQLITE_AFF_INTEGER || affinity==SQLITE_AFF_REAL in applyAffinity()
388 || affinity==SQLITE_AFF_NUMERIC ); in applyAffinity()
396 }else if( affinity==SQLITE_AFF_TEXT ){ in applyAffinity()
436 u8 affinity, in sqlite3ValueApplyAffinity() argument
439 applyAffinity((Mem *)pVal, affinity, enc); in sqlite3ValueApplyAffinity()
2185 affinity = pOp->p5 & SQLITE_AFF_MASK; in sqlite3VdbeExec()
2186 if( affinity>=SQLITE_AFF_NUMERIC ){ in sqlite3VdbeExec()
2197 }else if( affinity==SQLITE_AFF_TEXT ){ in sqlite3VdbeExec()
[all …]
H A Dupsert.c307 if( pTab->aCol[i].affinity==SQLITE_AFF_REAL ){ in sqlite3UpsertDoUpdate()
H A Dpragma.c1839 doTypeCheck = pCol->affinity>SQLITE_AFF_BLOB; in sqlite3Pragma()
1853 pCol->affinity, &pDfltValue); in sqlite3Pragma()
1904 }else if( !bStrict && pCol->affinity==SQLITE_AFF_TEXT ){ in sqlite3Pragma()
1913 }else if( !bStrict && pCol->affinity>=SQLITE_AFF_NUMERIC ){ in sqlite3Pragma()
H A Dinsert.c94 aff = pTab->aCol[x].affinity; in sqlite3IndexAffinityStr()
125 zColAff[j++] = pTab->aCol[i].affinity; in sqlite3TableAffinityStr()
2929 if( pDestCol->affinity!=pSrcCol->affinity ){ in xferOptimization()
H A Dupdate.c74 pCol->affinity, &pValue); in sqlite3ColumnDefault()
80 if( pCol->affinity==SQLITE_AFF_REAL && !IsVirtual(pTab) ){ in sqlite3ColumnDefault()
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc.test386 # give a column a type affinity or add a constraint such as UNIQUE or
409 # always has a type affinity of INTEGER and all other data columns have
410 # a type affinity of REAL.
422 # have type affinity of INTEGER.
1167 # column matters. The type affinity is ignored.
1186 # Check that the aux column has no affinity. Or NOT NULL constraint.

123