Lines Matching refs:b
15 CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c INT, d INT, e INT);
17 INSERT INTO t1(a,b,c,d,e) SELECT x,abs(random()%51),
19 CREATE TABLE t2(a INT, b INT, c INT,d INT,e INT,PRIMARY KEY(b,a))WITHOUT ROWID;
21 CREATE TABLE t3(a,b,c,d,e);
22 INSERT INTO t3 SELECT a,b,c,d,e FROM t1 ORDER BY random() LIMIT 5;
23 INSERT INTO t3 SELECT null,b,c,d,e FROM t1 ORDER BY random() LIMIT 5;
25 INSERT INTO t3 SELECT a,b,null,d,e FROM t1 ORDER BY random() LIMIT 5;
26 INSERT INTO t3 SELECT a,b,c,null,e FROM t1 ORDER BY random() LIMIT 5;
27 INSERT INTO t3 SELECT a,b,c,d,null FROM t1 ORDER BY random() LIMIT 5;
29 CREATE INDEX t3x1 ON t3(a,b,c,d,e);
30 CREATE TABLE t4(a INT UNIQUE NOT NULL, b INT UNIQUE NOT NULL,c,d,e);
31 INSERT OR IGNORE INTO t4 SELECT a,b,c,d,e FROM t3;
32 CREATE TABLE t5(a INTEGER PRIMARY KEY, b TEXT UNIQUE,c,d,e);
33 INSERT INTO t5(b) VALUES
84 UPDATE t1 SET e=(SELECT b FROM t5 WHERE t5.a=(t1.e%51));
87 UPDATE t2 SET e=(SELECT b FROM t5 WHERE t5.a=(t2.e%51));
88 UPDATE t3 SET e=(SELECT b FROM t5 WHERE t5.a=t3.e);
91 CREATE VIEW v00(a,b,c,d,e) AS SELECT 1,1,1,1,'one';
92 CREATE VIEW v10(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t1 WHERE a<>25;
93 CREATE VIEW v20(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t2 WHERE a<>25;
94 CREATE VIEW v30(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t3 WHERE a<>25;
95 CREATE VIEW v40(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t4 WHERE a<>25;
96 CREATE VIEW v50(a,b) AS SELECT a,b FROM t5 WHERE a<>25;
97 CREATE VIEW v11(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t1 ORDER BY b LIMIT 10;
98 CREATE VIEW v21(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t2 ORDER BY b LIMIT 10;
99 CREATE VIEW v31(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t3 ORDER BY b LIMIT 10;
100 CREATE VIEW v41(a,b,c,d,e) AS SELECT a,b,c,d,e FROM t4 ORDER BY b LIMIT 10;
101 CREATE VIEW v51(a,b) AS SELECT a,b FROM t5 ORDER BY b LIMIT 10;
102 CREATE VIEW v12(a,b,c,d,e) AS
103 SELECT sum(a), avg(b), count(*), min(d), e FROM t1 GROUP BY 5;
104 CREATE VIEW v22(a,b,c,d,e) AS
105 SELECT sum(a), avg(b), count(*), min(d), e FROM t2 GROUP BY 5
107 CREATE VIEW v32(a,b,c,d,e) AS
108 SELECT sum(a), avg(b), count(*), min(d), e FROM t3 GROUP BY 5
110 CREATE VIEW v42(a,b,c,d,e) AS
111 SELECT sum(a), avg(b), count(*), min(d), e FROM t4 GROUP BY 5
113 CREATE VIEW v52(a,b,c,d,e) AS
114 SELECT count(*), min(b), substr(b,1,1), min(a), max(a) FROM t5
117 CREATE VIEW v13(a,b,c,d,e) AS
118 SELECT a,b,c,d,e FROM t1
119 UNION SELECT a,b,c,d,e FROM t2
120 UNION SELECT a,b,c,d,e FROM t3;
121 CREATE VIEW v23(a,b,c,d,e) AS
122 SELECT a,b,c,d,e FROM t1
123 EXCEPT SELECT a,b,c,d,e FROM t1 WHERE b<25;
125 CREATE VIEW v60(a,b,c,d,e) AS
126 SELECT t1.a,t2.b,t1.c,t2.d,t1.e
127 FROM t1 LEFT JOIN t2 ON (t1.a=t2.b);
128 CREATE VIEW v61(a,b,c,d,e) AS
129 SELECT t2.a,t3.b,t2.c,t3.d,t2.e
131 CREATE VIEW v62(a,b,c,d,e) AS
132 SELECT t1.a,t2.b,t3.c,t4.d,t5.b
133 FROM t1 JOIN t2 ON (t1.a=t2.b)
135 JOIN t4 ON (t4.b=t3.b)
137 CREATE VIEW v70(a,b,c,d,e) AS
139 SELECT x, b, c, d, e FROM c0 JOIN t1 ON (t1.a=50-c0.x);