添加以dml格式更新变更集通过选择查询获得的更新值

Question

我想添加changeset来更新yaml格式的表列值，更新后的值在运行时通过select query获取；

UPDATE table SET groupid=(select id from group where groupname='star') WHERE studentid=(select studentid from student where name ='abc');

yaml格式

- changeSet:
id: 1
author: abc
changes:
- update: 
tableName: table
columns:
- column:
name: groupid
value: (select id from group where groupname='star')
where: studentid=(select studentid from student where name ='abc')

但它对我不起作用

Answer 1

我得到答案

- changeSet:
id: 1
author: abc
changes:
- update: 
tableName: table
columns:
- column:
name: groupid
valueComputed: (select id from group where groupname='star')
where: studentid=(select studentid from student where name ='abc')