| /external/chromium_org/third_party/sqlite/src/test/ |
| in4.test | 25 SELECT * FROM t1 WHERE a IN ('aaa', 'bbb', 'ccc');
34 SELECT b FROM t1 WHERE a IN ('aaa', 'bbb', 'ccc');
39 SELECT a FROM t1 WHERE rowid IN (1, 3);
44 SELECT a FROM t1 WHERE rowid IN ();
49 SELECT a FROM t1 WHERE a IN ('ddd');
65 execsql { SELECT b FROM t2 WHERE a IN (0, 2) }
69 execsql { SELECT b FROM t2 WHERE a IN (2, 0) }
73 execsql { SELECT b FROM t2 WHERE a IN (2, -1) }
77 execsql { SELECT b FROM t2 WHERE a IN (NULL, 3) }
81 execsql { SELECT b FROM t2 WHERE a IN (1.0, 2.1)
[all...] |
| ptrchng.test | 59 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=1
64 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=1
70 SELECT pointer_change(y, 'text', 'noop', 'text16') FROM t1 WHERE x=1
75 SELECT pointer_change(y, 'blob', 'noop', 'text16') FROM t1 WHERE x=1
80 SELECT pointer_change(y, 'text16', 'noop', 'blob') FROM t1 WHERE x=1
85 SELECT pointer_change(y, 'text16', 'noop', 'text') FROM t1 WHERE x=1
91 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=3
96 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=3
102 SELECT pointer_change(y, 'text', 'noop', 'text16') FROM t1 WHERE x=3
107 SELECT pointer_change(y, 'blob', 'noop', 'text16') FROM t1 WHERE x=
[all...] |
| like.test | 54 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
59 SELECT x FROM t1 WHERE x GLOB 'abc' ORDER BY 1;
64 SELECT x FROM t1 WHERE x LIKE 'ABC' ORDER BY 1;
69 SELECT x FROM t1 WHERE x LIKE 'aBc' ORDER BY 1;
75 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
81 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1;
86 SELECT x FROM t1 WHERE x GLOB 'abc' ORDER BY 1;
91 SELECT x FROM t1 WHERE x LIKE 'ABC' ORDER BY 1;
96 SELECT x FROM t1 WHERE x LIKE 'aBc' ORDER BY 1;
102 SELECT x FROM t1 WHERE x LIKE 'abc' ORDER BY 1
[all...] |
| collate8.test | 33 SELECT rowid FROM t1 WHERE a<'ccc' ORDER BY 1
38 SELECT rowid FROM t1 WHERE a<'ccc' COLLATE binary ORDER BY 1
43 SELECT rowid FROM t1 WHERE +a<'ccc' ORDER BY 1
58 SELECT a AS x FROM t1 WHERE x<'ccc' ORDER BY 1
63 SELECT a AS x FROM t1 WHERE x<'ccc' COLLATE binary ORDER BY [x]
68 SELECT a AS x FROM t1 WHERE +x<'ccc' ORDER BY 1
78 # When a result-set column is aliased into a WHERE clause, make sure the
86 SELECT a AS x FROM t2 WHERE x='abc';
91 SELECT a AS x FROM t2 WHERE x='abc' COLLATE nocase;
96 SELECT a AS x FROM t2 WHERE (x COLLATE nocase)='abc'
[all...] |
| fts1f.test | 36 DELETE FROM t1 WHERE rowid = 4;
38 UPDATE t1 SET content = 'update one three' WHERE rowid = 1;
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
48 UPDATE t1 SET content = 'update two five' WHERE rowid = 8;
50 DELETE FROM t1 WHERE rowid = 13;
54 DELETE FROM t1 WHERE rowid = 16;
58 DELETE FROM t1 WHERE rowid = 19;
59 UPDATE t1 SET content = 'update' WHERE rowid = 15;
67 execsql {SELECT rowid FROM t1 WHERE content MATCH 'update'
[all...] |
| fts2f.test | 36 DELETE FROM t1 WHERE rowid = 4;
38 UPDATE t1 SET content = 'update one three' WHERE rowid = 1;
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
48 UPDATE t1 SET content = 'update two five' WHERE rowid = 8;
50 DELETE FROM t1 WHERE rowid = 13;
54 DELETE FROM t1 WHERE rowid = 16;
58 DELETE FROM t1 WHERE rowid = 19;
59 UPDATE t1 SET content = 'update' WHERE rowid = 15;
67 execsql {SELECT rowid FROM t1 WHERE content MATCH 'update'
[all...] |
| fts3af.test | 36 DELETE FROM t1 WHERE rowid = 4;
38 UPDATE t1 SET content = 'update one three' WHERE rowid = 1;
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
48 UPDATE t1 SET content = 'update two five' WHERE rowid = 8;
50 DELETE FROM t1 WHERE rowid = 13;
54 DELETE FROM t1 WHERE rowid = 16;
58 DELETE FROM t1 WHERE rowid = 19;
59 UPDATE t1 SET content = 'update' WHERE rowid = 15;
67 execsql {SELECT rowid FROM t1 WHERE content MATCH 'update'
[all...] |
| tkt-80ba201079.test | 15 # without initialization when the OR optimization applies in the WHERE clause.
31 WHERE (a='A' AND b='X')
32 OR (a='A' AND EXISTS (SELECT * FROM t3 WHERE c='C'));
39 WHERE (a='A' AND b='X')
40 OR (a='A' AND EXISTS (SELECT * FROM t3 WHERE c='C'));
48 WHERE (a='A' AND b='X')
49 OR (a='A' AND EXISTS (SELECT * FROM t3 WHERE c='C'));
61 WHERE (a='A' AND b='X')
62 OR (a='A' AND EXISTS (SELECT * FROM t3 WHERE c='C'));}]
67 WHERE (a='A' AND b='X'
[all...] |
| indexedby.test | 44 EXPLAIN QUERY PLAN select * from t1 WHERE a = 10;
50 EXPLAIN QUERY PLAN select * from t1, t2 WHERE c = 10;
62 execsql { SELECT * FROM t1 NOT INDEXED WHERE a = 'one' AND b = 'two'}
65 execsql { SELECT * FROM t1 INDEXED BY i1 WHERE a = 'one' AND b = 'two'}
68 execsql { SELECT * FROM t1 INDEXED BY i2 WHERE a = 'one' AND b = 'two'}
72 catchsql { SELECT * FROM t1 INDEXED BY i3 WHERE a = 'one' AND b = 'two'}
75 catchsql { SELECT * FROM t1 INDEXED BY i5 WHERE a = 'one' AND b = 'two'}
78 catchsql { SELECT * FROM t1 INDEXED BY WHERE a = 'one' AND b = 'two'}
79 } {1 {near "WHERE": syntax error}}
81 catchsql { SELECT * FROM v1 INDEXED BY i1 WHERE a = 'one'
[all...] |
| tkt-f973c7ac31.test | 34 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 DESC
39 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 DESC
44 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 DESC
49 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 DESC
54 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<='5' ORDER BY c2 DESC
60 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='2' ORDER BY c2 ASC
65 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<=5 ORDER BY c2 ASC
70 SELECT * FROM t WHERE c1 = 5 AND c2>0 AND c2<='5' ORDER BY c2 ASC
75 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<=5 ORDER BY c2 ASC
80 SELECT * FROM t WHERE c1 = 5 AND c2>'0' AND c2<='5' ORDER BY c2 ASC
[all...] |
| tkt3334.test | 37 SELECT a FROM (SELECT a FROM t1 ORDER BY b LIMIT 2) WHERE a=1;
42 SELECT count(*) FROM (SELECT a FROM t1 ORDER BY b LIMIT 2) WHERE a=1;
47 SELECT a FROM (SELECT a FROM t1 ORDER BY b LIMIT 3) WHERE a=1;
52 SELECT count(*) FROM (SELECT a FROM t1 ORDER BY b LIMIT 3) WHERE a=1;
57 SELECT a FROM (SELECT a FROM t1 ORDER BY b LIMIT 99) WHERE a=1;
62 SELECT count(*) FROM (SELECT a FROM t1 ORDER BY b LIMIT 99) WHERE a=1;
67 SELECT a FROM (SELECT a FROM t1 ORDER BY b) WHERE a=1;
72 SELECT count(*) FROM (SELECT a FROM t1 ORDER BY b) WHERE a=1;
77 SELECT a FROM (SELECT a FROM t1) WHERE a=1;
82 SELECT count(*) FROM (SELECT a FROM t1) WHERE a=1
[all...] |
| vtabD.test | 40 execsql { SELECT * FROM tv1 WHERE a = 1 OR b = 4 }
43 execsql { SELECT * FROM tv1 WHERE a = 1 OR b = 1 }
46 execsql { SELECT * FROM tv1 WHERE (a > 0 AND a < 5) OR (b > 15 AND b < 65) }
50 execsql { SELECT * FROM tv1 WHERE a < 500 OR b = 810000 }
52 SELECT * FROM t1 WHERE a < 500
54 SELECT * FROM t1 WHERE b = 810000 AND NOT (a < 500)
58 execsql { SELECT * FROM tv1 WHERE a < 90000 OR b = 8100000000 }
60 SELECT * FROM t1 WHERE a < 90000
62 SELECT * FROM t1 WHERE b = 8100000000 AND NOT (a < 90000)
67 execsql { SELECT * FROM tv1 WHERE a = 90001 OR b = 810000
[all...] |
| fts3aa.test | 66 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
69 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two'}
72 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one'}
75 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two three'}
78 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one three two'}
81 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two three one'}
84 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one three'}
87 execsql {SELECT rowid FROM t1 WHERE content MATCH 'three one two'}
90 execsql {SELECT rowid FROM t1 WHERE content MATCH 'three two one'}
93 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two THREE'
[all...] |
| collate2.test | 23 # collate2-1.* WHERE <expr> expressions (sqliteExprIfTrue).
24 # collate2-2.* WHERE NOT <expr> expressions (sqliteExprIfFalse).
98 SELECT a FROM collate2t1 WHERE a > 'aa' ORDER BY 1;
103 SELECT a FROM collate2t1 WHERE a COLLATE binary > 'aa' ORDER BY 1;
108 SELECT a FROM collate2t1 WHERE b COLLATE binary > 'aa' ORDER BY 1;
113 SELECT a FROM collate2t1 WHERE c COLLATE binary > 'aa' ORDER BY 1;
118 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY 1, oid;
123 SELECT b FROM collate2t1 WHERE a COLLATE nocase > 'aa'
129 SELECT b FROM collate2t1 WHERE b COLLATE nocase > 'aa'
135 SELECT b FROM collate2t1 WHERE c COLLATE nocase > 'aa
[all...] |
| whereB.test | 12 # focus of this file is testing WHERE clause conditions with
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;
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
[all...] |
| fts3query.test | 41 SELECT * FROM t1 WHERE t1 MATCH 'sqlite'
50 SELECT * FROM t1 WHERE t1 MATCH 'sqlite'
63 SELECT docid FROM zoink WHERE zoink MATCH '(apple oranges) AND apple'
68 SELECT docid FROM zoink WHERE zoink MATCH 'apple AND (oranges apple)'
92 execsql { SELECT docid FROM foobar WHERE description MATCH '"high sp d"' }
104 execsql { SELECT mit(matchinfo(foobar)) FROM foobar WHERE foobar MATCH 'the' }
119 SELECT t1.number FROM t1, ft WHERE t1.number=ft.rowid ORDER BY t1.date
125 SELECT t1.number FROM ft, t1 WHERE t1.number=ft.rowid ORDER BY t1.date
131 SELECT t1.number FROM t1, bt WHERE t1.number=bt.rowid ORDER BY t1.date
137 SELECT t1.number FROM bt, t1 WHERE t1.number=bt.rowid ORDER BY t1.dat
[all...] |
| subselect.test | 35 execsql {SELECT * FROM t1 WHERE a = (SELECT count(*) FROM t1)}
41 set v [catch {execsql {SELECT * FROM t1 WHERE a = (SELECT * FROM t1)}} msg]
48 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=2)}
51 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=4)}
54 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6)}
57 execsql {SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=8)
[all...] |
| randexpr1.test | 36 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) | 17)),13) FROM t1 WHERE not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d}
39 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a | d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) | 17)),13) FROM t1 WHERE NOT (not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d)}
42 db eval {SELECT coalesce((select 11 from t1 where 19 in (t1.b,+11,coalesce((select max((abs(17)/abs(t1.f))) from t1 where ((abs(t1.f)/abs(t1.b)) in (select case (min(t1.a & d*d)+(abs(count(*)-count(*)+ -count(*)*max( -t1.c))-max(f))) when -count(distinct 19) then ((count(*))) else max(13) end from t1 union select count(distinct b) from t1)) or 19 in (t1.a,t1.c,17)),17) & 17)),13) FROM t1 WHERE NOT (not not c=a-+(select case ~case -~+count(distinct (select count(distinct t1.a)*max(13) from t1))+max( -19*f)*max(f)*max(f)* -count(distinct d)-(count(distinct 11)) | max(t1.f)*count(*) when count(distinct b) then count(distinct t1.b) else -min(t1.f) end*cast(avg(11) AS integer) when max(t1.f) then max(c) else count(*) end from t1)+d)}
45 db eval {SELECT t1.c*19-t1.f*19+coalesce((select 17 from t1 where e in (f,case (select cast(avg(t1.a) AS integer) from t1)-t1.d when coalesce((select +case when not (…)
[all...] |
| fts1e.test | 33 DELETE FROM t1 WHERE rowid = 1;
37 DELETE FROM t1 WHERE rowid = 4;
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
49 DELETE FROM t1 WHERE rowid = 13;
53 DELETE FROM t1 WHERE rowid = 16;
57 DELETE FROM t1 WHERE rowid = 19;
58 DELETE FROM t1 WHERE rowid = 22;
66 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
70 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two'
[all...] |
| fts2e.test | 33 DELETE FROM t1 WHERE rowid = 1;
37 DELETE FROM t1 WHERE rowid = 4;
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
49 DELETE FROM t1 WHERE rowid = 13;
53 DELETE FROM t1 WHERE rowid = 16;
57 DELETE FROM t1 WHERE rowid = 19;
58 DELETE FROM t1 WHERE rowid = 22;
66 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
70 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two'
[all...] |
| fts3ae.test | 33 DELETE FROM t1 WHERE rowid = 1;
37 DELETE FROM t1 WHERE rowid = 4;
41 DELETE FROM t1 WHERE rowid = 7;
45 DELETE FROM t1 WHERE rowid = 10;
49 DELETE FROM t1 WHERE rowid = 13;
53 DELETE FROM t1 WHERE rowid = 16;
57 DELETE FROM t1 WHERE rowid = 19;
58 DELETE FROM t1 WHERE rowid = 22;
66 execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
70 execsql {SELECT rowid FROM t1 WHERE content MATCH 'two'
[all...] |
| tkt2640.test | 19 # WHERE clause. If the subquery contained a compound SELECT,
53 WHERE d.person_id=p.person_id
55 SELECT person_id FROM directors d1 WHERE d1.person_id=p.person_id
65 WHERE d.person_id=p.person_id
67 SELECT person_id FROM directors d1 WHERE d1.person_id=p.person_id
77 WHERE d.person_id=p.person_id
79 SELECT person_id FROM directors d1 WHERE d1.person_id=p.person_id
89 WHERE d.person_id=p.person_id
91 SELECT person_id FROM directors d1 WHERE d1.person_id=d.person_id
101 WHERE d.person_id=p.person_i
[all...] |
| /external/chromium_org/third_party/skia/src/animator/ |
| SkDisplayAdd.cpp | 23 SK_MEMBER(where, Drawable)
29 // add onEndElement to turn where string into f_Where
31 // where="id", where="event-target" or not-specified
32 // offset="#" (implements before, after, and index if no 'where')
37 offset(SK_MaxS32), use(NULL), where(NULL) {
42 SkDrawable* saveWhere = where;
44 where = NULL;
47 copy->where = where = saveWhere
[all...] |
| /external/skia/src/animator/ |
| SkDisplayAdd.cpp | 23 SK_MEMBER(where, Drawable)
29 // add onEndElement to turn where string into f_Where
31 // where="id", where="event-target" or not-specified
32 // offset="#" (implements before, after, and index if no 'where')
37 offset(SK_MaxS32), use(NULL), where(NULL) {
42 SkDrawable* saveWhere = where;
44 where = NULL;
47 copy->where = where = saveWhere
[all...] |
| /external/valgrind/main/memcheck/tests/ |
| mempool2.c | 19 char *where; member in struct:_level_list
27 char *where; member in struct:_pool
42 p->where = p->mem = (char *)mmap(NULL, SUPERBLOCK_SIZE,
47 p->where = p->mem = (char *)malloc(SUPERBLOCK_SIZE);
52 VALGRIND_MAKE_MEM_NOACCESS(p->where, SUPERBLOCK_SIZE);
68 l->where = p->where;
69 VALGRIND_CREATE_MEMPOOL(l->where, REDZONE_SIZE, 0);
77 VALGRIND_DESTROY_MEMPOOL(l->where);
78 VALGRIND_MAKE_MEM_NOACCESS(l->where, p->where-l->where)
104 char *where; local
[all...] |
