Home
last modified time | relevance | path

Searched refs:explain (Results 1 – 25 of 68) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dspeed1p.explain97 explain {INSERT INTO t1 VALUES($i,$r,$x)}
160 explain {CREATE INDEX i1a ON t1(a)}
161 explain {CREATE INDEX i1b ON t1(b)}
218 explain {SELECT c FROM t1 WHERE a=$id}
231 explain {SELECT c FROM t1 WHERE c=$c}
270 explain {UPDATE t1 SET b=$r WHERE a=$i}
277 explain {UPDATE t1 SET c=a}
302 explain {DELETE FROM t1}
312 explain {DELETE FROM t1 WHERE 1}
321 explain {DROP TABLE t1}
[all …]
H A Dspeed4p.explain20 # $Id: speed4p.explain,v 1.1 2008/04/16 12:57:48 drh Exp $
128 explain $sql
133 explain $sql
144 explain {SELECT * FROm v1 WHERE rowid=$v}
159 explain {SELECT * FROM t1 WHERE rowid=$v}
174 explain {
207 explain {INSERT INTO t4 VALUES(NULL, $ii, $name)}
222 explain {UPDATE t4 SET i = $ii2, t = $name WHERE rowid = $ii}
230 explain {DELETE FROM t4 WHERE rowid = $ii}
255 explain {INSERT INTO t4 VALUES(NULL, $ii, $name)}
[all …]
H A Dindexexpr2.test205 load_static_extension db explain
213 FROM sqlite_master, explain('UPDATE t2 SET b=b+1')
214 WHERE explain.opcode LIKE 'Open%'
215 AND sqlite_master.rootpage=explain.p2
220 FROM sqlite_master, explain('UPDATE t2 SET c=c+1')
221 WHERE explain.opcode LIKE 'Open%'
222 AND sqlite_master.rootpage=explain.p2
227 FROM sqlite_master, explain('UPDATE t2 SET c=c+1, f=NULL')
228 WHERE explain.opcode LIKE 'Open%'
229 AND sqlite_master.rootpage=explain.p2
H A Dshell1.test201 catchcmd "test.db" ".explain \"OFF"
204 catchcmd "test.db" ".explain \'OFF"
215 catchcmd "test.db" ".explain 1"
218 catchcmd "test.db" ".explain on"
224 catchcmd "test.db" ".explain \"OFF\""
230 catchcmd "test.db" ".explain \'OFF\'"
335 catchcmd "test.db" ".explain"
339 catchcmd "test.db" ".explain ON"
342 catchcmd "test.db" ".explain OFF"
346 catchcmd "test.db" ".explain OFF BAD"
[all …]
H A Dorderby5.test148 explain query plan
154 explain query plan
160 explain query plan
H A Dcapi3d.test109 do_test $testname.explain [format {
209 # Tests for the is-explain interface.
222 test_is_explain capi3d-2.52 { explain SELECT * FROM sqlite_master} 1
H A Dwhere6.test49 ifcapable explain {
99 ifcapable explain {
H A Dhaving.test45 db eval "explain $sql1" { lappend r1 $opcode $p1 $p2 $p3 $p4 $p5}
46 db eval "explain $sql2" { lappend r2 $opcode $p1 $p2 $p3 $p4 $p5}
H A Dtkt3461.test41 # explain { SELECT a, b+1 AS b_plus_one FROM t1 WHERE a=1 OR b_plus_one }
H A DmallocH.test53 ifcapable explain {
H A Dindex2.test67 ifcapable explain {
H A DselectG.test55 set n [llength [split [db eval "explain $sql"] \n]]
H A Dkeyword1.test50 explain
H A Drowvaluevtab.test46 db eval "explain $sql" {
H A Dmain.test188 ifcapable {explain} {
204 ifcapable {explain} {
H A DselectB.test26 db eval "explain $sql1" { lappend ::vdbe1 $opcode }
27 db eval "explain $sql2" { lappend ::vdbe2 $opcode }
H A Dintarray.test76 #explain {SELECT b FROM t1 WHERE a NOT IN ia3}
H A Dmultiplex4.test101 do_test multiplex4-1.9-explain {
H A Dtrigger7.test48 ifcapable explain {
H A Dpagesize.test30 ifcapable {explain} {
H A Dinterrupt.test96 ifcapable {explain} {
/sqlite-3.40.0/tool/
H A Drun-speed-test.sh54 --explain)
89 ./speedtest1 --explain $SPEEDTEST_OPTS | ./sqlite3 >explain-$NAME.txt
H A Dspeed-check.sh105 --explain)
205 ./speedtest1 --explain $SPEEDTEST_OPTS | ./sqlite3 >explain-$NAME.txt
/sqlite-3.40.0/ext/rtree/
H A Drtree6.test36 db eval "explain $sql" a {
46 db eval "explain query plan $sql" a {
/sqlite-3.40.0/src/
H A Dvdbeaux.c446 if( pParse->explain==2 ) in sqlite3VdbeExplain()
2246 int bListSubprogs = (p->explain==1 || (db->flags & SQLITE_TriggerEQP)!=0); in sqlite3VdbeList()
2250 assert( p->explain ); in sqlite3VdbeList()
2280 rc = sqlite3VdbeNextOpcode(p, pSub, p->explain==2, &p->pc, &i, &aOp); in sqlite3VdbeList()
2290 if( p->explain==2 ){ in sqlite3VdbeList()
2527 if( pParse->explain ){ in sqlite3VdbeMakeReady()
2534 p->explain = pParse->explain; in sqlite3VdbeMakeReady()
2535 if( pParse->explain==2 ){ in sqlite3VdbeMakeReady()

123