3031 ** If compiled statement pSql appears to be an EXPLAIN statement, allocate
3051 static void explain_data_prepare(ShellState *p, sqlite3_stmt *pSql){  argument
3066   if( sqlite3_column_count(pSql)!=8 ){
3070   zSql = sqlite3_sql(pSql);
3078   for(iOp=0; SQLITE_ROW==sqlite3_step(pSql); iOp++){
3080     int iAddr = sqlite3_column_int(pSql, 0);
3081     const char *zOp = (const char*)sqlite3_column_text(pSql, 1);
3088     int p2 = sqlite3_column_int(pSql, 3);
3100           if( cli_strcmp(sqlite3_column_name(pSql,jj),explainCols[jj])!=0 ){
3102             sqlite3_reset(pSql);
3121      && (abYield[p2op] || sqlite3_column_int(pSql, 2))
3129   sqlite3_reset(pSql);
6264   sqlite3_stmt *pSql = 0;         /* Compiled version of SQL statement below */  local
6354     rc = sqlite3_prepare_v2(db, zSql, -1, &pSql, 0);
6357     sqlite3_bind_int(pSql, 1, bGroupByParent);
6363     while( SQLITE_ROW==sqlite3_step(pSql) ){
6366       const char *zEQP = (const char*)sqlite3_column_text(pSql, 0);
6367       const char *zGlob = (const char*)sqlite3_column_text(pSql, 1);
6368       const char *zFrom = (const char*)sqlite3_column_text(pSql, 2);
6369       const char *zTarget = (const char*)sqlite3_column_text(pSql, 3);
6370       const char *zCI = (const char*)sqlite3_column_text(pSql, 4);
6371       const char *zParent = (const char*)sqlite3_column_text(pSql, 5);
6413     rc2 = sqlite3_finalize(pSql);
6888   sqlite3_stmt *pSql = 0;  local
6894   shellPreparePrintf(pAr->db, &rc, &pSql, zSql, azCols[pAr->bVerbose],
6897     utf8_printf(pAr->p->out, "%s\n", sqlite3_sql(pSql));
6899     while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSql) ){
6902             sqlite3_column_text(pSql, 0),
6903             sqlite3_column_int(pSql, 1), 
6904             sqlite3_column_text(pSql, 2),
6905             sqlite3_column_text(pSql, 3)
6908         utf8_printf(pAr->p->out, "%s\n", sqlite3_column_text(pSql, 0));
6912   shellFinalize(&rc, pSql);
6975   sqlite3_stmt *pSql = 0;  local
6996   shellPreparePrintf(pAr->db, &rc, &pSql, zSql1, 
7001     j = sqlite3_bind_parameter_index(pSql, "$dir");
7002     sqlite3_bind_text(pSql, j, zDir, -1, SQLITE_STATIC);
7010       j = sqlite3_bind_parameter_index(pSql, "$dirOnly");
7011       sqlite3_bind_int(pSql, j, i);
7013         utf8_printf(pAr->p->out, "%s\n", sqlite3_sql(pSql));
7015         while( rc==SQLITE_OK && SQLITE_ROW==sqlite3_step(pSql) ){
7017             utf8_printf(pAr->p->out, "%s\n", sqlite3_column_text(pSql, 0));
7021       shellReset(&rc, pSql);
7023     shellFinalize(&rc, pSql);