[Feature Request]: Support PREPARE statement

[domingozhang]

Is there an existing issue for the same feature request?

• [X] I have checked the existing issues.

Is your feature request related to a problem?

No response

Describe the feature you'd like

PREPARE stmt_name FROM preparable_stmt EXECUTE stmt_name [USING @var_name [, @var_name] ...] {DEALLOCATE | DROP} PREPARE stmt_name

mysql> PREPARE stmt1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse'; mysql> SET @a = 3; mysql> SET @b = 4; mysql> EXECUTE stmt1 USING @a, @b; +------------+ | hypotenuse | +------------+ | 5 | +------------+ mysql> DEALLOCATE PREPARE stmt1;

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

[ouyuanning]

same as #3338.

[sukki37]

The response packet seems incorrect. Maybe the buffer of connection is handled incorrectly by the frontend.

The test code is: test.zip

[ouyuanning]

The response packet seems incorrect. Maybe the buffer of connection is handled incorrectly by the frontend.

The test code is: test.zip

i had asked @daviszhen for help.