Lines Matching defs:zSql
2189 const char *zSql, /* SQL to be evaluated */
2884 ** The second argument, "zSql", is the statement to be compiled, encoded
2889 ** ^If the nByte argument is less than zero, then zSql is read up to the
2891 ** number of bytes read from zSql. ^When nByte is non-negative, the
2892 ** zSql string ends at either the first '\000' or '\u0000' character or
2900 ** past the end of the first SQL statement in zSql. These routines only
2901 ** compile the first statement in zSql, so *pzTail is left pointing to
2955 const char *zSql, /* SQL statement, UTF-8 encoded */
2956 int nByte, /* Maximum length of zSql in bytes. */
2958 const char **pzTail /* OUT: Pointer to unused portion of zSql */
2962 const char *zSql, /* SQL statement, UTF-8 encoded */
2963 int nByte, /* Maximum length of zSql in bytes. */
2965 const char **pzTail /* OUT: Pointer to unused portion of zSql */
2969 const void *zSql, /* SQL statement, UTF-16 encoded */
2970 int nByte, /* Maximum length of zSql in bytes. */
2972 const void **pzTail /* OUT: Pointer to unused portion of zSql */
2976 const void *zSql, /* SQL statement, UTF-16 encoded */
2977 int nByte, /* Maximum length of zSql in bytes. */
2979 const void **pzTail /* OUT: Pointer to unused portion of zSql */
17762 char *zSql; /* Text of the SQL statement that generated this */
47203 assert( p->zSql==0 );
47204 p->zSql = sqlite3DbStrNDup(p->db, z, n);
47213 return (p->isPrepareV2 ? p->zSql : 0);
47231 zTmp = pA->zSql;
47232 pA->zSql = pB->zSql;
47233 pB->zSql = zTmp;
49480 sqlite3DbFree(db, p->zSql);
50613 if( rc!=SQLITE_ROW && db->xProfile && !db->init.busy && p->zSql ){
50620 db->xProfile(db->pProfileArg, p->zSql, elapseTime);
51505 ** zSql is a zero-terminated string of UTF-8 SQL text. Return the number of
51510 static int findNextHostParameter(const char *zSql, int *pnToken){
51516 while( zSql[0] ){
51517 n = sqlite3GetToken((u8*)zSql, &tokenType);
51524 zSql += n;
52569 char *zSql;
56746 char *zSql;
56781 u.bu.zSql = sqlite3MPrintf(db,
56784 if( u.bu.zSql==0 ){
56792 rc = sqlite3_exec(db, u.bu.zSql, sqlite3InitCallback, &u.bu.initData, 0);
56794 sqlite3DbFree(db, u.bu.zSql);
57880 u.cm.zTrace = (pOp->p4.z ? pOp->p4.z : p->zSql);
64017 unsigned char const *zSql = sqlite3_value_text(argv[0]);
64022 unsigned char const *zCsr = zSql;
64034 if( zSql ){
64055 zRet = sqlite3MPrintf(db, "%.*s\"%w\"%s", ((u8*)tname.z) - zSql, zSql,
64137 unsigned char const *zSql = sqlite3_value_text(argv[0]);
64143 unsigned char const *zCsr = zSql;
64155 if( zSql ){
64194 zRet = sqlite3MPrintf(db, "%.*s\"%w\"%s", ((u8*)tname.z) - zSql, zSql,
65305 char *zSql;
65327 zSql = sqlite3MPrintf(db,
65329 if( zSql==0 ){
65333 rc = sqlite3_exec(db, zSql, analysisLoader, &sInfo, 0);
65335 sqlite3DbFree(db, zSql);
65347 zSql = sqlite3MPrintf(db,
65349 if( !zSql ){
65353 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
65355 sqlite3DbFree(db, zSql);
66441 char *zSql;
66450 zSql = sqlite3VMPrintf(db, zFormat, ap);
66452 if( zSql==0 ){
66458 sqlite3RunParser(pParse, zSql, &zErrMsg);
66460 sqlite3DbFree(db, zSql);
75574 const char *zSql, /* The SQL to be executed */
75586 if( zSql==0 ) zSql = "";
75590 while( (rc==SQLITE_OK || (rc==SQLITE_SCHEMA && (++nRetry)<2)) && zSql[0] ){
75595 rc = sqlite3_prepare(db, zSql, -1, &pStmt, &zLeftover);
75602 zSql = zLeftover;
75654 zSql = zLeftover;
75655 while( sqlite3Isspace(zSql[0]) ) zSql++;
78432 char *zSql;
78433 zSql = sqlite3MPrintf(db,
78443 rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
78450 sqlite3DbFree(db, zSql);
78635 ** Compile the UTF-8 encoded SQL statement zSql into a statement handle.
78639 const char *zSql, /* UTF-8 encoded SQL statement. */
78640 int nBytes, /* Length of zSql in bytes. */
78708 if( nBytes>=0 && (nBytes==0 || zSql[nBytes-1]!=0) ){
78719 zSqlCopy = sqlite3DbStrNDup(db, zSql, nBytes);
78723 pParse->zTail = &zSql[pParse->zTail-zSqlCopy];
78725 pParse->zTail = &zSql[nBytes];
78728 sqlite3RunParser(pParse, zSql, &zErrMsg);
78779 sqlite3VdbeSetSql(pVdbe, zSql, (int)(pParse->zTail-zSql), saveSqlFlag);
78812 const char *zSql, /* UTF-8 encoded SQL statement. */
78813 int nBytes, /* Length of zSql in bytes. */
78827 rc = sqlite3Prepare(db, zSql, nBytes, saveSqlFlag, pOld, ppStmt, pzTail);
78830 rc = sqlite3Prepare(db, zSql, nBytes, saveSqlFlag, pOld, ppStmt, pzTail);
78848 const char *zSql;
78852 zSql = sqlite3_sql((sqlite3_stmt *)p);
78853 assert( zSql!=0 ); /* Reprepare only called for prepare_v2() statements */
78856 rc = sqlite3LockAndPrepare(db, zSql, -1, 0, p, &pNew, 0);
78884 const char *zSql, /* UTF-8 encoded SQL statement. */
78885 int nBytes, /* Length of zSql in bytes. */
78890 rc = sqlite3LockAndPrepare(db,zSql,nBytes,0,0,ppStmt,pzTail);
78896 const char *zSql, /* UTF-8 encoded SQL statement. */
78897 int nBytes, /* Length of zSql in bytes. */
78902 rc = sqlite3LockAndPrepare(db,zSql,nBytes,1,0,ppStmt,pzTail);
78910 ** Compile the UTF-16 encoded SQL statement zSql into a statement handle.
78914 const void *zSql, /* UTF-8 encoded SQL statement. */
78915 int nBytes, /* Length of zSql in bytes. */
78934 zSql8 = sqlite3Utf16to8(db, zSql, nBytes);
78946 *pzTail = (u8 *)zSql + sqlite3Utf16ByteLen(zSql, chars_parsed);
78964 const void *zSql, /* UTF-8 encoded SQL statement. */
78965 int nBytes, /* Length of zSql in bytes. */
78970 rc = sqlite3Prepare16(db,zSql,nBytes,0,ppStmt,pzTail);
78976 const void *zSql, /* UTF-8 encoded SQL statement. */
78977 int nBytes, /* Length of zSql in bytes. */
78982 rc = sqlite3Prepare16(db,zSql,nBytes,1,ppStmt,pzTail);
83394 const char *zSql, /* The SQL to be executed */
83419 rc = sqlite3_exec(db, zSql, sqlite3_get_table_cb, &res, pzErrMsg);
85254 ** Execute zSql on database db. Return an error code.
85256 static int execSql(sqlite3 *db, const char *zSql){
85259 if( !zSql ){
85262 if( SQLITE_OK!=sqlite3_prepare(db, zSql, -1, &pStmt, 0) ){
85271 ** Execute zSql on database db. The statement returns exactly
85274 static int execExecSql(sqlite3 *db, const char *zSql){
85278 rc = sqlite3_prepare(db, zSql, -1, &pStmt, 0);
85317 char *zSql = 0; /* SQL statements */
85359 zSql = "ATTACH '' AS vacuum_db;";
85360 rc = execSql(db, zSql);
94694 SQLITE_PRIVATE int sqlite3RunParser(Parse *pParse, const char *zSql, char **pzErrMsg){
94710 pParse->zTail = zSql;
94726 while( !db->mallocFailed && zSql[i]!=0 ){
94728 pParse->sLastToken.z = &zSql[i];
94729 pParse->sLastToken.n = sqlite3GetToken((unsigned char*)&zSql[i],&tokenType);
94752 pParse->zTail = &zSql[i];
94766 if( zSql[i]==0 && nErr==0 && pParse->rc==SQLITE_OK ){
94769 pParse->zTail = &zSql[i];
94938 SQLITE_API int sqlite3_complete(const char *zSql){
94971 while( *zSql ){
94972 switch( *zSql ){
94986 if( zSql[1]!='*' ){
94990 zSql += 2;
94991 while( zSql[0] && (zSql[0]!='*' || zSql[1]!='/') ){ zSql++; }
94992 if( zSql[0]==0 ) return 0;
94993 zSql++;
94998 if( zSql[1]!='-' ){
95002 while( *zSql && *zSql!='\n' ){ zSql++; }
95003 if( *zSql==0 ) return state==1;
95008 zSql++;
95009 while( *zSql && *zSql!=']' ){ zSql++; }
95010 if( *zSql==0 ) return 0;
95017 int c = *zSql;
95018 zSql++;
95019 while( *zSql && *zSql!=c ){ zSql++; }
95020 if( *zSql==0 ) return 0;
95028 if( IdChar((u8)*zSql) ){
95031 for(nId=1; IdChar(zSql[nId]); nId++){}
95035 switch( *zSql ){
95037 if( nId==6 && sqlite3StrNICmp(zSql, "create", 6)==0 ){
95045 if( nId==7 && sqlite3StrNICmp(zSql, "trigger", 7)==0 ){
95047 }else if( nId==4 && sqlite3StrNICmp(zSql, "temp", 4)==0 ){
95049 }else if( nId==9 && sqlite3StrNICmp(zSql, "temporary", 9)==0 ){
95057 if( nId==3 && sqlite3StrNICmp(zSql, "end", 3)==0 ){
95061 if( nId==7 && sqlite3StrNICmp(zSql, "explain", 7)==0 ){
95076 zSql += nId-1;
95085 zSql++;
95096 SQLITE_API int sqlite3_complete16(const void *zSql){
95106 sqlite3ValueSetStr(pVal, -1, zSql, SQLITE_UTF16NATIVE, SQLITE_STATIC);
98879 char *zSql = sqlite3_mprintf(
98889 if( zSql ){
98890 rc = sqlite3_exec(p->db, zSql, 0, 0, 0);
98891 sqlite3_free(zSql);
98912 char *zSql; /* SQL statement passed to declare_vtab() */
98922 zSql = sqlite3_mprintf(
98926 if( !zCols || !zSql ){
98929 rc = sqlite3_declare_vtab(p->db, zSql);
98932 sqlite3_free(zSql);
98946 char *zSql; /* SQL script to create required tables */
98956 zSql = sqlite3_mprintf(
98974 if( zContentCols==0 || zSql==0 ){
98977 rc = sqlite3_exec(p->db, zSql, 0, 0, 0);
98980 sqlite3_free(zSql);
100291 char *zSql; /* SQL statement used to access %_content */
100313 zSql = sqlite3_mprintf(azSql[idxNum==FTS3_FULLSCAN_SEARCH], p->zDb, p->zName);
100314 if( !zSql ){
100317 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pCsr->pStmt, 0);
100318 sqlite3_free(zSql);
100753 char *zSql; /* SQL script to run to rename tables */
100755 zSql = sqlite3_mprintf(
100763 if( zSql ){
100764 rc = sqlite3_exec(p->db, zSql, 0, 0, 0);
100765 sqlite3_free(zSql);
101662 const char zSql[] = "SELECT fts3_tokenizer(?)";
101665 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
103191 const char zSql[] = "SELECT fts3_tokenizer(?, ?)";
103193 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
103213 const char zSql[] = "SELECT fts3_tokenizer(?)";
103216 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
103773 char *zSql;
103788 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName, zVarlist);
103790 zSql = sqlite3_mprintf(azSql[eStmt], p->zDb, p->zName);
103792 if( !zSql ){
103795 rc = sqlite3_prepare_v2(p->db, zSql, -1, &pStmt, NULL);
103796 sqlite3_free(zSql);
109750 char *zSql = sqlite3_mprintf(
109758 if( zSql ){
109759 rc = sqlite3_exec(pRtree->db, zSql, 0, 0, 0);
109760 sqlite3_free(zSql);
109848 char *zSql = sqlite3_mprintf(azSql[i], zDb, zPrefix);
109849 if( zSql ){
109850 rc = sqlite3_prepare_v2(db, zSql, -1, appStmt[i], 0);
109854 sqlite3_free(zSql);
109868 char *zSql;
109871 zSql = sqlite3_mprintf("PRAGMA %Q.page_size", zDb);
109872 if( !zSql ){
109876 rc = sqlite3_prepare_v2(db, zSql, -1, &pStmt, 0);
109877 sqlite3_free(zSql);
109967 char *zSql = sqlite3_mprintf("CREATE TABLE x(%s", argv[3]);
109970 for(ii=4; zSql && ii<argc; ii++){
109971 zTmp = zSql;
109972 zSql = sqlite3_mprintf("%s, %s", zTmp, argv[ii]);
109975 if( zSql ){
109976 zTmp = zSql;
109977 zSql = sqlite3_mprintf("%s);", zTmp);
109980 if( !zSql ){
109982 }else if( SQLITE_OK!=(rc = sqlite3_declare_vtab(db, zSql)) ){
109985 sqlite3_free(zSql);