1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562
|
/*
* Copyright 2010-2016, Tarantool AUTHORS, please see AUTHORS file.
*
* Redistribution and use in source and binary forms, with or
* without modification, are permitted provided that the following
* conditions are met:
*
* 1. Redistributions of source code must retain the above
* copyright notice, this list of conditions and the
* following disclaimer.
*
* 2. Redistributions in binary form must reproduce the above
* copyright notice, this list of conditions and the following
* disclaimer in the documentation and/or other materials
* provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY <COPYRIGHT HOLDER> ``AS IS'' AND
* ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
* TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL
* <COPYRIGHT HOLDER> OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
* INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
* DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
* SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
* BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
* LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF
* THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
* SUCH DAMAGE.
*/
#include "xrow_update.h"
#include <stdbool.h>
#include "say.h"
#include "error.h"
#include "diag.h"
#include <msgpuck/msgpuck.h>
#include "column_mask.h"
#include "fiber.h"
#include "xrow_update_field.h"
#include "tuple_format.h"
/**
* UPDATE is represented by a sequence of operations, each
* working with a single field. There also are operations which
* add or remove fields. Only one operation on the same field
* is allowed.
* Field is any part of a tuple: top-level array's field, leaf of
* a complex tuple with lots of maps and arrays inside, a whole
* map/array inside a tuple.
*
* Supported field change operations are: SET, ADD, SUBTRACT;
* bitwise AND, XOR and OR; SPLICE.
* Supported tuple change operations are: SET, DELETE, INSERT.
*
* If the number of fields in a tuple is altered by an operation,
* field index of all following operations is evaluated against the
* new tuple. It applies to internal tuple's arrays too.
*
* Despite the allowed complexity, a typical use case for UPDATE
* is when the operation count is much less than field count in
* a tuple.
*
* With the common case in mind, UPDATE tries to minimize
* the amount of unnecessary temporary tuple copies.
*
* First, operations are parsed and initialized. Then they are
* applied one by one to a tuple. Each operation may change an
* already located field in a tuple, or may split parent of the
* field into subtrees. After all operations are applied, the
* result is a tree of updated, new, and non-changed fields.
* The tree needs to be flattened into MessagePack format. For
* that a resulting tuple length is calculated. Memory for the new
* tuple is allocated in one contiguous chunk. Then the update
* tree is stored into the chunk as a result tuple.
*
* Note, that the result tree didn't allocate anything until a
* result was stored. It was referencing old tuple's memory.
* With this approach, cost of UPDATE is proportional to O(tuple
* length) + O(C * log C), where C is the number of operations in
* the request, and data is copied from the old tuple to the new
* one only once.
*
* As long as INSERT and DELETE change the relative field order in
* arrays and maps, these fields are represented as special
* structures optimized for updates to provide fast search and
* don't realloc anything. It is 'rope' data structure for array,
* and a simpler key-value list sorted by update time for map.
*
* A rope is a binary tree designed to store long strings built
* from pieces. Each tree node points to a substring of a large
* string. In our case, each rope node points at a range of
* fields, initially in the old tuple, and then, as fields are
* added and deleted by UPDATE, in the "current" tuple.
* Note, that the tuple itself is not materialized: when
* operations which affect field count are initialized, the rope
* is updated to reflect the new field order.
* In particular, if a field is deleted by an operation,
* it disappears from the rope and all subsequent operations
* on this field number instead affect the field following the
* deleted one.
*/
/** Update internal state */
struct xrow_update
{
/** Operations array. */
struct xrow_update_op *ops;
/** Length of ops. */
uint32_t op_count;
/**
* Index base for MessagePack update operations. If update
* is from Lua, then the base is 1. Otherwise 0. That
* field exists because Lua uses 1-based array indexing,
* and Lua-to-MessagePack encoder keeps this indexing when
* encodes operations array. Index base allows not to
* re-encode each Lua update with 0-based indexes.
*/
int index_base;
/**
* A bitmask of all columns modified by this update. Only
* the first level of a tuple is accounted here. I.e. if
* a field [1][2][3] was updated, then only [1] is
* reflected.
*/
uint64_t column_mask;
/** First level of update tree. It is always array. */
struct xrow_update_field root;
};
/**
* Read and check update operations and fill column mask.
*
* @param[out] update Update meta.
* @param expr MessagePack array of operations.
* @param expr_end End of the @expr.
* @param dict Dictionary to lookup field number by a name.
* @param field_count_hint Field count in the updated tuple. If
* there is no tuple at hand (for example, when we are
* reading UPSERT operations), then 0 for field count will
* do as a hint: the only effect of a wrong hint is
* a possibly incorrect column_mask.
* A correct field count results in an accurate
* column mask calculation.
*
* @retval 0 Success.
* @retval -1 Error.
*/
static int
xrow_update_read_ops(struct xrow_update *update, const char *expr,
const char *expr_end, struct tuple_dictionary *dict,
int32_t field_count_hint)
{
if (mp_typeof(*expr) != MP_ARRAY) {
diag_set(ClientError, ER_ILLEGAL_PARAMS,
"update operations must be an "
"array {{op,..}, {op,..}}");
return -1;
}
uint64_t column_mask = 0;
/* number of operations */
update->op_count = mp_decode_array(&expr);
if (update->op_count > BOX_UPDATE_OP_CNT_MAX) {
diag_set(ClientError, ER_ILLEGAL_PARAMS,
"too many operations for update");
return -1;
}
int size = update->op_count * sizeof(update->ops[0]);
update->ops = (struct xrow_update_op *)
region_aligned_alloc(&fiber()->gc, size,
alignof(struct xrow_update_op));
if (update->ops == NULL) {
diag_set(OutOfMemory, size, "region_aligned_alloc",
"update->ops");
return -1;
}
struct xrow_update_op *op = update->ops;
struct xrow_update_op *ops_end = op + update->op_count;
for (int i = 1; op < ops_end; op++, i++) {
if (xrow_update_op_decode(op, i, update->index_base, dict,
&expr) != 0)
return -1;
/*
* Continue collecting the changed columns
* only if there are unset bits in the mask.
*/
if (column_mask != COLUMN_MASK_FULL) {
int32_t field_no;
char opcode;
if (xrow_update_op_is_term(op)) {
opcode = op->opcode;
} else {
/*
* When a field is not terminal,
* on the first level it for sure
* changes only one field and in
* terms of column mask is
* equivalent to any scalar
* operation. Even if it was '!'
* or '#'. Zero means, that it
* won't match any checks with
* non-scalar operations below.
*/
opcode = 0;
}
if (op->field_no >= 0)
field_no = op->field_no;
else if (opcode != '!')
field_no = field_count_hint + op->field_no;
else
/*
* '!' with a negative number
* inserts a new value after the
* position, specified in the
* field_no. Example:
* tuple: [1, 2, 3]
*
* update1: {'#', -1, 1}
* update2: {'!', -1, 4}
*
* result1: [1, 2, * ]
* result2: [1, 2, 3, *4]
* As you can see, both operations
* have field_no -1, but '!' actually
* creates a new field. So
* set field_no to insert position + 1.
*/
field_no = field_count_hint + op->field_no + 1;
/*
* Here field_no can be < 0 only if update
* operation encounters a negative field
* number N and abs(N) > field_count_hint.
* For example, the tuple is: {1, 2, 3},
* and the update operation is
* {'#', -4, 1}.
*/
if (field_no < 0) {
/*
* Turn off column mask for this
* incorrect UPDATE.
*/
column_mask_set_range(&column_mask, 0);
continue;
}
/*
* Update result statement's field count
* hint. It is used to translate negative
* field numbers into positive ones.
*/
if (opcode == '!')
++field_count_hint;
else if (opcode == '#')
field_count_hint -= (int32_t) op->arg.del.count;
if (opcode == '!' || opcode == '#')
/*
* If the operation is insertion
* or deletion then it potentially
* changes a range of columns by
* moving them, so need to set a
* range of bits.
*/
column_mask_set_range(&column_mask, field_no);
else
column_mask_set_fieldno(&column_mask, field_no);
}
}
/* Check the remainder length, the request must be fully read. */
if (expr != expr_end) {
diag_set(ClientError, ER_ILLEGAL_PARAMS,
"can't unpack update operations");
return -1;
}
update->column_mask = column_mask;
return 0;
}
/**
* Apply update operations to the concrete tuple.
*
* @param update Update meta.
* @param old_data MessagePack array of tuple fields without the
* array header.
* @param old_data_end End of the @old_data.
* @param part_count Field count in the @old_data.
*
* @retval 0 Success.
* @retval -1 Error.
*/
static int
xrow_update_do_ops(struct xrow_update *update, const char *header,
const char *old_data, const char *old_data_end,
uint32_t part_count)
{
if (xrow_update_array_create(&update->root, header, old_data,
old_data_end, part_count) != 0)
return -1;
struct xrow_update_op *op = update->ops;
struct xrow_update_op *ops_end = op + update->op_count;
for (; op < ops_end; op++) {
if (op->meta->do_op(op, &update->root) != 0)
return -1;
}
return 0;
}
/*
* Same as update_do_ops but for upsert.
* @param suppress_error True, if an upsert error is not critical
* and it is enough to simply write the error to the log.
*/
static int
xrow_upsert_do_ops(struct xrow_update *update, const char *header,
const char *old_data, const char *old_data_end,
uint32_t part_count, bool suppress_error)
{
if (xrow_update_array_create(&update->root, header, old_data,
old_data_end, part_count) != 0)
return -1;
struct xrow_update_op *op = update->ops;
struct xrow_update_op *ops_end = op + update->op_count;
for (; op < ops_end; op++) {
if (op->meta->do_op(op, &update->root) == 0)
continue;
struct error *e = diag_last_error(diag_get());
if (e->type != &type_ClientError)
return -1;
if (!suppress_error) {
say_error("UPSERT operation failed:");
error_log(e);
}
}
return 0;
}
static void
xrow_update_init(struct xrow_update *update, int index_base)
{
memset(update, 0, sizeof(*update));
update->index_base = index_base;
}
static const char *
xrow_update_finish(struct xrow_update *update, struct tuple_format *format,
uint32_t *p_tuple_len)
{
uint32_t tuple_len = xrow_update_array_sizeof(&update->root);
char *buffer = (char *) region_alloc(&fiber()->gc, tuple_len);
if (buffer == NULL) {
diag_set(OutOfMemory, tuple_len, "region_alloc", "buffer");
return NULL;
}
*p_tuple_len = xrow_update_array_store(&update->root, &format->fields,
&format->fields.root, buffer,
buffer + tuple_len);
assert(*p_tuple_len <= tuple_len);
return buffer;
}
int
xrow_update_check_ops(const char *expr, const char *expr_end,
struct tuple_format *format, int index_base)
{
struct xrow_update update;
xrow_update_init(&update, index_base);
return xrow_update_read_ops(&update, expr, expr_end, format->dict, 0);
}
const char *
xrow_update_execute(const char *expr,const char *expr_end,
const char *old_data, const char *old_data_end,
struct tuple_format *format, uint32_t *p_tuple_len,
int index_base, uint64_t *column_mask)
{
struct xrow_update update;
xrow_update_init(&update, index_base);
const char *header = old_data;
uint32_t field_count = mp_decode_array(&old_data);
if (xrow_update_read_ops(&update, expr, expr_end, format->dict,
field_count) != 0)
return NULL;
if (xrow_update_do_ops(&update, header, old_data, old_data_end,
field_count) != 0)
return NULL;
if (column_mask)
*column_mask = update.column_mask;
return xrow_update_finish(&update, format, p_tuple_len);
}
const char *
xrow_upsert_execute(const char *expr,const char *expr_end,
const char *old_data, const char *old_data_end,
struct tuple_format *format, uint32_t *p_tuple_len,
int index_base, bool suppress_error, uint64_t *column_mask)
{
struct xrow_update update;
xrow_update_init(&update, index_base);
const char *header = old_data;
uint32_t field_count = mp_decode_array(&old_data);
if (xrow_update_read_ops(&update, expr, expr_end, format->dict,
field_count) != 0)
return NULL;
if (xrow_upsert_do_ops(&update, header, old_data, old_data_end,
field_count, suppress_error) != 0)
return NULL;
if (column_mask)
*column_mask = update.column_mask;
return xrow_update_finish(&update, format, p_tuple_len);
}
const char *
xrow_upsert_squash(const char *expr1, const char *expr1_end,
const char *expr2, const char *expr2_end,
struct tuple_format *format, size_t *result_size,
int index_base)
{
const char *expr[2] = {expr1, expr2};
const char *expr_end[2] = {expr1_end, expr2_end};
struct xrow_update update[2];
struct tuple_dictionary *dict = format->dict;
for (int j = 0; j < 2; j++) {
xrow_update_init(&update[j], index_base);
if (xrow_update_read_ops(&update[j], expr[j], expr_end[j],
dict, 0) != 0)
return NULL;
mp_decode_array(&expr[j]);
int32_t prev_field_no = index_base - 1;
for (uint32_t i = 0; i < update[j].op_count; i++) {
struct xrow_update_op *op = &update[j].ops[i];
if (op->opcode != '+' && op->opcode != '-' &&
op->opcode != '=')
return NULL;
/*
* Not terminal operation means, that the
* update is not flat, and squash would
* need to build a tree of operations to
* find matches. That is too complex,
* squash is skipped.
*/
if (!xrow_update_op_is_term(op))
return NULL;
if (op->field_no <= prev_field_no)
return NULL;
prev_field_no = op->field_no;
}
}
size_t possible_size = expr1_end - expr1 + expr2_end - expr2;
const uint32_t space_for_arr_tag = 5;
char *buf = (char *) region_alloc(&fiber()->gc,
possible_size + space_for_arr_tag);
if (buf == NULL) {
diag_set(OutOfMemory, possible_size + space_for_arr_tag,
"region_alloc", "buf");
return NULL;
}
/* reserve some space for mp array header */
char *res_ops = buf + space_for_arr_tag;
uint32_t res_count = 0; /* number of resulting operations */
uint32_t op_count[2] = {update[0].op_count, update[1].op_count};
uint32_t op_no[2] = {0, 0};
struct json_tree *format_tree = &format->fields;
struct json_token *root = &format_tree->root;
struct json_token token;
token.type = JSON_TOKEN_NUM;
while (op_no[0] < op_count[0] || op_no[1] < op_count[1]) {
res_count++;
struct xrow_update_op *op[2] = {update[0].ops + op_no[0],
update[1].ops + op_no[1]};
/*
* from:
* 0 - take op from first update,
* 1 - take op from second update,
* 2 - merge both ops
*/
uint32_t from;
uint32_t has[2] = {op_no[0] < op_count[0], op_no[1] < op_count[1]};
assert(has[0] || has[1]);
if (has[0] && has[1]) {
from = op[0]->field_no < op[1]->field_no ? 0 :
op[0]->field_no > op[1]->field_no ? 1 : 2;
} else {
assert(has[0] != has[1]);
from = has[1];
}
if (from == 2 && op[1]->opcode == '=') {
/*
* If an operation from the second upsert is '='
* it is just overwrites any op from the first upsert.
* So we just skip op from the first upsert and
* copy op from the second
*/
mp_next(&expr[0]);
op_no[0]++;
from = 1;
}
if (from < 2) {
/* take op from one of upserts */
const char *copy = expr[from];
mp_next(&expr[from]);
size_t copy_size = expr[from] - copy;
memcpy(res_ops, copy, copy_size);
res_ops += copy_size;
op_no[from]++;
continue;
}
/* merge: apply second '+' or '-' */
assert(op[1]->opcode == '+' || op[1]->opcode == '-');
if (op[0]->opcode == '-') {
op[0]->opcode = '+';
int96_invert(&op[0]->arg.arith.int96);
}
struct xrow_update_arg_arith arith;
/*
* If we apply + or - on top of the set operation ('='),
* then resulting operation is {'=', op1.val + op2.val}.
* To continue processing arithmetic operation we should
* firstly extract value from set operation holder.
*/
if (op[0]->opcode == '=') {
if (xrow_mp_read_arg_arith(op[0], &op[0]->arg.set.value,
&arith) != 0)
return NULL;
} else {
arith = op[0]->arg.arith;
}
struct xrow_update_op res;
if (xrow_update_arith_make(op[1], arith,
&res.arg.arith) != 0)
return NULL;
res_ops = mp_encode_array(res_ops, 3);
res_ops = mp_encode_str(res_ops,
(const char *)&op[0]->opcode, 1);
token.num = op[0]->field_no;
res_ops = mp_encode_uint(res_ops, token.num +
update[0].index_base);
struct json_token *this_node =
json_tree_lookup(format_tree, root, &token);
xrow_update_op_store_arith(&res, format_tree, this_node, NULL,
res_ops);
res_ops += xrow_update_arg_arith_sizeof(&res.arg.arith);
mp_next(&expr[0]);
mp_next(&expr[1]);
op_no[0]++;
op_no[1]++;
}
assert(op_no[0] == op_count[0] && op_no[1] == op_count[1]);
assert(expr[0] == expr_end[0] && expr[1] == expr_end[1]);
char *arr_start = buf + space_for_arr_tag -
mp_sizeof_array(res_count);
mp_encode_array(arr_start, res_count);
*result_size = res_ops - arr_start;
return arr_start;
}
|