mysqltest case sequence.restart_mysql fails with error 4320 after nextval when ALTER SEQUENCE RESTART START WITH is executed

[chyujing]

Environment

• Version: Not specified (Not an RD-provided temporary version)
• Machine: 6.13.1.92
• Directory: /obdata/data/Andro...

Description

The mysqltest case sequence.restart_mysql fails after a nextval operation when an ALTER SEQUENCE ... RESTART START WITH statement is executed. The error returned is 4320 (MINVALUE must be less than MAXVALUE).

Steps to Reproduce

1. Connect using: mysql -uroot -h30.249.210.50 -P 2881
2. Execute the steps from the sequence.restart_mysql test case.
3. The test fails with error 4320.

Reproducibility: Consistently reproducible.

Expected Behavior

The test case should pass, matching the expected result defined in sequence.restart_mysql.

Actual Behavior

The test case fails with error 4320: "MINVALUE must be less than MAXVALUE".