Home
last modified time | relevance | path

Searched refs:B (Results 1 – 25 of 218) sorted by relevance

123456789

/sqlite-3.40.0/test/
H A Dcontrib01.test26 CREATE TABLE T1 (B INTEGER NOT NULL,
33 PRIMARY KEY (B, C, D));
36 B INTEGER NOT NULL,
38 PRIMARY KEY (A, B, C));
40 INSERT INTO T2(A, B, C) VALUES(702118,16183,15527);
41 INSERT INTO T2(A, B, C) VALUES(702118,16183,15560);
42 INSERT INTO T2(A, B, C) VALUES(702118,16183,15561);
43 INSERT INTO T2(A, B, C) VALUES(702118,16183,15563);
44 INSERT INTO T2(A, B, C) VALUES(702118,16183,15564);
73 WHERE T1.B = T2.B
[all …]
H A Dfts3offsets.test50 INSERT INTO xx VALUES('A B C x B x x C');
57 2 {(A) (B) (C) x (B) x x C}
80 INSERT INTO xx(rowid, x) VALUES(4, 'A B C x x x x x x x B');
88 1 {(A) (B) (C)}
90 3 {(A) (B) (C)}
91 4 {(A) (B) (C) x x x x x x x B}
94 7 {(A) (B) (C)}
103 INSERT INTO xx(rowid, x) VALUES(4, 'A B C x x x x x x x B');
112 7 {(A) (B) (C)}
114 5 {(A) (B) (C)}
[all …]
H A Dbackup.test79 } {B}
81 B finish
92 } {B}
94 B step 200
97 B finish
353 B finish
406 } {B}
419 } {B}
455 } {B}
676 list [B remaining] [B pagecount]
[all …]
H A Dtkt-a7debbe0.test32 CREATE VIEW v2(a, B) AS
33 SELECT 'a', 'B' COLLATE NOCASE FROM t0;
34 CREATE TABLE t2(a, B COLLATE NOCASE);
35 INSERT INTO t2 VALUES('a', 'B');
36 CREATE VIEW v3(a, B) AS
37 SELECT 'a' COLLATE BINARY, 'B' COLLATE NOCASE FROM t0;
39 CREATE VIEW v4(a, B) AS
40 SELECT 'a', +CAST('B' COLLATE NOCASE AS TEXT) FROM t0;
42 CREATE VIEW v5(a, B) AS
43 SELECT 'a', ('B' COLLATE NOCASE) || '' FROM t0;
[all …]
H A De_blobopen.test82 sqlite3_blob_close $B
166 sqlite3_blob_close $B
193 global B
194 set B "0x1234"
230 expr {$B == "0"}
325 sqlite3_blob_close $B
385 sqlite3_blob_close $B
402 sqlite3_blob_close $B
419 sqlite3_blob_close $B
436 sqlite3_blob_close $B
[all …]
H A Dcollate4.test75 INSERT INTO collate4t1 VALUES( 'B', 'B' );
108 INSERT INTO collate4t2 VALUES( 'B', 'B' );
119 } {{} B a sort}
128 } {{} a B sort}
139 INSERT INTO collate4t3 VALUES( 'B', 'B' );
150 } {{} B a sort}
159 } {{} a B sort}
167 INSERT INTO collate4t4 VALUES( 'B', 'B' );
207 INSERT INTO collate4t1 VALUES( 'B', 'B' );
240 INSERT INTO collate4t2 VALUES( 'B', 'B' );
[all …]
H A De_blobwrite.test40 sqlite3_blob_open db main t1 t $id 1 B
54 sqlite3_blob_close $B
108 sqlite3_blob_open db main t2 a 43 0 B
111 sqlite3_blob_close $B
116 sqlite3_blob_open db main t2 a 44 3 B
134 sqlite3_blob_close $B
151 sqlite3_blob_close $B
172 sqlite3_blob_open db main t3 j 1 1 B
182 sqlite3_blob_close $B
189 sqlite3_blob_open db main t3 j 2 1 B
[all …]
H A Dthread2.test49 thread_swap A B
66 thread_result B
69 thread_step B
70 thread_result B
73 thread_argv B 0
77 thread_result B
83 thread_swap A B
100 thread_result B
103 thread_step B
104 thread_result B
[all …]
H A Dorderby5.test30 } {~/B-TREE/}
34 } {~/B-TREE/}
38 } {/B-TREE/}
42 } {/B-TREE/}
46 } {~/B-TREE/}
50 } {~/B-TREE/}
54 } {~/B-TREE/}
58 } {~/B-TREE/}
66 } {/B-TREE/}
87 } {/B-TREE/}
[all …]
H A Dthread1.test45 # read-lock B
47 # unlock B
68 thread_step B
69 thread_result B
72 thread_argc B
75 thread_argv B 0
82 thread_finalize B
83 thread_result B
125 thread_step B
126 thread_result B
[all …]
H A DselectA.test323 } {{} 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}
431 } {1 a a 9.9 b B {} C c}
[all …]
H A Dfts3first.test52 INSERT INTO x1(docid,a,b,c) VALUES(11, 'T E R Q B', 'C I B C B', 'F Z U W R');
57 INSERT INTO x1(docid,a,b,c) VALUES(16, 'Q G C G H', 'H N N B H', 'B Q I H Y');
58 INSERT INTO x1(docid,a,b,c) VALUES(17, 'Q T S K B', 'W B D Y N', 'V J P E C');
100 1 {^K} {{[K] H D S T} {[K] N J L W} {[K] H A B L}}
101 2 {^X} {{[X] Y D L S} {[X] J P K R} {[X] S B X Y}}
148 INSERT INTO x3 VALUES('A B C');
149 INSERT INTO x3 VALUES('B A C');
152 INSERT INTO x4 VALUES('A B C');
153 INSERT INTO x4 VALUES('B A C');
158 } {{A B C} {B A C}}
[all …]
H A Dtkt-80ba201079.test34 } {A B}
42 } {A B}
51 } {A B}
159 } {A B C D E}
165 } {A B C D E}
171 (b='B' AND c IN (SELECT 'B' UNION SELECT 'C' UNION SELECT 'D'))
172 } {A B C D E}
179 } {A B C D E}
185 } {A B C D E}
190 (b='B' AND c IN (SELECT 'B' UNION SELECT 'C' UNION SELECT 'D')) OR
[all …]
H A Dserver1.test63 # read-lock B
65 # unlock B
84 client_step B
85 client_result B
88 client_argc B
91 client_argv B 0
98 client_finalize B
99 client_result B
132 client_step B
133 client_result B
[all …]
H A Deqp.test76 `--USE TEMP B-TREE FOR ORDER BY
89 |--USE TEMP B-TREE FOR GROUP BY
90 `--USE TEMP B-TREE FOR DISTINCT
190 |--USE TEMP B-TREE FOR GROUP BY
191 |--USE TEMP B-TREE FOR DISTINCT
192 `--USE TEMP B-TREE FOR ORDER BY
197 |--USE TEMP B-TREE FOR DISTINCT
198 `--USE TEMP B-TREE FOR ORDER BY
450 `--UNION USING TEMP B-TREE
461 |--UNION USING TEMP B-TREE
[all …]
H A Dwindowpushd.test64 INSERT INTO t1 VALUES('B', 'D', 5, 0.5);
65 INSERT INTO t1 VALUES('B', 'E', 6, 0.6);
66 INSERT INTO t1 VALUES('B', 'C', 7, 0.7);
67 INSERT INTO t1 VALUES('B', 'D', 8, 0.8);
106 B 5 8 B 6 8 B 7 8 B 8 8
111 SELECT * FROM v1 WHERE a IN ('A', 'B');
114 B 5 8 B 6 8 B 7 8 B 8 8
125 SELECT * FROM v1 WHERE a IN ('A', 'B');
137 B 5 8 5 B 6 8 6 B 7 8 7 B 8 8 8
H A Dinsert5.test40 CREATE TABLE B(Id INTEGER, Id1 INTEGER);
41 CREATE VIEW v1 AS SELECT * FROM B;
44 INSERT INTO B(Id,Id1) VALUES(2,3);
53 INSERT INTO B
54 SELECT * FROM B UNION ALL
55 SELECT * FROM MAIN WHERE exists (select * FROM B WHERE B.Id = MAIN.Id);
56 SELECT * FROM B;
62 INSERT INTO B SELECT * FROM B;
63 INSERT INTO B
64 SELECT * FROM MAIN WHERE exists (select * FROM B WHERE B.Id = MAIN.Id);
[all …]
H A Drowvaluefault.test23 INSERT INTO xyz VALUES('B', 'B', 'B', 2);
31 execsql { SELECT fou FROM xyz WHERE (one, two, thr) = ('B', 'B', 'B') }
43 execsql { SELECT fou FROM xyz WHERE (one, two, thr) > ('B', 'B', 'B') }
66 WHERE (one, two, thr) BETWEEN ('B', 'B', 'B') AND ('C', 'C', 'C') }
H A Dtkt-4c86b126f2.test28 INSERT INTO nodes VALUES('A/B',NULL);
30 INSERT INTO nodes VALUES('A/B/C-move',NULL);
31 INSERT INTO nodes VALUES('A/B/C','A/B/C-move');
32 INSERT INTO nodes VALUES('A/B-move',NULL);
33 INSERT INTO nodes VALUES('A/B-move/C-move',NULL);
34 INSERT INTO nodes VALUES('A/B-move/C','x');
37 WHERE (local_relpath = 'A/B' OR
38 ((local_relpath > 'A/B/') AND (local_relpath < 'A/B0')))
40 } {A/B/C A/B/C-move}
H A Dwalbak.test138 B step 50
140 list [B step 1000] [B finish]
151 B step 50
159 B step 1000
163 list [B step 1000] [B finish]
174 B step 50
182 B step 1000
187 list [B step 1000] [B finish]
259 B step 10000
260 B finish
[all …]
H A DwindowA.test27 (2, 'B', 5.55),
45 2 B 5.55 CBA \
63 2 B 5.55 CBA \
77 2 B 5.55 CBANN \
95 2 B 5.55 CBA \
109 2 B 5.55 CB \
127 2 B 5.55 CB \
141 2 B 5.55 EDCBA \
173 2 B 5.55 EDCBANN \
191 2 B 5.55 NNEDCBA \
[all …]
H A Dfts4content.test97 INSERT INTO t2 VALUES('P W I N J H I I N I F B K D U Q B Z S F'); -- 3
132 5 {"B Y D"} {17}
146 3 {"B Y D"} {{}}
225 INSERT INTO ft3(rowid, x, y) VALUES(15, 'P E B M V', 'E A A B U');
276 INSERT INTO t3(rowid, x, y) VALUES(15, 'P E B M V', 'E A A B U');
330 } {0 X'05182B'}
335 } {0 X'05182B'}
417 INSERT INTO t7 VALUES('A B', 'B A');
421 {A B} {B A} {C D} {A A}
442 INSERT INTO t7 VALUES('A B', 'B A');
[all …]
H A Dbackup_malloc.test44 set rc [catch {sqlite3_backup B db2 main db main}]
51 set rc [B step 50]
62 set rc [B step 5000]
68 B finish
70 catch { B finish }
77 set rc [catch {sqlite3_backup B db2 temp db main}]
83 catch { B finish }
103 sqlite3_backup B db2 main db main
106 set rc [B step 50]
116 catch { B finish }
H A Dfts4docid.test29 0 {F N K B T I K V B A} 1 {D M J E S P H E L O}
30 2 {W U T Q T Q T L H G} 3 {D W H M B R S Z B K}
31 4 {F Q I N P Q J L Z D} 5 {J O Q E Y A O E L B}
33 8 {L K J W G D Y W B M} 9 {K E Y I A Q R Q T S}
35 12 {B Y Q T J X C L L J} 13 {Q D C U U A Q E Z U}
41 24 {F V X E B C N B K W} 25 {E B A Y N N T Z I C}
42 26 {G E E B C P U D H G} 27 {J D J K N S B Q T M}
/sqlite-3.40.0/ext/rtree/
H A Drtreefuzz001.test201 | 688: 00 00 00 00 42 c8 00 00 42 4c 00 00 42 00 00 00 ....B...BL..B...
297 | 688: 00 00 00 00 42 c8 00 00 42 4c 00 00 42 00 00 00 ....B...BL..B...
535 | 2928: 42 b4 00 00 42 c8 00 00 00 00 00 00 41 20 00 00 B...B.......A ..
536 | 2944: 00 00 00 00 00 00 00 04 42 b4 00 00 42 c8 00 00 ........B...B...
537 | 2960: 42 b4 00 00 42 c8 00 00 00 00 00 00 00 00 00 05 B...B...........
538 | 2976: 42 20 00 00 42 70 00 00 42 20 00 00 42 70 00 00 B ..Bp..B ..Bp..
540 | 3008: 00 00 00 42 c8 00 00 00 00 00 00 00 00 00 07 42 ...B...........B
541 | 3024: be 00 00 42 c8 00 00 00 00 00 00 42 c8 00 00 00 ...B.......B....
544 | 3072: 00 00 00 42 c8 00 00 42 be 00 00 42 c8 00 00 00 ...B...B...B....
736 | 2912: 42 be 00 00 42 c8 00 00 00 00 00 00 42 c8 00 00 B...B.......B...
[all …]

123456789