Lines Matching defs:sql
737 const char *sql, /* SQL to be evaluated */
3026 SQLITE_API int sqlite3_complete(const char *sql);
3027 SQLITE_API int sqlite3_complete16(const void *sql);
19278 #define OPFLAG_ISUPDATE 0x04 /* This OP_Insert is an sql UPDATE */
88682 /* This case occurs after failing to recompile an sql statement.
112391 " AND sql NOT LIKE 'create virtual%%'"
112392 " AND sqlite_rename_test(%Q, sql, type, name, %d, %Q, %d)=NULL ",
112402 " AND sql NOT LIKE 'create virtual%%'"
112403 " AND sqlite_rename_test(%Q, sql, type, name, 1, %Q, %d)=NULL ",
112411 ** identifiers) within the "sql" column of the sqlite_schema table in
112419 " SET sql = sqlite_rename_quotefix(%Q, sql)"
112421 " AND sql NOT LIKE 'create virtual%%'" , zDb, zDb
112426 " SET sql = sqlite_rename_quotefix('temp', sql)"
112428 " AND sql NOT LIKE 'create virtual%%'"
112544 "sql = sqlite_rename_table(%Q, type, name, sql, %Q, %Q, %d) "
112585 "sql = sqlite_rename_table(%Q, type, name, sql, %Q, %Q, 1), "
112588 " sqlite_rename_test(%Q, sql, type, name, 1, 'after rename', 0) "
112745 "sql = printf('%%.%ds, ',sql) || %Q"
112746 " || substr(sql,1+length(printf('%%.%ds',sql))) "
112979 "sql = sqlite_rename_column(sql, type, name, %Q, %Q, %d, %Q, %d, %d) "
112989 "sql = sqlite_rename_column(sql, type, name, %Q, %Q, %d, %Q, %d, 1) "
114513 "sql = sqlite_drop_column(%d, sql, %d) "
120353 " SET type='%s', name=%Q, tbl_name=%Q, rootpage=#%d, sql=%Q"
132003 int (*complete)(const char*sql);
132004 int (*complete16)(const void*sql);
132134 const char *(*sql)(sqlite3_stmt*);
132479 #define sqlite3_sql sqlite3_api->sql
137373 "rootpage int,sql text)";
149554 ** corrupt the sqlite_schema.sql field with other kinds of statements
149803 "SELECT sql FROM \"%w\".sqlite_schema"
149810 "SELECT sql FROM \"%w\".sqlite_schema"
150426 "SET type='table', name=%Q, tbl_name=%Q, rootpage=0, sql=%Q "
150438 zWhere = sqlite3MPrintf(db, "name=%Q AND sql=%Q", pTab->zName, zStmt);
191584 ** s sq sql sqli sqlit sqlite
209804 "SELECT name, rootpage, sql IS NULL OR substr(8, 6)=='UNIQUE' "
209979 ** }else if( sql for the entry starts with "CREATE VIRTUAL" ){
210016 " (sql COLLATE nocase BETWEEN 'CREATE VIRTUAL' AND 'CREATE VIRTUAM'),"
211036 "SELECT trim(sql) FROM sqlite_schema WHERE type='index' AND name=?"
212417 "SELECT sql FROM sqlite_schema WHERE sql!='' AND rootpage!=0"
244300 char *zSql; /* column "sql" */
244363 "CREATE TABLE x(sql,ncol,ro,busy,nscan,nsort,naidx,nstep,"
246057 char *sql = sqlite3_mprintf("PRAGMA %s;", metaName);
246058 if(sql == NULL){
246062 int rc = sqlite3_prepare_v2(db, sql, -1, &statement, NULL);
246063 sqlite3_free(sql);
246075 sql = sqlite3_mprintf("PRAGMA %s.%s=%d;", dbName, metaName, metadata);
246076 if(sql == NULL){
246079 rc = sqlite3_exec(db, sql, NULL, NULL, NULL);
246080 sqlite3_free(sql);
246084 CODEC_STATIC int sqlite3CodecBatchExportSql(sqlite3 *db, const char *sql, char **errMsg){
246086 int rc = sqlite3_prepare_v2(db, sql, -1, &statement, NULL);
246106 char *sql = NULL;
246132 sql = sqlite3_mprintf("SELECT 'CREATE TABLE %s.' || substr(sql,14) FROM sqlite_master WHERE type='table' AND name!='sqlite_sequence' AND rootpage>0;", dbName);
246133 if(sql == NULL){
246137 rc = sqlite3CodecBatchExportSql(db, sql, &errMsg);
246138 sqlite3_free(sql);
246142 sql = sqlite3_mprintf("SELECT 'CREATE INDEX %s.' || substr(sql,14) FROM sqlite_master WHERE sql LIKE 'CREATE INDEX %%';", dbName);
246143 if(sql == NULL){
246147 rc = sqlite3CodecBatchExportSql(db, sql, &errMsg);
246148 sqlite3_free(sql);
246152 sql = sqlite3_mprintf("SELECT 'CREATE UNIQUE INDEX %s.' || substr(sql,21) FROM sqlite_master WHERE sql LIKE 'CREATE UNIQUE INDEX %%';", dbName);
246153 if(sql == NULL){
246157 rc = sqlite3CodecBatchExportSql(db, sql, &errMsg);
246158 sqlite3_free(sql);
246162 sql = sqlite3_mprintf("SELECT 'INSERT INTO %s.' || quote(name) || ' SELECT * FROM main.' || quote(name) || ';' FROM main.sqlite_master WHERE type = 'table' AND name!='sqlite_sequence' AND rootpage>0;", dbName);
246163 if(sql == NULL){
246167 rc = sqlite3CodecBatchExportSql(db, sql, &errMsg);
246168 sqlite3_free(sql);
246172 sql = sqlite3_mprintf("SELECT 'DELETE FROM %s.' || quote(name) || ';' FROM %s.sqlite_master WHERE name='sqlite_sequence';", dbName, dbName);
246173 if(sql == NULL){
246177 rc = sqlite3CodecBatchExportSql(db, sql, &errMsg);
246178 sqlite3_free(sql);
246182 sql = sqlite3_mprintf("SELECT 'INSERT INTO %s.' || quote(name) || ' SELECT * FROM main.' || quote(name) || ';' FROM %s.sqlite_master WHERE name=='sqlite_sequence';", dbName, dbName);
246183 if(sql == NULL){
246187 rc = sqlite3CodecBatchExportSql(db, sql, &errMsg);
246188 sqlite3_free(sql);
246192 sql = sqlite3_mprintf("INSERT INTO %s.sqlite_master SELECT type, name, tbl_name, rootpage, sql FROM main.sqlite_master WHERE type='view' OR type='trigger' OR (type='table' AND rootpage=0);", dbName, dbName);
246193 if(sql == NULL){
246197 rc = sqlite3_exec(db, sql, NULL, NULL, &errMsg);
246198 sqlite3_free(sql);