| /sqlite-3.40.0/test/ |
| H A D | cursorhint.test | 35 # Run EXPLAIN on $sql. Return a list of P4 values for all $opcode 38 proc p4_of_opcode {db opcode sql} { 41 if {$x(opcode)==$opcode} {lappend res $x(p4)} 46 # Run EXPLAIN on $sql. Return a list of P5 values for all $opcode 49 proc p5_of_opcode {db opcode sql} { 52 if {$x(opcode)==$opcode} {
|
| H A D | distinct.test | 33 if {$opcode != "Noop" && $opcode != "Explain"} { lappend program1 $opcode } 36 if {$opcode != "Noop" && $opcode != "Explain"} { lappend program2 $opcode } 52 if {$opcode == "OpenEphemeral" || $opcode == "SorterOpen"} {
|
| H A D | tester.tcl | 1451 $addr $opcode $p1 $p2 $p3 $p4 $p5 $comment 1479 foreach opcode { 1484 set color($opcode) $B 1486 foreach opcode {ResultRow} { 1487 set color($opcode) $G 1489 foreach opcode {IdxInsert Insert Delete IdxDelete} { 1490 set color($opcode) $R 1496 set op($addr) $opcode 1518 if {$opcode == "Goto" && $p2<$addr && $op($p2)=="Yield"} { 1542 catch { set col $color($opcode) } [all …]
|
| H A D | insert5.test | 26 # includes the opcode OpenEphemeral. An "INSERT INTO ... SELECT" 27 # statement includes such an opcode if a temp-table is used
|
| H A D | tkt2251.test | 16 # Long ago, the OP_Column opcode was sufficient to pull out the 19 # and so the OP_Column opcode has to contain a default value. Later
|
| H A D | indexexpr2.test | 214 WHERE explain.opcode LIKE 'Open%' 221 WHERE explain.opcode LIKE 'Open%' 228 WHERE explain.opcode LIKE 'Open%'
|
| H A D | fordelete.test | 44 if {$R(opcode)=="OpenWrite"} { 60 if {$R(opcode) == "Delete"} {
|
| H A D | having.test | 45 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 D | tkt-f67b41381a.test | 52 if {$opcode == "Column"} { set res 0 }
|
| H A D | triggerG.test | 24 # The OP_Once opcode was not working correctly for recursive triggers.
|
| H A D | rowvaluevtab.test | 47 if {$opcode=="VFilter"} {
|
| H A D | tkt-2a5629202f.test | 19 # opcode was executed. If an OP_Sort did occur, then "sort" is appended
|
| H A D | selectB.test | 26 db eval "explain $sql1" { lappend ::vdbe1 $opcode } 27 db eval "explain $sql2" { lappend ::vdbe2 $opcode }
|
| H A D | index9.test | 22 if {$a(opcode)=="OpenRead"} { set ::T($a(p2)) 1 }
|
| H A D | collate9.test | 27 # opcode was executed. If an OP_Sort did occur, then "sort" is appended
|
| H A D | cursorhint2.test | 34 switch -- $a(opcode) {
|
| /sqlite-3.40.0/src/ |
| H A D | vdbe.c | 2270 assert( aOp[iAddr].opcode==OP_Lt || aOp[iAddr].opcode==OP_Gt ); in sqlite3VdbeExec() 4169 assert( pOp->opcode==OP_OpenRead || pOp->opcode==OP_ReopenIdx in sqlite3VdbeExec() 4697 assert( pOp->opcode==OP_SeekGE || pOp->opcode==OP_SeekLE ); in sqlite3VdbeExec() 4699 assert( pOp->opcode==OP_SeekGE || pOp[1].opcode==OP_IdxLT ); in sqlite3VdbeExec() 4700 assert( pOp->opcode==OP_SeekLE || pOp[1].opcode==OP_IdxGT ); in sqlite3VdbeExec() 4790 assert( pOp[1].opcode==OP_IdxLT || pOp[1].opcode==OP_IdxGT ); in sqlite3VdbeExec() 6557 assert( pOp->opcode==OP_IdxLE || pOp->opcode==OP_IdxGT ); in sqlite3VdbeExec() 6560 assert( pOp->opcode==OP_IdxGE || pOp->opcode==OP_IdxLT ); in sqlite3VdbeExec() 6600 assert( pOp->opcode==OP_IdxLE || pOp->opcode==OP_IdxLT ); in sqlite3VdbeExec() 6603 assert( pOp->opcode==OP_IdxGE || pOp->opcode==OP_IdxGT ); in sqlite3VdbeExec() [all …]
|
| H A D | vdbeaux.c | 255 pOp->opcode = (u8)op; in sqlite3VdbeAddOp3() 722 int opcode = pOp->opcode; in sqlite3VdbeAssertMayAbort() local 723 if( opcode==OP_Destroy || opcode==OP_VUpdate || opcode==OP_VRename in sqlite3VdbeAssertMayAbort() 724 || opcode==OP_VDestroy in sqlite3VdbeAssertMayAbort() 725 || opcode==OP_VCreate in sqlite3VdbeAssertMayAbort() 726 || opcode==OP_ParseSchema in sqlite3VdbeAssertMayAbort() 727 || opcode==OP_Function || opcode==OP_PureFunc in sqlite3VdbeAssertMayAbort() 728 || ((opcode==OP_Halt || opcode==OP_HaltIfNull) in sqlite3VdbeAssertMayAbort() 829 switch( pOp->opcode ){ in resolveP2Values() 1076 pOut->opcode = aOp->opcode; in sqlite3VdbeAddOpList() [all …]
|
| H A D | insert.c | 31 int opcode /* OP_OpenRead or OP_OpenWrite */ in sqlite3OpenTable() argument 37 assert( opcode==OP_OpenWrite || opcode==OP_OpenRead ); in sqlite3OpenTable() 39 (opcode==OP_OpenWrite)?1:0, pTab->zName); in sqlite3OpenTable() 47 sqlite3VdbeAddOp3(v, opcode, iCur, pPk->tnum, iDb); in sqlite3OpenTable() 188 pPrev->opcode = OP_TypeCheck; in sqlite3TableAffinity() 212 assert( sqlite3VdbeGetLastOp(v)->opcode==OP_MakeRecord in sqlite3TableAffinity() 236 if( pOp->opcode==OP_OpenRead && pOp->p3==iDb ){ in readsTable() 249 if( pOp->opcode==OP_VOpen && pOp->p4.pVtab==pVTab ){ in readsTable() 299 if( pOp->opcode==OP_Affinity ){ in sqlite3ComputeGeneratedColumns() 316 }else if( pOp->opcode==OP_TypeCheck ){ in sqlite3ComputeGeneratedColumns() [all …]
|
| H A D | vdbevtab.c | 239 sqlite3_result_text(ctx, (char*)sqlite3OpcodeName(pOp->opcode), in bytecodevtabColumn() 270 assert( aOp[0].opcode==OP_Init ); in bytecodevtabColumn() 291 sqlite3_result_int(ctx, pOp->opcode==OP_OpenWrite); in bytecodevtabColumn()
|
| H A D | vdbeblob.c | 71 assert( v->aOp[v->pc].opcode==OP_NotExists ); in blobSeekToRow() 293 aOp[0].opcode = OP_Noop; in sqlite3_blob_open() 305 if( wrFlag ) aOp[1].opcode = OP_OpenWrite; in sqlite3_blob_open()
|
| H A D | vdbe.h | 42 u8 opcode; /* What operation to perform */ member 100 u8 opcode; /* What operation to perform */ member
|
| H A D | where.c | 680 if( pOp->opcode==OP_Column ){ in translateColumnToCopy() 681 pOp->opcode = OP_Copy; in translateColumnToCopy() 686 }else if( pOp->opcode==OP_Rowid ){ in translateColumnToCopy() 687 pOp->opcode = OP_Sequence; in translateColumnToCopy() 691 pOp->opcode = OP_Null; in translateColumnToCopy() 6240 if( pOp->opcode==OP_Close ) return 0; in cursorIsOpen() 6503 }else if( pOp->opcode==OP_Column in sqlite3WhereEnd() 6505 || pOp->opcode==OP_Offset in sqlite3WhereEnd() 6511 if( pOp->opcode==OP_Offset ){ in sqlite3WhereEnd() 6536 || pOp->opcode==OP_Offset in sqlite3WhereEnd() [all …]
|
| H A D | wherecode.c | 898 assert( pOp->opcode==OP_String8 in whereLikeOptimizationStringFixup() 1485 if( (pOp->opcode==OP_Column && pOp->p3==iReg+j+2) in sqlite3WhereCodeOneLoopStart() 1486 || (pOp->opcode==OP_Rowid && pOp->p2==iReg+j+2) in sqlite3WhereCodeOneLoopStart() 1488 testcase( pOp->opcode==OP_Rowid ); in sqlite3WhereCodeOneLoopStart() 1489 sqlite3VdbeAddOp3(v, pOp->opcode, pOp->p1, pOp->p2, pOp->p3); in sqlite3WhereCodeOneLoopStart()
|
| /sqlite-3.40.0/ |
| H A D | README.md | 187 opcode-number to opcode-name that is used for EXPLAIN output. 235 the [virtual machine](http://www.sqlite.org/opcode.html) that runs
|