Lines Matching refs:tab1
86061 ** INSERT INTO tab1 SELECT * FROM tab2;
86065 ** (1) tab1 and tab2 have identical schemas including all the
86068 ** (2) tab1 and tab2 are different tables
86070 ** (3) There must be no triggers on tab1
86081 ** tab2 over to tab1. The columns are not decoded. Raw records from
86082 ** the indices of tab2 are transfered to tab1 as well. In so doing,
86083 ** the resulting tab1 has much less fragmentation.
86116 return 0; /* tab1 must not have triggers */
86120 return 0; /* tab1 must not be a virtual table */
86177 return 0; /* tab1 and tab2 may not be the same table */
86188 return 0; /* Number of columns must be the same in tab1 and tab2 */
86201 return 0; /* tab2 must be NOT NULL if tab1 is */
90152 ** (tab1.col1 = tab2.col2)
90154 ** where tab1 is the iSrc'th table in SrcList pSrc and tab2 is the
90155 ** (iSrc+1)'th. Column col1 is column iColLeft of tab1, and col2 is
91661 int tab1, tab2;
91672 tab1 = pParse->nTab++;
91676 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab1, 0);
91682 /* Code the SELECTs to our left into temporary table "tab1".
91684 sqlite3SelectDestInit(&intersectdest, SRT_Union, tab1);
91724 sqlite3VdbeAddOp2(v, OP_Rewind, tab1, iBreak);
91726 iStart = sqlite3VdbeAddOp2(v, OP_RowKey, tab1, r1);
91729 selectInnerLoop(pParse, p, p->pEList, tab1, p->pEList->nExpr,
91732 sqlite3VdbeAddOp2(v, OP_Next, tab1, iStart);
91735 sqlite3VdbeAddOp2(v, OP_Close, tab1, 0);