Lines Matching defs:tab1
82876 ** INSERT INTO tab1 SELECT * FROM tab2;
82880 ** (1) tab1 and tab2 have identical schemas including all the
82883 ** (2) tab1 and tab2 are different tables
82885 ** (3) There must be no triggers on tab1
82896 ** tab2 over to tab1. The columns are not decoded. Raw records from
82897 ** the indices of tab2 are transfered to tab1 as well. In so doing,
82898 ** the resulting tab1 has much less fragmentation.
82931 return 0; /* tab1 must not have triggers */
82935 return 0; /* tab1 must not be a virtual table */
82992 return 0; /* tab1 and tab2 may not be the same table */
83003 return 0; /* Number of columns must be the same in tab1 and tab2 */
83016 return 0; /* tab2 must be NOT NULL if tab1 is */
86872 ** (tab1.col1 = tab2.col2)
86874 ** where tab1 is the iSrc'th table in SrcList pSrc and tab2 is the
86875 ** (iSrc+1)'th. Column col1 is column iColLeft of tab1, and col2 is
88296 int tab1, tab2;
88307 tab1 = pParse->nTab++;
88311 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab1, 0);
88317 /* Code the SELECTs to our left into temporary table "tab1".
88319 sqlite3SelectDestInit(&intersectdest, SRT_Union, tab1);
88356 sqlite3VdbeAddOp2(v, OP_Rewind, tab1, iBreak);
88358 iStart = sqlite3VdbeAddOp2(v, OP_RowKey, tab1, r1);
88361 selectInnerLoop(pParse, p, p->pEList, tab1, p->pEList->nExpr,
88364 sqlite3VdbeAddOp2(v, OP_Next, tab1, iStart);
88367 sqlite3VdbeAddOp2(v, OP_Close, tab1, 0);