[Tarantool-patches] [PATCH v3 8/8] sql: show value and its type in type mismatch error
Mergen Imeev
imeevma at tarantool.org
Sun Jul 5 18:03:17 MSK 2020
My answers and diff below.
On Tue, Jun 30, 2020 at 12:22:32AM +0000, Nikita Pettik wrote:
> On 25 Jun 18:17, imeevma at tarantool.org wrote:
> > After this patch value and its type will be shown in description
> > of type mismatch error
>
> Какие цели преследует этот патч? Зачем мы это делаем?
> Диф то на 1.5 кслок.
It is just a refactoring. It can be dropped.
> Забыл точку в конце :)
>
Fixed.
> > }
> > #ifdef SQL_DEBUG
> > @@ -4740,7 +4735,7 @@ case OP_IdxGE: { /* jump */
> > (mem->flags & (MEM_Real | MEM_Int | MEM_UInt)) != 0)
> > continue;
> > diag_set(ClientError, ER_SQL_TYPE_MISMATCH,
> > - field_type_strs[type], mem_type_to_str(mem));
> > + sql_value_to_diag_str(mem), mem_type_to_str(mem));
> > goto abort_due_to_error;
> > }
> > #ifdef SQL_DEBUG
> > diff --git a/src/box/sql/vdbemem.c b/src/box/sql/vdbemem.c
> > index a721afc83..bb7676354 100644
> > --- a/src/box/sql/vdbemem.c
> > +++ b/src/box/sql/vdbemem.c
> > @@ -1166,12 +1166,15 @@ sqlValueText(sql_value * pVal)
> > const char *
> > sql_value_to_diag_str(sql_value *value)
> > {
> > - if (sql_value_type(value) == MP_BIN) {
> > - if (mem_has_msgpack_subtype(value))
> > - return sqlValueText(value);
> > + if (sql_value_mp_type(value) == MP_BIN)
> > return "varbinary";
> > - }
> > - return sqlValueText(value);
> > + char *type = mem_type_to_str(value);
> > + char *str = (char *)sqlValueText(value);
> > + if (str == NULL)
> > + return "NULL";
> > + if (strlen(str) < 80)
>
> https://en.wikipedia.org/wiki/Magic_number_(programming)
>
Added a enum here.
> > + return tt_sprintf("'%s' (type: %s)", str, type);
> > + return tt_sprintf("'%.80s...' (type: %s)", str, type);
> > }
> >
> > /*
> > diff --git a/test/sql-tap/autoinc.test.lua b/test/sql-tap/autoinc.test.lua
> > index 07442b60a..1547ffcd3 100755
> > --- a/test/sql-tap/autoinc.test.lua
> > +++ b/test/sql-tap/autoinc.test.lua
> > @@ -618,7 +618,7 @@ test:do_catchsql_test(
> > INSERT INTO t2 VALUES('asd');
> > ]], {
> > -- <autoinc-10.2>
> > - 1, "Type mismatch: can not convert asd to integer"
> > + 1, "Type mismatch: can not convert 'asd' (type: text) to integer"
>
> Выглядит зачотно, выглядит all right!
>
> > diff --git a/test/sql-tap/gh-3809-implicit-cast-assignment.test.lua b/test/sql-tap/gh-3809-implicit-cast-assignment.test.lua
> > index a1809b3cb..f1edfa0f6 100755
> > --- a/test/sql-tap/gh-3809-implicit-cast-assignment.test.lua
> > +++ b/test/sql-tap/gh-3809-implicit-cast-assignment.test.lua
> > @@ -28,7 +28,7 @@ test:do_catchsql_test(
> > [[
> > INSERT INTO ti(i) VALUES (100000000000000000000000000000000.1)
> > ]], {
> > - 1, "Type mismatch: can not convert 1.0e+32 to integer"
> > + 1, "Type mismatch: can not convert '1.0e+32' (type: real) to integer"
> > })
>
> Я бы может еще кавычки вокруг чиселок/буленов не добавлял, но это
> в принципе мелочь - тип то печатается.
>
I think it is better as it is now since in some cases
STRING value and BOOLEAN values look the same.
> В остальном - ОК.
Diff:
diff --git a/src/box/sql/vdbemem.c b/src/box/sql/vdbemem.c
index 32f4ae0b6..7cff881c0 100644
--- a/src/box/sql/vdbemem.c
+++ b/src/box/sql/vdbemem.c
@@ -1163,6 +1163,10 @@ sqlValueText(sql_value * pVal)
return valueToText(pVal);
}
+enum {
+ DIAG_STR_LEN_MAX = 80,
+};
+
const char *
sql_value_to_diag_str(sql_value *value)
{
@@ -1172,7 +1176,7 @@ sql_value_to_diag_str(sql_value *value)
char *str = (char *)sqlValueText(value);
if (str == NULL)
return "NULL";
- if (strlen(str) < 80)
+ if (strlen(str) < DIAG_STR_LEN_MAX)
return tt_sprintf("'%s' (type: %s)", str, type);
return tt_sprintf("'%.80s...' (type: %s)", str, type);
}
More information about the Tarantool-patches
mailing list