Lines Matching defs:tab1
88459 ** INSERT INTO tab1 SELECT * FROM tab2;
88463 ** (1) tab1 and tab2 have identical schemas including all the
88466 ** (2) tab1 and tab2 are different tables
88468 ** (3) There must be no triggers on tab1
88479 ** tab2 over to tab1. The columns are not decoded. Raw records from
88480 ** the indices of tab2 are transfered to tab1 as well. In so doing,
88481 ** the resulting tab1 has much less fragmentation.
88514 return 0; /* tab1 must not have triggers */
88518 return 0; /* tab1 must not be a virtual table */
88575 return 0; /* tab1 and tab2 may not be the same table */
88586 return 0; /* Number of columns must be the same in tab1 and tab2 */
88599 return 0; /* tab2 must be NOT NULL if tab1 is */
92579 ** (tab1.col1 = tab2.col2)
92581 ** where tab1 is the iSrc'th table in SrcList pSrc and tab2 is the
92582 ** (iSrc+1)'th. Column col1 is column iColLeft of tab1, and col2 is
94109 int tab1, tab2;
94120 tab1 = pParse->nTab++;
94124 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab1, 0);
94130 /* Code the SELECTs to our left into temporary table "tab1".
94132 sqlite3SelectDestInit(&intersectdest, SRT_Union, tab1);
94172 sqlite3VdbeAddOp2(v, OP_Rewind, tab1, iBreak);
94174 iStart = sqlite3VdbeAddOp2(v, OP_RowKey, tab1, r1);
94177 selectInnerLoop(pParse, p, p->pEList, tab1, p->pEList->nExpr,
94180 sqlite3VdbeAddOp2(v, OP_Next, tab1, iStart);
94183 sqlite3VdbeAddOp2(v, OP_Close, tab1, 0);