multiwrite01.test - OpenGrok cross reference for /sqlite-3.40.0/mptest/multiwrite01.test

Lines Matching refs:a
7   CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
12   INSERT INTO t1 SELECT a+2, randomblob(1500) FROM t1;
13   INSERT INTO t1 SELECT a+4, randomblob(1500) FROM t1;
14   INSERT INTO t1 SELECT a+8, randomblob(1500) FROM t1;
16   INSERT INTO t1 SELECT a+16, randomblob(1500) FROM t1;
18   INSERT INTO t1 SELECT a+32, randomblob(1500) FROM t1;
24   UPDATE t1 SET b='x'||a||'y';
27   SELECT a FROM t1 WHERE b='x17y';
30   SELECT a FROM t1 WHERE b='x17y';
32   SELECT a FROM t1 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
39   CREATE TABLE t2(a INTEGER PRIMARY KEY, b);
44   INSERT INTO t2 SELECT a+2, randomblob(1500) FROM t2;
45   INSERT INTO t2 SELECT a+4, randomblob(1500) FROM t2;
46   INSERT INTO t2 SELECT a+8, randomblob(1500) FROM t2;
48   INSERT INTO t2 SELECT a+16, randomblob(1500) FROM t2;
50   INSERT INTO t2 SELECT a+32, randomblob(1500) FROM t2;
56   UPDATE t2 SET b='x'||a||'y';
59   SELECT a FROM t2 WHERE b='x17y';
62   SELECT a FROM t2 WHERE b='x17y';
64   SELECT a FROM t2 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
70   CREATE TABLE t3(a INTEGER PRIMARY KEY, b);
75   INSERT INTO t3 SELECT a+2, randomblob(1500) FROM t3;
76   INSERT INTO t3 SELECT a+4, randomblob(1500) FROM t3;
77   INSERT INTO t3 SELECT a+8, randomblob(1500) FROM t3;
79   INSERT INTO t3 SELECT a+16, randomblob(1500) FROM t3;
81   INSERT INTO t3 SELECT a+32, randomblob(1500) FROM t3;
87   UPDATE t3 SET b='x'||a||'y';
90   SELECT a FROM t3 WHERE b='x17y';
93   SELECT a FROM t3 WHERE b='x17y';
95   SELECT a FROM t3 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
101   CREATE TABLE t4(a INTEGER PRIMARY KEY, b);
106   INSERT INTO t4 SELECT a+2, randomblob(1500) FROM t4;
107   INSERT INTO t4 SELECT a+4, randomblob(1500) FROM t4;
108   INSERT INTO t4 SELECT a+8, randomblob(1500) FROM t4;
110   INSERT INTO t4 SELECT a+16, randomblob(1500) FROM t4;
112   INSERT INTO t4 SELECT a+32, randomblob(1500) FROM t4;
118   UPDATE t4 SET b='x'||a||'y';
121   SELECT a FROM t4 WHERE b='x17y';
124   SELECT a FROM t4 WHERE b='x17y';
126   SELECT a FROM t4 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
132   CREATE TABLE t5(a INTEGER PRIMARY KEY, b);
137   INSERT INTO t5 SELECT a+2, randomblob(1500) FROM t5;
138   INSERT INTO t5 SELECT a+4, randomblob(1500) FROM t5;
139   INSERT INTO t5 SELECT a+8, randomblob(1500) FROM t5;
141   INSERT INTO t5 SELECT a+16, randomblob(1500) FROM t5;
143   INSERT INTO t5 SELECT a+32, randomblob(1500) FROM t5;
149   UPDATE t5 SET b='x'||a||'y';
152   SELECT a FROM t5 WHERE b='x17y';
155   SELECT a FROM t5 WHERE b='x17y';
157   SELECT a FROM t5 WHERE b GLOB 'x2?y' ORDER BY b DESC LIMIT 5;
174   SELECT t1.a FROM t1, t2
175    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
176    ORDER BY t1.a LIMIT 4
178   SELECT t3.a FROM t3, t4
179    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
180    ORDER BY t3.a LIMIT 7
184   SELECT t1.a FROM t1, t2
185    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
186    ORDER BY t1.a LIMIT 4
188   SELECT t3.a FROM t3, t4
189    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
190    ORDER BY t3.a LIMIT 7
194   SELECT t1.a FROM t1, t2
195    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
196    ORDER BY t1.a LIMIT 4
198   SELECT t3.a FROM t3, t4
199    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
200    ORDER BY t3.a LIMIT 7
204   SELECT t1.a FROM t1, t2
205    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
206    ORDER BY t1.a LIMIT 4
208   SELECT t3.a FROM t3, t4
209    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
210    ORDER BY t3.a LIMIT 7
214   SELECT t1.a FROM t1, t2
215    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
216    ORDER BY t1.a LIMIT 4
218   SELECT t3.a FROM t3, t4
219    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
220    ORDER BY t3.a LIMIT 7
263   SELECT t1.a FROM t1, t2
264    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
265    ORDER BY t1.a LIMIT 4
267   SELECT t3.a FROM t3, t4
268    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
269    ORDER BY t3.a LIMIT 7
273   SELECT t1.a FROM t1, t2
274    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
275    ORDER BY t1.a LIMIT 4
277   SELECT t3.a FROM t3, t4
278    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
279    ORDER BY t3.a LIMIT 7
283   SELECT t1.a FROM t1, t2
284    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
285    ORDER BY t1.a LIMIT 4
287   SELECT t3.a FROM t3, t4
288    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
289    ORDER BY t3.a LIMIT 7
293   SELECT t1.a FROM t1, t2
294    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
295    ORDER BY t1.a LIMIT 4
297   SELECT t3.a FROM t3, t4
298    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
299    ORDER BY t3.a LIMIT 7
303   SELECT t1.a FROM t1, t2
304    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
305    ORDER BY t1.a LIMIT 4
307   SELECT t3.a FROM t3, t4
308    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
309    ORDER BY t3.a LIMIT 7
321   UPDATE t1 SET b='x'||a||'y';
322   SELECT a FROM t1 WHERE b='x63y';
328   UPDATE t2 SET b='x'||a||'y';
329   SELECT a FROM t2 WHERE b='x63y';
335   UPDATE t3 SET b='x'||a||'y';
336   SELECT a FROM t3 WHERE b='x63y';
342   UPDATE t4 SET b='x'||a||'y';
343   SELECT a FROM t4 WHERE b='x63y';
349   UPDATE t5 SET b='x'||a||'y';
350   SELECT a FROM t5 WHERE b='x63y';
356   SELECT t1.a FROM t1, t2
357    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
358    ORDER BY t1.a LIMIT 4
360   SELECT t3.a FROM t3, t4
361    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
362    ORDER BY t3.a LIMIT 7
368   SELECT t1.a FROM t1, t2
369    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
370    ORDER BY t1.a LIMIT 4
372   SELECT t3.a FROM t3, t4
373    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
374    ORDER BY t3.a LIMIT 7
380   SELECT t1.a FROM t1, t2
381    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
382    ORDER BY t1.a LIMIT 4
384   SELECT t3.a FROM t3, t4
385    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
386    ORDER BY t3.a LIMIT 7
392   SELECT t1.a FROM t1, t2
393    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
394    ORDER BY t1.a LIMIT 4
396   SELECT t3.a FROM t3, t4
397    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
398    ORDER BY t3.a LIMIT 7
404   SELECT t1.a FROM t1, t2
405    WHERE t2.b GLOB 'x3?y' AND t1.b=('x'||(t2.a+3)||'y')
406    ORDER BY t1.a LIMIT 4
408   SELECT t3.a FROM t3, t4
409    WHERE t4.b GLOB 'x4?y' AND t3.b=('x'||(t4.a+5)||'y')
410    ORDER BY t3.a LIMIT 7