contrib/sqlite3/sqlite3.c

686 ** The sqlite3_exec() interface is a convenience wrapper around
691 ** ^The sqlite3_exec() interface runs zero or more UTF-8 encoded,
695 ** sqlite3_exec() is not NULL, then it is invoked for each result row
697 ** sqlite3_exec() is relayed through to the 1st argument of each
698 ** callback invocation.  ^If the callback pointer to sqlite3_exec()
703 ** sqlite3_exec(), then execution of the current statement stops and
704 ** subsequent statements are skipped.  ^If the 5th parameter to sqlite3_exec()
709 ** sqlite3_exec() after the error message string is no longer needed.
710 ** ^If the 5th parameter to sqlite3_exec() is not NULL and no errors
711 ** occur, then sqlite3_exec() sets the pointer in its 5th parameter to
714 ** ^If an sqlite3_exec() callback returns non-zero, the sqlite3_exec()
718 ** ^The 2nd argument to the sqlite3_exec() callback function is the
719 ** number of columns in the result.  ^The 3rd argument to the sqlite3_exec()
723 ** sqlite3_exec() callback is a NULL pointer.  ^The 4th argument to the
724 ** sqlite3_exec() callback is an array of pointers to strings where each
728 ** ^If the 2nd parameter to sqlite3_exec() is a NULL pointer, a pointer
736 ** <li> The application must ensure that the 1st parameter to sqlite3_exec()
739 **      the 1st parameter to sqlite3_exec() while sqlite3_exec() is running.
741 **      the 2nd parameter of sqlite3_exec() while sqlite3_exec() is running.
746 SQLITE_API int sqlite3_exec(
2758 ** <li> [sqlite3_exec](db, "[VACUUM]", 0, 0, 0);
3448 ** [sqlite3_exec()].  The sqlite3_get_table() routine does not have access
3451 ** wrapper layer outside of the internal [sqlite3_exec()] call are not
4911 ** calls [sqlite3_exec()], then the following SQL statement would
54618       sqlite3_exec(db, "BEGIN IMMEDIATE; COMMIT;", 0, 0, 0);
65569     sqlite3_exec(db, "PRAGMA table_list",0,0,0);
95572 ** P1 is the result code returned by sqlite3_exec(), sqlite3_reset(),
101340   rc = sqlite3_exec(db, pOp->p4.z, 0, 0, &zErr);
101414       rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
122079       rc = sqlite3_exec(db, zSql, analysisLoader, &sInfo, 0);
122802 ** means that the SQL statement will never-run - the sqlite3_exec() call
126023   ** they will persist after the current sqlite3_exec() call returns.
138237 SQLITE_API int sqlite3_exec(
138307           ** sqlite3_exec() returns non-zero, then sqlite3_exec() will
138824 #define sqlite3_exec                   sqlite3_api->exec
139271   sqlite3_exec,
144119       rc = sqlite3_exec(db, zSql, sqlite3InitCallback, &initData, 0);
153676 ** interface routine of sqlite3_exec().
153696   int rc;            /* Return code from sqlite3_exec() */
153808   rc = sqlite3_exec(db, zSql, sqlite3_get_table_cb, &res, pzErrMsg);
183772 ** Return the number of changes in the most recent call to sqlite3_exec().
189663     *pRc = sqlite3_exec(db, zSql, 0, 0, 0);
193026         rc = sqlite3_exec(pTab->db, zSql, 0, 0, 0);
205257   rc = sqlite3_exec(p->db, "SAVEPOINT fts3", 0, 0, 0);
205261       int rc2 = sqlite3_exec(p->db, "RELEASE fts3", 0, 0, 0);
205264       sqlite3_exec(p->db, "ROLLBACK TO fts3", 0, 0, 0);
205265       sqlite3_exec(p->db, "RELEASE fts3", 0, 0, 0);
214536     rc = sqlite3_exec(pRtree->db, zCreate, 0, 0, 0);
216735     rc = sqlite3_exec(pRtree->db, zSql, 0, 0, 0);
216900     rc = sqlite3_exec(db, zCreate, 0, 0, 0);
222167       rc = sqlite3_exec(p->dbMain,
222346       p->rc = sqlite3_exec(db, zSql, 0, 0, &p->zErrmsg);
224098     p->rc = sqlite3_exec(p->dbRbu, "BEGIN", 0, 0, 0);
224129         p->rc = sqlite3_exec(p->dbRbu, "COMMIT", 0, 0, 0);
224311       p->rc = sqlite3_exec(p->dbMain, "SELECT * FROM sqlite_schema", 0, 0, 0);
224346     rc2 = sqlite3_exec(p->dbMain, "PRAGMA main.wal_checkpoint=restart", 0, 0,0);
224920   p->rc = sqlite3_exec(p->dbMain, "PRAGMA writable_schema=1", 0,0, &p->zErrmsg);
224931     p->rc = sqlite3_exec(p->dbMain, zSql, 0, 0, &p->zErrmsg);
224957     p->rc = sqlite3_exec(p->dbMain, "PRAGMA writable_schema=0",0,0,&p->zErrmsg);
225016             p->rc = sqlite3_exec(p->dbMain, "COMMIT", 0, 0, &p->zErrmsg);
225019             p->rc = sqlite3_exec(p->dbRbu, "COMMIT", 0, 0, &p->zErrmsg);
225383         p->rc = sqlite3_exec(p->dbRbu, "BEGIN", 0, 0, &p->zErrmsg);
225404             p->rc = sqlite3_exec(db, "BEGIN IMMEDIATE", 0, 0, &p->zErrmsg);
225413               p->rc = sqlite3_exec(
225532       p->rc = sqlite3_exec(p->dbMain, "COMMIT", 0, 0, &p->zErrmsg);
225544       p->rc = sqlite3_exec(p->dbRbu, "COMMIT", 0, 0, &p->zErrmsg);
225556       int rc2 = sqlite3_exec(p->dbRbu, "DELETE FROM stat.rbu_state", 0, 0, 0);
225667     if( rc==SQLITE_OK ) rc = sqlite3_exec(p->dbMain, "COMMIT", 0, 0, 0);
225682     if( rc==SQLITE_OK ) rc = sqlite3_exec(p->dbRbu, "COMMIT", 0, 0, 0);
225685       rc = sqlite3_exec(p->dbRbu, zBegin, 0, 0, 0);
225687     if( rc==SQLITE_OK ) rc = sqlite3_exec(p->dbMain, "BEGIN IMMEDIATE", 0, 0,0);
231197   rc = sqlite3_exec(pSession->db, "SAVEPOINT changeset", 0, 0, 0);
231286   sqlite3_exec(db, "RELEASE changeset", 0, 0, 0);
233232       rc = sqlite3_exec(db, "SAVEPOINT replace_op", 0, 0, 0);
233246         rc = sqlite3_exec(db, "RELEASE replace_op", 0, 0, 0);
233351     rc = sqlite3_exec(db, "SAVEPOINT changeset_apply", 0, 0, 0);
233354     rc = sqlite3_exec(db, "PRAGMA defer_foreign_keys = 1", 0, 0, 0);
233490     int rc2 = sqlite3_exec(db, "PRAGMA defer_foreign_keys = 0", 0, 0, 0);
233496       rc = sqlite3_exec(db, "RELEASE changeset_apply", 0, 0, 0);
233499       sqlite3_exec(db, "ROLLBACK TO changeset_apply", 0, 0, 0);
233500       sqlite3_exec(db, "RELEASE changeset_apply", 0, 0, 0);
257821     rc = sqlite3_exec(db, zSql, 0, 0, pzErr);