Lines Matching refs:tab2
96521 ** INSERT INTO tab1 SELECT * FROM tab2;
96523 ** The xfer optimization transfers raw records from tab2 over to tab1.
96527 ** The xfer optimization is only attempted if tab1 and tab2 are compatible.
96634 return 0; /* tab1 and tab2 may not be the same table */
96641 return 0; /* tab2 must not be a virtual table */
96645 return 0; /* tab2 may not be a view */
96648 return 0; /* Number of columns must be the same in tab1 and tab2 */
96663 return 0; /* tab2 must be NOT NULL if tab1 is */
101720 ** (tab1.col1 = tab2.col2)
101722 ** where tab1 is the iSrc'th table in SrcList pSrc and tab2 is the
101724 ** column iColRight of tab2.
103722 int tab1, tab2;
103734 tab2 = pParse->nTab++;
103752 /* Code the current SELECT into temporary table "tab2"
103754 addr = sqlite3VdbeAddOp2(v, OP_OpenEphemeral, tab2, 0);
103762 intersectdest.iSDParm = tab2;
103788 sqlite3VdbeAddOp4Int(v, OP_NotFound, tab2, iCont, r1, 0); VdbeCoverage(v);
103795 sqlite3VdbeAddOp2(v, OP_Close, tab2, 0);
104788 ** SELECT abs(z*2) FROM tab2
104797 ** SELECT abs(z*2)+1 FROM tab2 WHERE abs(z*2)+1!=5