MySQL Bugs: #116709: scripts/mysql_system_tables.sql still treating InnoDB as an optional SE

Bug #116709	scripts/mysql_system_tables.sql still treating InnoDB as an optional SE
Submitted:	19 Nov 2024 11:59	Modified:	19 Nov 2024 12:22
Reporter:	Laurynas Biveinis (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	9.1.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The very first non-comment line at scripts/mysql_system_tables.sql:

set @have_innodb= (select count(engine) from information_schema.engines where engine='INNODB' and support != 'NO');

InnoDB is mandatory. This variable cannot possibly be anything else than 1 since 5.7.

How to repeat:
See above

Suggested fix:
Remove it

Hello Laurynas,

Thank you for the report and feedback.

regards,
Umesh