From: Kirill Shcherbatov <kshcherbatov@tarantool.org>
To: tarantool-patches@freelists.org
Cc: v.shpilevoy@tarantool.org,
Kirill Shcherbatov <kshcherbatov@tarantool.org>
Subject: [tarantool-patches] [PATCH v7 5/7] sql: change sqlite3AddCheckConstraint signature
Date: Wed, 23 May 2018 17:05:32 +0300 [thread overview]
Message-ID: <d2a54c8e3d7095b67a429608ca36f2d8bd0adda2.1527084287.git.kshcherbatov@tarantool.org> (raw)
In-Reply-To: <cover.1527084286.git.kshcherbatov@tarantool.org>
In-Reply-To: <cover.1527084286.git.kshcherbatov@tarantool.org>
As we would store Check source expr in MsgPack we need
span instead of parsed Expr only.
Renamed refactored function to sql_add_check_constraint.
Part of #3272.
---
src/box/sql/build.c | 24 ++++++++++--------------
src/box/sql/parse.y | 4 ++--
src/box/sql/sqliteInt.h | 9 ++++++++-
3 files changed, 20 insertions(+), 17 deletions(-)
diff --git a/src/box/sql/build.c b/src/box/sql/build.c
index a6ddcf0..afb1128 100644
--- a/src/box/sql/build.c
+++ b/src/box/sql/build.c
@@ -1019,26 +1019,22 @@ sqlite3AddPrimaryKey(Parse * pParse, /* Parsing context */
return;
}
-/*
- * Add a new CHECK constraint to the table currently under construction.
- */
void
-sqlite3AddCheckConstraint(Parse * pParse, /* Parsing context */
- Expr * pCheckExpr /* The check expression */
- )
+sql_add_check_constraint(Parse *parser, ExprSpan *span)
{
#ifndef SQLITE_OMIT_CHECK
- Table *pTab = pParse->pNewTable;
- if (pTab) {
- pTab->pCheck =
- sqlite3ExprListAppend(pParse, pTab->pCheck, pCheckExpr);
- if (pParse->constraintName.n) {
- sqlite3ExprListSetName(pParse, pTab->pCheck,
- &pParse->constraintName, 1);
+ struct Expr *expr = span->pExpr;
+ Table *table = parser->pNewTable;
+ if (table != NULL) {
+ table->pCheck =
+ sqlite3ExprListAppend(parser, table->pCheck, expr);
+ if (parser->constraintName.n) {
+ sqlite3ExprListSetName(parser, table->pCheck,
+ &parser->constraintName, 1);
}
} else
#endif
- sql_expr_delete(pParse->db, pCheckExpr, false);
+ sql_expr_delete(parser->db, expr, false);
}
/*
diff --git a/src/box/sql/parse.y b/src/box/sql/parse.y
index 8eac310..cc3931d 100644
--- a/src/box/sql/parse.y
+++ b/src/box/sql/parse.y
@@ -284,7 +284,7 @@ ccons ::= PRIMARY KEY sortorder(Z) onconf(R) autoinc(I).
ccons ::= UNIQUE onconf(R). {sql_create_index(pParse,0,0,0,R,0,0,
SORT_ORDER_ASC, false,
SQLITE_IDXTYPE_UNIQUE);}
-ccons ::= CHECK LP expr(X) RP. {sqlite3AddCheckConstraint(pParse,X.pExpr);}
+ccons ::= CHECK LP expr(X) RP. {sql_add_check_constraint(pParse,&X);}
ccons ::= REFERENCES nm(T) eidlist_opt(TA) refargs(R).
{sqlite3CreateForeignKey(pParse,0,&T,TA,R);}
ccons ::= defer_subclause(D). {sqlite3DeferForeignKey(pParse,D);}
@@ -336,7 +336,7 @@ tcons ::= UNIQUE LP sortlist(X) RP onconf(R).
SORT_ORDER_ASC,false,
SQLITE_IDXTYPE_UNIQUE);}
tcons ::= CHECK LP expr(E) RP onconf.
- {sqlite3AddCheckConstraint(pParse,E.pExpr);}
+ {sql_add_check_constraint(pParse,&E);}
tcons ::= FOREIGN KEY LP eidlist(FA) RP
REFERENCES nm(T) eidlist_opt(TA) refargs(R) defer_subclause_opt(D). {
sqlite3CreateForeignKey(pParse, FA, &T, TA, R);
diff --git a/src/box/sql/sqliteInt.h b/src/box/sql/sqliteInt.h
index a7ef80f..a1a5269 100644
--- a/src/box/sql/sqliteInt.h
+++ b/src/box/sql/sqliteInt.h
@@ -3532,7 +3532,14 @@ void sqlite3StartTable(Parse *, Token *, int);
void sqlite3AddColumn(Parse *, Token *, Token *);
void sqlite3AddNotNull(Parse *, int);
void sqlite3AddPrimaryKey(Parse *, ExprList *, int, int, enum sort_order);
-void sqlite3AddCheckConstraint(Parse *, Expr *);
+
+/**
+ * Add a new CHECK constraint to the table currently under construction.
+ * @param parser Parsing context.
+ * @param span parser parsed expression object..
+ */
+void sql_add_check_constraint(Parse *parser, ExprSpan *span);
+
void sqlite3AddDefaultValue(Parse *, ExprSpan *);
void sqlite3AddCollateType(Parse *, Token *);
--
2.7.4
next prev parent reply other threads:[~2018-05-23 14:05 UTC|newest]
Thread overview: 43+ messages / expand[flat|nested] mbox.gz Atom feed top
2018-05-23 14:05 [tarantool-patches] [PATCH v7 0/7] sql: remove Checks to server Kirill Shcherbatov
2018-05-23 14:05 ` [tarantool-patches] [PATCH v7 1/7] sql: remove parser construct, destruct to sql.h Kirill Shcherbatov
2018-05-23 17:46 ` [tarantool-patches] " Konstantin Osipov
2018-05-24 19:26 ` Vladislav Shpilevoy
2018-05-25 12:05 ` Kirill Shcherbatov
2018-05-23 14:05 ` [tarantool-patches] [PATCH v7 2/7] box: introduce OPT_ARRAY opt_type to decode arrays Kirill Shcherbatov
2018-05-23 17:53 ` [tarantool-patches] " Konstantin Osipov
2018-05-24 7:32 ` Kirill Shcherbatov
2018-05-24 19:26 ` Vladislav Shpilevoy
2018-05-25 11:54 ` Kirill Shcherbatov
2018-05-23 14:05 ` [tarantool-patches] [PATCH v7 3/7] sql: introduce expr_len for sql_expr_compile Kirill Shcherbatov
2018-05-24 19:26 ` [tarantool-patches] " Vladislav Shpilevoy
2018-05-25 11:54 ` Kirill Shcherbatov
2018-05-23 14:05 ` [tarantool-patches] [PATCH v7 4/7] sql: rename sql_expr_free to sql_expr_delete Kirill Shcherbatov
2018-05-23 18:00 ` [tarantool-patches] " Konstantin Osipov
2018-05-24 19:26 ` Vladislav Shpilevoy
2018-05-25 11:54 ` Kirill Shcherbatov
2018-05-23 14:05 ` Kirill Shcherbatov [this message]
2018-05-23 18:01 ` [tarantool-patches] Re: [PATCH v7 5/7] sql: change sqlite3AddCheckConstraint signature Konstantin Osipov
2018-05-24 19:26 ` Vladislav Shpilevoy
2018-05-25 11:53 ` Kirill Shcherbatov
2018-05-29 11:51 ` n.pettik
2018-05-30 8:32 ` Kirill Shcherbatov
2018-05-23 14:05 ` [tarantool-patches] [PATCH v7 6/7] sql: export funcs defined on Expr, ExprList to sql.h Kirill Shcherbatov
2018-05-23 18:15 ` [tarantool-patches] " Konstantin Osipov
2018-05-24 7:33 ` Kirill Shcherbatov
2018-05-24 19:26 ` Vladislav Shpilevoy
2018-05-25 11:53 ` Kirill Shcherbatov
2018-05-28 11:19 ` Vladislav Shpilevoy
2018-05-28 14:59 ` Kirill Shcherbatov
2018-05-23 14:05 ` [tarantool-patches] [PATCH v7 7/7] sql: remove Checks to server Kirill Shcherbatov
2018-05-24 19:26 ` [tarantool-patches] " Vladislav Shpilevoy
2018-05-25 11:53 ` Kirill Shcherbatov
2018-05-28 11:19 ` Vladislav Shpilevoy
2018-05-28 14:59 ` Kirill Shcherbatov
2018-05-28 18:50 ` Vladislav Shpilevoy
2018-05-29 11:49 ` n.pettik
2018-05-30 8:32 ` Kirill Shcherbatov
2018-05-30 10:42 ` n.pettik
2018-05-25 12:04 ` [tarantool-patches] Re: [PATCH v7 0/7] " Kirill Shcherbatov
2018-05-28 11:19 ` Vladislav Shpilevoy
2018-05-30 11:03 ` n.pettik
2018-05-31 17:44 ` 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=d2a54c8e3d7095b67a429608ca36f2d8bd0adda2.1527084287.git.kshcherbatov@tarantool.org \
--to=kshcherbatov@tarantool.org \
--cc=tarantool-patches@freelists.org \
--cc=v.shpilevoy@tarantool.org \
--subject='Re: [tarantool-patches] [PATCH v7 5/7] sql: change sqlite3AddCheckConstraint signature' \
/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