bug: ALTER TABLE prompt information is incorrect

[davidshiz]

Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Describe the problem

mysql> CREATE TABLE st2 (
    ->     task_id INT NOT NULL,
    ->     subject VARCHAR(45) NULL,
    ->     start_date DATE NULL,
    ->     end_date DATE NULL,
    ->     description VARCHAR(200) NULL,
    ->     PRIMARY KEY (task_id)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER TABLE st2 ADD COLUMN col_name3 int auto_increment;
ERROR 6 (HY000): Unable to inplace alter table

Expected behavior

mysql> CREATE TABLE st2 (
    ->     task_id INT NOT NULL,
    ->     subject VARCHAR(45) NULL,
    ->     start_date DATE NULL,
    ->     end_date DATE NULL,
    ->     description VARCHAR(200) NULL,
    ->     PRIMARY KEY (task_id)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql> ALTER TABLE st2 ADD COLUMN col_name3 int auto_increment;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key

How To Reproduce

CREATE TABLE st2 (
    task_id INT NOT NULL,
    subject VARCHAR(45) NULL,
    start_date DATE NULL,
    end_date DATE NULL,
    description VARCHAR(200) NULL,
    PRIMARY KEY (task_id)
); 
ALTER TABLE st2 ADD COLUMN col_name3 int auto_increment;

Environment

root@ub01:/stonedb57/install# /stonedb57/install/bin/mysqld --version
/stonedb57/install/bin/mysqld  Ver 5.7.36-StoneDB for Linux on x86_64 (build-)
build information as follow:
        Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
        Branch name: stonedb-5.7-dev
        Last commit ID: e395f89e1
        Last commit time: Date:   Tue Dec 6 01:04:24 2022 +0800
        Build time: Date: Tue Dec  6 16:03:58 CST 2022
root@ub01:~# cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04.5 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.5 LTS"
VERSION_ID="20.04"

Are you interested in submitting a PR to solve the problem?

• Yes, I will!

[davidshiz]

similar to #1140

[DandreChen]

The exception handling has problems