33306       const struct Cte *pCte = &pWith->a[i];  in sqlite3TreeViewWith()  local
33308       sqlite3_str_appendf(&x, "%s", pCte->zName);  in sqlite3TreeViewWith()
33309       if( pCte->pCols && pCte->pCols->nExpr>0 ){  in sqlite3TreeViewWith()
33312         for(j=0; j<pCte->pCols->nExpr; j++){  in sqlite3TreeViewWith()
33313           sqlite3_str_appendf(&x, "%c%s", cSep, pCte->pCols->a[j].zEName);  in sqlite3TreeViewWith()
33318       if( pCte->eM10d!=M10d_Any ){  in sqlite3TreeViewWith()
33320            pCte->eM10d==M10d_No ? "NOT " : "");  in sqlite3TreeViewWith()
33322       if( pCte->pUse ){  in sqlite3TreeViewWith()
33323         sqlite3_str_appendf(&x, " (pUse=0x%p, nUse=%d)", pCte->pUse,  in sqlite3TreeViewWith()
33324                  pCte->pUse->nUse);  in sqlite3TreeViewWith()
33328       sqlite3TreeViewSelect(pView, pCte->pSelect, 0);  in sqlite3TreeViewWith()
128714 static void cteClear(sqlite3 *db, Cte *pCte){
128715   assert( pCte!=0 );
128716   sqlite3ExprListDelete(db, pCte->pCols);
128717   sqlite3SelectDelete(db, pCte->pSelect);
128718   sqlite3DbFree(db, pCte->zName);
128724 SQLITE_PRIVATE void sqlite3CteDelete(sqlite3 *db, Cte *pCte){
128725   assert( pCte!=0 );
128726   cteClear(db, pCte);
128727   sqlite3DbFree(db, pCte);
128739   Cte *pCte               /* CTE to add to the WITH clause */
128745   if( pCte==0 ){
128751   zName = pCte->zName;
128769     sqlite3CteDelete(db, pCte);
128772     pNew->a[pNew->nCte++] = *pCte;
128773     sqlite3DbFree(db, pCte);
150606   Cte *pCte;               /* Matched CTE (or NULL if no match) */
150633   pCte = searchWith(pParse->pWith, pFrom, &pWith);
150634   if( pCte ){
150650     if( pCte->zCteErr ){
150651       sqlite3ErrorMsg(pParse, pCte->zCteErr, pCte->zName);
150659     pCteUse = pCte->pUse;
150661       pCte->pUse = pCteUse = sqlite3DbMallocZero(db, sizeof(pCteUse[0]));
150668       pCteUse->eM10d = pCte->eM10d;
150672     pTab->zName = sqlite3DbStrDup(db, pCte->zName);
150676     sqlite3SrcItemAttachSubquery(pParse, pFrom, pCte->pSelect, 1);
150704          && 0==sqlite3StrICmp(pItem->zName, pCte->zName)
150711                "multiple references to recursive table: %s", pCte->zName
150724     pCte->zCteErr = "circular reference: %s";
150751     if( pCte->pCols ){
150752       if( pEList && pEList->nExpr!=pCte->pCols->nExpr ){
150754             pCte->zName, pEList->nExpr, pCte->pCols->nExpr
150759       pEList = pCte->pCols;
150765         pCte->zCteErr = "multiple recursive references: %s";
150767         pCte->zCteErr = "recursive reference in a subquery: %s";
150771     pCte->zCteErr = 0;