From: Nikita Pettik <korablev@tarantool.org> To: tarantool-patches@dev.tarantool.org Cc: v.shpilevoy@tarantool.org Subject: [Tarantool-patches] [PATCH v2 04/16] sql: rename sqlPrepare() to sql_compile() Date: Thu, 21 Nov 2019 00:28:03 +0300 [thread overview] Message-ID: <ef29039dfd4f45f8dc63a2497df93d95ddf942a0.1574277369.git.korablev@tarantool.org> (raw) In-Reply-To: <cover.1574277369.git.korablev@tarantool.org> In-Reply-To: <cover.1574277369.git.korablev@tarantool.org> sql_prepare() is going not only to compile statement, but also to save it to the prepared statement cache. So we'd better rename sqlPrepare() which is static wrapper around sql_prepare() and make it non-static. Where it is possible let's use sql_compile() instead of sql_prepare(). Needed for #2592 --- src/box/execute.c | 2 +- src/box/sql/analyze.c | 6 +++--- src/box/sql/legacy.c | 2 +- src/box/sql/prepare.c | 21 ++++++--------------- src/box/sql/sqlInt.h | 13 +++++++++++++ 5 files changed, 24 insertions(+), 20 deletions(-) diff --git a/src/box/execute.c b/src/box/execute.c index 0b21386b5..83680b70f 100644 --- a/src/box/execute.c +++ b/src/box/execute.c @@ -442,7 +442,7 @@ sql_prepare_and_execute(const char *sql, int len, const struct sql_bind *bind, struct region *region) { struct sql_stmt *stmt; - if (sql_prepare(sql, len, &stmt, NULL) != 0) + if (sql_compile(sql, len, NULL, &stmt, NULL) != 0) return -1; assert(stmt != NULL); port_sql_create(port, stmt); diff --git a/src/box/sql/analyze.c b/src/box/sql/analyze.c index 9a66f8254..a887a2bf3 100644 --- a/src/box/sql/analyze.c +++ b/src/box/sql/analyze.c @@ -1360,7 +1360,7 @@ load_stat_from_space(const char *sql_select_prepare, } } sql_stmt *stmt = NULL; - int rc = sql_prepare(sql_select_prepare, -1, &stmt, 0); + int rc = sql_compile(sql_select_prepare, -1, NULL, &stmt, 0); if (rc) goto finalize; uint32_t current_idx_count = 0; @@ -1428,7 +1428,7 @@ load_stat_from_space(const char *sql_select_prepare, rc = sql_finalize(stmt); if (rc) goto finalize; - rc = sql_prepare(sql_select_load, -1, &stmt, 0); + rc = sql_compile(sql_select_load, -1, NULL, &stmt, 0); if (rc) goto finalize; struct index *prev_index = NULL; @@ -1510,7 +1510,7 @@ load_stat_to_index(const char *sql_select_load, struct index_stat **stats) { assert(stats != NULL && *stats != NULL); struct sql_stmt *stmt = NULL; - if (sql_prepare(sql_select_load, -1, &stmt, 0) != 0) + if (sql_compile(sql_select_load, -1, NULL, &stmt, 0) != 0) return -1; uint32_t current_idx_count = 0; while (sql_step(stmt) == SQL_ROW) { diff --git a/src/box/sql/legacy.c b/src/box/sql/legacy.c index e3a2c77ca..93f927dea 100644 --- a/src/box/sql/legacy.c +++ b/src/box/sql/legacy.c @@ -71,7 +71,7 @@ sql_exec(sql * db, /* The database on which the SQL executes */ char **azVals = 0; pStmt = 0; - rc = sql_prepare(zSql, -1, &pStmt, &zLeftover); + rc = sql_compile(zSql, -1, NULL, &pStmt, &zLeftover); assert(rc == 0 || pStmt == NULL); if (rc != 0) continue; diff --git a/src/box/sql/prepare.c b/src/box/sql/prepare.c index 520b52d64..47e40223d 100644 --- a/src/box/sql/prepare.c +++ b/src/box/sql/prepare.c @@ -39,18 +39,11 @@ #include "box/space.h" #include "box/session.h" -/* - * Compile the UTF-8 encoded SQL statement zSql into a statement handle. - */ -static int -sqlPrepare(sql * db, /* Database handle. */ - const char *zSql, /* UTF-8 encoded SQL statement. */ - int nBytes, /* Length of zSql in bytes. */ - Vdbe * pReprepare, /* VM being reprepared */ - sql_stmt ** ppStmt, /* OUT: A pointer to the prepared statement */ - const char **pzTail /* OUT: End of parsed string */ - ) +int +sql_compile(const char *zSql, int nBytes, struct Vdbe *pReprepare, + sql_stmt **ppStmt, const char **pzTail) { + struct sql *db = sql_get(); int rc = 0; /* Result code */ Parse sParse; /* Parsing context */ sql_parser_create(&sParse, db, current_session()->sql_flags); @@ -185,12 +178,10 @@ sqlReprepare(Vdbe * p) { sql_stmt *pNew; const char *zSql; - sql *db; zSql = sql_sql((sql_stmt *) p); assert(zSql != 0); /* Reprepare only called for prepare_v2() statements */ - db = sqlVdbeDb(p); - if (sqlPrepare(db, zSql, -1, p, &pNew, 0) != 0) { + if (sql_compile(zSql, -1, p, &pNew, 0) != 0) { assert(pNew == 0); return -1; } @@ -206,7 +197,7 @@ int sql_prepare(const char *sql, int length, struct sql_stmt **stmt, const char **sql_tail) { - int rc = sqlPrepare(sql_get(), sql, length, 0, stmt, sql_tail); + int rc = sql_compile(sql, length, 0, stmt, sql_tail); assert(rc == 0 || stmt == NULL || *stmt == NULL); return rc; } diff --git a/src/box/sql/sqlInt.h b/src/box/sql/sqlInt.h index 3ca10778e..07c26e932 100644 --- a/src/box/sql/sqlInt.h +++ b/src/box/sql/sqlInt.h @@ -468,6 +468,19 @@ typedef void (*sql_destructor_type) (void *); #define SQL_STATIC ((sql_destructor_type)0) #define SQL_TRANSIENT ((sql_destructor_type)-1) +/** + * Compile the UTF-8 encoded SQL statement zSql into a statement handle. + * + * @param sql UTF-8 encoded SQL statement. + * @param sql_len Length of @sql in bytes. + * @param re_prepared VM being re-compiled. Can be NULL. + * @param[out] stmt A pointer to the compiled statement. + * @param[out] sql_tail End of parsed string. + */ +int +sql_compile(const char *sql, int bytes_count, struct Vdbe *re_prepared, + sql_stmt **stmt, const char **sql_tail); + int sql_step(sql_stmt *); -- 2.15.1
next prev parent reply other threads:[~2019-11-20 21:28 UTC|newest] Thread overview: 58+ messages / expand[flat|nested] mbox.gz Atom feed top 2019-11-20 21:27 [Tarantool-patches] [PATCH v2 00/16] sql: prepared statements Nikita Pettik 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 01/16] sql: remove sql_prepare_v2() Nikita Pettik 2019-12-04 11:36 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 02/16] sql: refactor sql_prepare() and sqlPrepare() Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-04 11:36 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 03/16] sql: move sql_prepare() declaration to box/execute.h Nikita Pettik 2019-12-04 11:37 ` Konstantin Osipov 2019-12-05 13:32 ` Nikita Pettik 2019-11-20 21:28 ` Nikita Pettik [this message] 2019-12-03 22:51 ` [Tarantool-patches] [PATCH v2 04/16] sql: rename sqlPrepare() to sql_compile() Vladislav Shpilevoy 2019-12-13 13:49 ` Nikita Pettik 2019-12-04 11:39 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 05/16] sql: move sql_finalize() to execute.h Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-04 11:39 ` Konstantin Osipov 2019-12-13 13:49 ` Nikita Pettik 2019-12-04 11:40 ` Konstantin Osipov 2019-12-05 13:37 ` Nikita Pettik 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 06/16] port: increase padding of struct port Nikita Pettik 2019-12-04 11:42 ` Konstantin Osipov 2019-12-13 13:54 ` Nikita Pettik 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 07/16] port: add dump format and request type to port_sql Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-13 13:55 ` Nikita Pettik 2019-12-04 11:52 ` Konstantin Osipov 2019-12-13 13:53 ` Nikita Pettik 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 08/16] sql: resurrect sql_bind_parameter_count() function Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-04 11:54 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 09/16] sql: resurrect sql_bind_parameter_name() Nikita Pettik 2019-12-04 11:55 ` Konstantin Osipov 2019-12-04 11:55 ` Konstantin Osipov 2019-12-13 13:55 ` Nikita Pettik 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 10/16] sql: add sql_stmt_schema_version() Nikita Pettik 2019-12-04 11:57 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 11/16] sql: introduce sql_stmt_sizeof() function Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-13 13:56 ` Nikita Pettik 2019-12-04 11:59 ` Konstantin Osipov 2019-12-13 13:56 ` Nikita Pettik 2019-12-13 14:15 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 12/16] box: increment schema_version on ddl operations Nikita Pettik 2019-12-04 12:03 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 13/16] sql: introduce sql_stmt_query_str() method Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-04 12:04 ` Konstantin Osipov 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 14/16] sql: introduce cache for prepared statemets Nikita Pettik 2019-12-03 22:51 ` Vladislav Shpilevoy 2019-12-04 12:11 ` Konstantin Osipov 2019-12-17 14:43 ` Kirill Yukhin 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 15/16] box: introduce prepared statements Nikita Pettik 2019-12-04 12:13 ` Konstantin Osipov 2019-12-06 23:18 ` Vladislav Shpilevoy 2019-11-20 21:28 ` [Tarantool-patches] [PATCH v2 16/16] netbox: " Nikita Pettik 2019-12-06 23:18 ` Vladislav Shpilevoy 2019-12-03 22:51 ` [Tarantool-patches] [PATCH v2 00/16] sql: " Vladislav Shpilevoy 2019-12-17 15:58 ` Georgy Kirichenko
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=ef29039dfd4f45f8dc63a2497df93d95ddf942a0.1574277369.git.korablev@tarantool.org \ --to=korablev@tarantool.org \ --cc=tarantool-patches@dev.tarantool.org \ --cc=v.shpilevoy@tarantool.org \ --subject='Re: [Tarantool-patches] [PATCH v2 04/16] sql: rename sqlPrepare() to sql_compile()' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox