Lines Matching refs:tab1
90542 ** INSERT INTO tab1 SELECT * FROM tab2;
90544 ** The xfer optimization transfers raw records from tab2 over to tab1.
90548 ** The xfer optimization is only attempted if tab1 and tab2 are compatible.
90591 return 0; /* tab1 must not have triggers */
90595 return 0; /* tab1 must not be a virtual table */
90650 return 0; /* tab1 and tab2 may not be the same table */
90661 return 0; /* Number of columns must be the same in tab1 and tab2 */
90674 return 0; /* tab2 must be NOT NULL if tab1 is */
90711 ** table (tab1) is initially empty.
94736 ** (tab1.col1 = tab2.col2)
94738 ** where tab1 is the iSrc'th table in SrcList pSrc and tab2 is the
94739 ** (iSrc+1)'th. Column col1 is column iColLeft of tab1, and col2 is
96273 int tab1, tab2;
96284 tab1 = pParse->nTab++;
96288 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab1, 0);
96294 /* Code the SELECTs to our left into temporary table "tab1".
96296 sqlite3SelectDestInit(&intersectdest, SRT_Union, tab1);
96336 sqlite3VdbeAddOp2(v, OP_Rewind, tab1, iBreak);
96338 iStart = sqlite3VdbeAddOp2(v, OP_RowKey, tab1, r1);
96341 selectInnerLoop(pParse, p, p->pEList, tab1, p->pEList->nExpr,
96344 sqlite3VdbeAddOp2(v, OP_Next, tab1, iStart);
96347 sqlite3VdbeAddOp2(v, OP_Close, tab1, 0);