Lines Matching defs:tab1
75291 ** INSERT INTO tab1 SELECT * FROM tab2;
75295 ** (1) tab1 and tab2 have identical schemas including all the
75298 ** (2) tab1 and tab2 are different tables
75300 ** (3) There must be no triggers on tab1
75311 ** tab2 over to tab1. The columns are not decoded. Raw records from
75312 ** the indices of tab2 are transfered to tab1 as well. In so doing,
75313 ** the resulting tab1 has much less fragmentation.
75346 return 0; /* tab1 must not have triggers */
75350 return 0; /* tab1 must not be a virtual table */
75407 return 0; /* tab1 and tab2 may not be the same table */
75418 return 0; /* Number of columns must be the same in tab1 and tab2 */
75431 return 0; /* tab2 must be NOT NULL if tab1 is */
79222 ** (tab1.col1 = tab2.col2)
79224 ** where tab1 is the iSrc'th table in SrcList pSrc and tab2 is the
79225 ** (iSrc+1)'th. Column col1 is column iColLeft of tab1, and col2 is
80647 int tab1, tab2;
80658 tab1 = pParse->nTab++;
80662 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab1, 0);
80668 /* Code the SELECTs to our left into temporary table "tab1".
80670 sqlite3SelectDestInit(&intersectdest, SRT_Union, tab1);
80707 sqlite3VdbeAddOp2(v, OP_Rewind, tab1, iBreak);
80709 iStart = sqlite3VdbeAddOp2(v, OP_RowKey, tab1, r1);
80712 selectInnerLoop(pParse, p, p->pEList, tab1, p->pEList->nExpr,
80715 sqlite3VdbeAddOp2(v, OP_Next, tab1, iStart);
80718 sqlite3VdbeAddOp2(v, OP_Close, tab1, 0);