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

[24 Nov 2022 15:08] Pedro Ferreira 
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.
[25 Nov 2022 6:57] MySQL Verification Team 
Hello Pedro Ferreira,

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

regards,
Umesh

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.