FISCO-BCOS / FISCO-BCOS/console

Console 3.8.0 关于alter sql 命令问题

Open
#866 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Shell
Stars
96
Forks
62
PR merge metrics
No merged PRs in 30d

Description

环境 : fisco 3.11.0
console 3.8.0
对于已经存有数据的表来说,若使用此altersql 增加一个字段,然后再用update语句更新 新增字段的数据,会造成节点关闭
【是因为不允许在原有的数据里更新此字段是的信息吗,而只能在新增的数据使用此字段】
【我增加的是status这个字段】
[group0]: /apps> update t_order_123 set extra_info = fff where order_status = 1;
1 row affected.

[group0]: /apps> update t_order_123 set status = 1 where order_status = 1;
{
"code":-4006,
"msg":"the session has been disconnected"
}

[group0]: /apps> update t_order_123 set extra_info = fff where order_status = 1;
{
"code":-4010,
"msg":"there has no connection available for the group,maybe all connections disconnected or the group does not exist,group: group0"
}

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.