[Bug]: change sql delimiter using "-- delimiter:" is not working

[chrisxu333]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):289e03f
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

When change delimiter using "--delimiter:", mo-tester is still using ; as delimiter in its logic. This causes trouble when testing stored procedure which has multiple ; within a single statement.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response