Home
last modified time | relevance | path

Searched refs:a (Results 1 – 25 of 1592) sorted by relevance

12345678910>>...64

/sqlite-3.40.0/test/
H A DjoinC.test51 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
65 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
79 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
93 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
107 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
122 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
137 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
152 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
167 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
181 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
[all …]
H A DjoinB.test51 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
74 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
95 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
124 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
149 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
172 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
195 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
224 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
250 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
275 SELECT a, t1.a, t2.a, t3.a, t4.a, t5.a
[all …]
H A Dtkt2927.test287 SELECT a+b, a-b, a, b FROM t1
289 SELECT a+b, a-b, a, b FROM t1
294 SELECT a+b, a-b, a, b FROM t1
296 SELECT a+b, a-b, a, abs(b) FROM t1
301 SELECT a+b, a-b, a, b FROM t1
303 SELECT a+b, a-b, abs(a), b FROM t1
308 SELECT a+b, a-b, a, b FROM t1
315 SELECT a+b, a-b, a, abs(b) FROM t1
317 SELECT a+b, a-b, a, b FROM t1
345 SELECT a+b, a-b, a, b FROM t1
[all …]
H A Dwhere7.test4 # a legal notice, here is a blessing:
55 SELECT * FROM t WHERE a<2 OR a<3 ORDER BY a;
57 DELETE FROM t WHERE a<2 OR a<3;
64 SELECT a FROM t1 WHERE b=3 OR c=6 ORDER BY a
69 SELECT a FROM t1 WHERE b=3 OR +c=6 ORDER BY a
84 SELECT a FROM t1 WHERE (3=b OR c=6) AND +a>0 ORDER BY a
136 set sql "SELECT a FROM t1 WHERE a=11 OR b=11"
415 WHERE ((a BETWEEN 8 AND 10) AND a!=9)
425 WHERE ((a BETWEEN 8 AND 10) AND a!=9)
664 OR ((a BETWEEN 2 AND 4) AND a!=3)
[all …]
H A Dboundary1.test4 # a legal notice, here is a blessing:
232 SELECT a FROM t1 WHERE rowid > 16384 ORDER BY a
282 SELECT a FROM t1 WHERE rowid < 16384 ORDER BY a
807 SELECT a FROM t1 WHERE rowid > 2 ORDER BY a
832 SELECT a FROM t1 WHERE rowid >= 2 ORDER BY a
857 SELECT a FROM t1 WHERE rowid < 2 ORDER BY a
882 SELECT a FROM t1 WHERE rowid <= 2 ORDER BY a
922 SELECT a FROM t1 WHERE rowid > 4 ORDER BY a
947 SELECT a FROM t1 WHERE rowid >= 4 ORDER BY a
972 SELECT a FROM t1 WHERE rowid < 4 ORDER BY a
[all …]
H A Dboundary3.test4 # a legal notice, here is a blessing:
128 SELECT t2.a FROM t1 JOIN t2 USING(a)
161 SELECT t2.a FROM t1 JOIN t2 USING(a)
194 SELECT t2.a FROM t1 JOIN t2 USING(a)
227 SELECT t2.a FROM t1 JOIN t2 USING(a)
275 SELECT t2.a FROM t1 JOIN t2 USING(a)
322 SELECT t2.a FROM t1 JOIN t2 USING(a)
369 SELECT t2.a FROM t1 JOIN t2 USING(a)
416 SELECT t2.a FROM t1 JOIN t2 USING(a)
478 SELECT t2.a FROM t1 JOIN t2 USING(a)
[all …]
H A Dboundary2.test4 # a legal notice, here is a blessing:
233 SELECT a FROM t1 WHERE r > 16384 ORDER BY a
283 SELECT a FROM t1 WHERE r < 16384 ORDER BY a
808 SELECT a FROM t1 WHERE r > 2 ORDER BY a
833 SELECT a FROM t1 WHERE r >= 2 ORDER BY a
858 SELECT a FROM t1 WHERE r < 2 ORDER BY a
883 SELECT a FROM t1 WHERE r <= 2 ORDER BY a
923 SELECT a FROM t1 WHERE r > 4 ORDER BY a
948 SELECT a FROM t1 WHERE r >= 4 ORDER BY a
973 SELECT a FROM t1 WHERE r < 4 ORDER BY a
[all …]
H A DselectA.test4 # a legal notice, here is a blessing:
323 } {{} C c 1 a a 9.9 b B}
347 } {{} C c 1 a a 9.9 b B}
353 } {{} C c 1 a a 9.9 b B}
359 } {9.9 b B 1 a a {} C c}
383 } {9.9 b B 1 a a {} C c}
389 } {9.9 b B 1 a a {} C c}
395 } {{} C c 1 a a 9.9 b B}
419 } {1 a a 9.9 b B {} C c}
425 } {{} C c 1 a a 9.9 b B}
[all …]
H A Dcolname.test4 # a legal notice, here is a blessing:
70 } {a 1 b 2 c 3 a 1 b 2 c 3}
157 } {v1.a 1 a 1 x 4 a:1 1 b 2 c 3 x:1 4 y 5 z 6}
263 CREATE TABLE t6(a, ['a'], ["a"], "[a]", [`a`]);
267 } {a 1 'a' 2 {"a"} 3 {[a]} 4 `a` 5}
269 execsql2 {SELECT ['a'], [`a`], "[a]", [a], ["a"] FROM t6}
270 } {'a' 2 `a` 5 {[a]} 4 a 1 {"a"} 3}
272 execsql2 {SELECT "'a'", "`a`", "[a]", "a", """a""" FROM t6}
273 } {'a' 2 `a` 5 {[a]} 4 a 1 {"a"} 3}
275 execsql2 {SELECT `'a'`, ```a```, `[a]`, `a`, `"a"` FROM t6}
[all …]
H A Dcollate4.test5 # a legal notice, here is a blessing:
72 INSERT INTO collate4t1 VALUES( 'a', 'a' );
82 cksort {SELECT a FROM collate4t1 ORDER BY a}
106 INSERT INTO collate4t2 VALUES( 'a', 'a' );
112 cksort {SELECT a FROM collate4t2 ORDER BY a}
137 INSERT INTO collate4t3 VALUES( 'a', 'a' );
143 cksort {SELECT a FROM collate4t3 ORDER BY a}
164 INSERT INTO collate4t4 VALUES( 'a', 'a' );
204 INSERT INTO collate4t1 VALUES( 'a', 'a' );
395 SELECT a FROM collate4t1 WHERE a IN ('z', 'a');
[all …]
H A Dfilter1.test4 # a legal notice, here is a blessing:
33 SELECT sum(a) FILTER( WHERE a>9 ),
34 sum(a) FILTER( WHERE a>8 ),
35 sum(a) FILTER( WHERE a>7 ),
36 sum(a) FILTER( WHERE a>6 ),
37 sum(a) FILTER( WHERE a>5 ),
38 sum(a) FILTER( WHERE a>4 ),
39 sum(a) FILTER( WHERE a>3 ),
40 sum(a) FILTER( WHERE a>2 ),
41 sum(a) FILTER( WHERE a>1 ),
[all …]
H A Dwindow4.test4 # a legal notice, here is a blessing:
31 SELECT a, ntile(1) OVER (ORDER BY a) FROM t3
35 SELECT a, ntile(2) OVER (ORDER BY a) FROM t3
39 SELECT a, ntile(3) OVER (ORDER BY a) FROM t3
43 SELECT a, ntile(4) OVER (ORDER BY a) FROM t3
47 SELECT a, ntile(5) OVER (ORDER BY a) FROM t3
51 SELECT a, ntile(6) OVER (ORDER BY a) FROM t3
55 SELECT a, ntile(7) OVER (ORDER BY a) FROM t3
59 SELECT a, ntile(8) OVER (ORDER BY a) FROM t3
63 SELECT a, ntile(9) OVER (ORDER BY a) FROM t3
[all …]
H A DselectD.test4 # a legal notice, here is a blessing:
40 WHERE t4.a=t3.a+111
41 AND t3.a=t2.a+111
42 AND t2.a=t1.a+111;
50 ON t2.a=t1.a+111;
58 ON t2.a=t1.a+111;
66 ON t2.a=t1.a+111;
74 ON t2.a=t1.a+111;
135 ON t1.a=t3.a-111;
143 ON t1.a=t3.a-111;
[all …]
H A Dconflict3.test4 # a legal notice, here is a blessing:
36 SELECT a,b,c FROM t1 ORDER BY a;
43 SELECT a,b,c FROM t1 ORDER BY a;
53 SELECT a,b,c FROM t1 ORDER BY a;
66 SELECT a,b,c FROM t1 ORDER BY a;
73 SELECT a,b,c FROM t1 ORDER BY a;
83 SELECT a,b,c FROM t1 ORDER BY a;
96 SELECT a,b,c FROM t1 ORDER BY a;
103 SELECT a,b,c FROM t1 ORDER BY a;
113 SELECT a,b,c FROM t1 ORDER BY a;
[all …]
H A Dorderby6.test4 # a legal notice, here is a blessing:
25 # Construct a table with 1000 rows and a split primary key
42 SELECT b,a,c FROM t1 ORDER BY b,a,c;
43 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b,+a,+c}]
45 SELECT b,a,c FROM t1 ORDER BY b,c DESC,a;
46 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b,+c DESC,+a}]
48 SELECT b,a,c FROM t1 ORDER BY b DESC,c,a;
49 } [db eval {SELECT b,a,c FROM t1 ORDER BY +b DESC,+c,+a}]
51 SELECT b,a,c FROM t1 ORDER BY b DESC,a,c;
57 SELECT a FROM t1 ORDER BY b, a LIMIT 10 OFFSET 20;
[all …]
H A Dtkt-38cb5df375.test4 # a legal notice, here is a blessing:
47 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
56 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
93 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a LIMIT 3)
102 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a LIMIT 3)
131 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
141 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a)
172 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a LIMIT 3)
192 UNION ALL SELECT a FROM (SELECT a FROM t1 ORDER BY a LIMIT 5)
222 UNION SELECT a+10 FROM (SELECT a FROM t1 ORDER BY a LIMIT 2)
[all …]
H A DjoinE.test4 # a legal notice, here is a blessing:
39 SELECT a, b
49 SELECT a, b
57 SELECT a, b
65 SELECT a, b
73 SELECT a, b
81 SELECT a, b
91 SELECT a, b
99 SELECT a, b
108 SELECT a, b
[all …]
H A Dmisc1.test4 # a legal notice, here is a blessing:
144 UPDATE t2 SET a=a||a||a||a;
228 CREATE TABLE t5(a,b,c,PRIMARY KEY(a,b));
490 execsql {UPDATE t1 SET a=a||'x' WHERE 0}
494 execsql {UPDATE t1 SET a=a||'y' WHERE 1}
538 CREATE TABLE test(a integer, primary key(a));
543 CREATE TABLE test(a integer, primary key(a));
713 …a,b,c,d,e, PRIMARY KEY(a,b,c,d,c,a,b,b,c,d,c,a,b,c,e,c,d,c,a,b,b,c,d,c,a,b,c,e,d,d,c,a,b,b,c,d,c,d…
714 …a,b,b,c,a,b,c,e,d,d,c,a,b,b,c,d,d,c,a,b,c,e,d,c,d,c,a,b,c,e,c,d,c,d,c,a,b,b,c,d,c,a,b,c,e,c,d,c,a,…
746 INSERT INTO dup1(a,b,c,a,b,c) VALUES(1,2,3,4,5,6);
[all …]
H A Drowvalue.test4 # a legal notice, here is a blessing:
234 SELECT * FROM t11 WHERE (a,a)<=1;
237 SELECT * FROM t11 WHERE (a,a)<1;
240 SELECT * FROM t11 WHERE (a,a)>=1;
243 SELECT * FROM t11 WHERE (a,a)>1;
246 SELECT * FROM t11 WHERE (a,a)==1;
375 WHERE a = new.a-1;
398 ) WHERE a = new.a-1;
401 UPDATE t16c SET a=a WHERE a=3;
416 WHERE b2.x=b1.a AND (b1.a, 2)
[all …]
H A Din.test4 # a legal notice, here is a blessing:
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}
215 SELECT a FROM ta WHERE a IN (SELECT a FROM tb);
220 SELECT a FROM ta WHERE a NOT IN (SELECT a FROM tb);
238 SELECT a FROM t1 WHERE a IN ();
248 SELECT a FROM t1 WHERE a NOT IN () ORDER BY a;
661 SELECT a.id FROM t1 AS a JOIN t1 AS b ON a.id=b.id WHERE a.id IN (1,2,3);
728 WHERE a IN (SELECT a FROM x1 WHERE (a%2)==0)
[all …]
H A Dupsert5.test4 # a legal notice, here is a blessing:
33 ON CONFLICT(a) DO UPDATE SET b='a'
43 ON CONFLICT(a) DO UPDATE SET b='a'
53 ON CONFLICT(a) DO UPDATE SET b='a'
63 ON CONFLICT(a) DO UPDATE SET b='a'
74 ON CONFLICT(a) DO UPDATE SET b='a'
84 ON CONFLICT(a) DO UPDATE SET b='a'
94 ON CONFLICT(a) DO UPDATE SET b='a'
104 ON CONFLICT(a) DO UPDATE SET b='a'
114 ON CONFLICT(a) DO UPDATE SET b='a'
[all …]
/sqlite-3.40.0/ext/fts5/
H A Dfts5_varint.c28 a = *p; in sqlite3Fts5GetVarint32()
45 a = a<<7; in sqlite3Fts5GetVarint32()
52 a = a<<14; in sqlite3Fts5GetVarint32()
119 a = a<<7; in sqlite3Fts5GetVarint()
130 a = a<<14; in sqlite3Fts5GetVarint()
154 a = a<<7; in sqlite3Fts5GetVarint()
170 a = a<<14; in sqlite3Fts5GetVarint()
199 a = a<<7; in sqlite3Fts5GetVarint()
207 a = a<<14; in sqlite3Fts5GetVarint()
232 a = a<<7; in sqlite3Fts5GetVarint()
[all …]
/sqlite-3.40.0/mptest/
H A Dmultiwrite01.test176 ORDER BY t1.a LIMIT 4
180 ORDER BY t3.a LIMIT 7
186 ORDER BY t1.a LIMIT 4
190 ORDER BY t3.a LIMIT 7
196 ORDER BY t1.a LIMIT 4
200 ORDER BY t3.a LIMIT 7
206 ORDER BY t1.a LIMIT 4
210 ORDER BY t3.a LIMIT 7
216 ORDER BY t1.a LIMIT 4
220 ORDER BY t3.a LIMIT 7
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5colset.test4 # a legal notice, here is a blessing:
37 2 "{a} : a" {1}
38 3 "-{a} : a" {2 3 4}
39 4 "- {a c} : a" {2 4}
41 6 "- {d c b a} : a" {}
53 0 {{a} : (a AND ":")} {}
55 2 "{a b c} : (a AND b:d)" {3}
56 3 "{a b c} : (a AND d:d)" {}
58 5 "{a} : ( {b a} : ( {c b a} : ( {d b c a} : ( d OR c ) ) ) )" {2 3}
68 0 "a MATCH 'a'" {1}
[all …]
/sqlite-3.40.0/tool/
H A Dlogest.c41 LogEst logEstMultiply(LogEst a, LogEst b){ return a+b; } in logEstMultiply() argument
54 if( a<b ){ LogEst t = a; a = b; b = t; } in logEstAdd()
55 if( a>b+49 ) return a; in logEstAdd()
56 if( a>b+31 ) return a+1; in logEstAdd()
57 return a+x[a-b]; in logEstAdd()
131 a[n-2] = logEstAdd(a[n-2],a[n-1]); in main()
136 a[n-2] = logEstMultiply(a[n-2],a[n-1]); in main()
141 a[n] = a[n-1]; in main()
145 if( n>0 ) a[n-1] = logEstFromInteger(a[n-1]) - 33; in main()
149 if( n>0 ) a[n-1] = -a[n-1]; in main()
[all …]

12345678910>>...64