Bug #118611 Creating an InnoDB table with a CONNECTION clause should not be allowed

• Submitted: 9 Jul 4:40
• Modified: 9 Jul 8:25
• Reporter: Jericho Arturo Rivera
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 8.4, 8.0.42
• OS: Linux
• CPU Architecture: Any

[9 Jul 4:40] Jericho Arturo Rivera

Description:
Creating an InnoDB table with a CONNECTION clause should not be allowed. Currently, it will work, and the InnoDB table will work with no apparent errors or warnings sent to the error log for DML statements.

```
mysql> show create table test_table\G
*************************** 1. row ***************************
       Table: test_table
Create Table: CREATE TABLE `test_table` (
  `id` int NOT NULL AUTO_INCREMENT,
  `c` char(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci CONNECTION='mysql://federated:federated@198.19.249.193:3306/federated/test_table'
1 row in set (0.02 sec)
```

How to repeat:
Create an InnoDB table with the CONNECTION clause.

Suggested fix:
Return an error.

[9 Jul 8:25] MySQL Verification Team

Hello Jericho Arturo Rivera,

Thank you for the report and feedback.

regards,
Umesh