Lines Matching refs:b

22 #  *   t2.b holds a text value with affinity TEXT
32     CREATE TABLE t2(a, b TEXT);  -- affinity of t2.b is TEXT
33     CREATE INDEX t2b ON t2(b);
36     SELECT x, a, y=b FROM t1, t2 ORDER BY +x, +a;
41     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
46     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
51     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
57     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
62     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
67     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
74 #  *   t2.b holds an integer value with affinity NONE
87     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
88     CREATE INDEX t2b ON t2(b);
91     SELECT x, a, y=b FROM t1, t2 ORDER BY +x, +a;
96     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
101     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
106     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
112     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
117     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
122     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
129 #  *   t2.b holds an integer value with affinity NONE
142     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
143     CREATE INDEX t2b ON t2(b);
146     SELECT x, a, y=b FROM t1, t2;
151     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
156     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
161     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
167     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
172     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
177     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
185 #  *   t2.b holds an integer value with affinity NUMERIC
187 # Because t2.b has a numeric affinity, type conversion should occur
198     CREATE TABLE t2(a, b NUMERIC);  -- affinity of t2.b is NUMERIC
199     CREATE INDEX t2b ON t2(b);
202     SELECT x, a, y=b FROM t1, t2;
207     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
212     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
219     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
225     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
230     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
237     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
246 #  *   t2.b holds an integer value with affinity INTEGER
248 # Because t2.b has a numeric affinity, type conversion should occur
259     CREATE TABLE t2(a, b INT);  -- affinity of t2.b is INTEGER
260     CREATE INDEX t2b ON t2(b);
263     SELECT x, a, y=b FROM t1, t2;
268     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
273     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
280     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
286     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
291     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
298     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
306 #  *   t2.b holds an integer value with affinity REAL
308 # Because t2.b has a numeric affinity, type conversion should occur
319     CREATE TABLE t2(a, b REAL);  -- affinity of t2.b is REAL
320     CREATE INDEX t2b ON t2(b);
323     SELECT x, a, y=b FROM t1, t2;
328     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
333     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
340     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
346     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
351     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
358     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
366 #  *   t2.b holds a text value with affinity NONE
379     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
380     CREATE INDEX t2b ON t2(b);
383     SELECT x, a, y=b FROM t1, t2;
388     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
393     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
400     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
406     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
411     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
418     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
425 #  *   t2.b holds a text value with affinity NONE
438     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
439     CREATE INDEX t2b ON t2(b);
442     SELECT x, a, y=b FROM t1, t2;
447     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
452     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
459     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
465     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
470     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
477     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
484 #  *   t2.b holds a text value with affinity NONE
497     CREATE TABLE t2(a, b BLOB);  -- affinity of t2.b is NONE
498     CREATE INDEX t2b ON t2(b);
501     SELECT x, a, y=b FROM t1, t2;
506     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
511     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
518     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;
524     SELECT x, a, y=b FROM t1, t2 WHERE y=b;
529     SELECT x, a, y=b FROM t1, t2 WHERE b=y;
536     SELECT x, a, y=b FROM t1, t2 WHERE +y=+b;