Home
last modified time | relevance | path

Searched refs:p3 (Results 1 – 21 of 21) sorted by relevance

/sqlite-3.40.0/test/
H A Dfkey5.test36 CREATE TABLE p3(a TEXT PRIMARY KEY);
52 CREATE TABLE c7(x INT references p3);
56 CREATE TABLE c11(x TEXT UNIQUE references p3);
212 } {c3 65 p3 0 c3 68 p3 0}
217 } {c3 65 p3 0 c3 68 p3 0}
225 } {c7 1 p3 0 c7 3 p3 0 c7 4 p3 0 c7 6 p3 0}
230 } {c7 1 p3 0 c7 3 p3 0 c7 4 p3 0 c7 6 p3 0}
237 } {c11 1 p3 0 c11 3 p3 0 c11 4 p3 0 c11 6 p3 0}
242 } {c11 1 p3 0 c11 3 p3 0 c11 4 p3 0 c11 6 p3 0}
293 } {{c13 1 0 p3} {c13 2 0 p3} {c13 3 0 p3} {c13 4 0 p3} {c13 5 0 p3} {c13 6 0 p3} {c14 1 0 p4} {c14 …
[all …]
H A Dfkey8.test150 CREATE TABLE p3(a PRIMARY KEY, b) WITHOUT ROWID;
151 CREATE TABLE c3(x REFERENCES p3);
153 INSERT INTO p3 VALUES(1, 'one');
154 INSERT INTO p3 VALUES(2, 'two');
158 CREATE TRIGGER p3d AFTER DELETE ON p3 WHEN old.a=1 BEGIN
159 INSERT OR REPLACE INTO p3 VALUES(2, 'three');
164 DELETE FROM p3 WHERE a=1
H A Daltertab2.test69 ALTER TABLE p2 RENAME TO p3;
78 ALTER TABLE p3 RENAME TO p2;
80 ALTER TABLE p2 RENAME TO p3;
83 {CREATE TABLE c1(x REFERENCES "p3")}
84 {CREATE TABLE c2(x, FOREIGN KEY (x) REFERENCES "p3")}
85 {CREATE TABLE c3(x, FOREIGN KEY (x) REFERENCES "p3"(a))}
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 Dfts3prefix.test99 CREATE VIRTUAL TABLE p3 USING fts4term(t1, 3);
107 do_execsql_test 1.3.3 { SELECT term FROM p3 } {firebi sqlite}
H A Dtester.tcl1451 $addr $opcode $p1 $p2 $p3 $p4 $p5 $comment
1545 $addr $I $col $opcode $D $p1 $p2 $p3 $p4 $p5 $comment
H A De_fkey.test766 CREATE TABLE p3(a PRIMARY KEY, b);
767 CREATE TABLE c3(c REFERENCES p3(b), d);
788 4 c3 p3 "foreign key mismatch - \"c3\" referencing \"p3\""
/sqlite-3.40.0/src/
H A Dvdbe.c857 REGISTER_TRACE(pOp->p3, &aMem[pOp->p3]); in sqlite3VdbeExec()
1038 assert( pOp->p3>=0 && pOp->p3<p->nOp ); in sqlite3VdbeExec()
2469 assert( pOp->p3==0 || pOp->p3==1 ); in sqlite3VdbeExec()
4703 assert( pOp[1].p3==pOp[0].p3 ); in sqlite3VdbeExec()
4882 assert( pOp[1].p3==aOp[pOp->p2-1].p3 ); in sqlite3VdbeExec()
5622 iKey = pOp->p3 ? aMem[pOp->p3].u.i : 0; in sqlite3VdbeExec()
6450 assert( pOp->p3>=0 && pOp->p3<p->nCursor ); in sqlite3VdbeExec()
6569 REGISTER_TRACE(pOp->p3+i, &aMem[pOp->p3+i]); in sqlite3VdbeExec()
7463 assert( pOp->p3<pOp->p2 || pOp->p3>=pOp->p2+n ); in sqlite3VdbeExec()
8475 for(ii=pOp->p3; ii<pOp->p3+pOp->p4.i; ii++){ in sqlite3VdbeExec()
[all …]
H A Dvdbeaux.c239 return sqlite3VdbeAddOp3(p, op, p1, p2, p3); in growOp3()
249 return growOp3(p, op, p1, p2, p3); in sqlite3VdbeAddOp3()
259 pOp->p3 = p3; in sqlite3VdbeAddOp3()
342 int p3, /* The P3 operand */ in sqlite3VdbeAddOp4() argument
346 int addr = sqlite3VdbeAddOp3(p, op, p1, p2, p3); in sqlite3VdbeAddOp4()
404 int p3, /* The P3 operand */ in sqlite3VdbeAddOp4Dup8() argument
500 int p3, /* The P3 operand */ in sqlite3VdbeAddOp4Int() argument
503 int addr = sqlite3VdbeAddOp3(p, op, p1, p2, p3); in sqlite3VdbeAddOp4Int()
1083 pOut->p3 = aOp->p3; in sqlite3VdbeAddOpList()
1151 sqlite3VdbeGetOp(p,addr)->p3 = val; in sqlite3VdbeChangeP3()
[all …]
H A Dpragma.c796 aOp[4].p3 = eAuto - 1; in sqlite3Pragma()
1832 int p1, p3, p4; /* Operands to the OP_IsType opcode */ in sqlite3Pragma() local
1848 p3 = 3; in sqlite3Pragma()
1862 p3 = sqlite3TableColumnToIndex(sqlite3PrimaryKeyIndex(pTab), j); in sqlite3Pragma()
1864 p3 = sqlite3TableColumnToStorage(pTab,j); in sqlite3Pragma()
1865 testcase( p3!=j); in sqlite3Pragma()
1896 sqlite3VdbeAddOp4Int(v, OP_IsType, p1, labelOk, p3, p4); in sqlite3Pragma()
1907 sqlite3VdbeAddOp4Int(v, OP_IsType, p1, labelOk, p3, p4); in sqlite3Pragma()
1916 sqlite3VdbeAddOp4Int(v, OP_IsType, p1, labelOk, p3, p4); in sqlite3Pragma()
2171 aOp[1].p3 = sqlite3Atoi(zRight); in sqlite3Pragma()
[all …]
H A Dvdbe.h47 int p3; /* The third parameter */ member
103 signed char p3; /* Third parameter */ member
H A Dinsert.c189 sqlite3VdbeAddOp3(v, OP_MakeRecord, pPrev->p1, pPrev->p2, pPrev->p3); in sqlite3TableAffinity()
236 if( pOp->opcode==OP_OpenRead && pOp->p3==iDb ){ in readsTable()
320 pOp->p3 = 1; in sqlite3ComputeGeneratedColumns()
491 aOp[0].p3 = memId+2; in sqlite3AutoincrementBegin()
492 aOp[2].p3 = memId; in sqlite3AutoincrementBegin()
494 aOp[3].p3 = memId; in sqlite3AutoincrementBegin()
497 aOp[5].p3 = memId; in sqlite3AutoincrementBegin()
557 aOp[2].p3 = iRec; in autoIncrementEnd()
559 aOp[3].p3 = memId+1; in autoIncrementEnd()
2425 sqlite3VdbeAddOp4(v, x.opcode, x.p1, p2, x.p3, zP4, x.p4type); in sqlite3GenerateConstraintChecks()
H A Dvdbevtab.c208 int iDb = pOp->p3; in bytecodevtabColumn()
249 sqlite3_result_int(ctx, pOp->p3); in bytecodevtabColumn()
H A Dvdbeblob.c297 aOp[0].p3 = wrFlag; in sqlite3_blob_open()
307 aOp[1].p3 = iDb; in sqlite3_blob_open()
H A DwhereInt.h92 u8 op, p3, p5; /* Opcode, P3 & P5 of the opcode that ends the loop */ member
H A Dwherecode.c900 pOp->p3 = (int)(pLevel->iLikeRepCntr>>1); /* Register holding counter */ in whereLikeOptimizationStringFixup()
1485 if( (pOp->opcode==OP_Column && pOp->p3==iReg+j+2) in sqlite3WhereCodeOneLoopStart()
1489 sqlite3VdbeAddOp3(v, pOp->opcode, pOp->p1, pOp->p2, pOp->p3); in sqlite3WhereCodeOneLoopStart()
2074 pLevel->p3 = (pLoop->wsFlags&WHERE_UNQ_WANTED)!=0 ? 1:0; in sqlite3WhereCodeOneLoopStart()
H A Dwhere.c683 pOp->p2 = pOp->p3; in translateColumnToCopy()
684 pOp->p3 = 0; in translateColumnToCopy()
692 pOp->p3 = 0; in translateColumnToCopy()
6311 sqlite3VdbeAddOp3(v, pLevel->op, pLevel->p1, pLevel->p2, pLevel->p3); in sqlite3WhereEnd()
H A Dexpr.c5086 && pOp->p1+pOp->p3+1==inReg in sqlite3ExprCodeExprList()
5087 && pOp->p2+pOp->p3+1==target+i in sqlite3ExprCodeExprList()
5090 pOp->p3++; in sqlite3ExprCodeExprList()
H A Dshell.c.in3097 "addr", "opcode", "p1", "p2", "p3", "p4", "p5", "comment" };
/sqlite-3.40.0/ext/rtree/util/
H A Drandomshape.tcl14 proc randomenclosure {cx cy p1 p2 p3 p4} {
36 set p3 [expr {rand()*100+25}]
38 return [randomenclosure $cx $cy $p1 $p2 $p3 $p4]
45 set p3 [expr {rand()*10+25}]
47 return [randomenclosure $cx $cy $p1 $p2 $p3 $p4]
54 set p3 [expr {rand()*50+200}]
56 return [randomenclosure $cx $cy $p1 $p2 $p3 $p4]
/sqlite-3.40.0/ext/wasm/
H A Dtester1.js526 const p3 = w.scopedAlloc(16);
528 .assert(Number.isFinite(p3))
530 .assert(p3===asc2[0]);
1049 let p3 = P.alloc(n);
1050 T.assert(p3 === stack-remaining)
1058 const [p1, p2, p3] = P.allocChunks(3,4);
1061 .assert(p3 === p2 + 4);
1070 let [p1, p2, p3] = P.allocPtr(3,false);
1074 .assert(p3 === p2 + 4);
1075 [p1, p2, p3] = P.allocPtr(3);
[all …]