Home
last modified time | relevance | path

Searched refs:EXPLAIN (Results 1 – 25 of 107) sorted by relevance

12345

/sqlite-3.40.0/test/
H A DanalyzeE.test37 EXPLAIN QUERY PLAN
41 EXPLAIN QUERY PLAN
45 EXPLAIN QUERY PLAN
49 EXPLAIN QUERY PLAN
53 EXPLAIN QUERY PLAN
57 EXPLAIN QUERY PLAN
61 EXPLAIN QUERY PLAN
65 EXPLAIN QUERY PLAN
69 EXPLAIN QUERY PLAN
73 EXPLAIN QUERY PLAN
[all …]
H A Dorderby5.test28 EXPLAIN QUERY PLAN
32 EXPLAIN QUERY PLAN
36 EXPLAIN QUERY PLAN
40 EXPLAIN QUERY PLAN
44 EXPLAIN QUERY PLAN
48 EXPLAIN QUERY PLAN
52 EXPLAIN QUERY PLAN
56 EXPLAIN QUERY PLAN
60 EXPLAIN QUERY PLAN
64 EXPLAIN QUERY PLAN
[all …]
H A Danalyze7.test38 EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=123;
42 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=123;}
45 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=2;}
55 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=123;}
58 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=123;}
61 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=2;}
77 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE a=123;}
80 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE b=123;}
83 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=?;}
89 execsql {EXPLAIN QUERY PLAN SELECT * FROM t1 WHERE c=2;}
[all …]
H A DwhereH.test25 EXPLAIN QUERY PLAN
29 EXPLAIN QUERY PLAN
39 EXPLAIN QUERY PLAN
43 EXPLAIN QUERY PLAN
54 EXPLAIN QUERY PLAN
58 EXPLAIN QUERY PLAN
69 EXPLAIN QUERY PLAN
73 EXPLAIN QUERY PLAN
84 EXPLAIN QUERY PLAN
88 EXPLAIN QUERY PLAN
[all …]
H A Dskipscan1.test45 EXPLAIN QUERY PLAN
49 EXPLAIN QUERY PLAN
57 EXPLAIN QUERY PLAN
61 EXPLAIN QUERY PLAN
69 EXPLAIN QUERY PLAN
73 EXPLAIN QUERY PLAN
81 EXPLAIN QUERY PLAN
85 EXPLAIN QUERY PLAN
93 EXPLAIN QUERY PLAN
97 EXPLAIN QUERY PLAN
[all …]
H A DanalyzeC.test44 EXPLAIN QUERY PLAN
51 EXPLAIN QUERY PLAN
55 EXPLAIN QUERY PLAN
68 EXPLAIN QUERY PLAN
75 EXPLAIN QUERY PLAN
79 EXPLAIN QUERY PLAN
92 EXPLAIN QUERY PLAN
99 EXPLAIN QUERY PLAN
103 EXPLAIN QUERY PLAN
120 EXPLAIN QUERY PLAN
[all …]
H A Dorderby1.test59 EXPLAIN QUERY PLAN
77 EXPLAIN QUERY PLAN
93 EXPLAIN QUERY PLAN
114 EXPLAIN QUERY PLAN
131 EXPLAIN QUERY PLAN
150 EXPLAIN QUERY PLAN
196 EXPLAIN QUERY PLAN
208 EXPLAIN QUERY PLAN
226 EXPLAIN QUERY PLAN
242 EXPLAIN QUERY PLAN
[all …]
H A Dtrigger7.test58 set txt [db eval {EXPLAIN UPDATE t1 SET x=5}]
62 set txt [db eval {EXPLAIN UPDATE t1 SET x=5}]
66 set txt [db eval {EXPLAIN UPDATE t1 SET y=5}]
70 set txt [db eval {EXPLAIN UPDATE t1 SET y=5}]
74 set txt [db eval {EXPLAIN UPDATE t1 SET rowid=5}]
78 set txt [db eval {EXPLAIN UPDATE t1 SET rowid=5}]
H A DwhereK.test34 EXPLAIN QUERY PLAN
42 EXPLAIN QUERY PLAN
50 EXPLAIN QUERY PLAN
58 EXPLAIN QUERY PLAN
67 EXPLAIN QUERY PLAN
H A Dindexexpr1.test34 EXPLAIN QUERY PLAN
41 EXPLAIN QUERY PLAN
50 EXPLAIN QUERY PLAN
62 EXPLAIN QUERY PLAN
73 EXPLAIN QUERY PLAN
100 EXPLAIN QUERY PLAN
107 EXPLAIN QUERY PLAN
127 EXPLAIN QUERY PLAN
134 EXPLAIN QUERY PLAN
143 EXPLAIN QUERY PLAN
[all …]
H A Dindex6.test158 EXPLAIN QUERY PLAN
166 EXPLAIN QUERY PLAN
173 EXPLAIN QUERY PLAN
180 EXPLAIN QUERY PLAN
196 EXPLAIN QUERY PLAN
203 EXPLAIN QUERY PLAN
210 EXPLAIN QUERY PLAN
298 EXPLAIN QUERY PLAN
365 EXPLAIN QUERY PLAN
372 EXPLAIN QUERY PLAN
[all …]
H A Dindex7.test114 EXPLAIN QUERY PLAN
202 EXPLAIN QUERY PLAN
209 EXPLAIN QUERY PLAN
216 EXPLAIN QUERY PLAN
223 EXPLAIN QUERY PLAN
239 EXPLAIN QUERY PLAN
246 EXPLAIN QUERY PLAN
253 EXPLAIN QUERY PLAN
351 EXPLAIN QUERY PLAN SELECT 1 FROM t1 WHERE y=5;
H A Dfunc3.test122 db eval {EXPLAIN SELECT likelihood(min(1.0+'2.0',4*11), 0.5)}
123 } [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
153 db eval {EXPLAIN SELECT unlikely(min(1.0+'2.0',4*11))}
154 } [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
197 db eval {EXPLAIN SELECT likely(min(1.0+'2.0',4*11))}
198 } [db eval {EXPLAIN SELECT min(1.0+'2.0',4*11)}]
H A Dautoindex3.test39 EXPLAIN QUERY PLAN SELECT * FROM t1, t2 WHERE d=b;
46 EXPLAIN QUERY PLAN SELECT * FROM t1, t2 WHERE d>b AND x=y;
49 EXPLAIN QUERY PLAN SELECT * FROM t1, t2 WHERE d<b AND x=y;
52 EXPLAIN QUERY PLAN SELECT * FROM t1, t2 WHERE d IS NULL AND x=y;
55 EXPLAIN QUERY PLAN SELECT * FROM t1, t2 WHERE d IN (5,b) AND x=y;
H A Dmisc3.test247 # Ticket #626: make sure EXPLAIN prevents BEGIN and COMMIT from working.
250 execsql {EXPLAIN BEGIN}
254 execsql {EXPLAIN COMMIT}
258 execsql {BEGIN; EXPLAIN ROLLBACK}
262 # Do some additional EXPLAIN operations to exercise the displayP4 logic.
271 EXPLAIN REINDEX;
282 EXPLAIN SELECT a+123456789012, b*4.5678, c FROM ex1 ORDER BY +a, b DESC
291 EXPLAIN SELECT a+123456789012, b*4.5678, c FROM ex1 ORDER BY +a, b DESC
H A DwhereE.test55 EXPLAIN QUERY PLAN SELECT x FROM t1, t2 WHERE a=z AND c=x;
58 EXPLAIN QUERY PLAN SELECT x FROM t2, t1 WHERE a=z AND c=x;
62 EXPLAIN QUERY PLAN SELECT x FROM t1, t2 WHERE a=z AND c=x;
65 EXPLAIN QUERY PLAN SELECT x FROM t2, t1 WHERE a=z AND c=x;
H A Dskipscan3.test33 EXPLAIN QUERY PLAN SELECT d FROM t1 WHERE +a=1 AND c=32;
43 EXPLAIN QUERY PLAN SELECT d FROM t1 WHERE a=1 AND c=32;
60 EXPLAIN QUERY PLAN SELECT d FROM t2 WHERE +a=1 AND c=32;
66 EXPLAIN QUERY PLAN SELECT d FROM t2 WHERE a=1 AND c=32;
H A Din5.test60 EXPLAIN SELECT d FROM t2 WHERE a IN t1x AND b IN t1y AND c IN t1z
70 EXPLAIN SELECT d FROM t2 WHERE a IN t3x AND b IN t1y AND c IN t1z
75 EXPLAIN SELECT d FROM t2 WHERE a IN t1x AND b IN t3y AND c IN t1z
80 EXPLAIN SELECT d FROM t2 WHERE a IN t1x AND b IN t1y AND c IN t3z
98 EXPLAIN SELECT d FROM t2 WHERE a IN t1x AND b IN t1y AND c IN t1z
116 EXPLAIN SELECT d FROM t2 WHERE a IN t1x AND b IN t1y AND c IN t1z
135 EXPLAIN SELECT d FROM t2 WHERE a IN t1x AND b IN t1y AND c IN t1z
H A Deqp.test500 # sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1;
509 # sqlite> EXPLAIN QUERY PLAN SELECT a, b FROM t1 WHERE a=1;
517 # XVIDENCE-OF: R-09991-48941 sqlite> EXPLAIN QUERY PLAN
528 # XVIDENCE-OF: R-33626-61085 sqlite> EXPLAIN QUERY PLAN
549 # XVIDENCE-OF: R-24577-38891 sqlite> EXPLAIN QUERY PLAN
560 # sqlite> EXPLAIN QUERY PLAN SELECT c, d FROM t2 ORDER BY c;
568 # XVIDENCE-OF: R-13931-10421 sqlite> EXPLAIN QUERY PLAN SELECT
586 # XVIDENCE-OF: R-50892-45943 sqlite> EXPLAIN QUERY PLAN
600 # XVIDENCE-OF: R-46219-33846 sqlite> EXPLAIN QUERY PLAN
610 # XVIDENCE-OF: R-37879-39987 sqlite> EXPLAIN QUERY PLAN
[all …]
H A Dtkt-78e04e52ea.test44 db eval {EXPLAIN QUERY PLAN SELECT "" FROM "" WHERE "" LIKE '1e5%';}
56 EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE x=5;
62 EXPLAIN QUERY PLAN SELECT * FROM t2 WHERE x=2;
H A Dcapi3d.test104 # EVIDENCE-OF: R-61212-30018 If prepared statement X is an EXPLAIN or
105 # EXPLAIN QUERY PLAN statement, then sqlite3_stmt_readonly(X) returns
106 # the same value as if the EXPLAIN or EXPLAIN QUERY PLAN prefix were
111 set STMT [sqlite3_prepare $DB {EXPLAIN %s} -1 TAIL]
118 set STMT [sqlite3_prepare $DB {EXPLAIN QUERY PLAN %s} -1 TAIL]
H A DmallocH.test51 # Malloc failures during EXPLAIN.
57 EXPLAIN SELECT * FROM abc AS t2 WHERE rowid=1;
58 EXPLAIN QUERY PLAN SELECT * FROM abc AS t2 WHERE rowid=1;
H A Din4.test199 EXPLAIN QUERY PLAN
210 EXPLAIN QUERY PLAN
224 EXPLAIN
234 # EXPLAIN
241 EXPLAIN
248 EXPLAIN
331 EXPLAIN QUERY PLAN
338 EXPLAIN QUERY PLAN
466 EXPLAIN SELECT * FROM t1
H A Dwithout_rowid6.test65 EXPLAIN QUERY PLAN
84 EXPLAIN QUERY PLAN
102 EXPLAIN QUERY PLAN
122 EXPLAIN QUERY PLAN
H A Dcursorhint.test35 # Run EXPLAIN on $sql. Return a list of P4 values for all $opcode
40 $db eval "EXPLAIN $sql" x {
46 # Run EXPLAIN on $sql. Return a list of P5 values for all $opcode
51 $db eval "EXPLAIN $sql" x {

12345