Lines Matching +full:4 +full:c

23     CREATE TABLE t1(a,b,c);
25     INSERT INTO t1 VALUES(2,3,4);
26     INSERT INTO t1 VALUES(3,4,5);
29 } {1 2 3 2 3 4 3 4 5}
32     CREATE TABLE t2(b,c,d);
34     INSERT INTO t2 VALUES(2,3,4);
35     INSERT INTO t2 VALUES(3,4,5);
38 } {1 2 3 2 3 4 3 4 5}
44 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
49 } {t2.b 2 t2.c 3 t2.d 4 t1.a 1 t2.b 3 t2.c 4 t2.d 5 t1.a 2}
52     SELECT * FROM t1 INNER JOIN t2 USING(b,c);
54 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
59 } {t1.a 1 t1.b 2 t1.c 3 t2.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.c 4 t2.d 5}
62     SELECT * FROM t1 INNER JOIN t2 USING(c);
64 } {t1.a 1 t1.b 2 t1.c 3 t2.b 2 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.b 3 t2.d 5}
67     SELECT * FROM t1 INNER JOIN t2 USING(c,b);
69 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t1.a 2 t1.b 3 t1.c 4 t2.d 5}
75 } {1 2 3 4 2 3 4 5}
78     SELECT * FROM t1 CROSS JOIN t2 USING(b,c);
80 } {1 2 3 4 2 3 4 5}
85 } {1 2 3 4 2 3 4 5}
88     SELECT * FROM t1 INNER JOIN t2 USING(b,c);
90 } {1 2 3 4 2 3 4 5}
95 } {1 2 3 4 2 3 4 5}
99       (SELECT b as 'c', c as 'd', d as 'e' FROM t2) as t3
101 } {t1.a 1 t1.b 2 t1.c 3 t3.d 4 t3.e 5}
104     SELECT * FROM (SELECT b as 'c', c as 'd', d as 'e' FROM t2) as 'tx'
107 } {tx.c 3 tx.d 4 tx.e 5 t1.a 1 t1.b 2}
111     CREATE TABLE t3(c,d,e);
112     INSERT INTO t3 VALUES(2,3,4);
113     INSERT INTO t3 VALUES(3,4,5);
114     INSERT INTO t3 VALUES(4,5,6);
117 } {2 3 4 3 4 5 4 5 6}
122 } {1 2 3 4 5 2 3 4 5 6}
127 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t3.e 5 t1.a 2 t1.b 3 t1.c 4 t2.d 5 t3.e 6}
131     INSERT INTO t4 VALUES(2,3,4);
132     INSERT INTO t4 VALUES(3,4,5);
133     INSERT INTO t4 VALUES(4,5,6);
136 } {2 3 4 3 4 5 4 5 6}
141 } {1 2 3 4 5 6}
146 } {t1.a 1 t1.b 2 t1.c 3 t2.d 4 t4.e 5 t4.f 6}
151 } {1 2 3 4 5}
157 } {1 2 3 4 2 3 4 5 3 4 5 {}}
162 } {1 2 3 {} 2 3 4 1 3 4 5 2}
172 } {1 2 3 {} {} {} 2 3 4 {} {} {} 3 4 5 1 2 3}
177 } {2 3 4 {} {} {} 3 4 5 1 2 3}
182 } {1 2 3 {} {} {} 2 3 4 {} {} {}}
208 } {0 {1 2 3 2 3 4 3 4 5}}
296     INSERT INTO usuarios VALUES(3,'c','cc',NULL);
302 } {1 a xxx 2 b xxx 3 c {}}
321     INSERT INTO t8 VALUES (4, NULL);
377     CREATE TABLE t13(b,c);