From: Mergen Imeev <imeevma@tarantool.org> To: Vladislav Shpilevoy <v.shpilevoy@tarantool.org> Cc: tarantool-patches@freelists.org Subject: [tarantool-patches] Re: [PATCH v1 15/28] sql: remove SQL_SCHEMA errcode Date: Sat, 15 Jun 2019 12:55:49 +0300 [thread overview] Message-ID: <20190615095549.GD32365@tarantool.org> (raw) In-Reply-To: <a586815c-0ad6-35a5-c6d7-2fad4c65062a@tarantool.org> On Fri, Jun 14, 2019 at 12:24:57AM +0200, Vladislav Shpilevoy wrote: > Thanks for the patch! > > Consider my review fix below and on the branch > in a separate commit. > > ====================================================== > Thank you! New patch: From 3ee6578d0c3400b991d8cceabe572b52c7c8cd85 Mon Sep 17 00:00:00 2001 Date: Tue, 21 May 2019 17:34:13 +0300 Subject: [PATCH] sql: remove SQL_SCHEMA errcode Removing this error code is part of getting rid of the SQL error system. diff --git a/src/box/sql/prepare.c b/src/box/sql/prepare.c index 3ed1269..d909c8b 100644 --- a/src/box/sql/prepare.c +++ b/src/box/sql/prepare.c @@ -56,7 +56,7 @@ sqlPrepare(sql * db, /* Database handle. */ Parse sParse; /* Parsing context */ sql_parser_create(&sParse, db, current_session()->sql_flags); sParse.pReprepare = pReprepare; - assert(ppStmt && *ppStmt == 0); + *ppStmt = NULL; /* assert( !db->mallocFailed ); // not true with SQL_USE_ALLOCA */ /* Check to verify that it is possible to get a read lock on all @@ -181,37 +181,12 @@ sqlPrepare(sql * db, /* Database handle. */ return rc; } -static int -sqlLockAndPrepare(sql * db, /* Database handle. */ - const char *zSql, /* UTF-8 encoded SQL statement. */ - int nBytes, /* Length of zSql in bytes. */ - int saveSqlFlag, /* True to copy SQL text into the sql_stmt */ - Vdbe * pOld, /* VM being reprepared */ - sql_stmt ** ppStmt, /* OUT: A pointer to the prepared statement */ - const char **pzTail) /* OUT: End of parsed string */ -{ - int rc; - - *ppStmt = 0; - assert(zSql != NULL && db != NULL); - rc = sqlPrepare(db, zSql, nBytes, saveSqlFlag, pOld, ppStmt, - pzTail); - if (rc == SQL_SCHEMA) { - sql_finalize(*ppStmt); - rc = sqlPrepare(db, zSql, nBytes, saveSqlFlag, pOld, ppStmt, - pzTail); - } - assert(rc == 0 || *ppStmt == NULL); - return rc; -} - /* * Rerun the compilation of a statement after a schema change. */ int sqlReprepare(Vdbe * p) { - int rc; sql_stmt *pNew; const char *zSql; sql *db; @@ -219,16 +194,11 @@ sqlReprepare(Vdbe * p) zSql = sql_sql((sql_stmt *) p); assert(zSql != 0); /* Reprepare only called for prepare_v2() statements */ db = sqlVdbeDb(p); - rc = sqlLockAndPrepare(db, zSql, -1, 0, p, &pNew, 0); - if (rc) { - if (rc == SQL_NOMEM) { - sqlOomFault(db); - } + if (sqlPrepare(db, zSql, -1, 0, p, &pNew, 0) != 0) { assert(pNew == 0); - return rc; - } else { - assert(pNew != 0); + return -1; } + assert(pNew != 0); sqlVdbeSwap((Vdbe *) pNew, p); sqlTransferBindings(pNew, (sql_stmt *) p); sqlVdbeResetStepResult((Vdbe *) pNew); @@ -239,7 +209,7 @@ sqlReprepare(Vdbe * p) /* * Two versions of the official API. Legacy and new use. In the legacy * version, the original SQL text is not saved in the prepared statement - * and so if a schema change occurs, SQL_SCHEMA is returned by + * and so if a schema change occurs, an error is returned by * sql_step(). In the new version, the original SQL text is retained * and the statement is automatically recompiled if an schema change * occurs. @@ -251,8 +221,7 @@ sql_prepare(sql * db, /* Database handle. */ sql_stmt ** ppStmt, /* OUT: A pointer to the prepared statement */ const char **pzTail) /* OUT: End of parsed string */ { - int rc; - rc = sqlLockAndPrepare(db, zSql, nBytes, 0, 0, ppStmt, pzTail); + int rc = sqlPrepare(db, zSql, nBytes, 0, 0, ppStmt, pzTail); assert(rc == 0 || ppStmt == NULL || *ppStmt == NULL); /* VERIFY: F13021 */ return rc; } @@ -265,8 +234,7 @@ sql_prepare_v2(sql * db, /* Database handle. */ const char **pzTail /* OUT: End of parsed string */ ) { - int rc; - rc = sqlLockAndPrepare(db, zSql, nBytes, 1, 0, ppStmt, pzTail); + int rc = sqlPrepare(db, zSql, nBytes, 1, 0, ppStmt, pzTail); assert(rc == 0 || ppStmt == NULL || *ppStmt == NULL); /* VERIFY: F13021 */ return rc; } diff --git a/src/box/sql/sqlInt.h b/src/box/sql/sqlInt.h index beae49c..9dfecb7 100644 --- a/src/box/sql/sqlInt.h +++ b/src/box/sql/sqlInt.h @@ -333,8 +333,6 @@ enum sql_ret_code { SQL_NOMEM, /** Some kind of disk I/O error occurred. */ SQL_IOERR, - /** The database schema changed. */ - SQL_SCHEMA, /** String or BLOB exceeds size limit. */ SQL_TOOBIG, /** Abort due to constraint violation. */ diff --git a/src/box/sql/vdbe.c b/src/box/sql/vdbe.c index 37e0892..bc13eb2 100644 --- a/src/box/sql/vdbe.c +++ b/src/box/sql/vdbe.c @@ -5089,10 +5089,7 @@ case OP_AggFinal: { /* Opcode: Expire P1 * * * * * - * Cause precompiled statements to expire. When an expired statement - * is executed using sql_step() it will either automatically - * reprepare itself (if it was originally created using sql_prepare_v2()) - * or it will fail with SQL_SCHEMA. + * Cause precompiled statements to expire. * * If P1 is 0, then all SQL statements become expired. If P1 is non-zero, * then only the currently executing statement is expired. diff --git a/src/box/sql/vdbeInt.h b/src/box/sql/vdbeInt.h index 064eb46..2b53aaf 100644 --- a/src/box/sql/vdbeInt.h +++ b/src/box/sql/vdbeInt.h @@ -40,14 +40,6 @@ #define SQL_VDBEINT_H /* - * The maximum number of times that a statement will try to reparse - * itself before giving up and returning SQL_SCHEMA. - */ -#ifndef SQL_MAX_SCHEMA_RETRY -#define SQL_MAX_SCHEMA_RETRY 50 -#endif - -/* * SQL is translated into a sequence of instructions to be * executed by a virtual machine. Each instruction is an instance * of the following structure. diff --git a/src/box/sql/vdbeapi.c b/src/box/sql/vdbeapi.c index 2f69853..46ca499 100644 --- a/src/box/sql/vdbeapi.c +++ b/src/box/sql/vdbeapi.c @@ -424,9 +424,8 @@ sqlStep(Vdbe * p) } if (p->pc <= 0 && p->expired) { - p->rc = SQL_SCHEMA; - rc = SQL_ERROR; - goto end_of_step; + p->rc = SQL_TARANTOOL_ERROR; + return SQL_TARANTOOL_ERROR; } if (p->pc < 0) { @@ -455,7 +454,6 @@ sqlStep(Vdbe * p) if (SQL_NOMEM == sqlApiExit(p->db, p->rc)) { p->rc = SQL_NOMEM; } - end_of_step: if (p->isPrepareV2 && rc != SQL_ROW && rc != SQL_DONE) { /* If this statement was prepared using sql_prepare_v2(), and an * error has occurred, then return the error code in p->rc to the @@ -474,24 +472,9 @@ sqlStep(Vdbe * p) int sql_step(sql_stmt * pStmt) { - int rc; /* Result from sqlStep() */ Vdbe *v = (Vdbe *) pStmt; /* the prepared statement */ - int cnt = 0; /* Counter to prevent infinite loop of reprepares */ - assert(v != NULL); - v->doingRerun = 0; - while ((rc = sqlStep(v)) == SQL_SCHEMA - && cnt++ < SQL_MAX_SCHEMA_RETRY) { - int savedPc = v->pc; - rc = sqlReprepare(v); - if (rc != 0) - break; - sql_reset(pStmt); - if (savedPc >= 0) - v->doingRerun = 1; - assert(v->expired == 0); - } - return rc; + return sqlStep(v); } /*
next prev parent reply other threads:[~2019-06-15 9:55 UTC|newest] Thread overview: 56+ messages / expand[flat|nested] mbox.gz Atom feed top 2019-06-10 13:56 [tarantool-patches] [PATCH v1 00/28] sql: Remove SQL error system imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 01/28] sql: remove field zErrMsg from struct Vdbe imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 02/28] sql: remove field pErr from struct sql imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 03/28] sql: remove field errCode " imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 04/28] sql: remove sqlError() and remove sqlErrorWithMsg() imeevma 2019-06-13 22:25 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 9:45 ` Mergen Imeev 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 05/28] sql: remove unused functions of SQL error system imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 06/28] sql: disable lookaside system imeevma 2019-06-13 22:25 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 9:47 ` Mergen Imeev 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 07/28] sql: remove SQL_OK error/status code imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 9:52 ` Mergen Imeev 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 08/28] sql: remove SQL_PERM, SQL_WARNING, SQL_ABORT errcodes imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 09/28] sql: remove SQL_CANTOPEN errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 10/28] sql: remove SQL_NOTFOUND error/status code imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 11/28] sql: remove SQL_LOCKED errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 12/28] sql: remove SQL_FULL errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 13/28] sql: remove SQL_MISUSE errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 14/28] sql: remove SQL_RANGE errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 15/28] sql: remove SQL_SCHEMA errcode imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 9:55 ` Mergen Imeev [this message] 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 16/28] sql: remove SQL_TOOBIG errcode imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 9:57 ` Mergen Imeev 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 17/28] sql: remove SQL_BUSY errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 18/28] sql: remove SQL_CONSTRAINT errcode imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 10:00 ` Mergen Imeev 2019-06-18 20:40 ` Vladislav Shpilevoy 2019-06-19 8:02 ` Mergen Imeev 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 19/28] sql: remove SQL_ERROR errcode imeevma 2019-06-10 13:56 ` [tarantool-patches] [PATCH v1 20/28] sql: remove SQL_NOMEM errcode imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 10:01 ` Mergen Imeev 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 21/28] sql: remove SQL_IOERR errcode imeevma 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 22/28] sql: remove SQL_TARANTOOL_ERROR errcode imeevma 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 23/28] sql: remove field errMask from struct sql imeevma 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 24/28] sql: replace rc by is_aborted in struct VDBE imeevma 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 25/28] sql: remove sql_log() imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 10:02 ` Mergen Imeev 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 26/28] sql: cleanup of legacy memory management system imeevma 2019-06-13 22:24 ` [tarantool-patches] " Vladislav Shpilevoy 2019-06-15 10:04 ` Mergen Imeev 2019-06-18 20:40 ` Vladislav Shpilevoy 2019-06-19 8:04 ` Mergen Imeev 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 27/28] sql: make function return void instead of int imeevma 2019-06-10 13:57 ` [tarantool-patches] [PATCH v1 28/28] sql: remove function sqlApiExit() imeevma 2019-06-11 10:00 ` [tarantool-patches] Re: [PATCH v1 00/28] sql: Remove SQL error system Imeev Mergen 2019-06-13 22:24 ` Vladislav Shpilevoy 2019-06-15 10:08 ` Mergen Imeev 2019-06-19 19:11 ` Vladislav Shpilevoy 2019-06-20 16:08 ` Kirill Yukhin
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=20190615095549.GD32365@tarantool.org \ --to=imeevma@tarantool.org \ --cc=tarantool-patches@freelists.org \ --cc=v.shpilevoy@tarantool.org \ --subject='[tarantool-patches] Re: [PATCH v1 15/28] sql: remove SQL_SCHEMA errcode' \ /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