bug: create constraint and foreign keys is not supported, there is no appropriate prompt information

[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 t1 (a INT PRIMARY KEY, b INT);
Query OK, 0 rows affected (0.20 sec)

mysql> CREATE TABLE t2 (a INT PRIMARY KEY, b INT,CONSTRAINT fk1 FOREIGN KEY (a) REFERENCES t1(a));
Query OK, 0 rows affected (0.05 sec)

mysql> show create table t2;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                           |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
| t2    | CREATE TABLE `t2` (
  `a` int NOT NULL,
  `b` int DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)

mysql> show create table t2\G
*************************** 1. row ***************************
       Table: t2
Create Table: CREATE TABLE `t2` (
  `a` int NOT NULL,
  `b` int DEFAULT NULL,
  PRIMARY KEY (`a`)
) ENGINE=TIANMU DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
1 row in set (0.00 sec)

Expected behavior

No response

How To Reproduce

No response

Environment

No response

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

• Yes, I will!

[RingsC]

mysql>  CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
Query OK, 0 rows affected (0.01 sec)

mysql>  CREATE TABLE t2 (a INT PRIMARY KEY, b INT,CONSTRAINT fk1 FOREIGN KEY (a) REFERENCES t1(a));
ERROR 3241 (HY000): Tianmu engine does not support foreign key.

mysql> select version();
+---------------------------------+
| version()                       |
+---------------------------------+
| 5.7.36-StoneDB-v1.0.1.6b369e53c |
+---------------------------------+

The error message issued. @davidshiz

[davidshiz]

This is a problem with version 8.0, need to wait for the code of version 5.7 related no_key_error to be merged