User defined variable assignment in select using functions is not getting reassigned in TiDB

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists t1,t2;
create table t1 (a int);
insert into t1 values (0),(1),(2),(3); 
create table t2 (a int, key(a), b int);
insert into t2 values (1,1),(2,2);

set @cnt= 1; 
set @str="update t2 set b=1 where a not in (";
select count(*) from (
  select @str:=concat(@str, @cnt:=@cnt+1, ",") 
  from t1 A, t1 B, t1 C, t1 D) Z;
select @str;

2. What did you expect to see? (Required)

 update t2 set b=1 where a not in (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,.......)

3. What did you see instead (Required)

mysql> select @str;
+------------------------------------+
| @str                               |
+------------------------------------+
| update t2 set b=1 where a not in ( |
+------------------------------------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

mysql> select version();
+-----------------------------------------------+
| version()                                     |
+-----------------------------------------------+
| 5.7.25-TiDB-v6.1.0-alpha-482-g81a852077-dirty |
+-----------------------------------------------+
1 row in set (0.00 sec)

[zanmato1984]

This is not a very common use. I'm adjusting it to moderate.