Lines Matching refs:affinity

13 # subtle affinity issues.
21 #  *   t1.y holds an integer value with affinity NONE
22 #  *   t2.b holds a text value with affinity TEXT
24 # These values are not equal and because neither affinity is NUMERIC
29     CREATE TABLE t1(x,y);    -- affinity of t1.y is NONE
32     CREATE TABLE t2(a, b TEXT);  -- affinity of t2.b is TEXT
73 #  *   t1.y holds a text value with affinity TEXT
74 #  *   t2.b holds an integer value with affinity NONE
76 # These values are not equal and because neither affinity is NUMERIC
84     CREATE TABLE t1(x, y TEXT);    -- affinity of t1.y is TEXT
87     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
128 #  *   t1.y holds a text value with affinity NONE
129 #  *   t2.b holds an integer value with affinity NONE
131 # These values are not equal and because neither affinity is NUMERIC
139     CREATE TABLE t1(x, y BLOB);    -- affinity of t1.y is NONE
142     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
184 #  *   t1.y holds a text value with affinity NONE
185 #  *   t2.b holds an integer value with affinity NUMERIC
187 # Because t2.b has a numeric affinity, type conversion should occur
195     CREATE TABLE t1(x, y BLOB);    -- affinity of t1.y is NONE
198     CREATE TABLE t2(a, b NUMERIC);  -- affinity of t2.b is NUMERIC
216   # In this case the unary "+" operator removes the column affinity so
234   # In this case the unary "+" operator removes the column affinity so
245 #  *   t1.y holds a text value with affinity NONE
246 #  *   t2.b holds an integer value with affinity INTEGER
248 # Because t2.b has a numeric affinity, type conversion should occur
256     CREATE TABLE t1(x, y BLOB);    -- affinity of t1.y is NONE
259     CREATE TABLE t2(a, b INT);  -- affinity of t2.b is INTEGER
277   # In this case the unary "+" operator removes the column affinity so
295   # In this case the unary "+" operator removes the column affinity so
305 #  *   t1.y holds a text value with affinity NONE
306 #  *   t2.b holds an integer value with affinity REAL
308 # Because t2.b has a numeric affinity, type conversion should occur
316     CREATE TABLE t1(x, y BLOB);    -- affinity of t1.y is NONE
319     CREATE TABLE t2(a, b REAL);  -- affinity of t2.b is REAL
337   # In this case the unary "+" operator removes the column affinity so
355   # In this case the unary "+" operator removes the column affinity so
365 #  *   t1.y holds an integer value with affinity NUMERIC
366 #  *   t2.b holds a text value with affinity NONE
368 # Because t1.y has a numeric affinity, type conversion should occur
376     CREATE TABLE t1(x, y NUMERIC);  -- affinity of t1.y is NUMERIC
379     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
397   # In this case the unary "+" operator removes the column affinity so
415   # In this case the unary "+" operator removes the column affinity so
424 #  *   t1.y holds an integer value with affinity INTEGER
425 #  *   t2.b holds a text value with affinity NONE
427 # Because t1.y has a numeric affinity, type conversion should occur
435     CREATE TABLE t1(x, y INT);  -- affinity of t1.y is INTEGER
438     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
456   # In this case the unary "+" operator removes the column affinity so
474   # In this case the unary "+" operator removes the column affinity so
483 #  *   t1.y holds an integer value with affinity REAL
484 #  *   t2.b holds a text value with affinity NONE
486 # Because t1.y has a numeric affinity, type conversion should occur
494     CREATE TABLE t1(x, y REAL);  -- affinity of t1.y is REAL
497     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
515   # In this case the unary "+" operator removes the column affinity so
533   # In this case the unary "+" operator removes the column affinity so