Lines Matching refs:y
21 # * t1.y holds an integer value with affinity NONE
29 CREATE TABLE t1(x,y); -- affinity of t1.y is NONE
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;
73 # * t1.y holds a text value with affinity TEXT
84 CREATE TABLE t1(x, y TEXT); -- affinity of t1.y is TEXT
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;
128 # * t1.y holds a text value with affinity NONE
139 CREATE TABLE t1(x, y BLOB); -- affinity of t1.y is NONE
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;
184 # * t1.y holds a text value with affinity NONE
195 CREATE TABLE t1(x, y BLOB); -- affinity of t1.y is NONE
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;
245 # * t1.y holds a text value with affinity NONE
256 CREATE TABLE t1(x, y BLOB); -- affinity of t1.y is NONE
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;
305 # * t1.y holds a text value with affinity NONE
316 CREATE TABLE t1(x, y BLOB); -- affinity of t1.y is NONE
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;
365 # * t1.y holds an integer value with affinity NUMERIC
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
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;
424 # * t1.y holds an integer value with affinity INTEGER
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
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;
483 # * t1.y holds an integer value with affinity REAL
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
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;