[tarantool-patches] [PATCH 2/6] Split on_conflict_action and affinity

Georgy Kirichenko georgy at tarantool.org
Mon Aug 20 11:49:55 MSK 2018


Introduce a separate field to store expressions on_conflict_action and
convert expression affinity into an enum
---
 src/box/sql/expr.c      | 14 +++++++-------
 src/box/sql/fkey.c      |  2 +-
 src/box/sql/parse.y     |  4 ++--
 src/box/sql/sqliteInt.h |  3 ++-
 src/box/sql/treeview.c  |  6 ++++--
 5 files changed, 16 insertions(+), 13 deletions(-)

diff --git a/src/box/sql/expr.c b/src/box/sql/expr.c
index a41ea8f13..a9bb013cc 100644
--- a/src/box/sql/expr.c
+++ b/src/box/sql/expr.c
@@ -4299,20 +4299,20 @@ sqlite3ExprCodeTarget(Parse * pParse, Expr * pExpr, int target)
 			break;
 		}
 	case TK_RAISE:{
-			assert(pExpr->affinity == ON_CONFLICT_ACTION_ROLLBACK
-			       || pExpr->affinity == ON_CONFLICT_ACTION_ABORT
-			       || pExpr->affinity == ON_CONFLICT_ACTION_FAIL
-			       || pExpr->affinity == ON_CONFLICT_ACTION_IGNORE);
+			assert(pExpr->on_conflict_action == ON_CONFLICT_ACTION_ROLLBACK
+			       || pExpr->on_conflict_action == ON_CONFLICT_ACTION_ABORT
+			       || pExpr->on_conflict_action == ON_CONFLICT_ACTION_FAIL
+			       || pExpr->on_conflict_action == ON_CONFLICT_ACTION_IGNORE);
 			if (!pParse->pTriggerTab) {
 				sqlite3ErrorMsg(pParse,
 						"RAISE() may only be used within a trigger-program");
 				return 0;
 			}
-			if (pExpr->affinity == ON_CONFLICT_ACTION_ABORT) {
+			if (pExpr->on_conflict_action == ON_CONFLICT_ACTION_ABORT) {
 				sqlite3MayAbort(pParse);
 			}
 			assert(!ExprHasProperty(pExpr, EP_IntValue));
-			if (pExpr->affinity == ON_CONFLICT_ACTION_IGNORE) {
+			if (pExpr->on_conflict_action == ON_CONFLICT_ACTION_IGNORE) {
 				sqlite3VdbeAddOp4(v, OP_Halt, SQLITE_OK,
 						  ON_CONFLICT_ACTION_IGNORE, 0,
 						  pExpr->u.zToken,
@@ -4321,7 +4321,7 @@ sqlite3ExprCodeTarget(Parse * pParse, Expr * pExpr, int target)
 			} else {
 				sqlite3HaltConstraint(pParse,
 						      SQLITE_CONSTRAINT_TRIGGER,
-						      pExpr->affinity,
+						      pExpr->on_conflict_action,
 						      pExpr->u.zToken, 0, 0);
 			}
 
diff --git a/src/box/sql/fkey.c b/src/box/sql/fkey.c
index 1208fe3da..4e59111af 100644
--- a/src/box/sql/fkey.c
+++ b/src/box/sql/fkey.c
@@ -844,7 +844,7 @@ fkey_action_trigger(struct Parse *pParse, struct Table *pTab, struct fkey *fkey,
 		struct Expr *r = sqlite3Expr(db, TK_RAISE, "FOREIGN KEY "\
 					     "constraint failed");
 		if (r != NULL)
-			r->affinity = ON_CONFLICT_ACTION_ABORT;
+			r->on_conflict_action = ON_CONFLICT_ACTION_ABORT;
 		select = sqlite3SelectNew(pParse,
 					  sql_expr_list_append(db, NULL, r),
 					  sqlite3SrcListAppend(db, NULL, &err),
diff --git a/src/box/sql/parse.y b/src/box/sql/parse.y
index 200d57a7d..3358a1e6c 100644
--- a/src/box/sql/parse.y
+++ b/src/box/sql/parse.y
@@ -1408,14 +1408,14 @@ expr(A) ::= RAISE(X) LP IGNORE RP(Y).  {
   spanSet(&A,&X,&Y);  /*A-overwrites-X*/
   A.pExpr = sqlite3PExpr(pParse, TK_RAISE, 0, 0); 
   if( A.pExpr ){
-    A.pExpr->affinity = ON_CONFLICT_ACTION_IGNORE;
+    A.pExpr->on_conflict_action = ON_CONFLICT_ACTION_IGNORE;
   }
 }
 expr(A) ::= RAISE(X) LP raisetype(T) COMMA STRING(Z) RP(Y).  {
   spanSet(&A,&X,&Y);  /*A-overwrites-X*/
   A.pExpr = sqlite3ExprAlloc(pParse->db, TK_RAISE, &Z, 1); 
   if( A.pExpr ) {
-    A.pExpr->affinity = (char)T;
+    A.pExpr->on_conflict_action = (char)T;
   }
 }
 
diff --git a/src/box/sql/sqliteInt.h b/src/box/sql/sqliteInt.h
index 189d16150..df335a298 100644
--- a/src/box/sql/sqliteInt.h
+++ b/src/box/sql/sqliteInt.h
@@ -2201,7 +2201,8 @@ typedef int ynVar;
  */
 struct Expr {
 	u8 op;			/* Operation performed by this node */
-	char affinity;		/* The affinity of the column or 0 if not a column */
+	enum affinity_type affinity;		/* The affinity of the column or 0 if not a column */
+	enum on_conflict_action on_conflict_action;
 	u32 flags;		/* Various flags.  EP_* See below */
 	union {
 		char *zToken;	/* Token value. Zero terminated and dequoted */
diff --git a/src/box/sql/treeview.c b/src/box/sql/treeview.c
index 4261e733e..90f5c466b 100644
--- a/src/box/sql/treeview.c
+++ b/src/box/sql/treeview.c
@@ -566,8 +566,8 @@ sqlite3TreeViewExpr(TreeView * pView, const Expr * pExpr, u8 moreToFollow)
 			break;
 		}
 	case TK_RAISE:{
-			const char *zType = "unk";
-			switch (pExpr->affinity) {
+			const char *zType;
+			switch (pExpr->on_conflict_action) {
 			case ON_CONFLICT_ACTION_ROLLBACK:
 				zType = "rollback";
 				break;
@@ -580,6 +580,8 @@ sqlite3TreeViewExpr(TreeView * pView, const Expr * pExpr, u8 moreToFollow)
 			case ON_CONFLICT_ACTION_IGNORE:
 				zType = "ignore";
 				break;
+			default:
+				zType = "unk";
 			}
 			sqlite3TreeViewLine(pView, "RAISE %s(%Q)", zType,
 					    pExpr->u.zToken);
-- 
2.18.0





More information about the Tarantool-patches mailing list