MySQL Bugs: #109194: Inexistent secondary

Bug #109194	Inexistent secondary_engine ignored
Submitted:	24 Nov 2022 15:08	Modified:	25 Nov 2022 6:57
Reporter:	Pedro Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S3 (Non-critical)
Version:	8.0.31	OS:	Ubuntu (22.04)
Assigned to:		CPU Architecture:	x86 (x86_64)
Tags:	CREATE TABLE

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
If I attempt to create a table with a inexistent secondary engine, an error is not thrown:

mysql> CREATE TABLE t0 (c0 INT) secondary_engine = idontexist;
Query OK, 0 rows affected (0,03 sec)

The same doesn't happen for the primary engine:

mysql> CREATE TABLE t1 (c0 INT) engine = idontexist;
ERROR 1286 (42000): Unknown storage engine 'idontexist'

How to repeat:
Run the query above.

Hello Pedro Ferreira,

Thank you for the report and feedback.
Observed that 8.0.31 build is affected.

regards,
Umesh