HomeSort by relevance Sort by last modified time
    Searched full:where (Results 76 - 100 of 21198) sorted by null

1 2 34 5 6 7 8 91011>>

  /external/chromium_org/third_party/sqlite/src/test/
intarray.test 35 SELECT b FROM t1 WHERE a IN (12,34,56,78) ORDER BY a
52 SELECT b FROM t1 WHERE a IN ia3 ORDER BY a
59 SELECT b FROM t1 WHERE a IN ia3 ORDER BY a
65 SELECT count(b) FROM t1 WHERE a NOT IN ia3 ORDER BY a
69 #explain {SELECT b FROM t1 WHERE a NOT IN ia3}
82 DELETE FROM t1 WHERE a NOT IN ia1;
89 DELETE FROM t1 WHERE a IN ia1;
98 SELECT count(*) FROM t3 WHERE p IN ia1;
105 SELECT count(*) FROM t3 WHERE p IN ia1;
fts2n.test 46 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lorem'"
51 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lore*'"
56 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lorem*'"
61 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lore'"
66 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lo*'"
71 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'l*'"
76 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lov*'"
81 execsql "SELECT rowid FROM t1 WHERE t1 MATCH 'lo *'"
86 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '*'"
91 execsql "SELECT rowid FROM t1 WHERE t1 MATCH '\"lovely r*\"'
    [all...]
boundary2.test 103 SELECT * FROM t1 WHERE r=72057594037927935
108 SELECT r, a FROM t1 WHERE x='00ffffffffffffff'
113 SELECT r, x FROM t1 WHERE a=17
118 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY a
123 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY a DESC
128 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY r
133 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY r DESC
138 SELECT a FROM t1 WHERE r > 72057594037927935 ORDER BY x
143 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY a
148 SELECT a FROM t1 WHERE r >= 72057594037927935 ORDER BY a DES
    [all...]
boundary1.test 102 SELECT * FROM t1 WHERE rowid=72057594037927935
107 SELECT rowid, a FROM t1 WHERE x='00ffffffffffffff'
112 SELECT rowid, x FROM t1 WHERE a=17
117 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY a
122 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY a DESC
127 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY rowid
132 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY rowid DESC
137 SELECT a FROM t1 WHERE rowid > 72057594037927935 ORDER BY x
142 SELECT a FROM t1 WHERE rowid >= 72057594037927935 ORDER BY a
147 SELECT a FROM t1 WHERE rowid >= 72057594037927935 ORDER BY a DES
    [all...]
between.test 12 # focus of this file is testing the use of indices in WHERE clauses
13 # when the WHERE clause contains the BETWEEN operator.
63 SELECT * FROM t1 WHERE w BETWEEN 5 AND 6 ORDER BY +w
68 SELECT * FROM t1 WHERE +w BETWEEN 5 AND 6 ORDER BY +w
73 SELECT * FROM t1 WHERE w BETWEEN 5 AND 65-y ORDER BY +w
78 SELECT * FROM t1 WHERE +w BETWEEN 5 AND 65-y ORDER BY +w
83 SELECT * FROM t1 WHERE w BETWEEN 41-y AND 6 ORDER BY +w
88 SELECT * FROM t1 WHERE +w BETWEEN 41-y AND 6 ORDER BY +w
93 SELECT * FROM t1 WHERE w BETWEEN 41-y AND 65-y ORDER BY +w
98 SELECT * FROM t1 WHERE 26 BETWEEN y AND z ORDER BY +
    [all...]
fts3e.test 27 # queries with no WHERE clause, or for WHERE clauses which cannot be
45 SELECT docid FROM t1 WHERE c LIKE '%test' ORDER BY docid;
51 SELECT docid FROM t1 WHERE c LIKE 'That%' ORDER BY docid;
76 SELECT docid FROM t1 WHERE docid in (1, 2, 10);
77 SELECT rowid FROM t1 WHERE rowid in (1, 2, 10);
83 SELECT docid, weight FROM t1, t2 WHERE t2.id = t1.docid ORDER BY weight;
84 SELECT t1.rowid, weight FROM t1, t2 WHERE t2.id = t1.rowid ORDER BY weight;
91 WHERE t2.weight>5 AND t2.id = t1.docid ORDER BY weight;
93 WHERE t2.weight>5 AND t2.id = t1.rowid ORDER BY weight
    [all...]
in.test 38 execsql {SELECT a FROM t1 WHERE b BETWEEN 10 AND 50 ORDER BY a}
41 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN 10 AND 50 ORDER BY a}
44 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 ORDER BY a}
47 execsql {SELECT a FROM t1 WHERE b NOT BETWEEN a AND a*5 ORDER BY a}
50 execsql {SELECT a FROM t1 WHERE b BETWEEN a AND a*5 OR b=512 ORDER BY a}
68 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) ORDER BY a}
71 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) ORDER BY a}
74 execsql {SELECT a FROM t1 WHERE b IN (8,12,16,24,32) OR b=512 ORDER BY a}
77 execsql {SELECT a FROM t1 WHERE b NOT IN (8,12,16,24,32) OR b=512 ORDER BY a}
84 execsql {SELECT a FROM t1 WHERE b IN (b+8,64)
    [all...]
fts1d.test 31 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
36 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'run jump';
43 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijqrstuvwyxz'
48 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijXXXXqrstuvwyxz'
55 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123789'
60 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
fts2d.test 31 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
36 SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'run jump';
43 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijqrstuvwyxz'
48 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijXXXXqrstuvwyxz'
55 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123789'
60 SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'
fts3b.test 31 DELETE FROM t1 WHERE c = 'that was a test';
37 SELECT rowid FROM t1 WHERE c MATCH 'this';
47 SELECT rowid FROM t1 WHERE c MATCH 'this';
56 # we need to merge a mult-level tree, which is where the 10,000 comes
92 SELECT rowid FROM t2 WHERE c MATCH 'lorem';
102 SELECT rowid FROM t2 WHERE c MATCH 'lorem';
114 DELETE FROM t3 WHERE c = 'that was a test';
120 SELECT snippet(t3) FROM t3 WHERE t3 MATCH 'test';
127 SELECT * FROM t3 WHERE rowid = 1;
147 DELETE FROM t4 WHERE c = 'that was a test'
    [all...]
tkt2141.test 37 WHERE t2.t2_id IN
39 WHERE t3_id IN (1,2) GROUP BY t2_id);
46 WHERE t2.t2_id IN
48 WHERE t3_id IN (1,2));
55 WHERE t2.t2_id IN
57 WHERE t3_id IN (1,2));
where8m.test 12 # is testing of where.c. More specifically, the focus is the optimization
13 # of WHERE clauses that feature the OR operator.
28 WHERE
33 SELECT c FROM t1 WHERE
36 SELECT c FROM t1 WHERE
54 SELECT count(*) FROM t1 WHERE a BETWEEN 5 AND 995 OR b BETWEEN 5 AND 900000;
select2.test 37 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
46 set sql {SELECT DISTINCT f1 FROM tbl1 WHERE f1>3 AND f1<5}
51 set sql2 "SELECT f2 FROM tbl1 WHERE f1=$f1 ORDER BY f2"
103 execsql {SELECT count(*) FROM tbl2 WHERE f2>1000}
107 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
114 execsql {SELECT f1 FROM tbl2 WHERE 1000=f2}
117 execsql {SELECT f1 FROM tbl2 WHERE f2=1000}
121 execsql {SELECT * FROM tbl2 WHERE 1000=f2}
126 execsql {SELECT * FROM tbl2 WHERE f2=1000}
135 execsql {SELECT f1 FROM tbl2 WHERE f2==2000
    [all...]
tkt3298.test 13 # in august of 2008 and where associated with tickets #3298 and #3301
31 UPDATE t1 SET b=new.y-1 WHERE a=new.x;
35 DELETE FROM t1 WHERE a=old.x;
42 UPDATE v1 SET y=3 WHERE x=0;
48 UPDATE v1 SET y=4 WHERE v1.x=2;
54 DELETE FROM v1 WHERE x=1;
60 DELETE FROM v1 WHERE v1.x=2;
75 SELECT *, (SELECT z FROM (SELECT y AS z FROM t3 WHERE x=t1.a+1) ) FROM t1;
  /ndk/sources/cxx-stl/llvm-libc++/libcxx/test/numerics/rand/rand.eng/rand.eng.sub/
values.pass.cpp 32 void where(const _Tp &) {} function
44 where(E::word_size);
45 where(E::short_lag);
46 where(E::long_lag);
47 where(E::default_seed);
60 where(E::word_size);
61 where(E::short_lag);
62 where(E::long_lag);
63 where(E::default_seed);
  /external/libcap-ng/libcap-ng-0.7/docs/
capng_print_caps_numeric.3 7 char *capng_print_caps_numeric(capng_print_t where, capng_select_t set);
11 capng_print_caps_numeric will create a numeric representation of the internal capabilities. The representation can be sent to either stdout or a buffer by passing CAPNG_PRINT_STDOUT or CAPNG_PRINT_BUFFER respectively for the where parameter. If the option was for a buffer, this function will malloc a buffer that the caller must free.
17 If CAPNG_PRINT_BUFFER was selected for where, this will be the text buffer and NULL on failure. If CAPNG_PRINT_STDOUT was selected then this value will be NULL no matter what.
capng_print_caps_text.3 7 char *capng_print_caps_text(capng_print_t where, capng_type_t which);
11 capng_print_caps_text will create a text string representation of the internal capability set specified. The representation can be sent to either stdout or a buffer by passing CAPNG_PRINT_STDOUT or CAPNG_PRINT_BUFFER respectively for the where parameter. If the option was for a buffer, this function will malloc a buffer that the caller must free.
17 If CAPNG_PRINT_BUFFER was selected for where, this will be the text buffer and NULL on failure. If CAPNG_PRINT_STDOUT was selected then this value will be NULL no matter what.
  /external/qemu/target-arm/
helper-android.h 17 * First pointer contains guest PC where BL/BLX has been found.
18 * Second pointer contains guest PC where BL/BLX will return.
24 * Pointer contains guest PC where BL/BLX will return.
  /external/netperf/
netcpu_perfstat.c 81 fprintf(where,
84 fflush(where);
96 fprintf(where,
101 fflush(where);
145 fprintf(where,"enter calibrate_perfstat\n");
146 fflush(where);
158 fprintf(where,
161 fflush(where);
178 fprintf(where,
183 fflush(where);
    [all...]
  /packages/services/Telephony/src/com/android/phone/
ClearMissedCallsService.java 51 StringBuilder where = new StringBuilder(); local
52 where.append(Calls.NEW);
53 where.append(" = 1 AND ");
54 where.append(Calls.TYPE);
55 where.append(" = ?");
56 getContentResolver().update(Calls.CONTENT_URI, values, where.toString(),
  /external/antlr/antlr-3.4/runtime/JavaScript/src/org/antlr/runtime/tree/
RewriteCardinalityException.js 6 * This signifies a case where the cardinality of two or more elements
7 * in a subrule are different: (ID INT)+ where |ID|!=|INT|
  /external/chromium_org/extensions/common/
constants.h 27 // The name of the directory inside the profile where extensions are
58 // The name of the directory inside the profile where per-app local settings
62 // The name of the directory inside the profile where per-extension local
66 // The name of the directory inside the profile where per-app synced settings
70 // The name of the directory inside the profile where per-extension synced
74 // The name of the directory inside the profile where per-extension persistent
78 // The name of the database inside the profile where chrome-internal
82 // The name of the database inside the profile where declarative extension
  /external/chromium_org/third_party/tcmalloc/vendor/m4/
stl_namespace.m4 19 [the namespace where STL code like vector<> is defined])
23 [the namespace where STL code like vector<> is defined])
  /external/clang/test/CodeGen/
2002-02-13-UnnamedLocal.c 3 /* Testcase for a problem where GCC allocated xqic to a register,
6 * has not been previously recognized. This is where alloca's named
  /external/jsr305/ri/src/main/java/javax/annotation/meta/
When.java 8 * used where a NEVER value is required, or if a NEVER or MAYBE value is used
9 * where an ALWAYS value is required.

Completed in 1141 milliseconds

1 2 34 5 6 7 8 91011>>