[Bug]: bvt failed in password_reuse.sql

[badboynt1]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

lastest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

2024-11-26 01:59:30 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/test/distributed/cases/zz_accesscontrol/password_management/password_reuse.sql][row:74][ALTER USER 'test_user'@'localhost' IDENTIFIED BY 'password1';] was executed failed, con[id=0, user=dump, ***
2024-11-26 01:59:30 ERROR Executor:271 - [EXPECT RESULT]:
null
2024-11-26 01:59:30 ERROR Executor:272 - [ACTUAL RESULT]:
invalid input: The password has been used before, please change another one
2024-11-26 01:59:30 ERROR Executor:269 - [/home/runner/work/matrixone/matrixone/test/distributed/cases/zz_accesscontrol/password_management/password_reuse.sql][row:77][ALTER USER 'test_user'@'localhost' IDENTIFIED BY 'password1';] was executed failed, con[id=0, user=dump, ***
2024-11-26 01:59:30 ERROR Executor:271 - [EXPECT RESULT]:
invalid input: The password has been used before, please change another one.
2024-11-26 01:59:30 ERROR Executor:272 - [ACTUAL RESULT]:
invalid input: The password has been used before, please change another one

Expected Behavior

No response

Steps to Reproduce

https://github.com/matrixorigin/matrixone/actions/runs/12022138515/job/33513845938?pr=20360

Additional information

No response

[YANGGMM]

看报错的是违反了 password_interval的规则，但是password_interval 已经set成default 0了

[sukki37]

repro：https://github.com/matrixorigin/matrixone/actions/runs/12034222811/job/33551184018

[qingxinhome]

repro: https://github.com/matrixorigin/matrixone/actions/runs/12051327175/job/33603030172

2024-11-27 14:14:21 INFO TestReport:76 - [/home/runner/_work/matrixone/matrixone/matrixone/test/distributed/cases/security/password.sql] SQL: ALTER USER user1_group4 IDENTIFIED BY 'oldpassword123'; -- Expected failure: Old password cannot be reused
2024-11-27 14:14:21 INFO TestReport:76 - [/home/runner/_work/matrixone/matrixone/matrixone/test/distributed/cases/security/password.sql] SQL: ALTER USER user2_group4 IDENTIFIED BY 'oldpassword456'; -- Expected failure: Old password cannot be reused

[Songxx-7]

由于全局变量需要每次设置之后退出对话，才可以生效，测试组设置较多导致超出session会话限制。发现在session id=10 or id=11的时候"%connection_control_failed_connections_threshold%"变量设置无效。现在已经把id限制在10以内，变量组设置成功，正在提pr。

[Songxx-7]

fix：#20428

[YANGGMM]

fixed