Lines Matching refs:zSql
3457 const char *zSql, /* SQL to be evaluated */
4728 ** The second argument, "zSql", is the statement to be compiled, encoded
4734 ** ^If the nByte argument is negative, then zSql is read up to the
4736 ** number of bytes read from zSql. When nByte is positive, zSql is read
4748 ** past the end of the first SQL statement in zSql. These routines only
4749 ** compile the first statement in zSql, so *pzTail is left pointing to
4810 const char *zSql, /* SQL statement, UTF-8 encoded */
4811 int nByte, /* Maximum length of zSql in bytes. */
4813 const char **pzTail /* OUT: Pointer to unused portion of zSql */
4817 const char *zSql, /* SQL statement, UTF-8 encoded */
4818 int nByte, /* Maximum length of zSql in bytes. */
4820 const char **pzTail /* OUT: Pointer to unused portion of zSql */
4824 const char *zSql, /* SQL statement, UTF-8 encoded */
4825 int nByte, /* Maximum length of zSql in bytes. */
4828 const char **pzTail /* OUT: Pointer to unused portion of zSql */
4832 const void *zSql, /* SQL statement, UTF-16 encoded */
4833 int nByte, /* Maximum length of zSql in bytes. */
4835 const void **pzTail /* OUT: Pointer to unused portion of zSql */
4839 const void *zSql, /* SQL statement, UTF-16 encoded */
4840 int nByte, /* Maximum length of zSql in bytes. */
4842 const void **pzTail /* OUT: Pointer to unused portion of zSql */
4846 const void *zSql, /* SQL statement, UTF-16 encoded */
4847 int nByte, /* Maximum length of zSql in bytes. */
4850 const void **pzTail /* OUT: Pointer to unused portion of zSql */
19232 ** in the middle of the Parse.zSql text. But it might also point to a
24094 char *zSql; /* Text of the SQL statement that generated this */
54577 char *zSql;
54607 zSql = sqlite3_mprintf("PRAGMA \"%w\".page_count", zSchema);
54608 rc = zSql ? sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0) : SQLITE_NOMEM;
54609 sqlite3_free(zSql);
54662 char *zSql;
54683 zSql = sqlite3_mprintf("ATTACH x AS %Q", zSchema);
54684 if( zSql==0 ){
54687 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
54688 sqlite3_free(zSql);
85971 assert( p->zSql==0 );
85972 p->zSql = sqlite3DbStrNDup(p->db, z, n);
86035 zTmp = pA->zSql;
86036 pA->zSql = pB->zSql;
86037 pB->zSql = zTmp;
88394 if( p->zSql ){
88395 z = p->zSql;
89444 if( sqlite3GlobalConfig.xSqllog && v->rc==SQLITE_OK && v->zSql && v->pc>=0 ){
89445 char *zExpanded = sqlite3VdbeExpandSql(v, v->zSql);
89528 if( p->zSql ){
89531 for(i=0; (c = p->zSql[i])!=0; i++){
89637 if( p->zSql ) sqlite3DbNNFreeNN(db, p->zSql);
91527 assert( p->zSql!=0 );
91532 db->xProfile(db->pProfileArg, p->zSql, iElapse);
92250 && !db->init.busy && p->zSql ){
93106 "bind on a busy prepared statement: [%s]", p->zSql);
93566 return p ? p->zSql : 0;
93583 const char *zSql = sqlite3_sql(pStmt);
93584 if( zSql ){
93587 z = sqlite3VdbeExpandSql(p, zSql);
93601 if( p->zNormSql==0 && ALWAYS(p->zSql!=0) ){
93603 p->zNormSql = sqlite3Normalize(p, p->zSql);
94080 ** zSql is a zero-terminated string of UTF-8 SQL text. Return the number of
94085 static int findNextHostParameter(const char *zSql, int *pnToken){
94091 while( zSql[0] ){
94092 n = sqlite3GetToken((u8*)zSql, &tokenType);
94099 zSql += n;
95661 sqlite3_log(pOp->p1, "abort at %d: %s; [%s]", pcx, p->zErrMsg, p->zSql);
101368 char *zSql;
101403 zSql = sqlite3MPrintf(db,
101406 if( zSql==0 ){
101414 rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
101422 sqlite3DbFreeNN(db, zSql);
103260 && (zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql))!=0
103278 zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql);
103289 && (zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql))!=0
103487 const char *zTrace = p->zSql;
103504 (int)(pOp - aOp), p->zErrMsg, p->zSql);
103546 || sqlite3_strlike("DELETE%",p->zSql,0)!=0
107227 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
107228 if( zSql==0 ){
107231 rc = sqlite3_prepare_v2(pVTab->db, zSql, -1, &pCur->pStmt, 0);
118896 ** Parse the SQL statement zSql using Parse object (*p). The Parse object
118903 const char *zSql, /* SQL to parse */
118910 if( zSql==0 ){
118913 if( sqlite3StrNICmp(zSql,"CREATE ",7)!=0 ){
118927 testcase( (db->flags & SQLITE_Comments)==0 && strstr(zSql," /* ")!=0 );
118929 rc = sqlite3RunParser(p, zSql);
118942 int nSql = sqlite3Strlen30(zSql);
118945 assert( pToken->t.z>=zSql && &pToken->t.z[pToken->t.n]<=&zSql[nSql] );
118955 ** This function edits SQL statement zSql, replacing each token identified
118966 const char *zSql, /* SQL statement to edit */
118971 i64 nSql = sqlite3Strlen30(zSql);
119011 memcpy(zOut, zSql, (size_t)nSql);
119045 iOff = (int)(pBest->t.z - zSql);
119257 ** 0. zSql: SQL statement to rewrite
119265 ** 8. bTemp: True if zSql comes from temp schema
119267 ** Do a column rename operation on the CREATE statement given in zSql.
119283 const char *zSql = (const char*)sqlite3_value_text(argv[0]);
119302 if( zSql==0 ) return;
119319 rc = renameParseSql(&sParse, zDb, db, zSql, bTemp);
119419 rc = renameEditSql(context, &sCtx, zSql, zNew, bQuote);
119882 const char *zSql = (const char*)sqlite3_value_text(argv[1]);
119898 rc = renameParseSql(&sParse, zDb, db, zSql, iSchema==1);
119914 zEnd = (const char*)&zSql[pTab->u.tab.addColOffset];
119918 zNew = sqlite3MPrintf(db, "%.*s%s", pCol->t.z-zSql, zSql, zEnd);
121875 char *zSql; /* Text of the SQL statement */
121880 zSql = sqlite3MPrintf(db, zSql1, zDb);
121881 if( !zSql ){
121884 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
121885 sqlite3DbFree(db, zSql);
121942 zSql = sqlite3MPrintf(db, zSql2, zDb);
121943 if( !zSql ){
121946 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
121947 sqlite3DbFree(db, zSql);
122045 char *zSql;
122074 zSql = sqlite3MPrintf(db,
122076 if( zSql==0 ){
122079 rc = sqlite3_exec(db, zSql, analysisLoader, &sInfo, 0);
122080 sqlite3DbFree(db, zSql);
123298 char *zSql;
123307 zSql = sqlite3VMPrintf(db, zFormat, ap);
123309 if( zSql==0 ){
123321 sqlite3RunParser(pParse, zSql);
123323 sqlite3DbFree(db, zSql);
138239 const char *zSql, /* The SQL to be executed */
138251 if( zSql==0 ) zSql = "";
138255 while( rc==SQLITE_OK && zSql[0] ){
138260 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, &zLeftover);
138267 zSql = zLeftover;
138320 zSql = zLeftover;
138321 while( sqlite3Isspace(zSql[0]) ) zSql++;
141950 char *zSql = sqlite3MPrintf(db, "SELECT*FROM\"%w\"", pTab->zName);
141951 if( zSql ){
141953 (void)sqlite3_prepare_v3(db, zSql, -1, SQLITE_PREPARE_DONT_LOG,
141956 sqlite3DbFree(db, zSql);
143625 char *zSql;
143651 zSql = sqlite3StrAccumFinish(&acc);
143652 if( zSql==0 ) return SQLITE_NOMEM;
143653 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pPragma, 0);
143654 sqlite3_free(zSql);
143818 const char *zSql, /* UTF-8 encoded SQL statement. */
143819 int nBytes, /* Length of zSql in bytes. */
144109 char *zSql;
144110 zSql = sqlite3MPrintf(db,
144119 rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
144125 sqlite3DbFree(db, zSql);
144425 ** Compile the UTF-8 encoded SQL statement zSql into a statement handle.
144429 const char *zSql, /* UTF-8 encoded SQL statement. */
144430 int nBytes, /* Length of zSql in bytes. */
144512 if( nBytes>=0 && (nBytes==0 || zSql[nBytes-1]!=0) ){
144522 zSqlCopy = sqlite3DbStrNDup(db, zSql, nBytes);
144525 sParse.zTail = &zSql[sParse.zTail-zSqlCopy];
144528 sParse.zTail = &zSql[nBytes];
144531 sqlite3RunParser(&sParse, zSql);
144540 sqlite3VdbeSetSql(sParse.pVdbe, zSql, (int)(sParse.zTail-zSql), prepFlags);
144583 const char *zSql, /* UTF-8 encoded SQL statement. */
144584 int nBytes, /* Length of zSql in bytes. */
144597 if( !sqlite3SafetyCheckOk(db)||zSql==0 ){
144606 rc = sqlite3Prepare(db, zSql, nBytes, prepFlags, pOld, ppStmt, pzTail);
144632 const char *zSql;
144637 zSql = sqlite3_sql((sqlite3_stmt *)p);
144638 assert( zSql!=0 ); /* Reprepare only called for prepare_v2() statements */
144642 rc = sqlite3LockAndPrepare(db, zSql, -1, prepFlags, p, &pNew, 0);
144670 const char *zSql, /* UTF-8 encoded SQL statement. */
144671 int nBytes, /* Length of zSql in bytes. */
144676 rc = sqlite3LockAndPrepare(db,zSql,nBytes,0,0,ppStmt,pzTail);
144682 const char *zSql, /* UTF-8 encoded SQL statement. */
144683 int nBytes, /* Length of zSql in bytes. */
144693 rc = sqlite3LockAndPrepare(db,zSql,nBytes,SQLITE_PREPARE_SAVESQL,0,
144700 const char *zSql, /* UTF-8 encoded SQL statement. */
144701 int nBytes, /* Length of zSql in bytes. */
144714 rc = sqlite3LockAndPrepare(db,zSql,nBytes,
144724 ** Compile the UTF-16 encoded SQL statement zSql into a statement handle.
144728 const void *zSql, /* UTF-16 encoded SQL statement. */
144729 int nBytes, /* Length of zSql in bytes. */
144746 if( !sqlite3SafetyCheckOk(db)||zSql==0 ){
144757 const char *z = (const char*)zSql;
144762 const char *z = (const char*)zSql;
144768 zSql8 = sqlite3Utf16to8(db, zSql, nBytes, SQLITE_UTF16NATIVE);
144780 *pzTail = (u8 *)zSql + sqlite3Utf16ByteLen(zSql, nBytes, chars_parsed);
144798 const void *zSql, /* UTF-16 encoded SQL statement. */
144799 int nBytes, /* Length of zSql in bytes. */
144804 rc = sqlite3Prepare16(db,zSql,nBytes,0,ppStmt,pzTail);
144810 const void *zSql, /* UTF-16 encoded SQL statement. */
144811 int nBytes, /* Length of zSql in bytes. */
144816 rc = sqlite3Prepare16(db,zSql,nBytes,SQLITE_PREPARE_SAVESQL,ppStmt,pzTail);
144822 const void *zSql, /* UTF-16 encoded SQL statement. */
144823 int nBytes, /* Length of zSql in bytes. */
144829 rc = sqlite3Prepare16(db,zSql,nBytes,
153780 const char *zSql, /* The SQL to be executed */
153808 rc = sqlite3_exec(db, zSql, sqlite3_get_table_cb, &res, pzErrMsg);
157155 ** Execute zSql on database db.
157157 ** If zSql returns rows, then each row will have exactly one
157158 ** column. (This will only happen if zSql begins with "SELECT".)
157164 static int execSql(sqlite3 *db, char **pzErrMsg, const char *zSql){
157168 /* printf("SQL: [%s]\n", zSql); fflush(stdout); */
157169 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
157173 assert( sqlite3_strnicmp(zSql,"SELECT",6)==0 );
157194 static int execSqlF(sqlite3 *db, char **pzErrMsg, const char *zSql, ...){
157198 va_start(ap, zSql);
157199 z = sqlite3VMPrintf(db, zSql, ap);
181949 SQLITE_PRIVATE int sqlite3RunParser(Parse *pParse, const char *zSql){
181963 assert( zSql!=0 );
181969 pParse->zTail = zSql;
181972 printf("parser: [[[%s]]]\n", zSql);
181995 n = sqlite3GetToken((u8*)zSql, &tokenType);
182020 zSql += n;
182023 if( zSql[0]==0 ){
182037 tokenType = analyzeWindowKeyword((const u8*)&zSql[6]);
182040 tokenType = analyzeOverKeyword((const u8*)&zSql[4], lastTokenParsed);
182043 tokenType = analyzeFilterKeyword((const u8*)&zSql[6], lastTokenParsed);
182050 zSql += n;
182054 x.z = zSql;
182060 pParse->sLastToken.z = zSql;
182064 zSql += n;
182093 pParse->zTail = zSql;
182127 ** Compute a normalization of the SQL given by zSql[0..nSql-1]. Return
182129 ** NULL if anything goes wrong or if zSql is NULL.
182133 const char *zSql /* The original SQL string */
182136 int i; /* Next unread byte of zSql[] */
182151 for(i=0; zSql[i] && pStr->accError==0; i+=n){
182155 n = sqlite3GetToken((unsigned char*)zSql+i, &tokenType);
182200 if( sqlite3Isquote(zSql[i]) ){
182201 char *zId = sqlite3DbStrNDup(db, zSql+i, n);
182206 if( zSql[i]=='"' && sqlite3VdbeUsesDoubleQuotedString(pVdbe, zId) ){
182221 sqlite3_str_append(pStr, zSql+i, n);
182234 if( sqlite3IsIdChar(zSql[i]) ) addSpaceSeparator(pStr);
182236 sqlite3_str_append(pStr, zSql+i, n);
182355 SQLITE_API int sqlite3_complete(const char *zSql){
182389 if( zSql==0 ){
182395 while( *zSql ){
182396 switch( *zSql ){
182410 if( zSql[1]!='*' ){
182414 zSql += 2;
182415 while( zSql[0] && (zSql[0]!='*' || zSql[1]!='/') ){ zSql++; }
182416 if( zSql[0]==0 ) return 0;
182417 zSql++;
182422 if( zSql[1]!='-' ){
182426 while( *zSql && *zSql!='\n' ){ zSql++; }
182427 if( *zSql==0 ) return state==1;
182432 zSql++;
182433 while( *zSql && *zSql!=']' ){ zSql++; }
182434 if( *zSql==0 ) return 0;
182441 int c = *zSql;
182442 zSql++;
182443 while( *zSql && *zSql!=c ){ zSql++; }
182444 if( *zSql==0 ) return 0;
182452 if( IdChar((u8)*zSql) ){
182455 for(nId=1; IdChar(zSql[nId]); nId++){}
182459 switch( *zSql ){
182461 if( nId==6 && sqlite3StrNICmp(zSql, "create", 6)==0 ){
182469 if( nId==7 && sqlite3StrNICmp(zSql, "trigger", 7)==0 ){
182471 }else if( nId==4 && sqlite3StrNICmp(zSql, "temp", 4)==0 ){
182473 }else if( nId==9 && sqlite3StrNICmp(zSql, "temporary", 9)==0 ){
182481 if( nId==3 && sqlite3StrNICmp(zSql, "end", 3)==0 ){
182485 if( nId==7 && sqlite3StrNICmp(zSql, "explain", 7)==0 ){
182500 zSql += nId-1;
182509 zSql++;
182520 SQLITE_API int sqlite3_complete16(const void *zSql){
182530 sqlite3ValueSetStr(pVal, -1, zSql, SQLITE_UTF16NATIVE, SQLITE_STATIC);
189655 char *zSql;
189658 zSql = sqlite3_vmprintf(zFormat, ap);
189660 if( zSql==0 ){
189663 *pRc = sqlite3_exec(db, zSql, 0, 0, 0);
189664 sqlite3_free(zSql);
189712 char *zSql; /* SQL statement passed to declare_vtab() */
189727 zSql = sqlite3_mprintf(
189731 if( !zCols || !zSql ){
189734 rc = sqlite3_declare_vtab(p->db, zSql);
189737 sqlite3_free(zSql);
189832 char *zSql; /* SQL text "PRAGMA %Q.page_size" */
189835 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", p->zDb);
189836 if( !zSql ){
189839 rc = sqlite3_prepare(p->db, zSql, -1, &pStmt, 0);
189850 sqlite3_free(zSql);
190183 char *zSql; /* "SELECT *" statement on zTbl */
190184 sqlite3_stmt *pStmt = 0; /* Compiled version of zSql */
190186 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", zDb, zTbl);
190187 if( !zSql ){
190190 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
190195 sqlite3_free(zSql);
190892 char *zSql;
190897 zSql = sqlite3_mprintf("SELECT %s WHERE rowid = ?", p->zReadExprlist);
190898 if( !zSql ) return SQLITE_NOMEM;
190901 p->db, zSql,-1,SQLITE_PREPARE_PERSISTENT,&pCsr->pStmt,0
190904 sqlite3_free(zSql);
192387 char *zSql; /* SQL statement used to access %_content */
192465 zSql = sqlite3_mprintf(
192471 zSql = sqlite3_mprintf("SELECT %s ORDER BY rowid %s",
192475 if( zSql ){
192478 p->db,zSql,-1,SQLITE_PREPARE_PERSISTENT,&pCsr->pStmt,0
192481 sqlite3_free(zSql);
193021 char *zSql = sqlite3_mprintf("INSERT INTO %Q.%Q(%Q) VALUES('flush')",
193024 if( zSql ){
193026 rc = sqlite3_exec(pTab->db, zSql, 0, 0, 0);
193028 sqlite3_free(zSql);
198576 const char zSql[] = "SELECT fts3_tokenizer(?, ?)";
198578 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
198599 const char zSql[] = "SELECT fts3_tokenizer(?)";
198602 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
199840 char *zSql;
199842 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName, p->zWriteExprlist);
199845 zSql = sqlite3_mprintf(azSql[eStmt], p->zReadExprlist);
199847 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName);
199849 if( !zSql ){
199852 rc = sqlite3_prepare_v3(p->db, zSql, -1, f, &pStmt, NULL);
199853 sqlite3_free(zSql);
203011 char *zSql = sqlite3_mprintf("SELECT %s" , p->zReadExprlist);
203012 if( !zSql ){
203015 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
203016 sqlite3_free(zSql);
204762 char *zSql;
204764 zSql = sqlite3_mprintf("SELECT %s" , p->zReadExprlist);
204765 if( !zSql ){
204768 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, 0);
204769 sqlite3_free(zSql);
216515 char *zSql;
216519 zSql = sqlite3_mprintf("SELECT * FROM %Q.%Q", pRtree->zDb, pRtree->zName);
216520 if( zSql ){
216521 rc = sqlite3_prepare_v2(pRtree->db, zSql, -1, &pStmt, 0);
216525 sqlite3_free(zSql);
216725 char *zSql = sqlite3_mprintf(
216733 if( zSql ){
216735 rc = sqlite3_exec(pRtree->db, zSql, 0, 0, 0);
216736 sqlite3_free(zSql);
216772 char *zSql;
216784 zSql = sqlite3_mprintf(zFmt, pRtree->zDb, pRtree->zName);
216785 if( zSql==0 ){
216788 rc = sqlite3_prepare_v2(db, zSql, -1, &p, 0);
216793 sqlite3_free(zSql);
216918 char *zSql;
216928 zSql = sqlite3_mprintf(zFormat, zDb, zPrefix);
216929 if( zSql ){
216930 rc = sqlite3_prepare_v3(db, zSql, -1, f, appStmt[i], 0);
216934 sqlite3_free(zSql);
216945 char *zSql;
216959 zSql = sqlite3_str_finish(p);
216960 if( zSql==0 ){
216963 rc = sqlite3_prepare_v3(db, zSql, -1, f, &pRtree->pWriteAux, 0);
216964 sqlite3_free(zSql);
216979 static int getIntFromStmt(sqlite3 *db, const char *zSql, int *piVal){
216981 if( zSql ){
216983 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
217016 char *zSql;
217019 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", pRtree->zDb);
217020 rc = getIntFromStmt(db, zSql, &iPageSize);
217030 zSql = sqlite3_mprintf(
217034 rc = getIntFromStmt(db, zSql, &pRtree->iNodeSize);
217045 sqlite3_free(zSql);
217080 char *zSql;
217144 zSql = sqlite3_str_finish(pSql);
217145 if( !zSql ){
217150 }else if( SQLITE_OK!=(rc = sqlite3_declare_vtab(db, zSql)) ){
217153 sqlite3_free(zSql);
219007 char *zSql;
219049 zSql = sqlite3_str_finish(pSql);
219050 if( !zSql ){
219052 }else if( SQLITE_OK!=(rc = sqlite3_declare_vtab(db, zSql)) ){
219055 sqlite3_free(zSql);
222016 ** Prepare the SQL statement in buffer zSql against database handle db.
222029 const char *zSql
222031 int rc = sqlite3_prepare_v2(db, zSql, -1, ppStmt, 0);
222056 ** Unless it is NULL, argument zSql points to a buffer allocated using
222067 ** If argument zSql is NULL, this function assumes that an OOM has occurred.
222074 char *zSql
222078 if( zSql==0 ){
222082 rc = prepareAndCollectError(db, ppStmt, pzErrmsg, zSql);
222083 sqlite3_free(zSql);
222313 char *zSql = 0;
222316 zSql = sqlite3_vmprintf(zFmt, ap);
222318 if( zSql==0 ) p->rc = SQLITE_NOMEM;
222320 sqlite3_free(zSql);
222321 zSql = 0;
222324 return zSql;
222339 char *zSql;
222341 zSql = sqlite3_vmprintf(zFmt, ap);
222343 if( zSql==0 ){
222346 p->rc = sqlite3_exec(db, zSql, 0, 0, &p->zErrmsg);
222349 sqlite3_free(zSql);
223415 char *zSql = 0;
223433 zSql = rbuMPrintf(p, "%z%s\"%w\" %s %sCOLLATE %Q%s",
223434 zSql, zComma, zCol, pIter->azTblType[iCol], zPk, zColl,
223443 zSql = rbuMPrintf(p, "%z, %z", zSql, zPk);
223449 pIter->zTbl, zSql,
223531 char *zSql = (char*)sqlite3_column_text(pStmt, 0);
223532 if( zSql ){
223533 pIter->zIdxSql = zSql = rbuStrndup(zSql, &rc);
223535 if( zSql ){
223540 for(i=0; zSql[i]; i++){
223541 char c = zSql[i];
223559 pIter->aIdxCol[0].zSpan = &zSql[i+1];
223566 int nSpan = (int)(&zSql[i] - pIter->aIdxCol[iIdxCol].zSpan);
223572 int nSpan = (int)(&zSql[i] - pIter->aIdxCol[iIdxCol].zSpan);
223574 pIter->aIdxCol[iIdxCol].zSpan = &zSql[i+1];
223577 if( zSql[i]==c ){
223578 if( zSql[i+1]!=c ) break;
223584 if( zSql[i]==']' ) break;
223586 }else if( c=='-' && zSql[i+1]=='-' ){
223587 for(i=i+2; zSql[i] && zSql[i]!='\n'; i++);
223588 if( zSql[i]=='\0' ) break;
223589 }else if( c=='/' && zSql[i+1]=='*' ){
223590 for(i=i+2; zSql[i] && (zSql[i]!='*' || zSql[i+1]!='/'); i++);
223591 if( zSql[i]=='\0' ) break;
223595 if( zSql[i] ){
223596 zRet = rbuStrndup(&zSql[i], &rc);
223677 char *zSql;
223688 zSql = sqlite3_mprintf(
223700 zSql = sqlite3_mprintf(
223706 zSql = sqlite3_mprintf(
223720 p->rc = prepareFreeAndCollectError(p->dbRbu,&pIter->pSelect,pz,zSql);
223722 sqlite3_free(zSql);
224930 const char *zSql = (const char*)sqlite3_column_text(pSql, 0);
224931 p->rc = sqlite3_exec(p->dbMain, zSql, 0, 0, &p->zErrmsg);
227466 char *zSql; /* String value of pSql */
227512 zSql = sqlite3_str_finish(pSql);
227513 if( zSql==0 ){
227516 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pCsr->pStmt, 0);
227517 sqlite3_free(zSql);
230977 char *zSql = 0;
231020 zSql = sqlite3_mprintf(
231025 if( zSql==0 ) rc = SQLITE_NOMEM;
231030 zSql = sqlite3_mprintf(
231034 if( zSql==0 ) rc = SQLITE_NOMEM;
231053 zSql = (char*)buf.aBuf;
231059 rc = sqlite3_prepare_v2(db, zSql, nSql, ppStmt, 0);
231061 sqlite3_free(zSql);
232554 char *zSql = (char*)buf.aBuf;
232555 rc = sqlite3_prepare_v2(p->db, zSql, buf.nBuf, &pUp->pStmt, 0);
232727 static int sessionPrepare(sqlite3 *db, sqlite3_stmt **pp, const char *zSql){
232728 return sqlite3_prepare_v2(db, zSql, -1, pp, 0);
240015 char *zSql;
240017 zSql = sqlite3Fts5Mprintf(&rc, "CREATE TABLE x(");
240018 for(i=0; zSql && i<pConfig->nCol; i++){
240020 zSql = sqlite3Fts5Mprintf(&rc, "%z%s%Q", zSql, zSep, pConfig->azCol[i]);
240022 zSql = sqlite3Fts5Mprintf(&rc, "%z, %Q HIDDEN, %s HIDDEN)",
240023 zSql, pConfig->zName, FTS5_RANK_NAME
240026 assert( zSql || rc==SQLITE_NOMEM );
240027 if( zSql ){
240028 rc = sqlite3_declare_vtab(pConfig->db, zSql);
240029 sqlite3_free(zSql);
240310 char *zSql;
240323 zSql = sqlite3Fts5Mprintf(&rc, zSelect, pConfig->zDb, pConfig->zName);
240324 if( zSql ){
240325 rc = sqlite3_prepare_v2(pConfig->db, zSql, -1, &p, 0);
240326 sqlite3_free(zSql);
245161 char *zSql
245164 if( zSql ){
245165 int rc = sqlite3_prepare_v3(p->pConfig->db, zSql, -1,
245176 sqlite3_free(zSql);
245213 char *zSql = sqlite3_mprintf(
245217 if( fts5IndexPrepareStmt(p, &p->pDeleter, zSql) ) return;
254749 char *zSql;
254753 zSql = sqlite3_vmprintf(zFmt, ap);
254754 if( zSql==0 ){
254757 rc = sqlite3_prepare_v3(pConfig->db, zSql, -1,
254762 sqlite3_free(zSql);
254895 char *zSql = sqlite3Fts5Mprintf(&rc, "SELECT %s", zRankArgs);
254896 if( zSql ){
254898 rc = sqlite3_prepare_v3(pConfig->db, zSql, -1,
254900 sqlite3_free(zSql);
257701 char *zSql = 0;
257707 zSql = sqlite3_mprintf(azStmt[eStmt],
257714 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zContentExprlist,
257722 zSql = sqlite3_mprintf(azStmt[eStmt],
257756 zSql = sqlite3Fts5Mprintf(&rc, azStmt[eStmt], pC->zDb, pC->zName,zBind);
257762 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName,
257768 zSql = sqlite3_mprintf(azStmt[eStmt],
257775 zSql = sqlite3_mprintf(azStmt[eStmt], pC->zDb, pC->zName);
257779 if( zSql==0 ){
257785 rc = sqlite3_prepare_v3(pC->db, zSql, -1, f, &p->aStmt[eStmt], 0);
257787 sqlite3_free(zSql);
257813 char *zSql;
257816 zSql = sqlite3_vmprintf(zFormat, ap);
257818 if( zSql==0 ){
257821 rc = sqlite3_exec(db, zSql, 0, 0, pzErr);
257822 sqlite3_free(zSql);
258689 char *zSql;
258692 zSql = sqlite3_mprintf("SELECT count(*) FROM %Q.'%q_%s'",
258695 if( zSql==0 ){
258699 rc = sqlite3_prepare_v2(pConfig->db, zSql, -1, &pCnt, 0);
258708 sqlite3_free(zSql);
262071 char *zSql = 0;
262079 zSql = sqlite3Fts5Mprintf(&rc,
262083 if( zSql ){
262084 rc = sqlite3_prepare_v2(pTab->db, zSql, -1, &pStmt, 0);
262086 sqlite3_free(zSql);
262584 char *zSql; /* column "sql" */
262727 sqlite3_result_text(ctx, pRow->zSql, -1, SQLITE_TRANSIENT);
262776 const char *zSql = sqlite3_sql(p);
262777 sqlite3_int64 nSql = zSql ? strlen(zSql)+1 : 0;
262782 if( zSql ){
262783 pNew->zSql = (char*)&pNew[1];
262784 memcpy(pNew->zSql, zSql, nSql);