Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: update sql 带变量卡死
|
username: TiDBer_Ok0TdPp0
[TiDB Usage Environment] Production Environment
[TiDB Version] v7.5.1
[Reproduction Path] set @tidb_seq_id=1;
select @tidb_seq_id;
update tb_uhome_acct_item a, sdc_dws.tb_uhome_fee_item_type b, map_organ_list c
set a.group_id=b.group_id
WHERE b.fee_item_type_id=a.fee_item_type_id
and a.community_id=c.organ_id
and c.seq_id=@tidb_seq_id;
[Encountered Problem: Phenomenon and Impact] When the update statement includes the variable @tidb_seq_id, it hangs. If the variable is not used, the update completes in seconds.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: