Lines Matching refs:zSql
3795 const char *zSql, /* SQL to be evaluated */
5009 ** The second argument, "zSql", is the statement to be compiled, encoded
5015 ** ^If the nByte argument is negative, then zSql is read up to the
5017 ** number of bytes read from zSql. ^If nByte is zero, then no prepared
5025 ** past the end of the first SQL statement in zSql. These routines only
5026 ** compile the first statement in zSql, so *pzTail is left pointing to
5087 const char *zSql, /* SQL statement, UTF-8 encoded */
5088 int nByte, /* Maximum length of zSql in bytes. */
5090 const char **pzTail /* OUT: Pointer to unused portion of zSql */
5094 const char *zSql, /* SQL statement, UTF-8 encoded */
5095 int nByte, /* Maximum length of zSql in bytes. */
5097 const char **pzTail /* OUT: Pointer to unused portion of zSql */
5101 const char *zSql, /* SQL statement, UTF-8 encoded */
5102 int nByte, /* Maximum length of zSql in bytes. */
5105 const char **pzTail /* OUT: Pointer to unused portion of zSql */
5109 const void *zSql, /* SQL statement, UTF-16 encoded */
5110 int nByte, /* Maximum length of zSql in bytes. */
5112 const void **pzTail /* OUT: Pointer to unused portion of zSql */
5116 const void *zSql, /* SQL statement, UTF-16 encoded */
5117 int nByte, /* Maximum length of zSql in bytes. */
5119 const void **pzTail /* OUT: Pointer to unused portion of zSql */
5123 const void *zSql, /* SQL statement, UTF-16 encoded */
5124 int nByte, /* Maximum length of zSql in bytes. */
5127 const void **pzTail /* OUT: Pointer to unused portion of zSql */
17833 ** in the middle of the Parse.zSql text. But it might also point to a
21085 char *zSql; /* Text of the SQL statement that generated this */
48218 char *zSql;
48246 zSql = sqlite3_mprintf("PRAGMA \"%w\".page_count", zSchema);
48247 rc = zSql ? sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) : SQLITE_NOMEM;
48248 sqlite3_free(zSql);
48293 char *zSql;
48313 zSql = sqlite3_mprintf("ATTACH x AS %Q", zSchema);
48314 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
48315 sqlite3_free(zSql);
77611 assert( p->zSql==0 );
77612 p->zSql = sqlite3DbStrNDup(p->db, z, n);
77668 zTmp = pA->zSql;
77669 pA->zSql = pB->zSql;
77670 pB->zSql = zTmp;
79734 if( p->zSql ){
79735 z = p->zSql;
80793 if( sqlite3GlobalConfig.xSqllog && v->rc==SQLITE_OK && v->zSql && v->pc>=0 ){
80794 char *zExpanded = sqlite3VdbeExpandSql(v, v->zSql);
80878 if( p->zSql ){
80881 for(i=0; (c = p->zSql[i])!=0; i++){
80980 sqlite3DbFree(db, p->zSql);
82844 assert( p->zSql!=0 );
82849 db->xProfile(db->pProfileArg, p->zSql, iElapse);
83452 && !db->init.busy && p->zSql ){
84118 "bind on a busy prepared statement: [%s]", p->zSql);
84530 return p ? p->zSql : 0;
84547 const char *zSql = sqlite3_sql(pStmt);
84548 if( zSql ){
84551 z = sqlite3VdbeExpandSql(p, zSql);
84565 if( p->zNormSql==0 && ALWAYS(p->zSql!=0) ){
84567 p->zNormSql = sqlite3Normalize(p, p->zSql);
84856 ** zSql is a zero-terminated string of UTF-8 SQL text. Return the number of
84861 static int findNextHostParameter(const char *zSql, int *pnToken){
84867 while( zSql[0] ){
84868 n = sqlite3GetToken((u8*)zSql, &tokenType);
84875 zSql += n;
86233 sqlite3_log(pOp->p1, "abort at %d in [%s]: %s", pcx, p->zSql, p->zErrMsg);
91197 char *zSql;
91229 zSql = sqlite3MPrintf(db,
91232 if( zSql==0 ){
91240 rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
91248 sqlite3DbFreeNN(db, zSql);
92876 && (zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql))!=0
92895 zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql);
92906 && (zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql))!=0
93088 (int)(pOp - aOp), p->zSql, p->zErrMsg);
93113 || sqlite3_strlike("DELETE%",p->zSql,0)!=0
96748 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
96749 if( zSql==0 ){
96752 rc = sqlite3_prepare_v2(pVTab->db, zSql, -1, &pCur->pStmt, 0);
106511 ** Parse the SQL statement zSql using Parse object (*p). The Parse object
106518 const char *zSql, /* SQL to parse */
106533 rc = sqlite3RunParser(p, zSql, &zErr);
106548 int nSql = sqlite3Strlen30(zSql);
106551 assert( pToken->t.z>=zSql && &pToken->t.z[pToken->t.n]<=&zSql[nSql] );
106561 ** This function edits SQL statement zSql, replacing each token identified
106572 const char *zSql, /* SQL statement to edit */
106577 int nSql = sqlite3Strlen30(zSql);
106608 memcpy(zOut, zSql, nSql);
106623 iOff = pBest->t.z - zSql;
106774 ** sqlite_rename_column(zSql, iCol, bQuote, zNew, zTable, zOld)
106776 ** 0. zSql: SQL statement to rewrite
106784 ** 8. bTemp: True if zSql comes from temp schema
106786 ** Do a column rename operation on the CREATE statement given in zSql.
106801 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
106820 if( zSql==0 ) return;
106837 rc = renameParseSql(&sParse, zDb, db, zSql, bTemp);
106933 rc = renameEditSql(context, &sCtx, zSql, zNew, bQuote);
108934 char *zSql; /* Text of the SQL statement */
108939 zSql = sqlite3MPrintf(db, zSql1, zDb);
108940 if( !zSql ){
108943 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
108944 sqlite3DbFree(db, zSql);
108991 zSql = sqlite3MPrintf(db, zSql2, zDb);
108992 if( !zSql ){
108995 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
108996 sqlite3DbFree(db, zSql);
109084 char *zSql;
109110 zSql = sqlite3MPrintf(db,
109112 if( zSql==0 ){
109115 rc = sqlite3_exec(db, zSql, analysisLoader, &sInfo, 0);
109116 sqlite3DbFree(db, zSql);
110300 char *zSql;
110308 zSql = sqlite3VMPrintf(db, zFormat, ap);
110310 if( zSql==0 ){
110321 sqlite3RunParser(pParse, zSql, &zErrMsg);
110323 sqlite3DbFree(db, zSql);
123059 const char *zSql, /* The SQL to be executed */
123071 if( zSql==0 ) zSql = "";
123075 while( rc==SQLITE_OK && zSql[0] ){
123080 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
123087 zSql = zLeftover;
123140 zSql = zLeftover;
123141 while( sqlite3Isspace(zSql[0]) ) zSql++;
127785 char *zSql;
127811 zSql = sqlite3StrAccumFinish(&acc);
127812 if( zSql==0 ) return SQLITE_NOMEM;
127813 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pPragma, 0);
127814 sqlite3_free(zSql);
127968 const char *zSql, /* UTF-8 encoded SQL statement. */
127969 int nBytes, /* Length of zSql in bytes. */
128238 char *zSql;
128239 zSql = sqlite3MPrintf(db,
128248 rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
128254 sqlite3DbFree(db, zSql);
128453 ** Compile the UTF-8 encoded SQL statement zSql into a statement handle.
128457 const char *zSql, /* UTF-8 encoded SQL statement. */
128458 int nBytes, /* Length of zSql in bytes. */
128527 if( nBytes>=0 && (nBytes==0 || zSql[nBytes-1]!=0) ){
128537 zSqlCopy = sqlite3DbStrNDup(db, zSql, nBytes);
128540 sParse.zTail = &zSql[sParse.zTail-zSqlCopy];
128543 sParse.zTail = &zSql[nBytes];
128546 sqlite3RunParser(&sParse, zSql, &zErrMsg);
128561 sqlite3VdbeSetSql(sParse.pVdbe, zSql, (int)(sParse.zTail-zSql), prepFlags);
128595 const char *zSql, /* UTF-8 encoded SQL statement. */
128596 int nBytes, /* Length of zSql in bytes. */
128609 if( !sqlite3SafetyCheckOk(db)||zSql==0 ){
128618 rc = sqlite3Prepare(db, zSql, nBytes, prepFlags, pOld, ppStmt, pzTail);
128641 const char *zSql;
128646 zSql = sqlite3_sql((sqlite3_stmt *)p);
128647 assert( zSql!=0 ); /* Reprepare only called for prepare_v2() statements */
128651 rc = sqlite3LockAndPrepare(db, zSql, -1, prepFlags, p, &pNew, 0);
128679 const char *zSql, /* UTF-8 encoded SQL statement. */
128680 int nBytes, /* Length of zSql in bytes. */
128685 rc = sqlite3LockAndPrepare(db,zSql,nBytes,0,0,ppStmt,pzTail);
128691 const char *zSql, /* UTF-8 encoded SQL statement. */
128692 int nBytes, /* Length of zSql in bytes. */
128702 rc = sqlite3LockAndPrepare(db,zSql,nBytes,SQLITE_PREPARE_SAVESQL,0,
128709 const char *zSql, /* UTF-8 encoded SQL statement. */
128710 int nBytes, /* Length of zSql in bytes. */
128723 rc = sqlite3LockAndPrepare(db,zSql,nBytes,
128733 ** Compile the UTF-16 encoded SQL statement zSql into a statement handle.
128737 const void *zSql, /* UTF-16 encoded SQL statement. */
128738 int nBytes, /* Length of zSql in bytes. */
128755 if( !sqlite3SafetyCheckOk(db)||zSql==0 ){
128760 const char *z = (const char*)zSql;
128765 zSql8 = sqlite3Utf16to8(db, zSql, nBytes, SQLITE_UTF16NATIVE);
128777 *pzTail = (u8 *)zSql + sqlite3Utf16ByteLen(zSql, chars_parsed);
128795 const void *zSql, /* UTF-16 encoded SQL statement. */
128796 int nBytes, /* Length of zSql in bytes. */
128801 rc = sqlite3Prepare16(db,zSql,nBytes,0,ppStmt,pzTail);
128807 const void *zSql, /* UTF-16 encoded SQL statement. */
128808 int nBytes, /* Length of zSql in bytes. */
128813 rc = sqlite3Prepare16(db,zSql,nBytes,SQLITE_PREPARE_SAVESQL,ppStmt,pzTail);
128819 const void *zSql, /* UTF-16 encoded SQL statement. */
128820 int nBytes, /* Length of zSql in bytes. */
128826 rc = sqlite3Prepare16(db,zSql,nBytes,
135760 const char *zSql, /* The SQL to be executed */
135788 rc = sqlite3_exec(db, zSql, sqlite3_get_table_cb, &res, pzErrMsg);
138405 ** Execute zSql on database db.
138407 ** If zSql returns rows, then each row will have exactly one
138408 ** column. (This will only happen if zSql begins with "SELECT".)
138414 static int execSql(sqlite3 *db, char **pzErrMsg, const char *zSql){
138418 /* printf("SQL: [%s]\n", zSql); fflush(stdout); */
138419 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
138423 assert( sqlite3_strnicmp(zSql,"SELECT",6)==0 );
138444 static int execSqlF(sqlite3 *db, char **pzErrMsg, const char *zSql, ...){
138448 va_start(ap, zSql);
138449 z = sqlite3VMPrintf(db, zSql, ap);
159466 SQLITE_PRIVATE int sqlite3RunParser(Parse *pParse, const char *zSql, char **pzErrMsg){
159479 assert( zSql!=0 );
159485 pParse->zTail = zSql;
159489 printf("parser: [[[%s]]]\n", zSql);
159512 n = sqlite3GetToken((u8*)zSql, &tokenType);
159532 zSql += n;
159535 if( zSql[0]==0 ){
159549 tokenType = analyzeWindowKeyword((const u8*)&zSql[6]);
159552 tokenType = analyzeOverKeyword((const u8*)&zSql[4], lastTokenParsed);
159555 tokenType = analyzeFilterKeyword((const u8*)&zSql[6], lastTokenParsed);
159558 sqlite3ErrorMsg(pParse, "unrecognized token: \"%.*s\"", n, zSql);
159562 pParse->sLastToken.z = zSql;
159566 zSql += n;
159597 pParse->zTail = zSql;
159655 ** Compute a normalization of the SQL given by zSql[0..nSql-1]. Return
159657 ** NULL if anything goes wrong or if zSql is NULL.
159661 const char *zSql /* The original SQL string */
159664 int i; /* Next unread byte of zSql[] */
159679 for(i=0; zSql[i] && pStr->accError==0; i+=n){
159683 n = sqlite3GetToken((unsigned char*)zSql+i, &tokenType);
159727 if( sqlite3Isquote(zSql[i]) ){
159728 char *zId = sqlite3DbStrNDup(db, zSql+i, n);
159733 if( zSql[i]=='"' && sqlite3VdbeUsesDoubleQuotedString(pVdbe, zId) ){
159748 sqlite3_str_append(pStr, zSql+i, n);
159761 if( sqlite3IsIdChar(zSql[i]) ) addSpaceSeparator(pStr);
159763 sqlite3_str_append(pStr, zSql+i, n);
159882 SQLITE_API int sqlite3_complete(const char *zSql){
159916 if( zSql==0 ){
159922 while( *zSql ){
159923 switch( *zSql ){
159937 if( zSql[1]!='*' ){
159941 zSql += 2;
159942 while( zSql[0] && (zSql[0]!='*' || zSql[1]!='/') ){ zSql++; }
159943 if( zSql[0]==0 ) return 0;
159944 zSql++;
159949 if( zSql[1]!='-' ){
159953 while( *zSql && *zSql!='\n' ){ zSql++; }
159954 if( *zSql==0 ) return state==1;
159959 zSql++;
159960 while( *zSql && *zSql!=']' ){ zSql++; }
159961 if( *zSql==0 ) return 0;
159968 int c = *zSql;
159969 zSql++;
159970 while( *zSql && *zSql!=c ){ zSql++; }
159971 if( *zSql==0 ) return 0;
159979 if( IdChar((u8)*zSql) ){
159982 for(nId=1; IdChar(zSql[nId]); nId++){}
159986 switch( *zSql ){
159988 if( nId==6 && sqlite3StrNICmp(zSql, "create", 6)==0 ){
159996 if( nId==7 && sqlite3StrNICmp(zSql, "trigger", 7)==0 ){
159998 }else if( nId==4 && sqlite3StrNICmp(zSql, "temp", 4)==0 ){
160000 }else if( nId==9 && sqlite3StrNICmp(zSql, "temporary", 9)==0 ){
160008 if( nId==3 && sqlite3StrNICmp(zSql, "end", 3)==0 ){
160012 if( nId==7 && sqlite3StrNICmp(zSql, "explain", 7)==0 ){
160027 zSql += nId-1;
160036 zSql++;
160047 SQLITE_API int sqlite3_complete16(const void *zSql){
160057 sqlite3ValueSetStr(pVal, -1, zSql, SQLITE_UTF16NATIVE, SQLITE_STATIC);
166614 char *zSql;
166617 zSql = sqlite3_vmprintf(zFormat, ap);
166619 if( zSql==0 ){
166622 *pRc = sqlite3_exec(db, zSql, 0, 0, 0);
166623 sqlite3_free(zSql);
166671 char *zSql; /* SQL statement passed to declare_vtab() */
166685 zSql = sqlite3_mprintf(
166689 if( !zCols || !zSql ){
166692 rc = sqlite3_declare_vtab(p->db, zSql);
166695 sqlite3_free(zSql);
166790 char *zSql; /* SQL text "PRAGMA %Q.page_size" */
166793 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", p->zDb);
166794 if( !zSql ){
166797 rc = sqlite3_prepare(p->db, zSql, -1, &pStmt, 0);
166808 sqlite3_free(zSql);
167141 char *zSql; /* "SELECT *" statement on zTbl */
167142 sqlite3_stmt *pStmt = 0; /* Compiled version of zSql */
167144 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", zDb, zTbl);
167145 if( !zSql ){
167148 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
167153 sqlite3_free(zSql);
167850 char *zSql;
167855 zSql = sqlite3_mprintf("SELECT %s WHERE rowid = ?", p->zReadExprlist);
167856 if( !zSql ) return SQLITE_NOMEM;
167859 p->db, zSql,-1,SQLITE_PREPARE_PERSISTENT,&pCsr->pStmt,0
167862 sqlite3_free(zSql);
169337 char *zSql; /* SQL statement used to access %_content */
169415 zSql = sqlite3_mprintf(
169421 zSql = sqlite3_mprintf("SELECT %s ORDER BY rowid %s",
169425 if( zSql ){
169428 p->db,zSql,-1,SQLITE_PREPARE_PERSISTENT,&pCsr->pStmt,0
169431 sqlite3_free(zSql);
175379 const char zSql[] = "SELECT fts3_tokenizer(?, ?)";
175381 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
175402 const char zSql[] = "SELECT fts3_tokenizer(?)";
175405 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
176637 char *zSql;
176639 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName, p->zWriteExprlist);
176642 zSql = sqlite3_mprintf(azSql[eStmt], p->zReadExprlist);
176644 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName);
176646 if( !zSql ){
176649 rc = sqlite3_prepare_v3(p->db, zSql, -1, f, &pStmt, NULL);
176650 sqlite3_free(zSql);
179783 char *zSql = sqlite3_mprintf("SELECT %s" , p->zReadExprlist);
179784 if( !zSql ){
179787 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
179788 sqlite3_free(zSql);
181517 char *zSql;
181519 zSql = sqlite3_mprintf("SELECT %s" , p->zReadExprlist);
181520 if( !zSql ){
181523 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
181524 sqlite3_free(zSql);
190318 char *zSql;
190322 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", pRtree->zDb, pRtree->zName);
190323 if( zSql ){
190324 rc = sqlite3_prepare_v2(pRtree->db, zSql, -1, &pStmt, 0);
190328 sqlite3_free(zSql);
190526 char *zSql = sqlite3_mprintf(
190534 if( zSql ){
190536 rc = sqlite3_exec(pRtree->db, zSql, 0, 0, 0);
190537 sqlite3_free(zSql);
190573 char *zSql;
190585 zSql = sqlite3_mprintf(zFmt, pRtree->zDb, pRtree->zName);
190586 if( zSql==0 ){
190589 rc = sqlite3_prepare_v2(db, zSql, -1, &p, 0);
190604 sqlite3_free(zSql);
190725 char *zSql;
190735 zSql = sqlite3_mprintf(zFormat, zDb, zPrefix);
190736 if( zSql ){
190737 rc = sqlite3_prepare_v3(db, zSql, -1, f, appStmt[i], 0);
190741 sqlite3_free(zSql);
190752 char *zSql;
190763 zSql = sqlite3_str_finish(p);
190764 if( zSql==0 ){
190767 rc = sqlite3_prepare_v3(db, zSql, -1, f, &pRtree->pWriteAux, 0);
190768 sqlite3_free(zSql);
190783 static int getIntFromStmt(sqlite3 *db, const char *zSql, int *piVal){
190785 if( zSql ){
190787 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
190820 char *zSql;
190823 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", pRtree->zDb);
190824 rc = getIntFromStmt(db, zSql, &iPageSize);
190834 zSql = sqlite3_mprintf(
190838 rc = getIntFromStmt(db, zSql, &pRtree->iNodeSize);
190849 sqlite3_free(zSql);
190884 char *zSql;
190943 zSql = sqlite3_str_finish(pSql);
190944 if( !zSql ){
190949 }else if( SQLITE_OK!=(rc = sqlite3_declare_vtab(db, zSql)) ){
190952 sqlite3_free(zSql);
192769 char *zSql;
192806 zSql = sqlite3_str_finish(pSql);
192807 if( !zSql ){
192809 }else if( SQLITE_OK!=(rc = sqlite3_declare_vtab(db, zSql)) ){
192812 sqlite3_free(zSql);
195671 ** Prepare the SQL statement in buffer zSql against database handle db.
195684 const char *zSql
195686 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0);
195711 ** Unless it is NULL, argument zSql points to a buffer allocated using
195722 ** If argument zSql is NULL, this function assumes that an OOM has occurred.
195729 char *zSql
195733 if( zSql==0 ){
195737 rc = prepareAndCollectError(db, ppStmt, pzErrmsg, zSql);
195738 sqlite3_free(zSql);
195967 char *zSql = 0;
195970 zSql = sqlite3_vmprintf(zFmt, ap);
195972 if( zSql==0 ) p->rc = SQLITE_NOMEM;
195974 sqlite3_free(zSql);
195975 zSql = 0;
195978 return zSql;
195993 char *zSql;
195995 zSql = sqlite3_vmprintf(zFmt, ap);
195997 if( zSql==0 ){
196000 p->rc = sqlite3_exec(db, zSql, 0, 0, &p->zErrmsg);
196003 sqlite3_free(zSql);
197065 char *zSql = 0;
197083 zSql = rbuMPrintf(p, "%z%s\"%w\" %s %sCOLLATE %Q%s",
197084 zSql, zComma, zCol, pIter->azTblType[iCol], zPk, zColl,
197093 zSql = rbuMPrintf(p, "%z, %z", zSql, zPk);
197099 pIter->zTbl, zSql,
197181 char *zSql = (char*)sqlite3_column_text(pStmt, 0);
197182 if( zSql ){
197183 pIter->zIdxSql = zSql = rbuStrndup(zSql, &rc);
197185 if( zSql ){
197190 for(i=0; zSql[i]; i++){
197191 char c = zSql[i];
197209 pIter->aIdxCol[0].zSpan = &zSql[i+1];
197216 int nSpan = &zSql[i] - pIter->aIdxCol[iIdxCol].zSpan;
197222 int nSpan = &zSql[i] - pIter->aIdxCol[iIdxCol].zSpan;
197224 pIter->aIdxCol[iIdxCol].zSpan = &zSql[i+1];
197227 if( zSql[i]==c ){
197228 if( zSql[i+1]!=c ) break;
197234 if( zSql[i]==']' ) break;
197236 }else if( c=='-' && zSql[i+1]=='-' ){
197237 for(i=i+2; zSql[i] && zSql[i]!='\n'; i++);
197238 if( zSql[i]=='\0' ) break;
197239 }else if( c=='/' && zSql[i+1]=='*' ){
197240 for(i=i+2; zSql[i] && (zSql[i]!='*' || zSql[i+1]!='/'); i++);
197241 if( zSql[i]=='\0' ) break;
197245 if( zSql[i] ){
197246 zRet = rbuStrndup(&zSql[i], &rc);
197327 char *zSql;
197338 zSql = sqlite3_mprintf(
197350 zSql = sqlite3_mprintf(
197356 zSql = sqlite3_mprintf(
197370 p->rc = prepareFreeAndCollectError(p->dbRbu,&pIter->pSelect,pz,zSql);
197372 sqlite3_free(zSql);
198551 const char *zSql = (const char*)sqlite3_column_text(pSql, 0);
198552 p->rc = sqlite3_exec(p->dbMain, zSql, 0, 0, &p->zErrmsg);
200961 char *zSql; /* String value of pSql */
201005 zSql = sqlite3_str_finish(pSql);
201006 if( zSql==0 ){
201009 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0);
201010 sqlite3_free(zSql);
203761 char *zSql = 0;
203765 zSql = sqlite3_mprintf(
203769 if( zSql==0 ) rc = SQLITE_NOMEM;
203789 zSql = (char*)buf.aBuf;
203794 rc = sqlite3_prepare_v2(db, zSql, nSql, ppStmt, 0);
203796 sqlite3_free(zSql);
205257 static int sessionPrepare(sqlite3 *db, sqlite3_stmt **pp, const char *zSql){
205258 return sqlite3_prepare_v2(db, zSql, -1, pp, 0);
211706 char *zSql;
211708 zSql = sqlite3Fts5Mprintf(&rc, "CREATE TABLE x(");
211709 for(i=0; zSql && i<pConfig->nCol; i++){
211711 zSql = sqlite3Fts5Mprintf(&rc, "%z%s%Q", zSql, zSep, pConfig->azCol[i]);
211713 zSql = sqlite3Fts5Mprintf(&rc, "%z, %Q HIDDEN, %s HIDDEN)",
211714 zSql, pConfig->zName, FTS5_RANK_NAME
211717 assert( zSql || rc==SQLITE_NOMEM );
211718 if( zSql ){
211719 rc = sqlite3_declare_vtab(pConfig->db, zSql);
211720 sqlite3_free(zSql);
211950 char *zSql;
211962 zSql = sqlite3Fts5Mprintf(&rc, zSelect, pConfig->zDb, pConfig->zName);
211963 if( zSql ){
211964 rc = sqlite3_prepare_v2(pConfig->db, zSql, -1, &p, 0);
211965 sqlite3_free(zSql);
216175 char *zSql
216178 if( zSql ){
216179 p->rc = sqlite3_prepare_v3(p->pConfig->db, zSql, -1,
216186 sqlite3_free(zSql);
216223 char *zSql = sqlite3_mprintf(
216227 if( fts5IndexPrepareStmt(p, &p->pDeleter, zSql) ) return;
223016 char *zSql;
223020 zSql = sqlite3_vmprintf(zFmt, ap);
223021 if( zSql==0 ){
223024 rc = sqlite3_prepare_v3(pConfig->db, zSql, -1,
223029 sqlite3_free(zSql);
223162 char *zSql = sqlite3Fts5Mprintf(&rc, "SELECT %s", zRankArgs);
223163 if( zSql ){
223165 rc = sqlite3_prepare_v3(pConfig->db, zSql, -1,
223167 sqlite3_free(zSql);
225047 char *zSql = 0;
225051 zSql = sqlite3_mprintf(azStmt[eStmt],
225058 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zContentExprlist,
225065 zSql = sqlite3_mprintf(azStmt[eStmt],
225083 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName, zBind);
225090 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName);
225094 if( zSql==0 ){
225100 rc = sqlite3_prepare_v3(pC->db, zSql, -1, f, &p->aStmt[eStmt], 0);
225102 sqlite3_free(zSql);
225123 char *zSql;
225126 zSql = sqlite3_vmprintf(zFormat, ap);
225128 if( zSql==0 ){
225131 rc = sqlite3_exec(db, zSql, 0, 0, pzErr);
225132 sqlite3_free(zSql);
225725 char *zSql;
225728 zSql = sqlite3_mprintf("SELECT count(*) FROM %Q.'%q_%s'",
225731 if( zSql==0 ){
225735 rc = sqlite3_prepare_v2(pConfig->db, zSql, -1, &pCnt, 0);
225744 sqlite3_free(zSql);
228851 char *zSql = 0;
228859 zSql = sqlite3Fts5Mprintf(&rc,
228863 if( zSql ){
228864 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0);
228866 sqlite3_free(zSql);